Implementation of Integrity Constraints and Views by Query Modification.

Michael Stonebraker: Implementation of Integrity Constraints and Views by Query Modification. SIGMOD Conference 1975: 65-78

@inproceedings{DBLP:conf/sigmod/Stonebraker75,
  author    = {Michael Stonebraker},
  editor    = {W. Frank King},
  title     = {Implementation of Integrity Constraints and Views by Query Modification},
  booktitle = {Proceedings of the 1975 ACM SIGMOD International Conference on
               Management of Data, San Jose, California, May 14-16, 1975},
  publisher = {ACM},
  year      = {1975},
  pages     = {65-78},
  ee        = {http://doi.acm.org/10.1145/500080.500091, db/conf/sigmod/Stonebraker75.html},
  crossref  = {DBLP:conf/sigmod/75},
  bibsource = {DBLP, http://dblp.uni-trier.de}
}

Abstract

Because the user interface in a relational data base management system may be decoupled from the storage representation of data, novel, powerful and efficient integrity control schemes are possible. This paper indicates the mechanism being implemented in one relational system to prevent integrity violations which can result from improper updates by a process. Basically each interaction with the data is immediately modified at the query language level to one guaranteed to have no integrity violations. Also, a similar modification teohnique is indicated to support the use of "views," i.e. relations which are not physically present in the data base but are defined in terms of ones that are.

Copyright © 1975 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

W. Frank King (Ed.): Proceedings of the 1975 ACM SIGMOD International Conference on Management of Data, San Jose, California, May 14-16, 1975. ACM 1975

Contents

References

[1]: ...
[2]: Donald D. Chamberlin, Raymond F. Boyce, Irving L. Traiger: A Deadlock-Free Scheme for Resource Locking in a Data-Base Environment. IFIP Congress 1974: 340-343
[3]: ...
[4]: ...
[5]: ...
[6]: ...
[7]: ...
[8]: J. J. Florentin: Consistency Auditing of Databases. Comput. J. 17(1): 52-58(1974)
[9]: ...
[10]: ...
[11]: Gerald Held, Michael Stonebraker: Storage Structures and Access Methods in the Relational Data Base Management System INGRES. ACM Pacific 1975: 26-33
[12]: E. F. Codd: A Database Sublanguage Founded on the Relational Calculus. SIGFIDET Workshop 1971: 35-68
[13]: ...
[14]: Donald D. Chamberlin, Raymond F. Boyce: SEQUEL: A Structured English Query Language. SIGMOD Workshop, Vol. 1 1974: 249-264
[15]: E. F. Codd: Relational Completeness of Data Base Sublanguages. In: R. Rustin (ed.): Database Systems: 65-98, Prentice Hall and IBM Research Report RJ 987, San Jose, California : (1972)
[16]: Michael Stonebraker: A Functional View of Data Independence. SIGMOD Workshop, Vol. 1 1974: 63-81
[17]: E. F. Codd: A Relational Model of Data for Large Shared Data Banks. Commun. ACM 13(6): 377-387(1970)
[18]: Nancy H. McDonald, Michael Stonebraker: CUPID - The Friendly Query Language. ACM Pacific 1975: 127-131
[19]: James B. Rothnie Jr.: An Approach to Implementing a Relational Data Management System. SIGMOD Workshop, Vol. 1 1974: 277-294
[20]: E. F. Codd: Normalized Data Structure: A Brief Tutorial. SIGFIDET Workshop 1971: 1-17
[21]: E. F. Codd: Recent Investigations in Relational Data Base Systems. IFIP Congress 1974: 1017-1021