ACM SIGMOD Anthology VLDB dblp.uni-trier.de

Achieving Zero Information-Loss in a Classical Database Environment.

Gautam Bhargava, Shashi K. Gadia: Achieving Zero Information-Loss in a Classical Database Environment. VLDB 1989: 217-224
@inproceedings{DBLP:conf/vldb/BhargavaG89,
  author    = {Gautam Bhargava and
               Shashi K. Gadia},
  editor    = {Peter M. G. Apers and
               Gio Wiederhold},
  title     = {Achieving Zero Information-Loss in a Classical Database Environment},
  booktitle = {Proceedings of the Fifteenth International Conference on Very
               Large Data Bases, August 22-25, 1989, Amsterdam, The Netherlands},
  publisher = {Morgan Kaufmann},
  year      = {1989},
  isbn      = {1-55860-101-5},
  pages     = {217-224},
  ee        = {db/conf/vldb/BhargavaG89.html},
  crossref  = {DBLP:conf/vldb/89},
  bibsource = {DBLP, http://dblp.uni-trier.de}
}

Abstract

The research in temporal databases has, so far, concentrated on the history of an object as it exists in the real world. Instead, in this paper we view the history of an object as it is recorded in a database. Such a history is obtained by extrpoating the outcome of the updates (insert, modify, and delete) made to the object at discrete instants. Our model supports two kinds of query-users: the system-user, and the classical-user. For the classical-user, the interface to the database is identical to the usual interface in classical snapshot databases. We extend the classical relational model so that a transaction, i.e.,anupdate or a (retrieval) query is recorded in such a way that its effectcan be determined at any time in the future; thus, our model is a zero information-loss model (Theorem 1). The logical structure imposed upon the model allows us to give a powerful algebra or the system-user to query the circumstantial information surrounding updates and queries. In addition, a single execution of a query can be identified with the relation it retrieves; thus, a user can query queries, query queries on queries, ad infinitum. The model represents an application of temporal databases to mainstreamdatabases. It can be used in auditing, and as a foundation for building secure systems.

Copyright © 1989 by the VLDB Endowment. Permission to copy without fee all or part of this material is granted provided that the copies are not made or distributed for direct commercial advantage, the VLDB copyright notice and the title of the publication and its date appear, and notice is given that copying is by the permission of the Very Large Data Base Endowment. To copy otherwise, or to republish, requires a fee and/or special permission from the Endowment.


Online Paper

ACM SIGMOD Anthology

CDROM Version: Load the CDROM "Volume 1 Issue 5, VLDB '89-'97" and ... DVD Version: Load ACM SIGMOD Anthology DVD 1" and ...

Printed Edition

Peter M. G. Apers, Gio Wiederhold (Eds.): Proceedings of the Fifteenth International Conference on Very Large Data Bases, August 22-25, 1989, Amsterdam, The Netherlands. Morgan Kaufmann 1989, ISBN 1-55860-101-5
CiteSeerX Google scholar pubzone.org BibTeX bibliographical record in XML

References

[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: The Role of Temporal Elements in Temporal Databases. IEEE Data Eng. Bull. 11(4): 19-25(1988) CiteSeerX Google scholar pubzone.org BibTeX bibliographical record in XML
[GB]
...
[GY1]
...
[Ga2]
Shashi K. Gadia, Chuen-Sing Yeung: A Generalized Model for a Relational Temporal Database. SIGMOD Conference 1988: 251-259 CiteSeerX Google scholar pubzone.org BibTeX bibliographical record in XML
[LJ]
Nikos A. Lorentzos, Roger G. Johnson: Extending relational algebra to manipulate temporal data. Inf. Syst. 13(3): 289-296(1988) CiteSeerX Google scholar pubzone.org BibTeX bibliographical record in XML
[Sn]
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
[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

Referenced by

  1. James Clifford, Curtis E. Dyreson, Tomás Isakowitz, Christian S. Jensen, Richard T. Snodgrass: On the Semantics of "Now" in Databases. ACM Trans. Database Syst. 22(2): 171-214(1997)
  2. Gautam Bhargava, Shashi K. Gadia: Relational Database Systems with Zero Information Loss. IEEE Trans. Knowl. Data Eng. 5(1): 76-87(1993)
  3. Christian S. Jensen, Michael D. Soo, Richard T. Snodgrass: Unification of Temporal Data Models. ICDE 1993: 262-271

Copyright © Mon Nov 2 21:18:24 2009 by Michael Ley (ley@uni-trier.de)