Method of efficient collection of SQL performance measures

Details Method of efficient collection of SQL performance measures Method of efficient collection of SQL performance measures

1997-04-11

1999-01-12

Black, Thomas G.

Data processing: database and file management or data structures

Database design

Data structure types

707 2, 707 3, 707 5, G06F 1730

Patent

active

058600698

ABSTRACT:
A computerized method of intercepting SQL processing within a relational database. The relational database includes a relational database management program having SQL processing logic. The method includes the steps of: (a) enabling an SQL intercept code by connecting directly into the SQL processing logic of the relational database management program; (b) using the SQL intercept code to intercept an SQL statement made to the relational database; (c) using the SQL intercept code to collect a first set of real-time SQL performance information located in selected structures of the relational database; (d) returning control to the SQL processing logic until the relational database management program has processed the SQL statement to completion; (e) using the SQL intercept code to collect a second set of real-time SQL performance information located in the structures; (f) comparing the first set with the second set in order to measure the performance of the SQL statement; and (g) returning control to the relational database management program.

REFERENCES:
patent: 5555367 (1996-09-01), Premerlani et al.
patent: 5664172 (1997-09-01), Antoshenkov
patent: 5724569 (1998-03-01), Andres
patent: 5742806 (1998-04-01), Reiner et al.
patent: 5758357 (1998-05-01), Barry et al.
patent: 5761654 (1998-06-01), Tow
patent: 5761657 (1998-06-01), Hoang
patent: 5765146 (1998-06-01), Wolf et al.
patent: 5765147 (1998-06-01), Mattos et al.
IBM Database 2 performance: Design, Implementation, and tuning, Cheng et al., IBM Systems Journal, vol. 23, No. 2, Aug. 1984, pp. 189-210.
Fast Algorithms for Universal Quantification in Large Database, Graefe et al., ACM Transactions on Database Systems, vol. 20, No. 2, Jun. 1995, pp. 187-236.
A Performance Analysis of Relational And Hierarchical Database Packages based on Query Response, Warren G. Weis, Computing vol. 3, No. 4, pp. 18-26, Sep. 1995.
Detector User Guide, Detector V2.1 P512AD Addendum, Platinum Technology, Feb. 1997.
SmartMode overview http://www.ibi.com/products/smartmode/overview.html, Nov. 1994.
Statement of inventor regarding upatented prior art, No Date.

Affiliated with

Also associated with

Rating

Method of efficient collection of SQL performance measures does not yet have a rating. At this time, there are no reviews or comments for this patent.

If you have personal experience with Method of efficient collection of SQL performance measures, we encourage you to share that experience with our LandOfFree.com community. Your opinion is very important and Method of efficient collection of SQL performance measures will most certainly appreciate the feedback.

Rate now

Comments { 0 }

Profile ID: LFUS-PAI-O-1524806