发明名称 |
Database execution detail repository |
摘要 |
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.
|
申请公布号 |
US8452756(B2) |
申请公布日期 |
2013.05.28 |
申请号 |
US20060558104 |
申请日期 |
2006.11.09 |
申请人 |
ANDERSON MARK JOHN;BESTGEN ROBERT JOSEPH;BEUCH DANIEL E.;BOGER CURTIS NEAL;FLANAGAN JAMES MICHAEL;FORSTIE SCOTT;KETHIREDDY SHANTAN;MCKINLEY THOMAS OWEN;PFEIFER MICHAEL DONALD;INTERNATIONAL BUSINESS MACHINES CORPORATION |
发明人 |
ANDERSON MARK JOHN;BESTGEN ROBERT JOSEPH;BEUCH DANIEL E.;BOGER CURTIS NEAL;FLANAGAN JAMES MICHAEL;FORSTIE SCOTT;KETHIREDDY SHANTAN;MCKINLEY THOMAS OWEN;PFEIFER MICHAEL DONALD |
分类号 |
G06F17/30;G06F15/16 |
主分类号 |
G06F17/30 |
代理机构 |
|
代理人 |
|
主权项 |
|
地址 |
|