Invention Grant
- Patent Title: Optimizing tables with too many columns in a database
-
Application No.: US15897220Application Date: 2018-02-15
-
Publication No.: US10331639B2Publication Date: 2019-06-25
- Inventor: Yaoliang Chen , Min Gong , CaiQin Ma , Yu Wang , Xiaomin Xu , Junchi Yan
- 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: Tutunjuan & Bitetto, P.C.
- Agent Grant Johnson
- Main IPC: G06F16/00
- IPC: G06F16/00 ; G06F16/22 ; G06F16/2455 ; G06F16/2453
Abstract:
Systems for database optimization include a database rebuild module configured to compact columns in an unoptimized database that co-appear in queries to the unoptimized database into a single hyper-column to form an optimized database. A database interface module is configured to accept queries according to a schema for the unoptimized database and to translate the accepted queries into queries according to a schema for the optimized database.
Public/Granted literature
- US20180173737A1 OPTIMIZING TABLES WITH TOO MANY COLUMNS IN A DATABASE Public/Granted day:2018-06-21
Information query
