ACM SIGMOD Anthology VLDB dblp.uni-trier.de

Providing Time-Related Constraints for Conventional Database Systems.

T. Abbod, K. Brown, H. Noble: Providing Time-Related Constraints for Conventional Database Systems. VLDB 1987: 167-175
@inproceedings{DBLP:conf/vldb/AbbodBN87,
  author    = {T. Abbod and
               K. Brown and
               H. Noble},
  editor    = {Peter M. Stocker and
               William Kent and
               Peter Hammersley},
  title     = {Providing Time-Related Constraints for Conventional Database
               Systems},
  booktitle = {VLDB'87, Proceedings of 13th International Conference on Very
               Large Data Bases, September 1-4, 1987, Brighton, England},
  publisher = {Morgan Kaufmann},
  year      = {1987},
  isbn      = {0-934613-46-X},
  pages     = {167-175},
  ee        = {db/conf/vldb/AbbodBN87.html},
  crossref  = {DBLP:conf/vldb/87},
  bibsource = {DBLP, http://dblp.uni-trier.de}
}

Abstract

A model for a historical database is described which is based upon time-stamped tuples as the unit of storage. The model includes both physical and logical time-stamps. The technical characteristics of write-once laser discs prevent the use of double logical time-stamps. The model distinguishes version from correction-updates. It is shown that if set- valued attributes are involved the use of null values is unavoidable if back-dated correction-updates are allowed. A method of handling user-defined integrity constraint rules is outlined which involves the maintenance of a time-stamped trace of such rules. Such a trace is necessary for the proper handling of back-dated correction-updates. An outline of a system SIS-BASE is described which implements some of these ideas.

Copyright © 1987 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 4, VLDB '75-'88" and ... DVD Version: Load ACM SIGMOD Anthology DVD 1" and ...

Printed Edition

Peter M. Stocker, William Kent, Peter Hammersley (Eds.): VLDB'87, Proceedings of 13th International Conference on Very Large Data Bases, September 1-4, 1987, Brighton, England. Morgan Kaufmann 1987, ISBN 0-934613-46-X
Contents CiteSeerX Google scholar pubzone.org BibTeX bibliographical record in XML

References

[1]
Gad Ariav, James Clifford, Matthias Jarke: Time and Databases. SIGMOD Conference 1983: 243-245 CiteSeerX Google scholar pubzone.org BibTeX bibliographical record in XML
[2]
Michael L. Brodie: The application of data types to database semantic integrity. Inf. Syst. 5(4): 287-296(1980) CiteSeerX Google scholar pubzone.org BibTeX bibliographical record in XML
[3]
...
[4]
José Mauro Volkmer de Castilho, Marco A. Casanova, Antonio L. Furtado: A Temporal Framework for Database Specifications. VLDB 1982: 280-291 CiteSeerX Google scholar pubzone.org BibTeX bibliographical record in XML
[5]
James Clifford, David Scott Warren: Formal Semantics for Time in Databases. ACM Trans. Database Syst. 8(2): 214-254(1983) CiteSeerX Google scholar pubzone.org BibTeX bibliographical record in XML
[6]
James Clifford, Abdullah Uz Tansel: On An Algebra For Historical Relational Databases: Two Views. SIGMOD Conference 1985: 247-265 CiteSeerX Google scholar pubzone.org BibTeX bibliographical record in XML
[7]
C. J. Date: Referential Integrity. VLDB 1981: 2-12 CiteSeerX Google scholar pubzone.org BibTeX bibliographical record in XML
[8]
Richard A. Frost, S. Whittaker: A Step Towards the Automatic Maintenance of the Semantic Integrity of Databases. Comput. J. 26(2): 124-133(1983) CiteSeerX Google scholar pubzone.org BibTeX bibliographical record in XML
[9]
Richard A. Frost: Formalising the Notion of Semantic Integrity in Database and Knowledge Base Systems Work. BNCOD 1986: 105-127 CiteSeerX Google scholar pubzone.org BibTeX bibliographical record in XML
[10]
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
[11]
Manfred R. Klopprogge, Peter C. Lockemann: Modelling Information Preserving Databases: Consequences of the Concept of Time. VLDB 1983: 399-416 CiteSeerX Google scholar pubzone.org BibTeX bibliographical record in XML
[12]
Isamu Kobayashi: Validating database updates. Inf. Syst. 9(1): 1-17(1984) CiteSeerX Google scholar pubzone.org BibTeX bibliographical record in XML
[13]
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 CiteSeerX Google scholar pubzone.org BibTeX bibliographical record in XML
[14]
Hugh Noble: Occuurence Dependencies, Linkages and the Structure of a Relational Database. BNCOD 1984: 16-27 CiteSeerX Google scholar pubzone.org BibTeX bibliographical record in XML
[15]
H. Noble, T. Abbod: Meta-Rules and Semantic Integrity Constraints in Databases. BNCOD 1986: 129-140 CiteSeerX Google scholar pubzone.org BibTeX bibliographical record in XML
[16]
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
[17]
Michael Stonebraker: Implementation of Integrity Constraints and Views by Query Modification. SIGMOD Conference 1975: 65-78 CiteSeerX Google scholar pubzone.org BibTeX bibliographical record in XML
[18]
...
[19]
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
[20]
Hans Weigand: Conceptual Models in Prolog. DS-1 1985: 59-69 CiteSeerX Google scholar pubzone.org BibTeX bibliographical record in XML

Copyright © Tue Mar 16 02:21:59 2010 by Michael Ley (ley@uni-trier.de)