A Spatial Database Management System for Urban and Rural Planning

Abstract

The data management of urban and rural planning is very important and special. It is quite necessary to customize a thematic database system for urban and rural planning. According to their characteristics and classifications, the requirements of this system are firstly analyzed in this paper. With the integration of traditional relation database management system and geographical information system, an extendable data model for this thematic database is proposed. In this model, Client/Server architecture is adopted, Oracle is extended to store both attribute data and spatial data, and spatial database engine is utilized to access the spatial data in Oracle. At the client side, some functional modules such as data import and export, browse and display, query and retrieval, update and maintain, and security management are designed and developed. Finally, a case study of the thematic database system is applied. It is concluded that the customized spatial database management system for urban and rural planning is not only able to unify and store all types of data, but also able to improve the efficiency and visualization.