The design and realization of a socio-economic statistical spatio-temporal database

This paper aims to introduce a case of Socio-economic statistical Spatio-temporal Database. This database system services in the rural socio-economic statistical work, which is a combination of statistical tables, spatial data, search algorithm and maintenance interface. Administrative codes are the conjunction media of spatial data and attribute data, and also are the key words of database query processing. Through storing the changing information in the database, it could reflect the change of administrative divisions. As the main issues of database design, the studying of the approach to recording and querying these changes as well as the processing of statistical data by the rules of administrative divisions changes, requires a large amount of research work. To address these problems, a series of management analysis tools have been developed to deal with the processing of socio-economic statistical data with changes in the administrative division. A searching algorithm of spatio-temporal database is used to ensure the comparability of the results, which are acquired by the positive sequence and the anti-sequence temporal query under complex spatial changes in the administrative division. According to the spatial changes, searching algorithm of spatio-temporal database mainly translates temporal series statistical data into standard format data which is matched to the benchmark year. The searching algorithm controls the process of inquiry through recursion of the table of the administrative code changes, which are composed of multi-way tree structure and double linked list and record the relationship between upper and lower level administrative units. These search algorithms and meta-data storage structures constitute the spatio-temporal database, so as to serve the spatial analysis of statistical data. The comparability problem mentioned above was well solved by this approach. And a set of functions was provided by this system with spatio-temporal database, such as specialization of statistical data, temporal query, spatial data which can be automatically updated, and maintenance interface.