Invention Grant
US07809694B2 Analysis of performance data from a relational database system for applications using stored procedures or SQL
有权
使用存储过程或SQL从应用程序的关系数据库系统分析性能数据
- Patent Title: Analysis of performance data from a relational database system for applications using stored procedures or SQL
- Patent Title (中): 使用存储过程或SQL从应用程序的关系数据库系统分析性能数据
-
Application No.: US11080171Application Date: 2005-03-15
-
Publication No.: US07809694B2Publication Date: 2010-10-05
- Inventor: Kenneth Carlin Nelson
- Applicant: Kenneth Carlin Nelson
- Applicant Address: US NY Armonk
- Assignee: International Business Machines Corporation
- Current Assignee: International Business Machines Corporation
- Current Assignee Address: US NY Armonk
- Agency: Patterson & Sheridan, LLP
- Main IPC: G06F7/00
- IPC: G06F7/00 ; G06F17/00 ; G06F17/30
Abstract:
Analyzing performance data from a relational database to discover poorly performing SQL statements includes creating event records of performance data for query statements executed by a relational database management system, and condensing the performance data in the event records. A performance summary can be generated for each condensed event record. The performance summaries can then be analyzed based on performance characteristics to identify poorly performing SQL statements.
Public/Granted literature
Information query
