Infrastructure Map Server General Discussion

Infrastructure Map Server General Discussion

Valued Mentor
Posts: 374
Registered: ‎10-10-2003
Message 1 of 2 (189 Views)

Schema Override For Views in Database

189 Views, 1 Replies
11-15-2013 07:38 AM

Joins are one of the biggest stresses in AIMS. 


They rarely work the way you wish and to work around them I have made a lot of JOINS in my spatial databases (Oracle Spatial and SQL Server Spatial) using a VIEW (or stored Query as it is called in MS Access).


My problem is that unless you can put an INDEX on the View or CONSTRAINT you can't select the features in AIMS on the map.


For SQL Server you need to do 2 things:

1. Create view with SHEMABINDING (i.e.. create view with SCHEMABINDING as select * from table:smileywink:

2. Create an index on the unique column in the view.


This does not work if your view points to another Database (for example I integrate with systems such as MAXIMO, TEMPEST, PEOPLESOFT, etc).


For Oracle, you just make a constraint:

1. alter view <viewname> add constraint <constraintname> primary key (<columnlist>) disable novalidate; 


Either way it is a hassle just to connect two tables together in AIMS. 


One of the best work-arounds is using FDO Toolbox and MapGuide Maestro to do a Schema Over-ride (thank goodness for Jackie!)


Imagine, I have to use 2 OpenSource Products to fix not 1 but 2 glaring issues with Autodesk Infrastructure Map Server:

"The ability to effectively join two databases together with a common filed (aka a JOIN)" and not being able to select features in a View.



Since the WISHLIST discussion group is now "Archived" I thought issue has best visibility here.









Posts: 25
Registered: ‎09-24-2012
Message 2 of 2 (163 Views)

Re: Schema Override For Views in Database

11-19-2013 04:14 AM in reply to: gluckett

Why has the Wishlist been archived?  Does that mean that forum is now dead?

Are you familiar with the Autodesk Expert Elites? The Expert Elite program is made up of customers that help other customers by sharing knowledge and exemplifying an engaging style of collaboration. To learn more, please visit our Expert Elite website.
Need installation help?

Start with some of our most frequented solutions or visit the Installation and Licensing Forum to get help installing your software.