The Commons

Back to Results

Patent Title: Method for executing aggregate queries, and computer system

Assignee: IBM
Patent Number: US6182061
Issue Date: 01-30-2001
Application Number:
File Date:04-09-1998


Abstract: To provide a method for performing a plurality of aggregations in parallel and at a high speed, in a computer system so constructed that each of a plurality of processors connected across a network can use a memory area for itself and a part of the database for itself that includes data categorized into one or a plurality of groups, a method comprising the steps of: (a) ensuring space for storing results of M aggregate queries of the N aggregate queries (M is an integer equal to or less than N) in the memory area for itself in each processor; (b) executing all of the M aggregate queries for the part of the database for itself in each processor; (c) transmitting the results of the M aggregate queries executed by each processor to another processor for counting up and calculating of a final result for counting up; and (d) repeating the steps (a) to (c) until execution of the N aggregate queries is completed by each processor.

Notes:

Link to USPTO

IBM Pledge dated 1/11/2005