Invention Grant
- Patent Title: Page filtering via compression dictionary filtering
-
Application No.: US15194635Application Date: 2016-06-28
-
Publication No.: US10432217B2Publication Date: 2019-10-01
- Inventor: Ian R. Finlay
- 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 Ewa M. Wozniak
- Main IPC: G06F16/22
- IPC: G06F16/22 ; H03M7/30

Abstract:
Page filtering in a database using a compression dictionary. A page of a database table is compressed, creating a compression dictionary. The compression dictionary includes entries with a byte sequence from the page and a compression symbol associated with the byte sequence. A part of the compressed page, the compression dictionary, and a page symbol list with compression symbols from the dictionary present in the part of the page, are received. A query having a predicate with a predicate value is received. A predicate symbol list, including symbols in the dictionary whose byte sequences at least partially match the predicate value, is generated. Based on the predicate symbol list and the page symbol list, it is determined that at least one symbol from the predicate symbol list is also present in the part of the page. The query is performed by evaluating the predicate on the part of the page.
Public/Granted literature
- US20170371972A1 PAGE FILTERING VIA COMPRESSION DICTIONARY FILTERING Public/Granted day:2017-12-28
Information query