The Kendall Square Query Decomposer
David S. Reiner · 2002
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.>