TY - BOOK ID - 1081040 TI - Translating relational queries into iterative programs PY - 1987 VL - vol 261 SN - 3540180001 0387180001 3540472096 DB - UniCat KW - Artificial intelligence. Robotics. Simulation. Graphics KW - Information systems KW - 681.3*D11 KW - 681.3*H24 KW - 681.3*I22 KW - Applicative (functional) programming KW - Systems: concurrency; distributed systems; query processing; transaction processing (Database management) KW - Automatic programming: automatic analysis of algorithms; program modification; program synthesis; program transformation; program verification (Artificialintelligence)--See also {681.3*D12}; {681.3*F31} KW - 681.3*I22 Automatic programming: automatic analysis of algorithms; program modification; program synthesis; program transformation; program verification (Artificialintelligence)--See also {681.3*D12}; {681.3*F31} KW - 681.3*H24 Systems: concurrency; distributed systems; query processing; transaction processing (Database management) KW - 681.3*D11 Applicative (functional) programming KW - Database management. KW - Computer science. KW - Information Systems. KW - Database Management. KW - Computer Applications. KW - Management of Computing and Information Systems. KW - Informatics KW - Science KW - Data base management KW - Data services (Database management) KW - Database management services KW - DBMS (Computer science) KW - Generalized data management systems KW - Services, Database management KW - Systems, Database management KW - Systems, Generalized database management KW - Electronic data processing KW - Electronic digital computers. KW - Relational databases. KW - Functional programming languages KW - Programming UR - https://www.unicat.be/uniCat?func=search&query=sysid:1081040 AB - 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. ER -