Construction Of Right To Use Rural House Sites Database Based On Oracle And ArcSDE

The Right To Use Rural House Sites involves the vital interests of the broad masses of farmers. How to bring about the informatization management of Right To Use Rural House Sites, which is the important measures of according to law to protect the owners’ legitimate rights of Right To Use Rural House Sites and strengthening the management of rural land. With the development of computer technology and GIS technology, using spatial database technology to realize the organization, management and application of cadastral information data of Right To Use Rural House Sites, become the inevitable demand of the rural collective land management and rural economic development.This paper launch reports around the database construction of Right To Use Rural House Sites.Firstly, the paper introduces the research actuality of the rural cadastral information system at home and abroad, and the related theory and technology of Relational DataBase Oracle, Spatial Data Engine ArcSDE and Database Query Language SQL.Secondly, in order to guarantee the quality of basic data for the database construction of Right To Use Rural House Sites, the related content of Right To Use Rural House Sites survey work is expounded, then putting forward the quality control method of the investigation and the process of the construction of cadastral data. Combining with the theory and technology above mentioned, to analyse the data of Right To Use Rural House Sites database, and present the process of the realization of data storage, organization and management based on Oracle and ArcSDE platform, and the flow of the construction of database, and put forward the concrete implementation steps. Five key problem and methods in the process of database construction are discussed: data format conversion, topological checking methods of data, perfecting the value of data’s attributes, the method of optimizing for the performance of ArcSDE(creating Spatial Index) and the auxiliary method of the construction of Oracle database using the SELECT statements.Finally, combining with the actual land based data as an example, using the methods above mentioned, successfully completed the construction of the Right To Use Rural House Sites Database.