Abstract and discrete modeling of spatio-temporal data types
Proceedings of the 6th ACM international symposium on Advances in geographic information systems
Developing time-oriented database applications in SQL
Developing time-oriented database applications in SQL
A data model and data structures for moving objects databases
SIGMOD '00 Proceedings of the 2000 ACM SIGMOD international conference on Management of data
A foundation for representing and querying moving objects
ACM Transactions on Database Systems (TODS)
A relational model of data for large shared data banks
Communications of the ACM
The TSQL2 Temporal Query Language
The TSQL2 Temporal Query Language
Time Granularities in Databases, Data Mining and Temporal Reasoning
Time Granularities in Databases, Data Mining and Temporal Reasoning
Supporting User-Defined Granularities in a Spatiotemporal Conceptual Model
Annals of Mathematics and Artificial Intelligence
An introduction to spatial database systems
The VLDB Journal — The International Journal on Very Large Data Bases - Spatial Database Systems
SQL Extension for Interval Data
IEEE Transactions on Knowledge and Data Engineering
Point-Based Temporal Extension of Temporal SQL
DOOD '97 Proceedings of the 5th International Conference on Deductive and Object-Oriented Databases
Using SQL to Build New Aggregates and Extenders for Object- Relational Systems
VLDB '00 Proceedings of the 26th International Conference on Very Large Data Bases
Temporal Objects for Spatio-Temporal Data Models and a Comparison of Their Representations
ER '98 Proceedings of the Workshops on Data Warehousing and Data Mining: Advances in Database Technologies
User Defined Aggregates in Object-Relational Systems
ICDE '00 Proceedings of the 16th International Conference on Data Engineering
An Introduction to Database Systems
An Introduction to Database Systems
A multigranular spatiotemporal data model
GIS '03 Proceedings of the 11th ACM international symposium on Advances in geographic information systems
ACM SIGMOD Record
Fundamentals of Database Systems, Fourth Edition
Fundamentals of Database Systems, Fourth Edition
SQLST: a spatio-temporal data model and query language
ER'00 Proceedings of the 19th international conference on Conceptual modeling
Formal and conceptual modeling of spatio-temporal granularities
IDEAS '09 Proceedings of the 2009 International Database Engineering & Applications Symposium
| Hi-index | 0.00 |
The notion of spatio-temporal multi-granularity is fundamental when modeling objects in GIS applications in that it supports the representation of the temporal evolutions of these objects. Concepts and issues in multi-granular spatio-temporal representations have been widely investigated by the research community. However, despite the large number of theoretical investigations, no comprehensive approaches, have been proposed dealing with the representation of multi-granular spatio-temporal objects in commercially available DBMSs. The goal of the work that we report in this paper is to address this gap. To achieve it, the paper first introduces an object-relational model based on OpenGis specifications described in SQL3. Several extensions are developed in order to improve the semantics and behavior for spatio-temporal data types introducing an approach to represent the temporal dimension in this model and the multi-representation of spatio-temporal granularities.