Design of Relational Views over Network Schemas.

@inproceedings{DBLP:conf/sigmod/Zaniolo79,
  author    = {Carlo Zaniolo},
  editor    = {Philip A. Bernstein},
  title     = {Design of Relational Views over Network Schemas},
  booktitle = {Proceedings of the 1979 ACM SIGMOD International Conference on
               Management of Data, Boston, Massachusetts, May 30 - June 1},
  publisher = {ACM},
  year      = {1979},
  isbn      = {0-89791-001-X},
  pages     = {179-190},
  ee        = {http://doi.acm.org/10.1145/582095.582126, db/conf/sigmod/Zaniolo79.html},
  crossref  = {DBLP:conf/sigmod/79},
  bibsource = {DBLP, http://dblp.uni-trier.de}
}

Abstract

An algorithm is presented for designing relational views over network schemas to :

(1) support general query and update capability, (2) preserve the information content of the data base and (3) provide independence from its physical organization. The proposed solution is applicable to many existing CCDASYL databases without data or schema conversion. The particular declarations of a CDDASYL schema which supply sources of logical data definition are first identified. Then the view design algorithm is derived on the basis of a formal analysis of the semantic constraints established by these declarations. A new form of data structure diagram is also introduced to visualize these constraints.

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

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

• 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

Online Edition: ACM Digital Library

References

[CODA 73]

...

[CODA 78]

CODASYL: Reports of the Data Description Language Committee. Inf. Syst. 3(4): 247-320(1978)

[CODD 72]

E. F. Codd: Further Normalization of the Data Base Relational Model. IBM Research Report, San Jose, California RJ909: (1971)

[DATE 77]

...

[DAYA 78]

Umeshwar Dayal, Philip A. Bernstein: On the Updatability of Relational Views. VLDB 1978: 368-377

[FAGI 77]

Ronald Fagin: Multivalued Dependencies and a New Normal Form for Relational Databases. ACM Trans. Database Syst. 2(3): 262-278(1977)

[GOLD 79]

...

[JOHN 78]

...

[SEVC 78]

...

[SMIT 77]

John Miles Smith, Diane C. P. Smith: Database Abstractions: Aggregation and Generalization. ACM Trans. Database Syst. 2(2): 105-133(1977)

[ZANI 77]

...

[ZANI 78]

Carlo Zaniolo: Design of Relational Views over Network Schemas. SIGMOD Conference 1979: 179-190

[ZANI 79]

...