The patent badge is an abbreviated version of the USPTO patent document. The patent badge does contain a link to the full patent document.
The patent badge is an abbreviated version of the USPTO patent document. The patent badge covers the following: Patent number, Date patent was issued, Date patent was filed, Title of the patent, Applicant, Inventor, Assignee, Attorney firm, Primary examiner, Assistant examiner, CPCs, and Abstract. The patent badge does contain a link to the full patent document (in Adobe Acrobat format, aka pdf). To download or print any patent click here.
Patent No.:
Date of Patent:
May. 28, 2013
Filed:
Nov. 09, 2006
Mark John Anderson, Oronoco, MN (US);
Robert Joseph Bestgen, Rochester, MN (US);
Daniel E. Beuch, Rochester, MN (US);
Curtis Neal Boger, Oronoco, MN (US);
James Michael Flanagan, Rochester, MN (US);
Scott Forstie, Rochester, MN (US);
Shantan Kethireddy, Rochester, MN (US);
Thomas Owen Mckinley, Rochester, MN (US);
Michael Donald Pfeifer, Rochester, MN (US);
Mark John Anderson, Oronoco, MN (US);
Robert Joseph Bestgen, Rochester, MN (US);
Daniel E. Beuch, Rochester, MN (US);
Curtis Neal Boger, Oronoco, MN (US);
James Michael Flanagan, Rochester, MN (US);
Scott Forstie, Rochester, MN (US);
Shantan Kethireddy, Rochester, MN (US);
Thomas Owen McKinley, Rochester, MN (US);
Michael Donald Pfeifer, Rochester, MN (US);
International Business Machines Corporation, Armonk, NY (US);
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.