Developing an Automated Technique for Translating a Relational Database into an Equivalent Network One.
Abstract
This thesis developed an automated technique for translating a relational schema into an equivalent network one. In addition to the usual translation applications, this technique is the major step towards developing the multi-model data base management system which enables implementing both relational and network databases via one system, allows the use of either relational or network commands, solves the problem of converting applications, and eases the communication between data base management systems. Reviewing the previous efforts in that field, there are two algorithms that were developed for the same objective. Each one was discussed explained, and used to solve an illustrative example. Both algorithms were compared and one was chosen as a basis for developing the automated technique. The chosen algorithm was modified to suit the requirements, and analyzed and decomposed using the SADT(Structural Analysis and Design Technique). The automated technique was developed and coded in PASCAL. In its development, it was considered to be user friendly, and to produce the network schema in a suitable format. The developed technique was tested and implemented using a relational schema in the third normal form. The resulting network schema was efficient, nonredundant, and had the minimum and necessary number of record types and sets as it was supposed to be. Originator-Supplied keywords include: Database, Multi-Model DBMS - Database Translation, Relational Database, Network Database.
Document Details
- Document Type
- Technical Report
- Publication Date
- Dec 01, 1984
- Accession Number
- ADA151844
Entities
People
- E. Y. Aly
Organizations
- Air Force Institute of Technology