Temporal Statement Modifiers

ACM Transactions on Database Systems

Volumn 25, Issue 4, 2000, Pages 407-456

  Böhlen, Michael H ^a   Jensen, Christian S ^a   Snodgrass, Richard T ^b  

^a AALBORG UNIVERSITY   (Denmark)

^b University of Arizona   (United States)

Author keywords

ATSQL; Data description languages (DDL); Data manipulation languages (DML); H.2.3 Database management : Languages Query languages; H.2.4 Database management : Systems Relational databases; Languages; Query processing; Statement modifiers; Theory

Indexed keywords

EID: 0042260804     PISSN: 03625915     EISSN: None     Source Type: Journal    
DOI: 10.1145/377674.377665     Document Type: Article

References (54)

1. ALLEN, J. F. 1983. Maintaining knowledge about temporal intervals. Commun. ACM 26, 11 (Nov.), 832-843.
2. ARIAV, G. 1986. A temporally oriented data model. ACM Trans. Database Syst. 11, 4 (Dec.), 499-527.
3. BAIR, J., JENSEN, C. S., SNODGRASS, R. T., AND BOEHLEN, M. 1997. Notions of upward compatibility of temporal query languages. Business Inf. 39, 1 (Feb.), 25-34.
4. BHARGAVA, G. AND GADIA, S. K. 1993. Relational database systems with zero information loss. IEEE Trans. Knowl. Data Eng. 5, 1 (Feb.), 76-87.
5. BÖHLEN, M. H., BUSATTO, R., AND JENSEN, C. S. 1998a. Point- versus interval-based temporal data models. In Proceedings of the 14th IEEE International Conference on Data Engineering (Orlando, FL, Feb. 23-27). IEEE Computer Society Press, Los Alamitos, CA, 192-200.
6. BÖHLEN, M. H., JENSEN, C. S., AND SKJELLAUG, B. 1998b. Spatio-temporal database support for legacy applications. In Proceedings of the 1998 ACM Symposium on Applied Computing (Atlanta, GA, Feb.). ACM Press, New York, NY, 226-234.
7. BÖHLEN, M. H. AND JENSEN, C. S. 1996. Seamless integration of time into SQL. Tech. Rep. R-96-2049. Aalborg Univ., Aalborg, Denmark.
8. BÖHLEN, M. H., SNODGRASS, R. T., AND SOO, M. D. 1996. Coalescing in temporal databases. In Proceedings of the 22nd International Conference on Very Large Data Bases (VLDB '96, Bombay, Sept.). Morgan Kaufmann Publishers Inc., San Francisco, CA, 180-191.
9. BÖHLEN, M. H., JENSEN, C. S., AND SNODGRASS, R. T. 1995. Evaluating the completeness of TSQL2. In Proceedings of the International Workshop on Recent Advances in Temporal Databases (Zurich, Sept.), S. Clifford and A. Tuzhlin, Eds. Springer-Verlag, New York, NY, 153-172.
10. BÖHLEN, M. AND MARTI, R. 1994. On the completeness of temporal database query languages. In Proceedings of the First International Conference on Temporal Logic (ICTL'94, Bonn, July). Springer-Verlag, Secaucus, NJ, 283-300.
11. BÖHLEN, M. 1994. Managing temporal knowledge in deductive databases. Ph.D. Dissertation. ETH, Zurich, Switzerland.
12. CATTELL, R. G. G., BARRY, D. K., BERLER, M., EASTMAN, J., JORDAN, D., RUSSELL, C., SCHADOW, O., STANIENDA, T., AND VELEZ, F. 2000. The Object Data Standard OMDG 3.0. Morgan Kaufmann Publishers Inc., San Francisco, CA.
13. CLIFFORD, J., CROKER, A., AND TUZHILIN, A. 1993. On the Completeness of Query Languages for Grouped and Ungrouped Historical Data Models. Benjamin/Cummings, Redwood City, CA.
14. CLIFFORD, J., DYRESON, C., ISAKOWITZ, T., JENSEN, C. S., AND SNODGRASS, R. T. 1997. On the semantics of NOW in databases. ACM Trans. Database Syst. 22, 2, 171-214.
15. CELKO, J. 1995. SQL for Smarties: Advanced SQL Programming. Morgan Kaufmann Publishers Inc., San Francisco, CA.
16. CERI, S. AND GOTTLOB, G. 1985. Translating SQL into relational algebra: Optimization, semantics, and equivalence of SQL queries. IEEE Trans. Softw. Eng. SE-11, 4 (Apr.), 324-345.
17. GADIA, S. K. AND BHARGAVA, G. 1993. SQL-like seamless query of temporal data. In Proceedings of the International Workshop on Infrastructure for Temporal Databases (Arlington, TX, June), R. T. Snodgrass, Ed.
18. GADIA, S. K. AND NAIR, S. S. 1993. Temporal databases: A prelude to parametric data. In Temporal Databases: Theory, Design, and Implementation, A. Tansel, J. Clifford, S. Gadia, S. Jajodia, A. Segev, and R. Snodgrass, Eds. Benjamin/Cummings, Redwood City, CA, 28-66.
19. GADIA, S. K. 1988. A homogeneous relational model and query languages for temporal databases. ACM Trans. Database Syst. 13, 4 (Dec.), 418-448.
20. GADIA, S. K. 1986. Weak temporal relations. In Proceedings of the ACM Symposium on Principles of Database Systems (PODS '86, Cambridge, MA). ACM Press, New York, NY.
21. DYRESON, C., GRANDI, F., KÄFER, W., KLINE, N., LORENTZOS, N., MITSOPOULOS, Y., MONTANARI, A., NONEN, D., PERESSI, E., PERNICI, B., RODDICK, J. F., SARDA, N. L., SCALAS, M. R., SEGEV, A., SNODGRASS, R. T., SOO, M. D., TANSEL, A., TIBERIO, P., AND WIEDERHOLD, G. 1994. A consensus glossary of temporal database concepts. SIGMOD Rec. 23, 1 (Mar.), 52-64.
22. JENSEN, C. S. AND SNODGRASS, R. T. 1999. Temporal data management. IEEE Trans. Knowl. Data Eng. 11, 1 (Jan./Feb.), 36-44.
23. JENSEN, C. S., SOO, M. D., AND SNODGRASS, R. T. 1994. Unifying temporal data models via a conceptual model. Inf. Syst. 19, 7 (Oct.), 513-547.
24. LORENTZOS, N. A. AND MITSOPOULOS, Y. G. 1997. SQL extension for interval data. IEEE Trans. Knowl. Data Eng. 9, 3 (May/June), 480-499.
25. MCKENZIE, L. E. AND SNODGRASS, R. T. 1991. Evaluation of relational algebras incorporating the time dimension in databases. ACM Comput. Surv. 23, 4 (Dec.), 501-543.
26. MELTON, J. 1999. Information technology, database languages, SQL.
27. MELTON, J. 1992. Information technology, database languages, SQL.
28. MELTON, J. AND SIMON, A. R. 1993. Understanding the New SQL: A Complete Guide. Morgan Kaufmann Series in Data Management Systems. Morgan Kaufmann Publishers Inc., San Francisco, CA.
29. NAIR, S. AND GADIA, S. 1993. Algebraic optimization in a relational model for temporal databases. In Proceedings of the International Workshop on Infrastructure for Temporal Databases (Arlington, TX, June), R. T. Snodgrass, Ed.
30. NAVATHE, S. B. AND AHMED, R. 1993. Temporal extensions to the relational model and SQL. In Temporal Databases: Theory, Design, and Implementation, A. Tansel, J. Clifford, S. Gadia, S. Jajodia, A. Segev, and R. Snodgrass, Eds. Benjamin/Cummings, Redwood City, CA, 92-109.
31. NAVATHE, S. B. AND AHMED, R. 1989. A temporal relational model and a query language. Inf. Sci. 49, 1, 2 & 3 (Oct./Nov./Dec.), 147-175.
32. NAVATHE, S. B. AND AHMED, R. 1987. TSQL-A language interface for history databases. In Proceedings of the Conference on Temporal Aspects in Information Systems (May). Assn. Francaise pour Cybern. Econ. Tech., Montreuil, France, 113-128.
33. SARDA, N. 1993. HSQL: A historical query language. In Temporal Databases: Theory, Design, and Implementation, A. Tansel, J. Clifford, S. Gadia, S. Jajodia, A. Segev, and R. Snodgrass, Eds. Benjamin/Cummings, Redwood City, CA, 110-140.
34. SARDA, N. L. 1990. Algebra and query language for a historical data model. Computer J. 33, 1 (Feb.), 11-18.
35. SCHUELER, B. 1977. Update reconsidered. In Architecture and Models in Data Base Management Systems, G. M. Nijssen, Ed. North-Holland Publishing Co., Amsterdam, The Netherlands.
36. SNODGRASS, R. T. 2000. Developing Time-Oriented Database Applications in SQL. Morgan Kaufmann Publishers Inc., San Francisco, CA.
37. SNODGRASS, R. T., BÖHLEN, M. H., JENSEN, C. S., AND STEINER, A. 1998. Transitioning temporal support in TSQL2 to SQL3. In Temporal Databases: Research and Practice: State-of-the-Art Survey, O. Etzion, S. Jajodia, and S. Sripada, Eds. Springer-Verlag, New York, NY, 150-194.
38. SNODGRASS, R. T., BÖHLEN, M. H., JENSEN, C. S., AND KLINE, N. 1996a. Adding valid time to SQL/Temporal. ANSI X3H2-96-501r2, ISO/IEC JTC1/SC21/WG3 DBL MAD-146r2.
39. SNODGRASS, R. T., BÖHLEN, H., JENSEN, S., AND STEINER, A. 1996b. Adding transaction time to SQL/Temporal: Temporal change proposal. ANSI X3H2-96-152r, ISO-;ANSI SQL/ISO/ IECJTC1/SC21/WG3 DBL MCI-143.
40. SNDOGRASS, R. T., ED. 1995. The TSQL2 Temporal Query Language. Kluwer Academic Publishers, Hingham, MA.
41. SNODGRASS, R. T. 1993. An overview of TQuel. In Temporal Databases: Theory, Design, and Implementation, A. Tansel, J. Clifford, S. Gadia, S. Jajodia, A. Segev, and R. Snodgrass, Eds. Benjamin/Cummings, Redwood City, CA, 141-182.
42. SNODGRASS, R. T. 1990. Temporal databases status and research directions. SIGMOD Rec. 19, 4 (Dec.), 83-89.
43. SNODGRASS, R. T. 1987. The temporal query language TQuel. ACM Trans. Database Syst. 12, 2 (June), 247-298.
44. SNODGRASS, R. T. AND AHN, I. 1985. A taxonomy of time in databases. In Proceedings of the ACM SIGMOD Conference on Management of Data. ACM Press, New York, NY, 236-246.
45. SOO, M. D., JENSEN, C. J., AND SNODGRASS, T. 1995. An algebra for TSQL2. In The TSQL2 Temporal Query Language, R. T. Sndograss, Ed. Kluwer Academic Publishers, Hingham, MA, 505-546.
46. TANSEL, A., CLIFFORD, J., GADIA, S., JAJODIA, S., SEGEV, A., AND SNODGRASS, R., EDS. 1993. Temporal Databases: Theory, Design, and Implementation. Benjamin/Cummings, Redwood City, CA.
47. TOMAN, D. AND NIWINSKI, D. 1996. First-order queries over temporal databases inexpressible in temporal logic. In Proceedings of the Fifth International Conference on Extending Database Technology (Avignon, France). Springer-Verlag, New York, NY, 307-324.
48. TOMAN, D. 1998. Point-based temporal extensions of SQL and their efficient implementation. In Temporal Databases: Research and Practice: State-of-the-Art Survey, O. Etzion, S. Jajodia and S. Sripada, Eds. Springer-Verlag, New York, NY, 211-237.
49. TORP K., JENSEN, C. S., AND BÖHLEN, M. H. 1997. Layered implementation of Temporal DBMSs: Concepts and techniques. In Proceedings of the 5th International Conference on Database Systems for Advanced Applications (Melbourne, Australia, Apr.), R. Topor and K. Tanaka Eds. World Scientific Publishing Co., Inc., River Edge, NJ.
50. TSICHRITZIS, D. C. AND LOCHOVSKY, F. H. 1982. Data Models. Prentice-Hall, New York, NY.
51. VAN BENTHEM, J. 1991. The Logic of Time. 2nd ed. Kluwer Academic Publishers, Hingham, MA.
52. VAN GELDER, A. AND TOPOR, R. W. 1991. Safety and translation of relational calculus queries. ACM Trans. Database Syst. 16, 2 (June), 235-278.
53. WIEDERHOLD, G. 1973. How to write a schema for a time oriented medical record data bank. Tech Rep. Stanford University, Stanford, CA.
54. ZANIOLO, C., CERI, S., FALOUTSOS, C., SNODGRASS, R. T., SUBRAHMANIAN, V. S., AND ZICARI, R. 1997. Advanced Database Systems. Morgan Kaufmann Publishers Inc., San Francisco, CA.