Invention Grant
- Patent Title: Automatically revising synopsis table structure
-
Application No.: US15474020Application Date: 2017-03-30
-
Publication No.: US10725995B2Publication Date: 2020-07-28
- Inventor: Ian R. Finlay , Christian M. Garcia-Arellano , Adam J. Storm , Calisto P. Zuzarte
- 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
- Agent Edward J. Wixted, III
- Main IPC: G06F16/22
- IPC: G06F16/22 ; G06F16/23 ; G06F16/215

Abstract:
Merging adjacent rows of a synopsis table so as to increase the effectiveness of the synopsis table regarding data skipping. Adjacent rows for merging are identified based on statistics regarding: (i) queries of the database; (ii) effectiveness of the synopsis table for data skipping; and (iii) usage of predicates in queries of the database. Once merged, the synopsis table is smaller, and more effective with respect to data skipping, while fewer computing resources (administrative, maintenance, memory, clock cycles, storage space, etc.) are needed to process the database queries.
Public/Granted literature
- US20170293642A1 AUTOMATICALLY REVISING SYNOPSIS TABLE STRUCTURE Public/Granted day:2017-10-12
Information query