Multi-partition query governor in a computer database system

Details Multi-partition query governor in a computer database system Multi-partition query governor in a computer database system

2006-12-05

2010-12-14

Vo, Tim T. (Department: 2168)

Data processing: database and file management or data structures

Database and file access

Query optimization

C707S759000, C715S738000

Reexamination Certificate

active

07853584

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 determines 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.

REFERENCES:
patent: 4769772 (1988-09-01), Dwyer
patent: 5325525 (1994-06-01), Shan et al.
patent: 5446886 (1995-08-01), Li
patent: 5826269 (1998-10-01), Hussey
patent: 6021405 (2000-02-01), Celis et al.
patent: 6405198 (2002-06-01), Bitar et al.
patent: 2004/0143571 (2004-07-01), Bjornson et al.
patent: 2005/0060285 (2005-03-01), Barsness et al.
patent: 2005/0097099 (2005-05-01), Kapoor et al.
patent: 2005/0192951 (2005-09-01), Day et al.
patent: 2005/0262045 (2005-11-01), Tsuchida et al.

Affiliated with

Also associated with

Rating

Multi-partition query governor in a computer database system does not yet have a rating. At this time, there are no reviews or comments for this patent.

If you have personal experience with Multi-partition query governor in a computer database system, we encourage you to share that experience with our LandOfFree.com community. Your opinion is very important and Multi-partition query governor in a computer database system will most certainly appreciate the feedback.

Rate now

Comments { 0 }

Profile ID: LFUS-PAI-O-4197349