Method of efficient collection of SQL performance measures
US5860069A · kind A · utility
Assignee
Inventor
Key dates
| Filing date | Apr 11, 1997 |
| Grant date | Jan 12, 1999 |
| Priority date | — |
| Expiry date | Apr 11, 2017 |
Classification
- Technology area (CPC Y)Emerging Cross-Sectional Technologies
- CPC primaryY10S707/99934
- WIPO fieldComputer technology
- WIPO sectorElectrical engineering
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.
Source: USPTO / EPO open patent data. Objective bibliographic and citation counts.