Search

KR-102963352-B1 - Customized database migration system and method

KR102963352B1KR 102963352 B1KR102963352 B1KR 102963352B1KR-102963352-B1

Abstract

A user-customized database migration system and method are disclosed. A user-customized database migration system according to one aspect of the present invention includes: a source analysis unit that analyzes a source DB including a data structure; a target analysis unit that analyzes a migration target DB; a data conversion unit that converts columns of a data table according to a user's request based on the analyses of the source analysis unit and the target analysis unit; and a transfer unit that stores a new table with converted columns in the target DB.

Inventors

  • 김범수
  • 구본규
  • 신영호
  • 김준형
  • 김진일

Assignees

  • 주식회사 에티버스

Dates

Publication Date
20260511
Application Date
20250818

Claims (20)

  1. Source analysis unit that analyzes the source DB including data structures; Target Analysis Department analyzing the migration target DB; A data conversion unit that converts columns of a data table according to a user's request based on each analysis of the source analysis unit and the target analysis unit; A transfer unit that saves the new table with converted columns to the above target DB; A backup DB transferred from the source DB to be used as backup data for the original table for the above-mentioned new table; and The system includes a data management unit that monitors the usage status of the new table in the target DB and deletes the original table from the backup DB only when no abnormalities are detected in the new table to the extent that a preset usage amount is exceeded. The above data management unit divides the above original table into two or more parts, stores the divided tables in physically or logically partitioned storage, and sequentially deletes the divided tables according to a pre-set order based on the usage status of the corresponding new table. The above transfer unit transfers data from the source DB to the target DB based on the transfer reference point, and periodically reflects changed data regarding the source DB after the transfer reference point in the target DB, while setting the transfer reference point and the reflection cycle for the changed data based on the data usage history of the source DB. A user-customized database migration system that sets the transfer reference time earlier as the number of new tables converted by the data conversion unit increases, and separately reflects only the change data related to the new tables in the target DB at a faster cycle.
  2. In claim 1, The above data conversion unit is equipped with a general-purpose driver and a database adapter layer specialized for each DB type, and is a user-customized database migration system that converts the schema and metadata of the source DB into an abstracted common model.
  3. In claim 1, The above data transformation unit enables a user to define mapping rules between a source table/column combination and a target table/column through a GUI or script, and after extracting data according to the mapping rules, combines values from multiple source columns, selects only some columns, or modifies values according to specific conditions and inserts them into target columns, thereby creating a user-customized database migration system.
  4. In claim 1, The above data transformation unit generates an integrated transformation pattern including matching column merging, splitting, or deletion based on similarity with a target schema calculated through analysis of a source schema using artificial intelligence or machine learning, and A user-customized database migration system that generates recommended table transformation items and examples corresponding to the integrated transformation pattern using at least one of the migration purpose and the data usage purpose, and guides the user.
  5. delete
  6. delete
  7. delete
  8. delete
  9. In claim 1, A user-customized database migration system that divides the above original table based on whether it contains personal information.
  10. In claim 1, The above data management unit is a user-customized database migration system that stores some of the above partitioned tables on a user terminal.
  11. In claim 10, A user-customized database migration system in which the data management unit encrypts and stores the original table, and the decryption key is managed at the user terminal and obtained according to user authentication.
  12. delete
  13. delete
  14. In claim 1, It further includes a verification unit that performs verification on data transferred by the above-mentioned transfer unit, The above verification unit performs verification on the above new table whenever the above change data is reflected, in a user-customized database migration system.
  15. delete
  16. Regarding database migration methods in a migration system, Step of analyzing the source DB and target DB, including data structures; A step of converting the columns of the source table according to the user's request based on the analysis results; A step of transferring the new table with converted columns to the above target DB; A step of transferring and storing data from the source DB to the backup DB to be used as backup data for the original table for the above-mentioned new table; and The method includes the step of monitoring the usage status of the new table in the target DB and deleting the original table from the backup DB only if no abnormalities are found in the new table to the extent that a preset usage amount is exceeded. The above original table is divided into two or more parts, and the divided tables are stored separately in physically or logically partitioned storage; however, the divided tables are deleted sequentially according to a pre-set order based on the usage status of the corresponding new table. The transfer department transfers data from the source DB to the target DB based on the transfer reference point, and periodically reflects changed data in the source DB after the transfer reference point in the target DB, while setting the transfer reference point and the reflection cycle for the changed data based on the data usage history of the source DB. A user-customized database migration method that advances the migration reference time as the number of new tables increases, and separately reflects only the change data related to the new tables in the target DB at a faster cycle.
  17. In claim 16, A user-customized database migration method that allows a user to define mapping rules between a combination of source tables/columns and a target table/column through a GUI or script, extracts data according to the said mapping rules, and then inserts values from multiple source columns, selects only some columns, or modifies values according to specific conditions into a target column.
  18. In claim 16, Generates an integrated transformation pattern including matching column merging, splitting, or deletion based on similarity with a target schema derived from the analysis of a source schema using artificial intelligence or machine learning, and A user-customized database migration method that generates recommended table transformation items and examples corresponding to the integrated transformation pattern using at least one of the migration purpose and the data usage purpose, and guides the user.
  19. delete
  20. delete

