The patent badge is an abbreviated version of the USPTO patent document. The patent badge does contain a link to the full patent document.
The patent badge is an abbreviated version of the USPTO patent document. The patent badge covers the following: Patent number, Date patent was issued, Date patent was filed, Title of the patent, Applicant, Inventor, Assignee, Attorney firm, Primary examiner, Assistant examiner, CPCs, and Abstract. The patent badge does contain a link to the full patent document (in Adobe Acrobat format, aka pdf). To download or print any patent click here.
Patent No.:
Date of Patent:
Mar. 17, 2015
Filed:
Oct. 05, 2012
International Business Machines Corporation, Armonk, NY (US);
Stephan Arenswald, Stuttgart, DE;
Andreas Limmer, Deckenpfronn, DE;
Michael Reichert, Schoenaich, DE;
John B. Tobler, San Jose, CA (US);
Matthias Tschaffler, Nufringen, DE;
Maryela E. Weihrauch, San Jose, CA (US);
International Business Machines Corporation, Armonk, NY (US);
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.