The Organization , Management And Query Of Spatial Data Based On Oracle Spatial

Geographical Information System (GIS) is a spatial information system which is in charge of collecting, storing, managing, analyzing and describing data related spatial distribution. From naissance to now, GIS has experienced a development over 30 years and it has already entered a diversified phase. Especially after 1990s, the rapid development of Internet has also driven the development from GIS to WEBGIS. A difficulty point of GIS is implementing integrated storing and management of spatial data and attribute data. Oracle Spatial technology is adopted to solve this problem in this paper.This paper deep researched Oracle Spatial at first, including the classifying of spatial data, two kinds of models of Oracle Spatial and the indexing of spatial data, etc. These two kinds of models are object-relational model and relational model. After comparing these two models, the object-relational model is adopted. After confirming the model is adopted, this paper researches this model in detail, including a object type SDO_GEOMETRY used to store spatial data, concrete meaning of its every part and metadata. The metadata are used to describe the information of geometry. The functions of every component of the metadata are studied too. On the basis of this, the storing of several representative geometry using this object type is studied in this paper. Oracle Spatial supplies two kinds of Indexing of Spatial data, which are R-tree Indexing and Quadtree Indexing.After comparing their advantage and disadvantage, Quadtree Indexing is adopted in this paper.After researching Oracle Spatial technology, this paper sets about to load spatial data into Oracle dababase. For this reason, this paper compares two kinds of tools used to load sptial data, which are SQLLDR supplied by Oracle and EasyLoader supplied by MapInfo. On the basis of this, this paper selects EasyLoader as loading tool and loads the map data of Maplnfo form into Oracle database with this tool.Finally, this paper researches the query mechanism of Oracle Spatial and some important query operators. At the same time, this paper realizes the query of the spatial data in Oracle database using these operatorsJava is adopted as developing tool in this paper.There are two ways of linking Java to Oracle Database,which are JDBC and SQLJ.The way of JDBC is adopted in this paper.After the researching of JDBC'soperation principle ,this paper researches the flow of realizing query with JDBC in details. Three kinds of basic query using JDBC and the query operators of Oracle Spatia are realized in this paper, which are also several kinds of very basic query in GIS.