Patent · US Active

Database execution detail repository

US8452756B2 · kind B2 · utility

13Cited by

1References

6Claims

0Family size

Assignee

International Business Machines Corporation · US

Inventors

Mark J. Anderson · Oronoco, US
Robert Joseph Bestgen · Rochester, US
Daniel E. Beuch · Rochester, US
Curtis Boger · Oronoco, US
James Michael Flanagan · Rochester, US
Scott Forstie · Rochester, US
Shantan Kethireddy · Rochester, US
Thomas Owen McKinley · Rochester, US
Michael D. Pfeifer · Rochester, US

Key dates

Filing date	Nov 9, 2006
Grant date	May 28, 2013
Priority date	—
Expiry date	Mar 16, 2031

Classification

Technology area (CPC G)Physics
CPC primaryG06F16/24547
WIPO fieldComputer technology
WIPO sectorElectrical engineering

Abstract

A database query optimizer includes an access plan storage mechanism that stores execution detail corresponding to a query statement in an access plan cache. By storing execution detail in the access plan cache along with the query statement, the execution detail is available when needed to debug database problems, even after a problem occurs. The execution detail stored in the access plan cache may be mined and analyzed after-the-fact, producing a very powerful tool for debugging database problems. Snapshots of the execution detail may also be created by a user. In addition, the user may setup autonomic snapshots and comparisons so that a user may be alerted from a degradation in database performance between two snapshots.

Source: USPTO / EPO open patent data. Objective bibliographic and citation counts.