Invention Grant
US08386463B2 Method and apparatus for dynamically associating different query execution strategies with selective portions of a database table
失效
用于将不同查询执行策略与数据库表的选择性部分动态关联的方法和装置
- Patent Title: Method and apparatus for dynamically associating different query execution strategies with selective portions of a database table
- Patent Title (中): 用于将不同查询执行策略与数据库表的选择性部分动态关联的方法和装置
-
Application No.: US11181713Application Date: 2005-07-14
-
Publication No.: US08386463B2Publication Date: 2013-02-26
- Inventor: Robert Joseph Bestgen , Shantan Kethireddy , Jeffrey Wayne Tenner
- Applicant: Robert Joseph Bestgen , Shantan Kethireddy , Jeffrey Wayne Tenner
- Applicant Address: US NY Armonk
- Assignee: International Business Machines Corporation
- Current Assignee: International Business Machines Corporation
- Current Assignee Address: US NY Armonk
- Agent Roy W. Truelson
- Main IPC: G06F11/30
- IPC: G06F11/30

Abstract:
A query facility for database queries dynamically determines whether selective portions of a database table are likely to benefit from separate query execution strategies, and constructs an appropriate separate execution strategies accordingly. Preferably, the database contains at least one relatively large table comprising multiple partitions, each sharing the definitional structure of the table and containing a different respective discrete subset of the table records. The query facility compares metadata for different partitions to determine whether sufficiently large differences exist among the partitions, and in appropriate cases selects one or more partitions for separate execution strategies. Preferably, partitions are ranked for separate evaluation using a weighting formula which takes into account: (a) the number of indexes for the partition, (b) recency of change activity, and (c) the size of the partition.
Public/Granted literature
Information query