18544049. METHODS AND SYSTEM FOR RECOMMENDING STORAGE FORMAT FOR MIGRATING A RDBMS simplified abstract (Huawei Technologies Co., Ltd.)

From WikiPatents
Revision as of 10:15, 19 September 2024 by Wikipatents (talk | contribs) (Creating a new page)
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Jump to navigation Jump to search

METHODS AND SYSTEM FOR RECOMMENDING STORAGE FORMAT FOR MIGRATING A RDBMS

Organization Name

Huawei Technologies Co., Ltd.

Inventor(s)

Vishal Navnit Pandya of Bengaluru (IN)

Vineet Kumar Maheshwari of Bengaluru (IN)

METHODS AND SYSTEM FOR RECOMMENDING STORAGE FORMAT FOR MIGRATING A RDBMS - A simplified explanation of the abstract

This abstract first appeared for US patent application 18544049 titled 'METHODS AND SYSTEM FOR RECOMMENDING STORAGE FORMAT FOR MIGRATING A RDBMS

The present disclosure describes a method for recommending storage formats when migrating a relational database management system (RDBMS) from a source server system to a target server system.

  • The method involves extracting SQL queries from the source database of the source server system.
  • The SQL queries are then parsed to identify a set of queries related to column-based operations.
  • The method identifies the number of columns involved in the queries and determines if values of at least a subset of column records are the same.
  • If the values of the subset of column records are the same, the method recommends a column storage format for the RDBMS on the target server system.

Potential Applications: - Database migration processes - Database management systems optimization

Problems Solved: - Efficiently recommending storage formats during database migration - Enhancing the performance of the RDBMS on the target server system

Benefits: - Streamlined database migration process - Improved performance of the RDBMS - Cost-effective storage format recommendations

Commercial Applications: Title: Database Migration Optimization Tool This technology can be utilized by IT companies specializing in database management services to enhance the efficiency of database migration processes, ultimately improving client satisfaction and reducing operational costs.

Questions about the technology: 1. How does this method improve the efficiency of database migration processes? 

  - This method streamlines the process by recommending optimal storage formats based on the analysis of SQL queries, reducing the time and resources required for migration.

2. What are the potential cost savings associated with implementing this method? 

  - By recommending efficient storage formats, this method can help companies save on storage costs and optimize the performance of their RDBMS.


Original Abstract Submitted

The present disclosure provides a method of recommending storage format for migrating a relational database management system (RDBMS) from a source server system to a target server system, and a system thereof. The method comprises extracting SQL queries from a source database of the source server system. Further, the method comprises parsing the SQL queries to identify a set of queries corresponding to column-based operations, identifying a number of columns (Cn) involved in the identified set of queries and for each column (C), from the number of columns (Cn), determining if values of at least a subset of column records are same. On determining that values of the at least the subset of the column records are the same, the method further comprises recommending a column storage format for the RDBMS on the target server system.

Retrieved from "http://wikipatents.org/index.php?title=18544049._METHODS_AND_SYSTEM_FOR_RECOMMENDING_STORAGE_FORMAT_FOR_MIGRATING_A_RDBMS_simplified_abstract_(Huawei_Technologies_Co.,_Ltd.)&oldid=235153"