Method to monitor dynamic SQL statements for automatic stabilization in a data sharing environment
US10380104B2 · kind B2 · utility
Assignee
Inventors
Key dates
| Filing date | Aug 9, 2016 |
| Grant date | Aug 13, 2019 |
| Priority date | — |
| Expiry date | Sep 9, 2037 |
Classification
- Technology area (CPC G)Physics
- CPC primaryG06F16/24526
- WIPO fieldComputer technology
- WIPO sectorElectrical engineering
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.
Source: USPTO / EPO open patent data. Objective bibliographic and citation counts.