Investigations into the Application of the Relational Model to Data Translation.

@inproceedings{DBLP:conf/sigmod/NavatheM75,
  author    = {Shamkant B. Navathe and
               Alan G. Merten},
  editor    = {W. Frank King},
  title     = {Investigations into the Application of the Relational Model to
               Data Translation},
  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     = {123-138},
  ee        = {http://doi.acm.org/10.1145/500080.500098, db/conf/sigmod/NavatheM75.html},
  crossref  = {DBLP:conf/sigmod/75},
  bibsource = {DBLP, http://dblp.uni-trier.de}
}

Abstract

Experience with data translation over the last two years has resulted in a definite set of requirements for the normalized representation of data when used as an intermediate form during the process. The logical requirements pertain to the ability to represent a class of data structures including networks. The implementation requirements include the specification of two physical representations termed as the Restructurer Internal Form and the Interchange Form.

Recent investigations with the Normal Forms of the relational model have shown that

1. they satisfy the logical requirements
2. a complete normalization to the third Normal Form requires excessive dependency data and results in reducing the restructuring operation to an identity transformation.
3. normalization is not conducive to localizing the restructuring operations in the translator
4. the first Normal Form used as a vehicle for translation poses problems with specification of keys and in handling networks.

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

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

References

[CODASYL (1971)]

...

[CODD (1970)]

E. F. Codd: A Relational Model of Data for Large Shared Data Banks. Commun. ACM 13(6): 377-387(1970)

[CODD (1971)]

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

[CODD AND DATE (1974)]

E. F. Codd, C. J. Date: Interactive Support For Non-Programmers: The Relational and Network Approaches. SIGMOD Workshop, Vol. 2 1974: 11-41

[DEFIORE et al.(1971)]

...

[DELOBEL AND CASEY (1973)]

...

[FRY et al. (1972)]

James P. Fry, Randall L. Frank, Ernest A. Hershey III: A Development Model for Data Translation. SIGFIDET Workshop 1972: 77-105

[FRY et al. (1972)]

James P. Fry, Diane C. P. Smith, Robert W. Taylor: An Approach to Stored Data Definition and Translation. SIGFIDET Workshop 1972: 13-56

[FRY et al (1974)]

...

[GOLDSTEIN AND STRNAD (1970)]

Robert C. Goldstein, Alois Strnad: The MacAIMS Data Management System. SIGFIDET Workshop 1970: 201-229

[NAVATHE (1974)]

...

[NAVATHE AND FRY (1974)]

...

[ROTHNIE (1974)]

James B. Rothnie Jr.: An Approach to Implementing a Relational Data Management System. SIGMOD Workshop, Vol. 1 1974: 277-294

[SIBLEY AND TAYLOR (1973)]

Edgar H. Sibley, Robert W. Taylor: A Data Definition and Mapping Language. Commun. ACM 16(12): 750-759(1973)

[STEUERT AND GOLDMAN (1974)]

James Steuert, Jay Goldman: The Relational Data Management System: A Perspective. SIGMOD Workshop, Vol. 1 1974: 295-320

[WANG AND WEDEKIND (1974)]

...