US 2003/0229640 A1 · Parallel database query processing for non-uniform data sources via buffered access

Abstract

An apparatus, program product and method utilize a dynamically-populated query buffer to facilitate the handling of at least a portion of a database query in parallel. A query is implemented using at least first and second portions, where the second portion of the query is executed in parallel using a plurality of threads. The first portion of the query is executed to dynamically populate a query buffer with records from a data source, and the plurality of threads that execute the second portion of the query are specified to the query buffer so that the effective data source for the second portion of the query comprises the records that are dynamically populated into the query buffer.

Claims28

Dependent claims

A method of executing a database query, the method comprising:

(a) executing a first portion of a query to dynamically populate a query buffer with records from a data source;
and
(b) executing a second portion of the query in parallel using a plurality of threads specified to the query buffer.

Dependencies are inferred from the claim text.

Facts

Application

10/165,235Filed 7 Jun 2002

Published

11 Dec 2003

Term ends

Not estimatedThe source records don’t support an estimate.

Classification9 codes

G06F 16/24553
Query execution: of query operations
G06F 16/24532
Query optimisation: of parallel queries
G06F 16/24554
Of query operations: unary operations; Data partitioning operations
G06F 16/24561
Of query operations: intermediate data storage techniques for performance improvement

Parallel database query processing for non-uniform data sources via buffered access

Life of this patent

Parallel database query processing for non-uniform data sources via buffered access

Life of this patent

Abstract

Claims28