%0 Journal Article
%T Research on Realizing Spatial-temporal Database Based on Historical Relational Database<br>基于历史关系数据库的时空数据库实现研究
%A 黄勇奇
%A 崔伟宏
%J 遥感学报
%D 2008
%I 
%X Spatial-temporal database researcheson how to store historicaland currentspatial-temporaldata so as to track and analyze changes of some region, which finally mi plements spatial-temporal modeling and geographical smi ulation process. Atpresent there aremainly two solutions as for spatio-temporal database. The one is adding tmi e dmi ension on the basis of spatial database. The other is extending spatial dmi ension on the basis of temporal database. The research on spatialdatabase has alreadybeenmature at the present tmi e. Sowe should fullymake use ofexisting spatial data model and spatial processing and analyzing functions of GIS, which will reduce enormously workload. Consequently this paper chooses to add tmi e dmi ension on the basis of spatial database. Extended relational spatio- temporal database extends tmi e dmi ension by considering tmi e as attribute ofspatialgeometry and thematic feature, which has its particular advantages. For one thing, relational database is supported by strict relational algebra and hasmany available large commercial relational databases. In addition, many information systems are originally established on the basis of relational database. In the second place many researches on temporal database itselfmostly adopt relational mode,l which extend temporal semantics for relational algebra and develop temporal structured query language. Thirdly many researches on spatial database in GIS domain also employ relational data mode,l and research on spatial query language is also based on relationalmode.l All in al,l spatial-temporal database adoptingmodel of historical relational database can make the best of research results and existing systems such as temporal query function of temporal relational database and spatial process and analysis function ofGIS, reducing the costof establishing spatial-temporal database. This paper at first introduces historical relational database mode,l temporal relational algebra and temporal query language, and then conducts researcheson historical relationaldatabase to organize temporal information in spatialdatabase. Ami ing at completely relational spatialdatabase, this papermakesuse of temporally upward compatible function ofATSQL2 and adopts themode of transplanting non-temporal database to temporal database to extend temporal information for spatial data. In the lightoforganizing principle ofspatio-temporaldata, currentdata and historicaldata are stored separately. As a result, spatio-temporaldatabase includes currentspatialdatabase and historical spatialdatabase. Currentdatabase stores the latestbase state version ofmap layers, yethistoricaldatabase storeshistoricalbase state version ofmap layers. Ifspatialdata and attribute data change, data ofnew versionwillbe added to currentspatialdatabase. At the same tmi e originaldatawill become data of old version and be shifted to historical spatial database. We can adopt indexing pointer to establish the relationship between current spatia
%K spatial-temporal database
%K completely relational spatial database
%K historical relational database
%K rotating<br>时空数据库
%K 全关系化空间数据库
%K 历史关系数据库
%K 轮作
%U http://www.alljournals.cn/get_abstract_url.aspx?pcid=E62459D214FD64A3C8082E4ED1ABABED5711027BBBDDD35B&cid=A41A70F4AB56AB1B&jid=F926358B31AC94511E4382C083F7683C&aid=E781612C911A08B4E9BEB612DF90943A&yid=67289AFF6305E306&vid=59906B3B2830C2C5&iid=94C357A881DFC066&journal_id=1007-4619&journal_name=遥感学报&referenced_num=0&reference_num=16