Invention Grant
- Patent Title: Derived data dictionary for optimizing transformations of encoded data
-
Application No.: US16210049Application Date: 2018-12-05
-
Publication No.: US11042544B2Publication Date: 2021-06-22
- Inventor: Ian R. Finlay , Robert W. Lyle
- 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: Schmeiser, Olsen & Watts
- Agent Stephanie Carusillo
- Main IPC: G06F16/24
- IPC: G06F16/24 ; G06F16/2453 ; G06F16/22 ; H03M7/40 ; G06F16/23

Abstract:
A database-management system evaluates a query that retrieves and transforms encoded symbols stored in a database. If the stored symbols assume a relatively small set of distinct values, the system initially performs the transformation on every value in the set. During execution of subsequent queries, rather than performing the transformation upon every stored symbol fetched from the database, the system merely returns the previously derived encoded transformation results that correspond to the decoded value of each fetched symbol. If the symbols stored in the database span a relatively large set of distinct values, the system does not initially perform the transformation upon every value in the set. Instead, the first time the system fetches a symbol that has a particular value, it saves that symbol's encoded transformation result and reuses that result the next time it fetches an encoded symbol with the same value.
Public/Granted literature
- US20200183933A1 DERIVED DATA DICTIONARY FOR OPTIMIZING TRANSFORMATIONS OF ENCODED DATA Public/Granted day:2020-06-11
Information query