Invention Grant
- Patent Title: Continuous automatic update statistics evaluation using change data capture techniques
-
Application No.: US15467743Application Date: 2017-03-23
-
Publication No.: US10210238B2Publication Date: 2019-02-19
- Inventor: Nita Dembla , Marco Greco , Bingjie Miao
- 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: G06F17/30
- IPC: G06F17/30

Abstract:
In a method for table statistics update, in response to a request to modify a row in a target table, a database management system inspects a log record for the modified row in the target table, determines that the target table is configured for continuous statistics evaluation, and determines whether a mini-bin related to the modified row exists. When the mini-bin related to the modified row does not exist, the database management system creates the mini-bin. When the mini-bin related to the modified row exists, the database management system aggregates the modified row into the mini-bin, and when the mini-bin is determined to have reached a threshold size, stores the mini-bin to a disk. The database management system then consolidates a plurality of mini-bins stored in the disk and corresponding to the target table into a set of bins.
Public/Granted literature
- US20170249342A1 Continuous Automatic Update Statistics Evaluation Using Change Data Capture Techniques Public/Granted day:2017-08-31
Information query