Patent · US Active

Monitoring stored procedure execution

US8984023B2 · kind B2 · utility

0Cited by

4References

18Claims

0Family size

Assignee

International Business Machines Corporation · US

Inventors

Stephan ARENSWALD · Stuttgart, DE
Andreas Limmer · Seybothenreuth, DE
Michael Reichert · Hildrizhausen, DE
John B. Tobler · San Jose, US
Matthias Tschaffler · Nufringen, DE
Maryela E. Weihrauch · San Jose, US

Key dates

Filing date	Oct 5, 2012
Grant date	Mar 17, 2015
Priority date	—
Expiry date	Feb 1, 2033

Classification

Technology area (CPC G)Physics
CPC primaryG06F16/2455
WIPO fieldComputer technology
WIPO sectorElectrical engineering

Abstract

A computer-implemented method, system, and/or computer program product monitors stored procedures that are executed in a database management system. A determination is made, for a stored procedure that is executed in a database management system, of an identification of the stored procedure and event data related to the stored procedure. The event data includes when the stored procedure began and ended executing, an SQL identifier for an SQL statement in the stored procedure, and a counter of how many times the SQL statement executed. The database management system provides values of parameters used when executing the SQL statement. These values are then correlated with the count of how many times the SQL statement executed.

Source: USPTO / EPO open patent data. Objective bibliographic and citation counts.