Spatio-temporal Models and Languages: An Approach Based on Constraints

The introduction of spatio-temporal information in database systems presents us with an important data modelling challenge: the design of data models general and powerful enough to handle conventional thematic data, purely temporal or spatial concepts and spatio-temporal concepts. General purpose DBMS (e.g., relational) are not appropriate for storing and manipulating spatio-temporal data because of the complex structure of temporal and geometric information and the intricate temporal and spatial relationships among sets of related objects. Moreover, the costly operations involved in temporal and spatial object management seem at first glance to prevent the logical-level approach based on simple data structures (e.g., relations) manipulated through a limited set of simple operations (e.g., relational algebra). In the temporal world the main research trend has therefore been to introduce a variety of temporal data models with new temporal operations, and then worry about the semantics and appropriateness of these operations [45,44]. Similarly, in the spatial world the main approach has been to introduce extensions of conventional database models with abstract spatial data types encapsulating geometric structures and operations (see for example [39,35,40,19,20]). Chapter 4 of this book follows this school of thought for the modeling and querying of spatio-temporal information. Similarly, in the commercial world, DBMS such as Oracle [21] and Illustra [47] provide in their latest version separate modules devoted to temporal and spatial data. In this chapter we take an approach that differs significantly from the trends outlined above. We notice that the abstract data type approach lacks uniformity for the representation of data. To avoid this, we adopt the constraint data model, first introduced by Kanellakis, Kuper, and Revesz [25,33], and show that it is a very successful paradigm for the representation of spatio-temporal data in a unified framework. The constraint data model allows a uniform representation of all kinds of information present in spatio-temporal applications, and supports declarative query languages well-suited for complex spatio-temporal queries. Contrary to the temporal and spatial data models mentioned above, it also enables the straightforward modeling of indefinite information, a feature particularly useful in many spatio-temporal applications.

[1]  Gabriel M. Kuper,et al.  Constraint Query Languages , 1995, J. Comput. Syst. Sci..

[2]  Peter Z. Revesz,et al.  The MLPQ/GIS constraint database system , 2000, SIGMOD 2000.

[3]  Gösta Grahne,et al.  The Problem of Incomplete Information in Relational Databases , 1991, Lecture Notes in Computer Science.

[4]  Spiros Skiadopoulos,et al.  Tractable Query Answering in Indefinite Constraint Databases: Basic Results and Applications to Querying Spatiotemporal Information , 1999, Spatio-Temporal Database Management.

[5]  Manolis Koubarakis,et al.  Database models for infinite and indefinite temporal information , 1994, Inf. Syst..

[6]  Jia Chen,et al.  The CCUBE Constraint Object-Oriented Database System , 1999, SIGMOD '99.

[7]  Jan Chomicki,et al.  A geometric framework for specifying spatiotemporal objects , 1999, Proceedings. Sixth International Workshop on Temporal Representation and Reasoning. TIME-99.

[8]  Christian S. Jensen,et al.  Spatio-Temporal Database Management , 1999, Lecture Notes in Computer Science.

[9]  Gabriel M. Kuper,et al.  A constrant-based spatial extension to SQL , 1998, GIS '98.

[10]  Christos Faloutsos,et al.  An Efficient Pictorial Database System for PSQL , 1988, IEEE Trans. Software Eng..

[11]  Max J. Egenhofer,et al.  Advances in Spatial Databases , 1997, Lecture Notes in Computer Science.

[12]  Max J. Cresswell,et al.  A New Introduction to Modal Logic , 1998 .

[13]  Manolis Koubarakis Foundations of Indefinite Constraint Databases , 1994, PPCP.

[14]  Catriel Beeri,et al.  Data Models and Languages for Databases , 1988, ICDT.

[15]  Peter Z. Revesz,et al.  Parametric Rectangles: A Model for Querying and Animation of Spatiotemporal Databases , 2000, EDBT.

[16]  Richard T. Snodgrass,et al.  The TSQL2 Temporal Query Language , 1995 .

[17]  Manolis Koubarakis,et al.  The Complexity of Query Evaluation in Indefinite Temporal Constraint Databases , 1997, Theor. Comput. Sci..

[18]  A. Prasad Sistla,et al.  Modeling and querying moving objects , 1997, Proceedings 13th International Conference on Data Engineering.

