Techniques for Integrating Oracle Spatial with ArcSDE and the Geodatabase
Track: Database Design, Automation, and Management
Author(s): Robert Gage
In the course of implementing an integrated system for management of facilities information at NASA Langley Research Center, many issues were encountered in integrating the various Esri and Oracle technologies. This paper will summarize the solutions and techniques which were discovered. Topics addressed will be in the use of database views to simplify map generation and web development, using multiversioned data in non-ArcSDE clients, options for implementing custom object behavior using both client side COM/ATL and server side PL/SQL and Java, and techniques for implementing a quality controlled editing process with change visualization and tracking of change metadata.
NASA Langley GIS Team
NASA Langley Research Center
Hampton , VA 23681