Logical Design and Schema Conversion for Relational and DBTG Databases.

Eugene Wong, Randy H. Katz: Logical Design and Schema Conversion for Relational and DBTG Databases. ER 1979: 311-322

@inproceedings{DBLP:conf/er/WongK79,
  author    = {Eugene Wong and
               Randy H. Katz},
  editor    = {Peter P. Chen},
  title     = {Logical Design and Schema Conversion for Relational and DBTG
               Databases},
  booktitle = {Entity-Relationship Approach to Systems Analysis and Design.
                Proc. 1st International Conference on the Entity-Relationship
               Approach},
  publisher = {North-Holland},
  year      = {1979},
  isbn      = {0-444-85487-8},
  pages     = {311-322},
  ee        = {db/conf/er/WongK79.html},
  crossref  = {DBLP:conf/er/79},
  bibsource = {DBLP, http://dblp.uni-trier.de}
}

Abstract

The objective of this paper is three-fold: first, a variant of the Entity-Relationship model is proposed as the data model for logical design. In terms of the constructs of the model "update anomalies" are precisely defined. Second, with the prevention of "update anomalies" as the goal for logical design, mapping rules will be proposed for transforming a design schema into a corresponding schema of either relational or DBTG type. Third, it is shown that with relatively minor semantic augmentation of DBTG and relational data models, the mapping is reversible. As a consequence, reversible schema conversion between DBTG and relational models becomes possible.

ACM SIGMOD Anthology

CDROM Version: Load the CDROM "Volume 2 Issue 1, ER 1979-1998" 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/An2-1 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

References

[BERN76]: Philip A. Bernstein: Synthesizing Third Normal Form Relations from Functional Dependencies. ACM Trans. Database Syst. 1(4): 277-298(1976)
[CHEN76]: Peter P. Chen: The Entity-Relationship Model - Toward a Unified View of Data. ACM Trans. Database Syst. 1(1): 9-36(1976)
[CODD71]: E. F. Codd: Further Normalization of the Data Base Relational Model. IBM Research Report, San Jose, California RJ909: (1971)
[CODD79]: E. F. Codd: Extending the Database Relational Model to Capture More Meaning. ACM Trans. Database Syst. 4(4): 397-434(1979)
[FAGI77a]: Ronald Fagin: Multivalued Dependencies and a New Normal Form for Relational Databases. ACM Trans. Database Syst. 2(3): 262-278(1977)
[FAGI77b]: Ronald Fagin: The Decomposition Versus Synthetic Approach to Relational Database Design. VLDB 1977: 441-446
[NIJI75]: G. M. Nijssen: Set and CODASYL Set or Coset. IFIP TC-2 Special Working Conference on Data Base Description 1975: 1-72
[SCHM75]: Hans Albrecht Schmid, J. Richard Swenson: On the Semantics of the Relational Data Model. SIGMOD Conference 1975: 211-223