Selected papers of the 9th annual ACM SIGACT-SIGMOD-SIGART symposium on Principles of database systems
Point vs. interval-based query languages for temporal databases (extended abstract)
PODS '96 Proceedings of the fifteenth ACM SIGACT-SIGMOD-SIGART symposium on Principles of database systems
Advanced database systems
The DEDALE system for complex spatial queries
SIGMOD '98 Proceedings of the 1998 ACM SIGMOD international conference on Management of data
Spatio-temporal data handling with constraints
Proceedings of the 6th ACM international symposium on Advances in geographic information systems
A foundation for representing and querying moving objects
ACM Transactions on Database Systems (TODS)
Maintaining knowledge about temporal intervals
Communications of the ACM
The TSQL2 Temporal Query Language
The TSQL2 Temporal Query Language
The temporal query language TQuel
PODS '84 Proceedings of the 3rd ACM SIGACT-SIGMOD symposium on Principles of database systems
Realm-based spatial data types: the ROSE algebra
The VLDB Journal — The International Journal on Very Large Data Bases
Spatial SQL: A Query and Presentation Language
IEEE Transactions on Knowledge and Data Engineering
SQL Extension for Interval Data
IEEE Transactions on Knowledge and Data Engineering
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
Point-Versus Interval-Based Temporal Data Models
ICDE '98 Proceedings of the Fourteenth International Conference on Data Engineering
Constraint-Based Interoperability of Spatiotemporal Databases
SSD '97 Proceedings of the 5th International Symposium on Advances in Spatial Databases
A Geometric Framework for Specifying Spatiotemporal Objects
TIME '99 Proceedings of the Sixth International Workshop on Temporal Representation and Reasoning
Universal Temporal Extensions for Database Languages
ICDE '99 Proceedings of the 15th International Conference on Data Engineering
User Defined Aggregates in Object-Relational Systems
ICDE '00 Proceedings of the 16th International Conference on Data Engineering
Tripod: A Comprehensive Model for Spatial and Aspatial Historical Objects
ER '01 Proceedings of the 20th International Conference on Conceptual Modeling: Conceptual Modeling
A Theory of Spatio-Temporal Database Queries
DBPL '01 Revised Papers from the 8th International Workshop on Database Programming Languages
A multigranular spatiotemporal data model
GIS '03 Proceedings of the 11th ACM international symposium on Advances in geographic information systems
Time-dependent affine triangulation of spatio-temporal data
Proceedings of the 12th annual ACM international workshop on Geographic information systems
Spatiotemporal Aggregate Computation: A Survey
IEEE Transactions on Knowledge and Data Engineering
SQL extension for spatio-temporal data
The VLDB Journal — The International Journal on Very Large Data Bases
Efficient data modeling and querying system for multi-dimensional spatial data
Proceedings of the 16th ACM SIGSPATIAL international conference on Advances in geographic information systems
Geometrically Enhanced Conceptual Modelling
ER '09 Proceedings of the 28th International Conference on Conceptual Modeling
A spatio-temporal approach to the discovery of online social trends
COCOA'11 Proceedings of the 5th international conference on Combinatorial optimization and applications
The vehicle tracking system for analyzing transportation vehicle information
APWeb'06 Proceedings of the 2006 international conference on Advanced Web and Network Technologies, and Applications
An object-relational approach to the representation of multi-granular spatio-temporal data
CAiSE'05 Proceedings of the 17th international conference on Advanced Information Systems Engineering
Querying multiple video streams and hypermedia objects of a video-based virtual space system
Digital Cities'03 Proceedings of the Third international conference on Information Technologies for Social Capital: cross-Cultural Perspectives
On the semantics of ST4SQL, a multidimensional spatio-temporal query language
Proceedings of the 16th International Database Engineering & Applications Sysmposium
Hi-index | 0.00 |
In this paper, we propose a query language and data model for spatio-temporal information, including objects of time-changing geometry. Our objective is to minimize the extensions required in SQL, or other relational languages, to support spatio-temporal queries. We build on the model proposed by Worboys where each state of a spatial object is captured as a snapshot of time; then, we use a directed-triangulation model to represent spatial data, and a point-based model to represent time at the conceptual level. Spatio-temporal reasoning and queries can be fully expressed with no new constructs, but user-defined aggregates, such as area and inside for spatial relationships, duration and contain for temporal ones, and moving distance for spatio-temporal ones. We also consider the implementation problem under the assumption that, for performance reasons, the representation at the physical level can be totally different from the conceptual one. Thus, alternative physical representations and mappings between conceptual and physical representations are discussed.