Invention Grant
- Patent Title: Multi-partition query governor in a computer database system
- Patent Title (中): 计算机数据库系统中的多分区查询调控器
-
Application No.: US12892919Application Date: 2010-09-28
-
Publication No.: US08135703B2Publication Date: 2012-03-13
- Inventor: Eric Lawrence Barsness , Robert Joseph Bestgen , John Matthew Santosuosso
- Applicant: Eric Lawrence Barsness , Robert Joseph Bestgen , John Matthew Santosuosso
- Applicant Address: US NY Armonk
- Assignee: International Business Machines Corporation
- Current Assignee: International Business Machines Corporation
- Current Assignee Address: US NY Armonk
- Agency: Martin & Associates LLC
- Agent Bret J. Petersen
- Main IPC: G06F7/00
- IPC: G06F7/00 ; G06F17/30 ; G06F3/00

Abstract:
An apparatus and method for a multi-partition query governor in a partitioned computer database system. In preferred embodiments a query governor uses data of a query governor file that is associated with multiple partitions to determine how the query governor manages access to the database across multiple partitions. Also, in preferred embodiments, the query governor in a local partition that receives a query request communicates with a query governor in a target partition to accumulate the total resource demands of the query on the local and target partitions. In preferred embodiments, a query governor estimates whether resources to execute a query will exceed a threshold over all or a combination of database partitions.
Public/Granted literature
- US20110022585A1 MULTI-PARTITION QUERY GOVERNOR IN A COMPUTER DATABASE SYSTEM Public/Granted day:2011-01-27
Information query