Accession Number : ADA187878

Title :   Accessing Hierarchical Databases Via SQL Transactions in a Multi-Model Database System.

Descriptive Note : Master's thesis,

Corporate Author : NAVAL POSTGRADUATE SCHOOL MONTEREY CA

Personal Author(s) : Zawis, John A.

Report Date : DEC 1987

Pagination or Media Count : 124

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.

Descriptors :   *DATA BASES, *MULTIPLE ACCESS, *PROGRAMMING LANGUAGES, REQUIREMENTS, DATA MANAGEMENT, MODELS, HETEROGENEITY, INFORMATION SYSTEMS, LANGUAGE TRANSLATION, METHODOLOGY, COMPUTER PROGRAMS, SYSTEMS ENGINEERING, TRANSFORMATIONS, THESES, ACCESS, COLLECTION, COMPUTER PROGRAMS, DATA BASES, DATA MANAGEMENT, HETEROGENEITY, HIERARCHIES, INFORMATION SYSTEMS, LANGUAGE TRANSLATION, METHODOLOGY, MODELS, REQUIREMENTS, SYSTEMS ENGINEERING, THESES, TRANSFORMATIONS.

Subject Categories : Computer Systems

Distribution Statement : APPROVED FOR PUBLIC RELEASE