A Taxonomy of Time in Databases.

Richard T. Snodgrass, Ilsoo Ahn: A Taxonomy of Time in Databases. SIGMOD Conference 1985: 236-246

@inproceedings{DBLP:conf/sigmod/SnodgrassA85,
  author    = {Richard T. Snodgrass and
               Ilsoo Ahn},
  editor    = {Shamkant B. Navathe},
  title     = {A Taxonomy of Time in Databases},
  booktitle = {Proceedings of the 1985 ACM SIGMOD International Conference on
               Management of Data, Austin, Texas, May 28-31, 1985},
  publisher = {ACM Press},
  year      = {1985},
  pages     = {236-246},
  ee        = {http://doi.acm.org/10.1145/318898.318921, db/conf/sigmod/SnodgrassA85.html},
  crossref  = {DBLP:conf/sigmod/85},
  bibsource = {DBLP, http://dblp.uni-trier.de}
}

Abstract

The need for supporting time varying information in databases has been recognized for quite some time. Many authors have proposed numerous schemes to satisfythis need by incorporating one or two time attributes in the database. Unfortunately, there has been confusion concerning the terminology and definition of these time attributes. This paper proposes a new taxonomy of three times for use in databases, one that is more cleanly defined, that may be conceptualized ina pictorial fashion, and that defines several kinds of databases differentiated by their ability to represent temporal information. The paper argues that fu ture database management systems should support all three times to fully capture time varying behavior.

Copyright © 1985 by the ACM, Inc., used by permission. Permission to make digital or hard copies is granted provided that copies are not made or distributed for profit or direct commercial advantage, and that copies show this notice on the first page or initial screen of a display along with the full citation.

ACM SIGMOD Anthology

Online Version (ACM WWW Account required): Full Text in PDF Format

CDROM Version: Load the CDROM "Volume 1 Issue 2, SIGMOD '75-'92" and ...

Windows: Click the letter of your CD drive
A B C D E F G H I J K L M N O P Q R S T U V W X Y Z
Mac: Click here
UNIX/LINUX: mount the CD and click on the path of your mount point:
/Anthology/smod7592 or /cdrom

DVD Version: Load ACM SIGMOD Anthology DVD 1" and ...

Windows: Click the letter of your CD drive
A B C D E F G H I J K L M N O P Q R S T U V W X Y Z
Mac: Click here
UNIX/LINUX: mount the DVD and click on the path of your mount point:
/Anthology/aDVD1 or /dvd

Printed Edition

Shamkant B. Navathe (Ed.): Proceedings of the 1985 ACM SIGMOD International Conference on Management of Data, Austin, Texas, May 28-31, 1985. ACM Press 1985

, SIGMOD Record 14(4)
Contents

Online Edition: ACM Digital Library

References

[Anderson 1982]: T. Lougenia Anderson: Modeling Time at the Conceptual Level. JCDKB 1982: 273-297
[Ariav & Morgan 1981]: ...
[Ariav & Morgan 1982]: ...
[Ben-Zvi 1982]: ...
[Bontempo 1983]: ...
[Breutmann et al. 1979]: ...
[Bubenko 1976]: ...
[Bubenko 1977]: ...
[Clifford & Warren 1983]: James Clifford, David Scott Warren: Formal Semantics for Time in Databases. ACM Trans. Database Syst. 8(2): 214-254(1983)
[Codd 1979]: E. F. Codd: Extending the Database Relational Model to Capture More Meaning. ACM Trans. Database Syst. 4(4): 397-434(1979)
[Copeland & Maier 1984]: George P. Copeland, David Maier: Making Smalltalk a Database System. SIGMOD Conference 1984: 316-325
[Dadam et al. 1984]: Peter Dadam, Vincent Y. Lum, H.-D. Werner: Integration of Time Versions into a Relational Database System. VLDB 1984: 509-522
[Findler & Chen 1971]: ...
[Hammer & McLeod 1981]: Michael Hammer, Dennis McLeod: Database Description with SDM: A Semantic Database Model. ACM Trans. Database Syst. 6(3): 351-386(1981)
[Held et al. 1975]: ...
[Jones et al. 1979]: Susan Jones, Peter Mason, Ronald K. Stamper: LEGOL 2.0: A relational specification language for complex rules. Inf. Syst. 4(4): 293-305(1979)
[Jones & Mason 1980]: S. Jones, P. J. Mason: Handling the Time Dimension in a Data Base. ICOD 1980: 65-83
[Klopprogge 1981]: Manfred R. Klopprogge: TERM: An Approach to Include Time Dimension in the Entity-Relationship Model. ER 1981: 473-508
[Lum et al. 1984]: Vincent Y. Lum, Peter Dadam, R. Erbe, Jürgen Günauer, Peter Pistor, Georg Walch, H. Werner, John Woodfill: Designing DBMS Support for the Temporal Dimension. SIGMOD Conference 1984: 115-130
[Mueller & Steinbauer 1983]: ...
[Overmyer & Stonebraker 1982]: Ricky Overmyer, Michael Stonebraker: Implementation of a Time Expert in a Data Base System. SIGMOD Record 12(3): 51-60(1982)
[Reed 1978]: ...
[Relational 1984]: ...
[Sernadas 1980]: Amílcar Sernadas: Temporal aspects of logical procedure definiton. Inf. Syst. 5(3): 167-187(1980)
[Snodgrass 1982]: ...
[Snodgrass 1984]: Richard T. Snodgrass: The Temporal Query Language TQuel. PODS 1984: 204-213
[Snodgrass 1985]: Richard T. Snodgrass: The Temporal Query Language TQuel. ACM Trans. Database Syst. 12(2): 247-298(1987)
[Svobodova 1981]: Liba Svobodova: A Reliable Object-Oriented Data Repository for a Distributed Computer System. SOSP 1981: 47-58
[Tandem 1983]: ...
[Wiederhold et al. 1975]: ...