Ricardo Mireles
The Spatial Database Engine represents a new era in GIS. Distributing geographic information at the enterprise level is no longer a dream but a reality. High-speed access for hundreds of users is now at the touch of a button. This paper is about how SDE will be used in an enterprise network for the City of Las Vegas. Specifically, it is a study about how people and technology can work together to build an enterprise network using SDE.
With the ever increasing speed and capacity of symmetrical multiprocessing systems (SMP), applications using relational databases are achieving unprecedented performance running complex and sophisticated user programs. These SMP systems are also being configured in parallel to execute processes that are not only distributed across processors in a stand-alone system but across multiple SMP systems. The purpose of this paper is to describe how hundreds of users can access spatial databases based on Esri's SDE, Oracle's Parallel Data Query Option and Oracle RDBMS.
The Esri Spatial Database Engine (SDE) provides an enterprisewide repository for spatial and attribute data within an RDBMS. Its client/server architecture and built-in spatial analysis and query tools allow efficient access, management, and distribution of spatial and attribute data throughout the network. This paper describes a process to build a system using the SDE Application Programmers Interface (API) to integrate a corporate database containing spatial data. There are several steps that must be taken when building such a system such as integration with other COTS applications and tools to provide the framework for the user interface and the graphic display environment, the overall RDBMS database design, and the capabilities required by the end user to query, display, and report on the data.