Optimization of query evaluation algorithms
ACM Transactions on Database Systems (TODS)
System R: relational approach to database management
ACM Transactions on Database Systems (TODS)
Optimizing the performance of a relational algebra database interface
Communications of the ACM
Principles of Database Systems
Principles of Database Systems
File and Data Base Techniques
Query generation in an instructional database management system
SIGCSE '87 Proceedings of the eighteenth SIGCSE technical symposium on Computer science education
Program transformations and their applications in teaching procedural and nonprocedural languages
SIGCSE '85 Proceedings of the sixteenth SIGCSE technical symposium on Computer science education
REQUEST: a testbed relational database management system for instructional and research purposes
AFIPS '84 Proceedings of the July 9-12, 1984, national computer conference and exposition
| Hi-index | 0.00 |
A database management system designed for instructional use should offer facilities usually not required in a commercial environment. One of the most important features desirable in such a system is its ability to perform query transformation. The use of an universal symbol and tree manipulation system to perform query translation, decomposition and optimization is described in the paper. Examples of transformation rules required to translate SQL expressions into equivalent QUEL expressions, decompose SQL expressions into parse trees and perform optimization of expressions based on relational algebra are shown. An experimental relational DBMS using the above approach is currently under development at the University of Houston. It supports various nonprocedural query languages within a single system, using a unified database dictionary. Cross-translation between various query languages is allowed. The results of every important phase of the query transformation during its execution are interactively available to the system user.