Modification semantics in now-relative databases

Information Systems

Volumn 29, Issue 8, 2004, Pages 653-683

  Torp, Kristian ^a   Jensen, Christian S ^a   Snodgrass, Richard T ^b  

^a AALBORG UNIVERSITY   (Denmark)

^b University of Arizona   (United States)

Author keywords

Now; Now relative information; SQL; Temporal data; Temporal query language; Updates

Indexed keywords

COMPUTATIONAL COMPLEXITY; DATA STRUCTURES; ENCODING (SYMBOLS); INDEXING (OF INFORMATION); RELATIONAL DATABASE SYSTEMS; SEMANTICS;

NOW-RELATIVE INFORMATION; SQL; TEMPORAL DATA; TEMPORAL QUERY LANGUAGE;

QUERY LANGUAGES;

EID: 3342894932     PISSN: 03064379     EISSN: None     Source Type: Journal    
DOI: 10.1016/S0306-4379(03)00047-4     Document Type: Article

References (28)

1. J. Melton, A.R. Simon, Understanding the New SQL: A Complete Guide, Morgan Kaufmann Publishers, Los Altos, CA, 1993.
2. Snodgrass R.T. Developing Time-Oriented Database Applications in SQL. 1999;Morgan Kaufmann Publishers, Los Altos, CA.
3. Clifford J., Dyreson C.E., Isakowitz T., Jensen C.S., Snodgrass R.T. On the semantics of "NOW" in databases. ACM Trans. Database Systems. 22(2):1997;171-214.
4. M. Finger, P. McBrien, On the semantics of 'Current-Time' in temporal databases, in: Proceedings of the 11th Brazilian Symposium on Databases, Sao Carlos, Brazil, 1996, pp. 324-337.
5. S.K. Gadia, S. Nair, Temporal Databases: A Prelude to Parametric Data, Vol. 26, pp. 28-66 (Chapter 2). In A. Tansel, J. Clifford, S. Gadia, S. Jajodia, A. Segev, R.T. Snodgrass (Eds.), Temporal Databases: Theory, Design, and Implementation, Benjamin/Cummings, Menlo Park, CA, 1993.
6. S. Navathe, R. Ahmed, Temporal Extensions to the Relational Model and SQL, Vol. 26, pp. 92-109 (Chapter 4). In A. Tansel, J. Clifford, S. Gadia, S. Jajodia, A. Segev, R.T. Snodgrass (Eds.), Temporal Databases: Theory, Design, and Implementation, Benjamin/Cummings, Menlo Park, CA, 1993.
7. K. Torp, C.S. Jensen, R.T. Snodgrass, Modification semantics in now-relative databases, TIME CENTER Technical Report TR-43, September 1999.
8. C.S. Jensen, C.E. Dyreson (Eds.), The Consensus Glossary of Temporal Database Concepts - February 1998 Version, Vol. 10, pp. 367-405. In O. Etzion, S. Jajodia, S. Sripada (Eds.), Temporal Databases: Research and Practice, Lectures Notes in Computer Science, Vol. 1399, Springer, Berlin, 1998.
9. C.S. Jensen, C.E. Dyreson (Eds.), The Consensus Glossary of Temporal Database Concepts - February 1998 Version, Vol. 10, pp. 367-405. In O. Etzion, S. Jajodia, S. Sripada (Eds.), Temporal Databases: Research and Practice, Lectures Notes in Computer Science, Vol. 1399, Springer, Berlin, 1998.
10. Ahn I., Snodgrass R.T. Partitioned storage for temporal databases. Inf. Systems. 13(4):1988;369-391.
11. R.T. Snodgrass (Ed.), I. Ahn, G. Ariav, D. Batory, J. Clifford, C.E. Dyreson, R. Elmasri, F. Grandi, C.S. Jensen, W. Käfer, N. Kline, K. Kulkarni, T.Y.C. Leung, N. Lorentzos, J.F. Roddick, A. Segev, M.D. Soo, S.M. Sripada, The TSQL2 Temporal Query Language, Kluwer Academic Publishers, Dordrecht, 1995.
12. Böhlen M., Jensen C.S., Snodgrass R.T. Temporal statement modifiers. ACM Trans. Database Systems. 25(4):2000;407-456.
13. Snodgrass R.T. The temporal query language TQuel. ACM Trans. Database Systems. 12(2):1987;247-298.
14. M.H. Böhlen, R.T. Snodgrass, M.D. Soo, Coalescing in temporal databases, in: Proceedings of the Conference on Very Large Databases, Bombay, India, 1996, pp. 180-191.
15. R.T. Snodgrass, M.H. Böhlen, C.S. Jensen, A. Steiner, Adding valid time to SQL/temporal. ANSI X3H2-96-501r2, ISO/IEC JTC 1/SC 21/WG 3 DBL-MAD-146r2, November 1996.
16. Bair J., Böhlen M., Jensen C.S., Snodgrass R.T. Notions of upward compatibility of temporal query languages. Wirtsch. Infor. 39(1):1997;25-34.
17. J. Clifford, T. Isakowitz, On the semantics of (bi)temporal variable databases, in: Proceedings of the International Conference on Extending Database Technology, Cambridge, UK, 1994, pp. 215-230.
18. Jensen C.S., Snodgrass R.T. Temporal specialization and generalization. IEEE Trans. Knowledge Data Eng. 6(6):1994;954-974.
19. K. Torp, C.S. Jensen, M.H. Böhlen, Layered implementation of temporal DBMSs - concepts and techniques, in: Proceedings of the DASFAA Conference, Melbourne, Australia, 1997, pp. 371-380.
20. Melton J. Understanding SQL's Stored Procedures: A Complete Guide to SQL/PSM. 1998;Morgan Kaufmann Publishers, Los Altos, CA.
21. Lorentzos N., Manolopoulos Y. SQL extension for interval data. IEEE Trans. Knowledge Data Eng. 9(3):1997;480-499.
22. M. Finger, P. McBrien, Concurrency control for perceivedly instantaneous transactions in valid-time databases, in: Proceedings of the Fourth International Workshop on Temporal Representation and Reasoning, Daytona Beach, FL, 1997, pp. 112-118.
23. Torp K., Jensen C.S., Snodgrass R.T. Effective timestamping in databases. VLDB J. 8(3+4):2000;267-288.
24. H.-P. Kriegel, M. Pötke, T. Seidl, Managing intervals efficiently in object-relational databases, in: Proceedings of International Conference on Very Large Data Bases, Cairo, Egypt, 2000, pp. 407-418.
25. R. Bliujute, C.S. Jensen, S. Šaltenis, G. Slivinskas, R-tree based indexing of now-relative bitemporal data, in: Proceedings of the Conference on Very Large Databases, New York city, NY, 1998, pp. 345-356.
26. R. Bliujute, C.S. Jensen, S. Šaltenis, G. Slivinskas, Light-weight indexing of bitemporal data, in: Proceedings of the International Conference on Scientific and Statistical Database Management, Berlin, Germany, 2000, pp. 125-138.
27. Šaltenis S., Jensen C.S. Indexing of now-relative spatio-bitemporal data. VLDB J. 11(1):2002;1-16.
28. Allen J.F. Maintaining knowledge about temporal intervals. CACM. 26(11):1983;832-843.