Invention Grant
- Patent Title: Query restart based on changing system resources and an amount of data change
-
Application No.: US15384595Application Date: 2016-12-20
-
Publication No.: US10409812B2Publication Date: 2019-09-10
- Inventor: Eric L. Barsness , Daniel E. Beuch , Alexander Cook , Brian R. Muras , John M. Santosuosso
- 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: Patterson + Sheridan, LLP
- Main IPC: G06F16/00
- IPC: G06F16/00 ; G06F16/2453

Abstract:
Techniques are described for re-starting queries based on an expected amount of data to be changed in a database. Embodiments of the present disclosure may generally receive a first query to be executed against a database, and start execution of the first query against the database according to a first access plan. Upon detecting, during execution of the first query, that an amount of data to be changed in one or more tables of the database as a result of a second query satisfies a predetermined condition, embodiments of the present disclosure determine whether to re-start execution of the first query against the database with a second access plan different from the first access plan or wait a predetermined period of time before re-starting execution of the first query against the database with the first access plan.
Public/Granted literature
- US20180173759A1 QUERY RESTART BASED ON CHANGING SYSTEM RESOURCES AND AN AMOUNT OF DATA CHANGE Public/Granted day:2018-06-21
Information query