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.
|