Infrastructure Map Server General

Reply
Valued Mentor
gluckett
Posts: 355
Registered: ‎10-10-2003
Message 1 of 2 (171 Views)

Schema Override For Views in Database

171 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!)

http://themapguyde.blogspot.ca/2010/09/using-fdo-schema-overrides-redux.html

 

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.

 

 

 

 

 

 

 

 

Contributor
tony.witham
Posts: 25
Registered: ‎09-24-2012
Message 2 of 2 (145 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?

You are not logged in.

Log into access your profile, ask and answer questions, share ideas and more. Haven't signed up yet? Register

Announcements
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 to get help installing your software.

Ask the Community