Title :
The Kendall Square Query Decomposer
Author :
Reiner, David S.
Author_Institution :
Kendall Square Res. Corp. Waltham, MA, USA
Abstract :
The Kendall Square Query Decomposer works in conjunction with the underlying ORACLE7 relational database management system to greatly speed the execution of decision support queries. Based on the data access strategy selected for a query by the ORACLE query optimizer, the Query Decomposer generates a number of subqueries to match the underlying physical data partitions of a table on disk. These subqueries are submitted in parallel to ORACLE over multiple connections. The subqueries are executed in parallel, each accessing only its own part of the driving table. Finally, the Query Decomposer assembles subquery results and returns the full result
Keywords :
distributed databases; parallel programming; query processing; relational databases; Kendall Square Query Decomposer; ORACLE query optimizer; ORACLE7; data access strategy; decision support queries; physical data partitions; relational database management system; Aggregates; Assembly; Knee; Mission critical systems; Packaging; Relational databases; Scattering; Sorting; Table lookup;
Conference_Titel :
Parallel and Distributed Information Systems, 1993., Proceedings of the Second International Conference on
Conference_Location :
San Diego, CA
Print_ISBN :
0-8186-3330-1
DOI :
10.1109/PDIS.1993.253075
