Back to Results

Patent Title: Method and computer program product for implementing skip key processing for database grouping queries involving aggregate operations by using one or more indices

Assignee: IBM
Patent Number: US6260037
Issue Date: 07-10-2001
Application Number:
File Date:02-09-1999

Abstract: A method and computer program product are provided for implementing skip key processing for database grouping queries involving aggregate operations using one or more indices in a computer system. First checking for a selected entry in a current group in a primary file is performed. Responsive to finding the selected entry in the current group, the set of records of the current group is ordered to provide an aggregate value in an aggregate field of the current group. Then checking for an excluded value in the aggregate field of the current group is performed. Responsive to not finding the excluded value in the aggregate field, a current entry is saved as a result for the group. Then checking for more groups in the primary file is performed. Responsive to finding more groups in the primary file, a unique key or prefix to the query index is obtained to position to a next group. When the selected entry in the next group is not found, then checking for more groups in the primary file is performed.

Notes:

Link to USPTO

IBM Pledge dated 1/11/2005