Freytag, Johann Christoph.
Translating Relational Queries into Iterative Programs [electronic resource] / by Johann Christoph Freytag. - Berlin, Heidelberg : Springer Berlin Heidelberg, 1987. - XIV, 134 p. online resource. - Lecture Notes in Computer Science, 261 0302-9743 ; . - Lecture Notes in Computer Science, 261 .
Data models and rewriting systems -- A transformation system based on recursive programs -- Query transformation based on map expressions -- The transformation of aggregate functions -- The implementation of database systems in T -- Conclusion and future work.
This book investigates the problem of translating relational queries into iterative programs using methods and techniques from the areas of functional programming and program transformation. The first part presents two algorithms which generate iterative programs from algebra-based query specifications. While the first algorithm is based on the transformation of recursive programs, the second uses functional expressions to generate the final iterative form. In the second part the same techniques generate efficient programs for the evaluation of aggregate functions in relational database systems. In several steps, programs which perform aggregation after sorting, are transformed into programs which perform aggregation while sorting. The third part then investigates the Lisp-dialect T as a possible implementation language for database systems. The book describes all transformations by transformation rules. The reader can expect a formal treatment of the proposed transformations which provide the basis for proving the correctness of the algorithms and, at the same time, give important insight into the techniques and methods developed for the transformation. Additionally, the high-level, detailed description of the algorithms immediately leads to their implementation and allows their extension to meet new requirements. Overall, the use of transformation rules and transformation methods introduces a new approach to query processing in relational database systems.
9783540472094
10.1007/BFb0055115 doi
Computer science.
Database management.
Information storage and retrieval systems.
Computer Science.
Database Management.
Information Storage and Retrieval.
QA76.9.D3
005.74
Translating Relational Queries into Iterative Programs [electronic resource] / by Johann Christoph Freytag. - Berlin, Heidelberg : Springer Berlin Heidelberg, 1987. - XIV, 134 p. online resource. - Lecture Notes in Computer Science, 261 0302-9743 ; . - Lecture Notes in Computer Science, 261 .
Data models and rewriting systems -- A transformation system based on recursive programs -- Query transformation based on map expressions -- The transformation of aggregate functions -- The implementation of database systems in T -- Conclusion and future work.
This book investigates the problem of translating relational queries into iterative programs using methods and techniques from the areas of functional programming and program transformation. The first part presents two algorithms which generate iterative programs from algebra-based query specifications. While the first algorithm is based on the transformation of recursive programs, the second uses functional expressions to generate the final iterative form. In the second part the same techniques generate efficient programs for the evaluation of aggregate functions in relational database systems. In several steps, programs which perform aggregation after sorting, are transformed into programs which perform aggregation while sorting. The third part then investigates the Lisp-dialect T as a possible implementation language for database systems. The book describes all transformations by transformation rules. The reader can expect a formal treatment of the proposed transformations which provide the basis for proving the correctness of the algorithms and, at the same time, give important insight into the techniques and methods developed for the transformation. Additionally, the high-level, detailed description of the algorithms immediately leads to their implementation and allows their extension to meet new requirements. Overall, the use of transformation rules and transformation methods introduces a new approach to query processing in relational database systems.
9783540472094
10.1007/BFb0055115 doi
Computer science.
Database management.
Information storage and retrieval systems.
Computer Science.
Database Management.
Information Storage and Retrieval.
QA76.9.D3
005.74