Research on Spatial Database Design and Tuning Based on Oracle and ARCSDE

Abstract

With the development of the Database technology and Geographic Information System technology, the spatial data managing mode go through three stages, entirely File system management, File system and Relation Database System mixed management and entirely Database management. At the same time database model also develop from Relation Model, Object-Relation Model, to Object- oriented Model. At the present time there are two main spatial database management approaches using commercial database. One is using Spatial Data Engine (Such as ArcSDE) in the Relation Database Management System. The other is using Object-Relation Database. Whichever spatial database management approach is used, in practical project we need a set of technics flow about the data preparing, database design, database configuration and tuning. Especially in commercial database, the rational database design, configuration and tuning are more important. In this article the experiment construct a fundamental spatial database system for Tibet province using Geodatabase model of the ArcSDE and the Oracle database management System. Concretely, the main fields are researched as following: (1) Analyse the character of fundamental spatial data including the Digital Orthophoto Map data, the Digital Elevation Modal data, the Digital Raster Graphic data and the Digital line Graphic data. And scheme out a data processing plan for spatial database construction. (2) Rationally Design Database, this process includes the design for Geodatabase model and the design for Oracle database. (3) Configure and tune Oracle database, this process includes the configuration of the table and index of the spatial object and the configuration and tuning of the database initial parameters.