dblp.uni-trier.de www.dagstuhl.de www.uni-trier.de

A Generalized Model for a Relational Temporal Database.

Shashi K. Gadia, Chuen-Sing Yeung: A Generalized Model for a Relational Temporal Database. SIGMOD Conference 1988: 251-259
@inproceedings{DBLP:conf/sigmod/GadiaY88,
  author    = {Shashi K. Gadia and
               Chuen-Sing Yeung},
  editor    = {Haran Boral and
               Per-{\AA}ke Larson},
  title     = {A Generalized Model for a Relational Temporal Database},
  booktitle = {Proceedings of the 1988 ACM SIGMOD International Conference on
               Management of Data, Chicago, Illinois, June 1-3, 1988},
  publisher = {ACM Press},
  year      = {1988},
  pages     = {251-259},
  ee        = {http://doi.acm.org/10.1145/50202.50233, db/conf/sigmod/GadiaY88.html},
  crossref  = {DBLP:conf/sigmod/88},
  bibsource = {DBLP, http://dblp.uni-trier.de}
}

Abstract

We propose a generalized relational model for a temporal database which allows time stamping with respect to a Boolean algebra of multidimensional time stamps. The interplay between the various temporal dimensions is symmetric. As an application, a two dimensional model which allows objects with real world and transaction oriented time stamps is discussed. The two dimensional model can be used to query the past states of the database. It can also be used to give a precise classification of the errors and updates in a database, and is a promising approach for querying these errors and updates.

Copyright © 1988 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 ...

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

Printed Edition

Haran Boral, Per-Åke Larson (Eds.): Proceedings of the 1988 ACM SIGMOD International Conference on Management of Data, Chicago, Illinois, June 1-3, 1988. ACM Press 1988 CiteSeerX Google scholar pubzone.org BibTeX bibliographical record in XML, SIGMOD Record 17(2), June 1988
Contents

Online Edition: ACM Digital Library


References

[Bo]
A. Bolour, T. L. Anderson, L. J. Dekeyser, Harry K. T. Wong: The Role of Time in Information Processing: A Survey. SIGMOD Record 12(3): 27-50(1982) CiteSeerX Google scholar pubzone.org BibTeX bibliographical record in XML
[CC]
James Clifford, Albert Croker: The Historical Relational Data Model (HRDM) and Algebra Based on Lifespans. ICDE 1987: 528-537 CiteSeerX Google scholar pubzone.org BibTeX bibliographical record in XML
[Ga1]
Shashi K. Gadia: A Homogeneous Relational Model and Query Languages for Temporal Databases. ACM Trans. Database Syst. 13(4): 418-448(1988) CiteSeerX Google scholar pubzone.org BibTeX bibliographical record in XML
[Ga2]
Shashi K. Gadia: Toward a Multihomogeneous Model for a Temporal Database. ICDE 1986: 390-397 CiteSeerX Google scholar pubzone.org BibTeX bibliographical record in XML
[Ga3]
Shashi K. Gadia: Weak Temporal Relations. PODS 1986: 70-77 CiteSeerX Google scholar pubzone.org BibTeX bibliographical record in XML
[GV]
Shashi K. Gadia, Jay H. Vaishnav: A Query Language for a Homogeneous Temporal Database. PODS 1985: 51-56 CiteSeerX Google scholar pubzone.org BibTeX bibliographical record in XML
[GY]
...
[JM]
S. Jones, P. J. Mason: Handling the Time Dimension in a Data Base. ICOD 1980: 65-83 CiteSeerX Google scholar pubzone.org BibTeX bibliographical record in XML
[Mc]
L. Edwin McKenzie: Bibliography: Temporal Databases. SIGMOD Record 15(4): 40-52(1986) CiteSeerX Google scholar pubzone.org BibTeX bibliographical record in XML
[MS1]
L. Edwin McKenzie, Richard T. Snodgrass: Extending the Relational Algebra to Support Transaction Time. SIGMOD Conference 1987: 467-478 CiteSeerX Google scholar pubzone.org BibTeX bibliographical record in XML
[MS2]
...
[MS3]
L. Edwin McKenzie, Richard T. Snodgrass: Schema Evolution and the Relational Algebra. Inf. Syst. 15(2): 207-232(1990) CiteSeerX Google scholar pubzone.org BibTeX bibliographical record in XML
[NA]
...
[RS]
Doron Rotem, Arie Segev: Physical Organization of Temporal Data. ICDE 1987: 547-553 CiteSeerX Google scholar pubzone.org BibTeX bibliographical record in XML
[SK]
Arie Shoshani, Kyoji Kawagoe: Temporal Data Management. VLDB 1986: 79-88 CiteSeerX Google scholar pubzone.org BibTeX bibliographical record in XML
[Sn1]
Richard T. Snodgrass: The Temporal Query Language TQuel. PODS 1984: 204-213 CiteSeerX Google scholar pubzone.org BibTeX bibliographical record in XML
[Sn2]
Richard T. Snodgrass: The Temporal Query Language TQuel. ACM Trans. Database Syst. 12(2): 247-298(1987) CiteSeerX Google scholar pubzone.org BibTeX bibliographical record in XML
[Sn3]
Richard T. Snodgrass: Research Concerning Time in Databases - Project Summaries. SIGMOD Record 15(4): 19-39(1986) CiteSeerX Google scholar pubzone.org BibTeX bibliographical record in XML
[SA]
Richard T. Snodgrass, Ilsoo Ahn: A Taxonomy of Time in Databases. SIGMOD Conference 1985: 236-246 CiteSeerX Google scholar pubzone.org BibTeX bibliographical record in XML
[SGM]
Richard T. Snodgrass, Santiago Gomez, L. Edwin McKenzie: Aggregates in the Temporal Query Language TQuel. IEEE Trans. Knowl. Data Eng. 5(5): 826-842(1993) CiteSeerX Google scholar pubzone.org BibTeX bibliographical record in XML
[Ta]
Abdullah Uz Tansel: Adding time dimension to relational model and extending relational algebra. Inf. Syst. 11(4): 343-355(1986) CiteSeerX Google scholar pubzone.org BibTeX bibliographical record in XML
[TA1]
Abdullah Uz Tansel: A Statistical Interface for Historical Relational Databases. ICDE 1987: 538-546 CiteSeerX Google scholar pubzone.org BibTeX bibliographical record in XML
[TA2]
...
[TA3]
...
[TAO]
Abdullah Uz Tansel, M. Erol Arkun, Gultekin Özsoyoglu: Time-by-Example Query Language for Historical Databases. IEEE Trans. Software Eng. 15(4): 464-478(1989) CiteSeerX Google scholar pubzone.org BibTeX bibliographical record in XML
[Ye]
...

Referenced by

  1. Shashi K. Gadia, Sunil S. Nair: Algebraic Identities and Query Optimization in a Parametric Model for Relational Temporal Databases. IEEE Trans. Knowl. Data Eng. 10(5): 793-807(1998)
  2. Jae Young Lee, Ramez Elmasri: An EER-Based Conceptual Model and Query Language for Time-Series Data. ER 1998: 21-34
  3. Sonia Bergamaschi, Claudio Sartori: Chrono: A Conceptual Design Framework for Temporal Entities. ER 1998: 35-50
  4. Paolo Terenziani: Integrating Calendar Dates and Qualitative Temporal Constraints in the Treatment of Periodic Events. IEEE Trans. Knowl. Data Eng. 9(5): 763-783(1997)
  5. Abdullah Uz Tansel: Temporal Relational Data Model. IEEE Trans. Knowl. Data Eng. 9(3): 464-479(1997)
  6. Debabrata Dey, Terence M. Barron, Veda C. Storey: A Complete Temporal Relational Algebra. VLDB J. 5(3): 167-180(1996)
  7. Esa Falkenroth: Computational Indexes for Time Series. SSDBM 1996: 242-251
  8. Jongho Won, Ramez Elmasri: Representing Retroactive and Proactive Versions in Bi-Temporal Databases. ICDE 1996: 85-94
  9. Jae Young Lee, Ramez Elmasri, Jongho Won: Specification of Calendars and Time Series for Temporal Databases. ER 1996: 341-356
  10. Gultekin Özsoyoglu, Richard T. Snodgrass: Temporal and Real-Time Databases: A Survey. IEEE Trans. Knowl. Data Eng. 7(4): 513-532(1995)
  11. Vram Kouramajian, Michael Gertz: A Visual Query Editor for Temporal Databases. OOER 1995: 388-399
  12. Woo Saeng Kim, Duk Chul Chang, Tae Young Lim, Young Ho Shin: Temporal Object-Oriented Data Model for the Schema Modification. DASFAA 1995: 422-429
  13. Christian S. Jensen, Richard T. Snodgrass: Temporal Specialization and Generalization. IEEE Trans. Knowl. Data Eng. 6(6): 954-974(1994)
  14. Hongjun Lu, Beng Chin Ooi, Kian-Lee Tan: On Spatially Partitioned Temporal Join. VLDB 1994: 546-557
  15. Andreas Oberweis, Volker Sänger: GTL - A Graphical Language for Temporal Data. SSDBM 1994: 22-31
  16. Gautam Bhargava, Shashi K. Gadia: Relational Database Systems with Zero Information Loss. IEEE Trans. Knowl. Data Eng. 5(1): 76-87(1993)
  17. Christian S. Jensen, Michael D. Soo, Richard T. Snodgrass: Unification of Temporal Data Models. ICDE 1993: 262-271
  18. Seung-Kyum Kim, Sharma Chakravarthy: Modeling Time: Adequacy of Three Distinct Time Concepts for Temporal Databases. ER 1993: 475-491
  19. TaeNam Cho, Kyung-Chang Kim: Design of Historical Databases Using the 3-D Relational Data Model. DASFAA 1993: 297-305
  20. Shashi K. Gadia, Sunil S. Nair, Yiu-Cheong Poon: Incomplete Information in Relational Temporal Databases. VLDB 1992: 395-406
  21. Umeshwar Dayal, Gene T. J. Wuu: A Uniform Approach to Processing Temporal Queries. VLDB 1992: 407-418
  22. Wolfgang Käfer, Harald Schöning: Realizing a Temporal Complex-Object Data Model. SIGMOD Conference 1992: 266-275
  23. Gene T. J. Wuu, Umeshwar Dayal: A Uniform Model for Temporal Object-Oriented Databases. ICDE 1992: 584-593
  24. Ramez Elmasri, Muhammad Jaseemuddin, Vram Kouramajian: Partitioning of Time Index for Optical Disks. ICDE 1992: 574-583
  25. Ramez Elmasri, Vram Kouramajian: A Temporal Query Language Based on Conceptual Entities and Roles. ER 1992: 375-388
  26. Edward Sciore: Using Annotations to Support Multiple Kinds of Versioning in an Object-Oriented Database System. ACM Trans. Database Syst. 16(3): 417-438(1991)
  27. Christian S. Jensen, Leo Mark, Nick Roussopoulos: Incremental Implementation Model for Relational Databases with Transaction Time. IEEE Trans. Knowl. Data Eng. 3(4): 461-473(1991)
  28. L. Edwin McKenzie, Richard T. Snodgrass: Evaluation of Relational Algebras Incorporating the Time Dimension in Databases. ACM Comput. Surv. 23(4): 501-543(1991)
  29. Ramez Elmasri, Yeong-Joon Kim, Gene T. J. Wuu: Efficient Implementation Techniques For the Time Index. ICDE 1991: 102-111
  30. Vram Kouramajian, Ramez Elmasri: Mapping of 2-D Temporal Extended ER Models into Temporal Nested Relational Models. ER 1991: 671-691
  31. Ramez Elmasri, Gene T. J. Wuu, Yeong-Joon Kim: The Time Index: An Access Structure for Temporal Data. VLDB 1990: 1-12
  32. Ramez Elmasri, Gene T. J. Wuu: A Temporal Model and Query Language for ER Databases. ICDE 1990: 76-83
  33. Ramez Elmasri, Ihab El-Assal, Vram Kouramajian: Semantics of Temporal Data in an Extended ER Model. ER 1990: 249-264
  34. Gautam Bhargava, Shashi K. Gadia: Achieving Zero Information-Loss in a Classical Database Environment. VLDB 1989: 217-224
  35. Abdullah Uz Tansel, Lucy Garnett: Nested Historical Relations. SIGMOD Conference 1989: 284-294
  36. Arie Segev, Arie Shoshani: The Representation of a Temporal Data Model in the Relational Environment. SSDBM 1988: 39-61

Last update Fri May 25 08:38:29 2012 CET by the DBLP TeamThis material is Open Data Data released under the ODC-BY 1.0 license — See also our legal information page