Invention Grant
- Patent Title: Managing execution of a query against selected data partitions of a partitioned database
- Patent Title (中): 管理针对分区数据库的选定数据分区的查询执行
-
Application No.: US11468966Application Date: 2006-08-31
-
Publication No.: US07962442B2Publication Date: 2011-06-14
- Inventor: Eric L. Barsness , John M. Santosuosso
- Applicant: Eric L. Barsness , John M. Santosuosso
- Applicant Address: US NY Armonk
- Assignee: International Business Machines Corporation
- Current Assignee: International Business Machines Corporation
- Current Assignee Address: US NY Armonk
- Agency: Patterson & Sheridan, LLP
- Main IPC: G06F7/00
- IPC: G06F7/00

Abstract:
The present invention generally relates to data processing, and more specifically to executing queries against a partitioned database. One embodiment provides a computer-implemented method of managing execution of a query against a partitioned database having a plurality of data partitions. The method comprises receiving a query having conditional filtering logic to restrict the data records in the partitioned database to a result set satisfying the conditional filtering logic. On the basis of an indication that only a subset of the result set is to be returned, a subset of data partitions is determined from the plurality of data partitions from which the subset of the result set can be retrieved. Then, the query is executed only against the subset of data partitions.
Public/Granted literature
- US20080059408A1 MANAGING EXECUTION OF A QUERY AGAINST SELECTED DATA PARTITIONS OF A PARTITIONED DATABASE Public/Granted day:2008-03-06
Information query