Title :
SQL query modification algorithms
Author :
Chou, Darong ; Segev, Arie
Author_Institution :
California Univ., Berkeley, CA, USA
Abstract :
Algebra rules and a query modification algorithm that enable modifications of SQL queries considered hitherto as nonmodifiable are introduced. Cases where aggregates are involved are emphasized. Also introduced is a technique to translate a view with DISTINCT keyword into an equivalent grouped view without DISTINCT; as a result some queries that were not modifiable on the DISTINCT view become modifiable. A set of commutative and merging rules at the relational algebra level that are used to derive the query modification algorithm systematically is developed
Keywords :
query languages; relational databases; DISTINCT keyword; SQL query modification algorithms; commutative rules; merging rules; relational algebra level; Aggregates; Algebra; Contracts; Laboratories; Law; Legal factors; Relational databases; Research and development; Research and development management; Terminology;
Conference_Titel :
Information Technology, 1990. 'Next Decade in Information Technology', Proceedings of the 5th Jerusalem Conference on (Cat. No.90TH0326-9)
Conference_Location :
Jerusalem
Print_ISBN :
0-8186-2078-1
DOI :
10.1109/JCIT.1990.128327
