Design and construction of Spatial Decision Support System database based on metadata

Abstract

The Spatial Decision Support System (SDSS), as an emerging field of science and technology, is combined by Geographic Information System (GIS) and decision support system (DSS). Nowadays, more and more attentions have been paid to the technology of SDSS, and the construction of geographic database in SDSS has been a hot-spot for many years. One of the commonly used methods in geographical data management is directly entry spatial and attributes information into the relational database (generally used the Oracle relational database). Metadata plays an important role in process of building and in spatial data management. A case study is introduced. The Beijing Rural Resource Management Geographical Information System (BJRMGIS) is designed for the Beijing Agricultural Research Center, aiming for rural spatial decision support to facilitate its analysis operations. The paper mainly contains two parts from the viewpoint of database, that is, the design of database metadata table and the function of database maintenance. (1) The frame of metadata. According to report of needs analysis, the data in BJRMGIS are classified into four categories: fundamental data, remotely sensed image data, statistical data and multimedia data. Moreover, the map is a special form of data. (2) The database maintenance functions include three modules, that is, user management, database import and database management. This paper put forward the metadata-based database management decision support system model, and process from the practical problems to solve the applications. Also, the construction provides a reference for designing of other similar SDSS systems.