Invention Grant
- Patent Title: Optimizing tables with too many columns in a database
-
Application No.: US15992641Application Date: 2018-05-30
-
Publication No.: US10318507B2Publication Date: 2019-06-11
- 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: Tutunjian & Bitetto, P.C.
- Agent Grant Johnson
- Main IPC: G06F17/30
- IPC: G06F17/30 ; G06F16/22 ; G06F16/2455 ; G06F16/2453
Abstract:
Methods and systems for database optimization include compacting columns in an unoptimized database that co-appear in queries to the database into a single hyper-column using a processor to form an optimized database. Queries are received according to a schema for the unoptimized database. The received queries are translated into queries according to a schema for the optimized database.
Public/Granted literature
- US20180276258A1 OPTIMIZING TABLES WITH TOO MANY COLUMNS IN A DATABASE Public/Granted day:2018-09-27
Information query
