Open AccessIntegrating Spatial and Temporal Relationship Operators into SQL3 for Historical Data Management
Author(s) -
Lee JongYun
Publication year - 2002
Publication title -
etri journal
Language(s) - English
Resource type - Journals
SCImago Journal Rank - 0.295
H-Index - 46
eISSN - 2233-7326
pISSN - 1225-6463
DOI - 10.4218/etrij.02.0102.0307
Subject(s) - temporal database , operator (biology) , computer science , spatial analysis , data mining , object (grammar) , spatiotemporal database , spatial relationship , aggregate (composite) , geography , database design , artificial intelligence , remote sensing , database schema , biochemistry , chemistry , repressor , transcription factor , database testing , gene , materials science , composite material
A spatial object changes its states over time. However, existing spatial and temporal database systems cannot fully manage time‐varying data with both spatial and nonspatial attributes. To overcome this limitation, we present a framework for spatio‐temporal databases that can manage all time‐varying historical information and integrate spatial and temporal relationship operators into the select statement in SQL3. For the purpose of our framework, we define three referencing macros and a history aggregate operator and classify the existing spatial and temporal relationship operators into three groups: exclusively spatial relationship operators, exclusively temporal relationship operators, and spatio‐temporal common relationship operators. Finally, we believe the integration of spatial and temporal relationship operators into SQL3 will provide a useful framework for the history management of time‐varying spatial objects in a uniform manner.