Design and Implementation of a Query Editor for the Amadeus System
Abstract
One side effect of the proliferation of relational databases within a single organization is that sharing of data to access a global information base is difficult. People erroneously assume that since almost all of the commercially available RDBMSs support the Structured Query Language (SQL), sharing of data is easy. Unfortunately, currently available systems only support a specific dialect of SQL. The Amadeus front-end system overcomes the data- sharing problem. With the Amadeus front-end system, database users can use one common language called Dataflow Query Language (DFQL) to access heterogeneous RDBMSS. A query specified in DFQL is correctly translated into a SQL dialect that the connected RDBMS recognizes. With this front-end approach, the user can access data from multiple databases by writing a single DFQL query, instead of writing multiple SQL queries. A prototype query builder is reimplemented using an object-oriented design. This component of Amadeus interacts with the user for creating DFQL queries. Adding a connection to a new SQL-based Object-oriented programming, Data flow query, Prograph, Visual programming, Database systems, SQL, Relational model, Relational calculus, Relational algebra.
Document Details
- Document Type
- Technical Report
- Publication Date
- Sep 01, 1993
- Accession Number
- ADA274955
Entities
People
- Turgay Cince
Organizations
- Naval Postgraduate School