SQL Extension for Interval Data.

@article{DBLP:journals/tkde/LorentzosM97,
  author    = {Nikos A. Lorentzos and
               Yannis G. Mitsopoulos},
  title     = {SQL Extension for Interval Data},
  journal   = {IEEE Trans. Knowl. Data Eng.},
  volume    = {9},
  number    = {3},
  year      = {1997},
  pages     = {480-499},
  ee        = {db/journals/tkde/LorentzosM97.html},
  bibsource = {DBLP, http://dblp.uni-trier.de}
}

Abstract

Copyright © 1997 by The Institute of Electrical and Electronic Engineers, Inc. (IEEE). Abstract used with permission.

References

[1]

...

[2]

Stephen J. Cannan, Gerard A. M. Otten: SQL - The Standard Handbook. McGraw-Hill Book Company 1993
BibTeX

[3]

Christian S. Jensen, James Clifford, Ramez Elmasri, Shashi K. Gadia, Patrick J. Hayes, Sushil Jajodia: A Consensus Glossary of Temporal Database Concepts. SIGMOD Record 23(1): 52-64(1994) BibTeX

[4]

Gad Ariav: A Temporally Oriented Data Model. ACM Trans. Database Syst. 11(4): 499-527(1986) BibTeX

[5]

James Clifford, Albert Croker: The Historical Relational Data Model (HRDM) and Algebra Based on Lifespans. ICDE 1987: 528-537 BibTeX

[6]

Shashi K. Gadia: A Homogeneous Relational Model and Query Languages for Temporal Databases. ACM Trans. Database Syst. 13(4): 418-448(1988) BibTeX

[7]

...

[8]

Shamkant B. Navathe, Rafi Ahmed: Temporal Extensions to the Relational Model and SQL. Temporal Databases 1993: 92-109 BibTeX

[9]

Nandlal L. Sarda: Extensions to SQL for Historical Databases. IEEE Trans. Knowl. Data Eng. 2(2): 220-230(1990) BibTeX

[10]

Richard T. Snodgrass (Ed.): The TSQL2 Temporal Query Language. Kluwer 1995, ISBN 0-7923-9614-6
Contents BibTeX

[11]

Abdullah Uz Tansel: A Historical query language. Inf. Sci. 53(1-2): 101-133(1991) BibTeX

[12]

Nikos A. Lorentzos: The Interval-extended Relational Model and Its Applications to Valid-time Databases. Temporal Databases 1993: 67-91 BibTeX

[13]

...

[14]

...

[15]

Richard T. Snodgrass: The Temporal Query Language TQuel. ACM Trans. Database Syst. 12(2): 247-298(1987) BibTeX

[16]

Khaled K. Al-Taha, Richard T. Snodgrass, Michael D. Soo: Bibliography on Spatiotemporal Databases. International Journal of Geographical Information Systems 8(1): 95-103(1994) BibTeX

[17]

E. F. Codd: A Relational Model of Data for Large Shared Data Banks. Commun. ACM 13(6): 377-387(1970) BibTeX

[18]

Nikos A. Lorentzos, Alexandra Poulovassilis, Carol Small: Manipulation Operations for an Interval-Extended Relational Model. Data Knowl. Eng. 17(1): 1-29(1995) BibTeX

[19]

Nikos A. Lorentzos, Roger G. Johnson: TRA: A Model for a Temporal Relational Algebra. Temporal Aspects in Information Systems 1987: 95-108 BibTeX

[20]

Peter Dadam, Klaus Küspert, F. Andersen, Henk M. Blanken, R. Erbe, Jürgen Günauer, Vincent Y. Lum, Peter Pistor, Georg Walch: A DBMS Prototype to Support Extended NF2 Relations: An Integrated View on Flat Tables and Hierarchies. SIGMOD Conference 1986: 356-367 BibTeX

[21]

Gultekin Özsoyoglu, Z. Meral Özsoyoglu, Victor Matos: Extending Relational Algebra and Relational Calculus with Set-Valued Attributes and Aggregate Functions. ACM Trans. Database Syst. 12(4): 566-592(1987) BibTeX

[22]

Arie Segev, Arie Shoshani: Logical Modeling of Temporal Data. SIGMOD Conference 1987: 454-466 BibTeX

[23]

James Clifford, Albert Croker, Alexander Tuzhilin: On Completeness of Historical Relational Query Languages. ACM Trans. Database Syst. 19(1): 64-116(1994) BibTeX

[24]

Mark A. Roth, Henry F. Korth, Don S. Batory: SQL/NF: a query language for ¬1 NF relational databases. Inf. Syst. 12(1): 99-114(1987) BibTeX

[25]

...

[26]

...

[27]

Nikos A. Lorentzos: DBMS Support for Nonmetric Measurement Systems. IEEE Trans. Knowl. Data Eng. 6(6): 945-953(1994) BibTeX

[28]

Nikos A. Lorentzos: DBMS support for time and totally ordered compound data types. Inf. Syst. 17(5): 347-358(1992) BibTeX

[29]

Nikos A. Lorentzos, Alexandra Poulovassilis, Carol Small: Implementation of Update Operations for Interval Relations. Comput. J. 37(3): 164-176(1994) BibTeX

[30]

Nikos A. Lorentzos, Yannis Manolopoulos: Efficient Management of 2-d Interval Relations. DEXA 1994: 72-82 BibTeX

[31]

...

[32]

...

Referenced by

1. Costas Vassilakis: An Optimisation Scheme for Coalesce/Valid Time Selection Operator Sequences. SIGMOD Record 29(1): 38-43(2000)
2. Cindy Xinmin Chen, Carlo Zaniolo: Universal Temporal Extensions for Database Languages. ICDE 1999: 428-437
3. Michael H. Böhlen, Renato Busatto, Christian S. Jensen: Point-Versus Interval-Based Temporal Data Models. ICDE 1998: 192-200