Title:
METHODS AND SYSTEM FOR RECOMMENDING STORAGE FORMAT FOR MIGRATING RDBMS
Document Type and Number:
WIPO Patent Application WO/2022/262325
Kind Code:
A1
Abstract:
A method of recommending storage format for migrating a relational database management system (RDBMS) from a source server system to a target server system, the method comprising: extracting SQL queries from a source database of the source server system (302); parsing the SQL queries to identify a set of queries corresponding to columnar operations (304); identifying a number of columns (Cn) involved in the identified set of queries (306); for each column (C) from the number of columns (Cn), determining if values of at least a subset of column records are same (308); and on determining, recommending a column storage format for the RDBMS on the target server system (310).
Inventors:
PANDYA VISHAL NAVNIT (IN)
MAHESHWARI VINEET KUMAR (IN)
MAHESHWARI VINEET KUMAR (IN)
Application Number:
PCT/CN2022/079412
Publication Date:
December 22, 2022
Filing Date:
March 04, 2022
Export Citation:
Assignee:
HUAWEI TECH CO LTD (CN)
International Classes:
G06F16/24; G06F16/27
Domestic Patent References:
| WO2016194159A1 | 2016-12-08 |
Foreign References:
| US20160078079A1 | 2016-03-17 | |||
| US20160078085A1 | 2016-03-17 | |||
| US20140201244A1 | 2014-07-17 | |||
| US20160253382A1 | 2016-09-01 | |||
| US20200293545A1 | 2020-09-17 |
Download PDF: