Invention Grant
- Patent Title: Method to monitor dynamic SQL statements for automatic stabilization in a data sharing environment
-
Application No.: US15231838Application Date: 2016-08-09
-
Publication No.: US10380104B2Publication Date: 2019-08-13
- Inventor: Patrick D. Bossman , Frank D. Bower , Tammie Dang , Peter Kuang , Euna Park , Maryela E. Weihrauch
- Applicant: International Business Machines Corporation
- Applicant Address: US NY Armonk
- Assignee: International Business Machines Corporation
- Current Assignee: International Business Machines Corporation
- Current Assignee Address: US NY Armonk
- Agency: North Shore Patents, P.C.
- Agent Michele Liu Baillie
- Main IPC: G06F16/242
- IPC: G06F16/242 ; G06F16/2452

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.
Public/Granted literature
- US20180046677A1 METHOD TO MONITOR DYNAMIC SQL STATEMENTS FOR AUTOMATIC STABILIZATION IN A DATA SHARING ENVIRONMENT Public/Granted day:2018-02-15
Information query