Description

Customized database migration system and method The present invention relates to a user-customized database migration system and method. Database migration refers to the process of transferring data, schemas, and application components to a new environment when modifying or upgrading a database system. It is performed for various purposes, such as improving system performance, replacing technologies, or transitioning to the cloud, and involves complex data transformation and verification tasks. In other words, DB migration is the process of moving data and structures from an existing database (DB) to another DB system, such as Oracle -> MySQL -> On-premises DB -> Cloud DB (AWS RDS), and DB version upgrades (Oracle 11g -> 19c). It is used for technical upgrades to utilize the latest features or resolve compatibility issues, or for purposes such as transitioning to a cloud environment to reduce infrastructure costs, migrating to a flexible system to handle increased traffic, centralizing distributed data, or integrating analysis environments. DB migration is performed for various purposes, and it is often necessary to modify table structures depending on the efficient use or intended purpose of heterogeneous databases. However, conventional migration methods are limited to simply transferring data, requiring users to manually modify table structures and remove duplicate data after the migration. FIG. 1 is a schematic diagram illustrating the entire system for user-customized database migration according to one embodiment of the present invention. FIG. 2 is a functional block diagram illustrating the configuration of a migration system according to an embodiment of the present invention. FIG. 3 is a flowchart illustrating a user-customized database migration process according to an embodiment of the present invention. FIG. 4 is a flowchart illustrating a table conversion recommendation process using artificial intelligence according to an embodiment of the present invention. FIG. 5 is a flowchart illustrating a backup data management process for the stability of a table conversion migration according to an embodiment of the present invention. FIG. 6 is a flowchart illustrating the process of storing original data for security enhancement according to an embodiment of the present invention. FIG. 7 is a flowchart illustrating a transfer process for stable synchronization between a source DB and a target DB according to an embodiment of the present invention. FIG. 8 is a conceptual diagram of migration utilizing a transfer reference point according to an embodiment of the present invention. FIG. 9 is a flowchart illustrating a verification process using change data for a new table converted from a table according to an embodiment of the present invention. The present invention is capable of various modifications and may have various embodiments, and specific embodiments are illustrated in the drawings and described in detail in the detailed description. However, this is not intended to limit the invention to specific embodiments, and it should be understood that the invention includes all modifications, equivalents, and substitutions that fall within the spirit and scope of the invention. When it is stated that one component is "connected" or "connected" to another component, it should be understood that while it may be directly connected or connected to that other component, there may also be other components in between. On the other hand, when it is stated that one component is "directly connected" or "directly connected" to another component, it should be understood that there are no other components in between. Terms such as "first," "second," etc., may be used to describe various components, but said components should not be limited by said terms. These terms are used solely for the purpose of distinguishing one component from another. For example, terms such as "first threshold," "second threshold," etc., to be described later may be pre-designated as thresholds that are substantially different or partially identical; however, since there is a possibility of confusion when expressed using the same word "threshold," the terms "first," "second," etc., will be used together for the convenience of distinction. The terms used herein are merely for describing specific embodiments and are not intended to limit the invention. Singular expressions include plural expressions unless the context clearly indicates otherwise. In this specification, terms such as “comprising” or “having” are intended to indicate the presence of the features, numbers, steps, actions, components, parts, or combinations thereof described in the specification, and should be understood as not precluding the existence or addition of one or more other features, numbers, steps, actions, components, parts, or combinations thereof. Furthermore, the components of the embodiments described with reference to each drawing are not limited to the respect