Querying now-relative data

Now-relative temporal data play an important role in most temporal applications, and their management has been proved to impact in a crucial way the efficiency of temporal databases. Though several temporal relational approaches have been developed to deal with now-relative data, none of them has provided a whole temporal algebra to query them. In this paper we overcome such a limitation, by proposing a general algebra which is parametrically adapted to cope with the relational approaches to now-relative data in the literature, i.e., MIN, MAX, NULL and POINT approaches. Besides being general enough to provide a query language for several approaches in the literature, our algebra has been designed in such a way to satisfy several theoretical and practical desiderata: closure with respect to representation languages, correctness with respect to the “consensus” BCDM semantics, reducibility to the standard non-temporal algebra (which involves interoperability with non-temporal relational databases), implementability and efficiency. Indeed, the experimental evaluation we have drawn on our implementation has shown that only a slight overhead is added by our treatment of now-relative data (with respect to an approach in which such data are not present).

[1]  Abdul Sattar,et al.  Advanced indexing technique for temporal data , 2010, Comput. Sci. Inf. Syst..

[2]  Richard T. Snodgrass,et al.  The temporal query language TQuel , 1987, TODS.

[3]  Curtis E. Dyreson Temporal coalescing with now granularity, and incomplete information , 2003, SIGMOD '03.

[4]  Tesfa Tegegne Asfaw,et al.  Student use of Internet in China: A study on Huazhong University of Science and Technology (HUST) , 2003 .

[5]  Shirley Dex,et al.  JR 旅客販売総合システム(マルス)における運用及び管理について , 1991 .

[6]  Walid G. Aref,et al.  Spatio-Temporal Access Methods , 2003, IEEE Data Eng. Bull..

[7]  Ling Liu,et al.  Encyclopedia of Database Systems , 2009, Encyclopedia of Database Systems.

[8]  Christian S. Jensen,et al.  On the semantics of “now” in databases , 1996, TODS.

[9]  Abdul Sattar,et al.  Indexing Temporal Data with Virtual Structure , 2010, ADBIS.

[10]  Christian S. Jensen,et al.  Indexing of now-relative spatio-bitemporal data , 2002, The VLDB Journal.

[11]  Christian S. Jensen,et al.  Layered Temporal DBMS: Concepts and Techniques , 1997, DASFAA.

[12]  Kenneth N. Creem A Comparison of Approaches to Modeling NOW in Bitemporal Databases , 2005 .

[13]  Michael H. Böhlen,et al.  A split operator for now-relative bitemporal databases , 2001, Proceedings 17th International Conference on Data Engineering.

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

[15]  E. F. Codd,et al.  Relational Completeness of Data Base Sublanguages , 1972, Research Report / RJ / IBM / San Jose, California.

[16]  Alan R. Simon,et al.  Sql: 1999 Understanding Relational Language Components , 2002 .

[17]  Christian S. Jensen,et al.  On the Semantics of , 1996 .

[18]  Volker Markl,et al.  Interval processing with the UB-Tree , 2002, Proceedings International Database Engineering and Applications Symposium.

[19]  Abdul Sattar,et al.  The POINT approach to represent now in bitemporal databases , 2009, Journal of Intelligent Information Systems.

[20]  Richard T. Snodgrass,et al.  Coalescing in Temporal Databases , 1996, VLDB.

[21]  Christian S. Jensen,et al.  Temporal Data Management , 1999, IEEE Trans. Knowl. Data Eng..

[22]  Abdul Sattar,et al.  A novel approach to model NOW in temporal databases , 2003, 10th International Symposium on Temporal Representation and Reasoning, 2003 and Fourth International Conference on Temporal Logic. Proceedings..

[23]  Richard T. Snodgrass,et al.  Evaluation of relational algebras incorporating the time dimension in databases , 1991, CSUR.

[24]  Sushil Jajodia,et al.  Temporal Database Bibliography Update , 1997, Temporal Databases, Dagstuhl.

[25]  Chengjie Mao,et al.  Temporal Data Model and Temporal Database Systems , 2010 .

[26]  Christos H. Papadimitriou,et al.  On the analysis of indexing schemes , 1997, PODS '97.

[27]  Hong Lin,et al.  Layered Implementation of Temporal DBMSs|Concepts and Techniques , 2007 .

[28]  David B. Lomet,et al.  Transaction time indexing with version compression , 2008, Proc. VLDB Endow..

[29]  Amit P. Sheth,et al.  Semantic (Web) Technology In Action: Ontology Driven Information Systems for Search, Integration and Analysis , 2003, IEEE Data Eng. Bull..

[30]  Christian S. Jensen,et al.  Semantics of Time-Varying Information , 1996, Inf. Syst..

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

[32]  Arbee L. P. Chen,et al.  Proceedings of the Sixth International Conference on Database Systems for Advanced Applications , 1999 .

[33]  Hans-Peter Kriegel,et al.  Managing Intervals Efficiently in Object-Relational Databases , 2000, VLDB.

[34]  Xiaoping Ye,et al.  Temporal Information Processing Technology and Its Applications , 2011 .

[35]  Chengqi Zhang,et al.  Modeling Temporal Semantics of Data , 2003 .

[36]  Christian S. Jensen,et al.  Transaction Timestamping in (Temporal) Databases , 2001, VLDB.

[37]  Christian S. Jensen,et al.  Effective timestamping in databases , 2000, The VLDB Journal.

[38]  Christian S. Jensen,et al.  Now in Temporal Databases , 2009, Encyclopedia of Database Systems.

[39]  Walid G. Aref,et al.  Spatio-Temporal Access Methods: Part 2 (2003 - 2010) , 2010, IEEE Data Eng. Bull..

[40]  Christian S. Jensen,et al.  Modi � cation Semantics in Now Relative Databases , 1999 .

[41]  Chun Zhang,et al.  Storing and querying ordered XML using a relational database system , 2002, SIGMOD '02.

[42]  Deborah S. Franzblau,et al.  An algorithm for the difference between set covers , 2008, Discret. Appl. Math..

[43]  Gultekin Özsoyoglu,et al.  Temporal and Real-Time Databases: A Survey , 1995, IEEE Trans. Knowl. Data Eng..

[44]  Connolly,et al.  Database Systems , 2004 .

[45]  Richard T. Snodgrass,et al.  Developing Time-Oriented Database Applications in SQL , 1999 .