I have a geospatial database which contains both spatial and not-spatial tables I would like to publish my data on ArcGis for server and perform both simple and spatial queries. Also, foreign key relationships should be used so as to perform more complicated queries.
To be more specific: There is a need to be able to execute application specific queries over multiple relational tables and some of them should contain geometries. So, for examle through the arcgis I have to be able to ask a question like : Give all the stations (stations Table) that are connected to ports(ports table) and have color blue (color table). The criteria should be added dynamically so, for example one could select through the jS api, the stations to have an additional characteristic from another table
I know that you could build the the Query object dynamically, but it's only for attributes of a single table (or joined table). If you could not know in advance which exactly tables you would join (for example implementing a filter) or how many of them you would join (table A with B , A with B and C , A C , A B C E, A E etc).I suppose you dont have to precompute all the possible join combinations.
Should I publish the entire geodatabase in some way? Would relates help in that case? Since queries should be constructed dynamically, I suppose it is not possible to be based on precomputed joined tables.
I need to do this maybe through the JS APi I am using arcgis for Deskotop 10.2 and oracle DB 11g