US 10,380,104 B2Granted

Method to monitor dynamic SQL statements for automatic stabilization in a data sharing environment

AssigneeInternational Business Machines Corporation

InventorsPatrick D. Bossman, Frank D. Bower, Tammie Dang, Peter Kuang, Euna Park, Maryela E. Weihrauch

Life of this patent

Estimating the term…

Loading patent…

Abstract

A database system searches for any statements that satisfy one or more of a set of filtering criteria. When a given dynamic query statement fully satisfies the set of filtering criteria, the given statement is stabilized by persistently storing a bound form of the given dynamic query statement. When the given dynamic query statement partly satisfies the set of filtering criteria, a monitoring request is created with the set of filtering criteria to begin monitoring subsequent executions of the statement, and the statement is linked to the monitoring request. When the given dynamic query statement subsequently fully satisfies the set of filtering criteria, the statement is stabilized by persistently storing the bound form of the statement. When the given dynamic query is re-executed, the stabilized statement is loaded, and the PREPARE process is bypassed.

Claims17

Dependent claims

A method for monitoring dynamic query statements in a database system, comprising:

searching for any dynamic query statements that satisfy one or more of a set of filtering criteria;
when a given dynamic query statement fully satisfies the set of filtering criteria:
stabilizing the given dynamic query statement by persistently storing a bound form of the given dynamic query statement;
when the given dynamic query statement partly satisfies the set of filtering criteria:
creating a monitoring request comprising the set of filtering criteria to begin monitoring subsequent executions of the given dynamic query statement;
linking the given dynamic query statement to the monitoring request;
and
when the given dynamic query statement subsequently fully satisfies the set of filtering criteria, stabilizing the given dynamic query statement by persistently storing the bound form of the given dynamic query statement;
and
when the given dynamic query statement fully satisfies the set of filtering criteria:
receiving a subsequent input of the given dynamic query statement for execution;
retrieving the persistently stored bound form of the given dynamic query statement;
and
inserting the bound form of the given dynamic query statement into an in-memory dynamic statement cache, wherein a PREPARE process is bypassed.

11 more elements

A computer program product for monitoring dynamic query statements in a database system, the computer program product comprising a computer readable storage medium having program instructions embodied therewith, the program instructions executable by a processor to cause the processor to:

search for any dynamic query statements that satisfy one or more of a set of filtering criteria;
when a given dynamic query statement fully satisfies the set of filtering criteria:
stabilize the given dynamic query statement by persistently storing a bound form of the given dynamic query statement;
when the given dynamic query statement partly satisfies the set of filtering criteria:
create a monitoring request comprising the set of filtering criteria to begin monitoring subsequent executions of the given dynamic query statement;
link the given dynamic query statement to the monitoring request;
and
when the given dynamic query statement subsequently fully satisfies the set of filtering criteria, stabilize the given dynamic query statement by persistently storing the bound form of the given dynamic query statement;
and
when the given dynamic query statement fully satisfies the set of filtering criteria:
receive a subsequent input of the given dynamic query statement for execution;
retrieve the persistently stored bound form of the given dynamic query statement;
and
insert the bound form of the given dynamic query statement into an in-memory dynamic statement cache, wherein a PREPARE process is bypassed.

11 more elements

A system, comprising:

a processor;
and
a computer readable storage medium having program instructions embodied therewith, the program instructions executable by the processor to cause the processor to:
search for any dynamic query statements that satisfy one or more of a set of filtering criteria;
when a given dynamic query statement fully satisfies the set of filtering criteria:
stabilize the given dynamic query statement by persistently storing a bound form of the given dynamic query statement;
when the given dynamic query statement partly satisfies the set of filtering criteria:
create a monitoring request comprising the set of filtering criteria to begin monitoring subsequent executions of the given dynamic query statement;
link the given dynamic query statement to the monitoring request;
and
when the given dynamic query statement subsequently fully satisfies the set of filtering criteria, stabilize the given dynamic query statement by persistently storing the bound form of the given dynamic query statement;
and
when the given dynamic query statement fully satisfies the set of filtering criteria:
receive a subsequent input of the given dynamic query statement for execution;
retrieve the persistently stored bound form of the given dynamic query statement;
and
insert the bound form of the given dynamic query statement into an in-memory dynamic statement cache, wherein a PREPARE process is bypassed.

14 more elements

Dependencies are inferred from the claim text.