Time and Relational Theory: Temporal Databases in the Relational Model and SQL

Time and Relational Theory: Temporal Databases in the Relational Model and SQL

Volumn , Issue , 2014, Pages 1-558

  Date, C J ^a   Darwen, Hugh ^a   Lorentzos, Nikos A ^a  

^a NONE   (Greece)

Author keywords

[No Author keywords available]

Indexed keywords

EID: 85141237450     PISSN: None     EISSN: None     Source Type: Book    
DOI: None     Document Type: Book

References (121)

1. Ahn Ilsoo, Snodgrass Richard T. Partitioned Storage Structures for Temporal Databases. Information Systems 1988, 13(4).
2. Allen James F. Maintaining Knowledge about Temporal Intervals. CACM 1983, 26(11). November.
3. Al-Taha Khaled K., Snodgrass Richard T., Soo Michael D. Bibliography on Spatiotemporal Databases. ACM SIGMOD Record 1993, 22(1). March.
4. Ariav Gad A Temporally Oriented Data Model. ACM TODS December 1986, 11(4).
5. Ben-Zvi J. The Time Relational Model 1982, Computer Science Department, University of California at Los Angeles, Ph.D. Dissertation.
6. Claudio Bettini, Curtis E. Dyreson, William S. Evans, Richard T. Snodgrass, and X. Sean Wang: "A Glossary of Time Granularity Concepts," in reference [55].
7. Böhlen Michael H. Temporal Database System Implementations. ACM SIGMOD Record December 1995, 24(4).
8. Böhlen Michael H., Jensen Christian S., Snodgrass Richard T. Temporal Statement Modifiers. ACM TODS December 2000, 25(4).
9. Böhlen Michael H., Snodgrass Richard T., Soo Michael D. Coalescing in Temporal Databases September 1996.
10. Casanova Marco A., Fagin Ronald, Papadimitriou Christos H. Inclusion Dependencies and Their Interaction with Functional Dependencies March 1982.
11. The Object Data Standard: ODMG 3.0 2000, Morgan Kaufmann, San Francisco, Calif. R.G.G. Cattell, D.K. Barry (Eds.).
12. Clifford James A Model for Historical Databases December 1982.
13. James Clifford and Albert Croker: "The Historical Relational Data Model (HRDM) Revisited," in reference [110].
14. Clifford James, Croker Albert, Tuzhilin Alexander On Completeness of Historical Relational Query Languages. ACM TODS March 1994, 19(1).
15. J. Clifford and A. Rao: "A Simple General Structure for Temporal Domains," in reference [96].
16. Recent Advances in Temporal Databases 1995, Springer-Verlag, New York, N.Y., (Proc. Int. Workshop on Temporal Databases, Zurich, Switzerland, September 17th-18th, 1995). J. Clifford, A. Tuzhilin (Eds.).
17. Clifford James, Warren David S. Formal Semantics for Time in Databases. ACM TODS June 1983, 8(2).
18. Clifford James, Tansel Abdullah Uz On An Algebra for Historical Relational Databases: Two Views May 1985.
19. Clifford James, Dyreson Curtis, Isakowitz Tomás, Jensen Christian S., Snodgrass Richard T. On the Semantics of 'Now' in Databases. ACM TODS June 1997, 22(2).
20. Codd E.F. Derivability, Redundancy, and Consistency of Relations Stored in Large Data Banks. ACM SIGMOD Record March 2009, 38(1). IBM Research Report RJ599 (August 19th, 1969). Republished in.
21. Codd E.F. A Relational Model of Data for Large Shared Data Banks. CACM June 1970, 13(6). Republished in Milestones of Research-Selected Papers 1958-1982 (CACM 25th Anniversary Issue), CACM 26, No. 1 (January 1983) and elsewhere.
22. Codd E.F. Relational Completeness of Data Base Sublanguages. Data Base Systems: Courant Computer Science Symposia 6 1972, Prentice-Hall, Englewood Cliffs, N.J. R. Rustin (Ed.).
23. Codd E.F., Date C.J. Much Ado about Nothing. Relational Database Writings 1991-1994 1995, Addison-Wesley, Reading, Mass. C.J. Date (Ed.).
24. Darwen Hugh Into the Unknown. Relational Database Writings 1985-1989 1990, (writing as Andrew Warden), Addison-Wesley, Reading, Mass. C.J. Date (Ed.).
25. Darwen Hugh The Nullologist in Relationland. Relational Database Writings 1989-1991 1992, Addison-Wesley, Reading, Mass. C.J. Date, H. Darwen (Eds.).
26. Hugh Darwen: "Valid Time and Transaction Time Proposals: Language Design Aspects," in reference [55].
27. Darwen Hugh The Decomposition Approach. Database Explorations: Essays on The Third Manifesto and Related Topics 2010, Trafford Publishing, Bloomington, Ind., Note: This paper is based on an earlier presentation by Darwen titled "How to Handle Missing Information Without Using Nulls," the slides for which can be found at www.thethirdmanifesto.com (May 9th, 2003; revised May 16th, 2005). C.J. Date, H. Darwen (Eds.).
28. Darwen Hugh An Introduction to Relational Database Theory 2012, Ventus, Frederiksberg, Denmark, Free download available at. http://bookboon.com.
29. Darwen Hugh, Date C.J. An Overview and Analysis of Proposals Based on the TSQL2 Approach. Date on Database: Writings 2000-2006 2006, Apress, Berkeley, Calif. C.J. Date (Ed.).
30. Darwen Hugh, Date C.J., Fagin Ronald A Normal Form for Preventing Redundant Tuples in Relational Databases 2012, March 26th-29th.
31. Darwen Hugh, Sykes Mike Concerns about the TSQL2 Approach to Temporal Databases May 1996, Kansas City, Mo., (This is an internal working document, not generally available at the time of writing.). ftp://sqistandards.org/SC32/WG3/Meetings/MCI_1996_05_KansasCity_USA/mci071.ps.
32. Darwen Hugh, Sykes Mike, et al. On Proposals for Valid-Time and Transaction-Time Support January 1997, Madrid, Spain, (This is an internal working document, not generally available at the time of writing.). ftp://sqlstandards.org/SC32/WG3/Meetings/MAD_1997_01_Madrid_ESP/mad146.ps.
33. Date C.J. Dates and Times in IBM SQL: Some Technical Criticisms. Relational Database Writings 1985-1989 1990, Addison-Wesley, Reading, Mass.
34. Date C.J. NOT Is Not "Not"! (Notes on Three-Valued Logic and Related Matters). Relational Database Writings 1985-1989 1990, Addison-Wesley, Reading, Mass.
35. Date C.J. A Note on Orthogonality. Relational Database Writings 1994-1997 1998, Addison-Wesley, Reading, Mass.
36. Date C.J. Encapsulation Is a Red Herring. Database Programming & Design September 1998, 12(9).
37. Date C.J. An Introduction to Database Systems 2004, Addison-Wesley, Boston, Mass. 8th edition.
38. Date C.J. "On the Notion of Logical Difference" "On the Logical Difference Between Model and Implementation" and "On the Logical Differences Between Types, Values, and Variables,". Date on Database: Writings 2000-2006 2006, all, Apress, Berkeley, Calif.
39. Date C.J. The Theory of Bags: An Investigative Tutorial. Logic and Databases: The Roots of Relational Theory 2007, Trafford Publishing, Victoria, B.C.
40. Date C.J. Image Relations. Database Explorations: Essays on The Third Manifesto and Related Topics 2010, Trafford Publishing, Bloomington, Ind. C.J. Date, H. Darwen (Eds.).
41. Date C.J. Inclusion Dependencies and Foreign Keys. Database Explorations: Essays on The Third Manifesto and Related Topics 2010, Trafford Publishing, Bloomington, Ind. C.J. Date, H. Darwen (Eds.).
42. Date C.J. SQL and Relational Theory: How to Write Accurate SQL Code 2012, O'Reilly Media, Sebastopol, Calif. 2nd edition.
43. Date C.J. Database Design and Relational Theory: Normal Forms and All That Jazz 2012, O'Reilly Media, Sebastopol, Calif.
44. Date C.J. View Updating and Relational Theory: Solving the View Update Problem 2013, O'Reilly Media, Sebastopol, Calif.
45. Date C.J. Relational Theory for Computer Professionals: What Relational Databases Are Really All About 2013, O'Reilly Media, Sebastopol, Calif.
46. C. J. Date: The New Relational Database Dictionary (to appear).
47. Date C.J., Darwen Hugh A Guide to the SQL Standard 1997, Addison-Wesley, Reading, Mass. 4th edition.
48. Date C.J., Darwen Hugh Multiple Assignment. Date on Database: Writings 2000-2006 2006, Apress, Berkeley, Calif. C.J. Date (Ed.).
49. Date C.J., Darwen Hugh The Third Manifesto. Database Explorations: Essays on The Third Manifesto and Related Topics 2010, Trafford Publishing, Bloomington, Ind.
50. Date C.J., Darwen Hugh Tutorial D. Database Explorations: Essays on The Third Manifesto and Related Topics 2010, Trafford Publishing, Bloomington, Ind.
51. Date C.J., Darwen Hugh The Inheritance Model and The Inheritance Model: What Was Changed and Why. Database Explorations: Essays on The Third Manifesto and Related Topics 2010, Trafford Publishing, Bloomington, Ind.
52. Date C.J., Darwen Hugh Databases, Types, and the Relational Model: The Third Manifesto 2007, Addison-Wesley, Boston, Mass. 3rd edition.
53. Date C.J., Darwen Hugh, Lorentzos Nikos A. Temporal Data and the Relational Model 2003, Morgan Kaufmann, San Francisco, Calif.
54. Christina Davies, Brian Lazell, Martin Hughes, and Leslie Cooper: "Time Is Just Another Attribute-Or at Least Another Dimension," in reference [16].
55. Temporal Databases: Research and Practice 1998, Springer-Verlag, New York, N.Y. O. Etzion, S. Jajodia, S. Sripada (Eds.).
56. Fagin Ronald Normal Forms and Relational Database Operators May/June 1979.
57. Gadia Shashi K., Vaishnav Jay H. A Query Language for a Homogeneous Temporal Database March 1985.
58. Gadia Shashi K. A Homogeneous Relational Model and Query Languages for Temporal Databases. ACM TODS 1988, 13(4). December.
59. Shashi K. Gadia: "Ben-Zvi's Pioneering Work in Relational Temporal Databases," in reference [110].
60. Hall Patrick, Owlett John, Todd Stephen Relations and Entities. Modelling in Data Base Management Systems 1976, North-Holland, Amsterdam, Netherlands. G.M. Nijssen (Ed.).
61. Database Language SQL 2011, International Organization for Standardization (ISO), Document ISO/IEC 9075:2011.
62. Christian S. Jensen and Curtis E. Dyreson (eds.): "The Consensus Glossary of Temporal Database Concepts-February 1998 Version," in reference [55].
63. Jensen Christian S., Snodgrass Richard T., Soo Michael D. Extending Existing Dependency Theory to Temporal Databases. IEEE Transactions on Knowledge and Data Engineering August 1996, 8(4).
64. Jones S., Mason P.J. Handling the Time Dimension in a Data Base 1980, Heyden & Son, London, U.K., (July 1980).
65. Kulkarni Krishna, Michels Jan-Eike Temporal Features in SQL:2011. ACM SIGMOD Record September 2012, 41(3).
66. Levene Mark, Loizou George G. A Guided Tour of Relational Databases and Beyond 1999, Springer-Verlag, London, U.K.
67. Lorentzos Nikos A. A Formal Extension of the Relational Model for the Representation and Manipulation of Generic Intervals August 1988, Birkbeck College, University of London, U.K., Ph.D. Dissertation.
68. Nikos A. Lorentzos and R. G. Johnson: "TRA: A Model for a Temporal Relational Algebra," in reference [96].
69. Lorentzos Nikos A., Johnson R.G. Extending Relational Algebra to Manipulate Temporal Data. Information Systems 1988, 13(3).
70. Nikos A. Lorentzos: "The Interval-Extended Relational Model and Its Application to Valid-Time Databases," in reference [110].
71. Lorentzos Nikos A. DBMS Support for Time and Totally Ordered Compound Data Types. Information Systems September 1992, 17(5).
72. Lorentzos Nikos A. DBMS Support for Nonmetric Measurement Systems. IEEE Transactions on Knowledge and Data Engineering 1994, 6(6). December.
73. Lorentzos Nikos A., Darwen Hugh Extension to SQL2 Binary Operations for Temporal Data 1996, (invited paper), September 26th-28th.
74. Lorentzos Nikos A., Johnson R.G. An Extension of the Relational Model to Support Generic Intervals. Extending Database Technology 1988, Springer-Verlag, New York, N.Y. J.W. Schmidt, S. Ceri, M. Missikoff (Eds.).
75. Lorentzos Nikos A., Kollias Vassiliki J. The Handling of Depth and Time Intervals in Soil Information Systems. Comp. Geosci. 1989, 15(3).
76. Lorentzos Nikos A., Mitsopoulos Yannis G. IXSQL: An Interval Extension to SQL 1993, June 14th-16th.
77. Lorentzos Nikos A., Manolopoulos Yannis Efficient Management of 2-Dimensional Interval Relations. Lecture Notes in Computer Science 856 September 1994, Springer-Verlag, New York, N.Y. D. Karagiannis (Ed.).
78. Lorentzos Nikos A., Manolopoulos Yannis Functional Requirements for Historical and Interval Extensions to the Relational Model. Data and Knowledge Engineering 17 1995.
79. Lorentzos Nikos A., Mitsopoulos Yannis G. SQL Extension for Interval Data. IEEE Transactions on Knowledge and Data Engineering May/June 1997, 9(3).
80. Lorentzos Nikos A., Poulovassilis Alexandra, Small Carol Implementation of Update Operators for Interval Relations. BCS Comp. J. 1994, 37(3).
81. Lorentzos Nikos A., Poulovassilis Alexandra, Small Carol Manipulation Operations for an Interval-Extended Relational Model. Data and Knowledge Engineering 1995, 17.
82. Lorentzos Nikos A., Tryfona Nektaria, Viqueira Jose R.Rios Relational Algebra for Spatial Data Management 1999, June 14th-16th.
83. Lorentzos N.A., Viqueira J.R.R. On a Spatio-Temporal Relational Model Based on Quanta. Spatiotemporal Databases: The Chorochronos Approach-Lecture Notes in Computer Science 2520 2003, Springer-Verlag, New York, N.Y. M. Koubarakis (Ed.).
84. Lorentzos N.A., Viqueira J.R.R. Relational Formalism for the Management of Spatial Data. BCS Comp. J. January 2006, 49(1).
85. Lorentzos N.A., Rios Viqueira J.R., Tryfona N. Quantum-Based Spatial Extension to the Relational Model. Advances in Informatics 2000, World Scientific Publishing, Singapore. D.I. Fotiadis, S.D. Nikolopoulos (Eds.).
86. Lorentzos N.A., Yialouris C.P., Sideridis A.B. Time-Evolving Rule-Based Knowledge Bases. Data and Knowledge Engineering 1999, 29(3).
87. Lum V. Designing DBMS Support for the Temporal Dimension June 1984.
88. Martin N.G., Navathe S.B., Ahmed R. Dealing with Temporal Schema Anomalies in History Databases September 1987.
89. Matchett Robert Temporal Tables in DB2. IBM Data Magazine April 2012.
90. McGoveran David Nothing from Nothing. Relational Database Writings 1994-1997 1998, (in four parts), Addison-Wesley, Reading, Mass. C.J. Date, H. Darwen, D. McGoveran (Eds.).
91. McKenzie E., Snodgrass R. Supporting Valid Time: An Historical Algebra 1987, Tech. Report TR87-008, Dept. of Computer Science, University of North Carolina, Chapel Hill, N.C.
92. McKenzie Edwin, Snodgrass Richard Extending the Relational Algebra to Support Transaction Time May 1987.
93. Edwin McKenzie L., Snodgrass Richard T. Evaluation of Relational Algebras Incorporating the Time Dimension in Databases. ACM Comp. Surv. December 1991, 23(4).
94. Shamkant B. Navathe and Rafi Ahmed: "Temporal Extensions to the Relational Model and SQL," in reference [110].
95. Özsoyoglu G., Özsoyoglu Z.M., Matos V. Extending Relational Algebra and Relational Calculus with Set-Valued Attributes and Aggregate Functions. ACM TODS December 1987, 12(4).
96. Temporal Aspects in Information Systems 1988, North-Holland, Amsterdam, Netherlands. C. Rolland, F. Bodart, M. Leonard (Eds.).
97. Saracco Cynthia, Nicola Matthias, Gandhi Lenisha A Matter of Time: Temporal Data Management in DB2 10 April 2012, http://www.ibm.com/developerworks/data/library/techarticle/dm1204db2temporaldata/.
98. Sarda N.L. Algebra and Query Language for a Historical Data Model. BCS Comp. J. February 1990, 33(1).
99. Sarda N.L. Extension to SQL for Historical Databases. IEEE Transactions on Knowledge and Data Engineering February 1990, 2(2).
100. Schueler B.-M. Update Reconsidered. Architecture and Models in Data Base Management Systems 1977, North-Holland, Amsterdam, Netherlands. G.M. Nijssen (Ed.).
101. Shoshani Arie, Kawagoe Kyoji Temporal Data Management August 1986.
102. Erwin Smout: "Could Packing Be Specified in Terms of Closed-Open Interval Semantics Without Having to Commit to Granularity?", (to appear). Note: A draft of this paper dated January 14th, 2014 was offered as a contribution to the email discussion forum , and the remarks that follow are based on that draft. mailto:ttm@thethirdmanifesto.com.
103. Snodgrass Richard, Ahn Ilsoo A Taxonomy of Time in Databases May 1985.
104. Snodgrass Richard The Temporal Query Language TQuel. ACM TODS June 1987, 12(2). See also Richard Snodgrass: "An Overview of TQuel," in reference [110].
105. Snodgrass R.T. TSQL2 Language Specification. ACM SIGMOD Record March 1994, 23(1).
106. The TSQL2 Temporal Query Language 1995, Kluwer Academic Publishers, Norwell, Mass., Note: A new edition of this book was published by Springer in 2012. R.T. Snodgrass (Ed.).
107. Snodgrass Richard T., Böhlen Michael H., Jensen Christian S., Steiner Andreas Adding Valid Time to SQL/Temporal and Adding Transaction Time to SQL/Temporal 1997, Madrid, Spain January, (This is an internal working document, not generally available at the time of writing.). ftp://sqlstandards.org/SC32/WG3/Meetings/MAD_1997_01_Madrid_ESP/mad146.ps.
108. Snodgrass Richard T. Developing Time-Oriented Database Applications in SQL 2000, Morgan Kaufmann, San Francisco, Calif.
109. Tansel Abdullah U. Adding Time Dimension to Relational Model and Extending Relational Algebra. Information Systems 1986, 11(4).
110. Temporal Databases: Theory, Design, and Implementation 1993, Benjamin/Cummings, Redwood City, Calif. A.U. Tansel, J. Clifford, S. Gadia, S. Jajodia, A. Segev, R. Snodgrass (Eds.).
111. Tansel A.U., Garnett L. Nested Historical Relations June 1989.
112. Abdullah Uz Tansel and Erkan Tin: "Expressive Power of Temporal Relational Query Languages and Temporal Completeness," in reference [55].
113. David Toman: "Point-Based Temporal Extensions of SQL and Their Efficient Implementation," in reference [55].
114. Tuzhilin Alexander, Clifford James A Temporal Relational Algebra as a Basis for Temporal Relational Completeness August 1990.
115. van Roessel J.W. Conceptual Folding and Unfolding of Spatial Data for Spatial Queries. Toward SQL Database Extensions for Geographic Information Systems 1993, National Institute of Standards and Technology, Gaithersburg, Md, Report NISTIR 5258. V.B. Robinson, H. Tom (Eds.).
116. van Roessel J.W. An Integrated Point-Attribute Model for Four Types of Areal GIS Features 1994, September 5th-9th.
117. Vassilakis Costas Design and Optimized Implementation of a System for the Management of Historical Data October 1995, Department of Informatics, University of Athens, Greece.
118. Vassilakis Costas, Lorentzos Nikos, Georgiadis Panagiotis Implementation of Transaction and Concurrency Control Support in a Temporal DBMS. Information Systems 1998, 23(5).
119. Viqueira J.R.R., Lorentzos N.A. SQL Extension for Spatio-Temporal Data. VLDB Journal April 2007, 16(2).
120. Yu Wu, Sushil Jajodia, and X. Sean Wang: "Temporal Database Bibliography Update," in reference [55].
121. Zhang Y. Multi-Temporal Database Management with a Visual Query Interface October 1997, Department of Computer and Systems Services, Royal Institute of Technology and Stockholm University, Sweden, Ph.D. Dissertation.