The Kendall Square Query Decomposer

Author

Reiner, David S.

Author_Institution

Kendall Square Res. Corp. Waltham, MA, USA

fYear

1993

fDate

20-22 Jan 1993

Firstpage

36

Lastpage

37

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;

fLanguage

English

Publisher

ieee

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

Type

conf

DOI

10.1109/PDIS.1993.253075

Filename

253075