Accessing Hierarchical Databases Via SQL Transactions in a Multi-Model Database System.
Abstract
There has been a tremendous growth in recent years in the use of data base management systems (DBMS) throughout the world. The multi-lingual database system (MLDS) was designed to increase the functionality of data base systems by allowing the use of multiple data models and several model based languages on a single system. This system could support a heterogeneous collection of databases, each based on the data model most appropriate for the individual application requirements. MLDS currently supports the use of relational, hierarchical, network, and functional databases. The goal of this thesis is to further increase the functionality of MLDS by permitting a user knowledgeable only in a relational-based data language (SQL) to access and manipulate information in a hierarchical database, while strictly maintaining the integrity of the hierarchical model. This extends the multi-lingual database system to a multi-model database system (MMDS). The emphasis in this thesis is two fold. First, to provide the design analysis necessary to accomplish the translation. More specifically, to develop a process for transforming a hierarchical database schema into an equivalent relational schema and to analyze the SQL requests that are used to access a database and provide a methodology for equivalent access to a hierarchy -based database system. The second area of emphasis is in the implementation of the schema transformation process and language translation methodology within the current MLDS structure. The software engineering aspects of the implementation are detailed to provide a base for further expansion of similar systems.
Document Details
- Document Type
- Technical Report
- Publication Date
- Dec 01, 1987
- Accession Number
- ADA187878
Entities
People
- John A. Zawis
Organizations
- Naval Postgraduate School