A temporally oriented data model
ACM Transactions on Database Systems (TODS)
Adding time dimension to relational model and extending relational algebra
Information Systems
SSD '90 Proceedings of the first symposium on Design and implementation of large spatial databases
Geographic applications: An experience with O2
Building an object-oriented database system
A pattern matching language for spatio-temporal databases
CIKM '94 Proceedings of the third international conference on Information and knowledge management
Manipulation operations for an interval-extended relational model
Data & Knowledge Engineering
Information Sciences: an International Journal
The DEDALE system for complex spatial queries
SIGMOD '98 Proceedings of the 1998 ACM SIGMOD international conference on Management of data
A constrant-based spatial extension to SQL
Proceedings of the 6th ACM international symposium on Advances in geographic information systems
On an algebra for historical relational databases: two views
SIGMOD '85 Proceedings of the 1985 ACM SIGMOD international conference on Management of data
Spatio-temporal database support for legacy applications
SAC '98 Proceedings of the 1998 ACM symposium on Applied Computing
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)
Query operations for moving objects database systems
Proceedings of the 8th ACM international symposium on Advances in geographic information systems
Formalization of temporal thematic map contents
Proceedings of the 9th ACM international symposium on Advances in geographic information systems
Algorithms for Graphics and Imag
Algorithms for Graphics and Imag
Topology in Raster and Vector Representation
Geoinformatica
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
An Efficient Pictorial Database System for PSQL
IEEE Transactions on Software Engineering
Geo-Relational Algebra: A Model and Query Language for Geometric Database Systems
EDBT '88 Proceedings of the International Conference on Extending Database Technology: Advances in Database Technology
Modeling and Querying Moving Objects
ICDE '97 Proceedings of the Thirteenth International Conference on Data Engineering
Manipulating Interpolated Data is Easier than You Thought
VLDB '00 Proceedings of the 26th International Conference on Very Large Data Bases
Geo-SAL: A Query Language for Spatial Data Analysis
SSD '91 Proceedings of the Second International Symposium on Advances in Spatial Databases
Strong Integration of Spatial Domains and Operators in a relational Database System
SSD '93 Proceedings of the Third International Symposium on Advances in Spatial Databases
Tripod: A Comprehensive Model for Spatial and Aspatial Historical Objects
ER '01 Proceedings of the 20th International Conference on Conceptual Modeling: Conceptual Modeling
Logical Data Modeling of SpatioTemporal Applications: Definitions and a Model
IDEAS '98 Proceedings of the 1998 International Symposium on Database Engineering & Applications
Temporal Data and the Relational Model
Temporal Data and the Relational Model
PCI'01 Proceedings of the 8th Panhellenic conference on Informatics
SQLST: a spatio-temporal data model and query language
ER'00 Proceedings of the 19th international conference on Conceptual modeling
The t4sql temporal query language
Proceedings of the sixteenth ACM conference on Conference on information and knowledge management
Data & Knowledge Engineering
A sensor observation service based on OGC specifications for a meteorological SDI in Galicia
ER'10 Proceedings of the 2010 international conference on Advances in conceptual modeling: applications and challenges
Representation and management of spatiotemporal data in object-relational databases
Proceedings of the 27th Annual ACM Symposium on Applied Computing
A spatiotemporal extension for dealing with moving objects with extent in Oracle 11g
ACM SIGAPP Applied Computing Review
On the semantics of ST4SQL, a multidimensional spatio-temporal query language
Proceedings of the 16th International Database Engineering & Applications Sysmposium
Hi-index | 0.01 |
An SQL extension is formalized for the management of spatio-temporal data, i.e. of spatial data that evolves with respect to time. The extension is dedicated to applications such as topography, cartography, and cadastral systems, hence it considers discrete changes both in space and in time. It is based on the rigid formalization of data types and of SQL constructs. Data types are defined in terms of time and spatial quanta. The SQL constructs are defined in terms of a kernel of few relational algebra operations, composed of the well-known operations of the 1NF model and of two more, Unfold and Fold. In conjunction with previous work, it enables the uniform management of 1NF structures that may contain not only spatio-temporal but also either purely temporal or purely spatial or conventional data. The syntax and semantics of the extension is fully consistent with the {SQL:2003} standard.