Invention Grant
- Patent Title: Database table format conversion based on user data access patterns in a networked computing environment
-
Application No.: US15809004Application Date: 2017-11-10
-
Publication No.: US10725991B2Publication Date: 2020-07-28
- Inventor: Lisa Seacat DeLuca , Yu Deng , Jenny S. Li , Liangzhao Zeng
- 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: Keohane & D'Alessandro PLLC
- Agent William H. Hartwell; Maxine L. Barasch
- Main IPC: G06F16/22
- IPC: G06F16/22 ; G06F16/84 ; G06F16/25

Abstract:
An approach for conversion between database formats (e.g., from a relational database format to a hash table or a “big table” database format) based on user data access patterns in a networked computing environment is provided. A first set of database tables having a first format is identified based on a set of access patterns stored in a computer storage device. A second set of database tables having a second database format corresponding to the first set of database tables may then be provided (e.g., accessed, augmented, and/or generated). A mapping between the first set of database tables and the second set of database tables may then be created. A column set may then be generated based on at least one condition of the set of queries. The column set may then be used as a key for the second set of database tables.
Public/Granted literature
- US20180095961A1 DATABASE TABLE FORMAT CONVERSION BASED ON USER DATA ACCESS PATTERNS IN A NETWORKED COMPUTING ENVIRONMENT Public/Granted day:2018-04-05
Information query