[19]  Terence R. Smith,et al.  Design and Implementation of Large Spatial Databases , 1989, Lecture Notes in Computer Science.

[20]  Alexander Schrijver,et al.  Theory of linear and integer programming , 1986, Wiley-Interscience series in discrete mathematics and optimization.

[21]  Sushil Jajodia,et al.  Temporal Databases: Theory, Design, and Implementation , 1993 .

[22]  Ralf Hartmut Güting,et al.  Gral: An Extensible Relational Database System for Geometric Applications , 1989, VLDB.

[23]  Alexander Brodsky,et al.  The C3 Constraint Object-Oriented Database System: An Overview , 1997, CDB.

[24]  Michael Ubell,et al.  The Montage extensible DataBlade architecture , 1994, SIGMOD '94.

[25]  Pierre-Claude Scholl,et al.  Un modèle d'historique pour un SGBD temporel , 1998 .

[26]  Jianwen Su,et al.  Linear Constraint Query Languages: Expressive Power and Complexity , 1994, LCC.

[27]  Jan Paredaens,et al.  Towards a theory of spatial database queries (extended abstract) , 1994, PODS.

[28]  Gabriel M. Kuper,et al.  Constraint Databases , 2010, Springer Berlin Heidelberg.

[29]  Manolis Koubarakis,et al.  Databases and Temporal Constraints: Semantics and Complexity , 1995, Temporal Databases.

[30]  Stéphane Grumbach,et al.  The DEDALE system for complex spatial queries , 1998, SIGMOD '98.

[31]  Mehmet A. Orgun,et al.  ON TEMPORAL DEDUCTIVE DATABASES , 1996, Comput. Intell..

[32]  Jan Chomicki,et al.  Animating Spatiotemporal Constraint Databases , 1999, Spatio-Temporal Database Management.

[33]  Frank Manola,et al.  PROBE Spatial Data Modeling and Query Processing in an Image Database Application , 1988, IEEE Trans. Software Eng..

[34]  Agnès Voisard,et al.  Thematic Map Modeling , 1989, SSD.

[35]  Jan Chomicki,et al.  Constraint-Based Interoperability of Spatiotemporal Databases , 1997, SSD.

[36]  Daniel Leivant,et al.  Logic and Computational Complexity , 1995, Lecture Notes in Computer Science.

[37]  Peter Z. Revesz,et al.  A Closed-Form Evaluation for Datalog Queries with Integer (Gap)-Order Constraints , 1993, Theor. Comput. Sci..

[38]  Stéphane Grumbach,et al.  On the Orthographic Dimension of Constraint Databases , 1999, ICDT.

[39]  Michel Scholl,et al.  DEDALE, A Spatial Constraint Database , 1997, DBPL.

[40]  Manolis Koubarakis,et al.  Representation and querying in temporal databases: the power of temporal constraints , 1993, Proceedings of IEEE 9th International Conference on Data Engineering.

[41]  Rina Dechter,et al.  Temporal Constraint Networks , 1989, Artif. Intell..

[42]  Pierre Wolper,et al.  Handling infinite temporal data , 1990, PODS.

[43]  Ralf Hartmut Güting,et al.  Realm-based spatial data types: The ROSE algebra , 1995, The VLDB Journal.

[44]  Peter C. Lockemann,et al.  Advances in Database Technology — EDBT 2000 , 2000, Lecture Notes in Computer Science.

[45]  Jan Chomicki,et al.  Constraint-based Interoperability of Spatiotemporal Databases* , 1999, GeoInformatica.

[46]  Jan Chomicki,et al.  Datalog with Integer Periodicity Constraints , 1994, J. Log. Program..

[47]  Spiros Skiadopoulos,et al.  Querying Temporal Constraint Networks in PTIME , 1999, AAAI/IAAI.

[48]  Tomasz Imielinski,et al.  Incomplete Information in Relational Databases , 1984, JACM.

[49]  Marie-Christine Fauvet,et al.  Handling temporal grouping and pattern-matching queries in a temporal object model , 1998, CIKM '98.

[50]  Elisa Bertino,et al.  Manipulating Spatial Data in Constraint Databases , 1997, SSD.

[51]  Elisa Bertino,et al.  An Extended Algebra for Constraint Databases , 1998, IEEE Trans. Knowl. Data Eng..

[52]  Gabriel M. Kuper,et al.  Constraint query languages (preliminary report) , 1990, PODS '90.