KR20080084332A - Database migration apparatus and method - Google Patents

Database migration apparatus and method Download PDF

Info

Publication number
KR20080084332A
KR20080084332A KR1020070025913A KR20070025913A KR20080084332A KR 20080084332 A KR20080084332 A KR 20080084332A KR 1020070025913 A KR1020070025913 A KR 1020070025913A KR 20070025913 A KR20070025913 A KR 20070025913A KR 20080084332 A KR20080084332 A KR 20080084332A
Authority
KR
South Korea
Prior art keywords
database
migration
data
source
module
Prior art date
Application number
KR1020070025913A
Other languages
Korean (ko)
Inventor
이승규
Original Assignee
(주)온디멘드
Priority date (The priority date is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the date listed.)
Filing date
Publication date
Application filed by (주)온디멘드 filed Critical (주)온디멘드
Priority to KR1020070025913A priority Critical patent/KR20080084332A/en
Publication of KR20080084332A publication Critical patent/KR20080084332A/en

Links

Images

Classifications

    • G—PHYSICS
    • G06—COMPUTING; CALCULATING OR COUNTING
    • G06F—ELECTRIC DIGITAL DATA PROCESSING
    • G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
    • G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
    • G06F16/21—Design, administration or maintenance of databases
    • G06F16/214—Database migration support
    • G—PHYSICS
    • G06—COMPUTING; CALCULATING OR COUNTING
    • G06F—ELECTRIC DIGITAL DATA PROCESSING
    • G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
    • G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
    • G06F16/23—Updating
    • G06F16/2308—Concurrency control
    • G—PHYSICS
    • G06—COMPUTING; CALCULATING OR COUNTING
    • G06F—ELECTRIC DIGITAL DATA PROCESSING
    • G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
    • G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
    • G06F16/25—Integrating or interfacing systems involving database management systems
    • G06F16/258—Data format conversion from or to a database

Landscapes

  • Engineering & Computer Science (AREA)
  • Databases & Information Systems (AREA)
  • Theoretical Computer Science (AREA)
  • Data Mining & Analysis (AREA)
  • Physics & Mathematics (AREA)
  • General Engineering & Computer Science (AREA)
  • General Physics & Mathematics (AREA)
  • Information Retrieval, Db Structures And Fs Structures Therefor (AREA)

Abstract

A device and a method for performing database migration are provided to systematically and stably perform the database migration from a source database to a destination database by using an automatic tool, and check/manage an error position and cause when an error occurs in the migration by using a modularized database migration device. A database analyzing module(130) generates a spreadsheet type analysis report by generating metadata, which is property data of a database, from a source database(110), analyzing an operation environment of the database, and calculating complexity of migration. A data migration module(140) converts schema, data, and business logic of the source database in order by using mapping. An application migration module(150) converts a source code of applications subordinated to the database into a destination code. The data migration module includes a synchronization module(146) synchronizing a structure of the source database with a destination database(120), a migration engine(148) converting the schema, the data, and the business logic according to the synchronized structure, and a script generator(142). Repository(144) stores schema information from a meta-database in XML format.

Description

Database migration apparatus and method

1 is a block diagram showing the configuration of a database migration apparatus according to the present invention.

2 is a flowchart illustrating a database migration method according to the present invention.

The present invention relates to a database migration, and more particularly, to a database migration apparatus and method for migrating a database systematically and stably.

Recently, the necessity of database migration is increasing due to the increase in the amount of data, the number of users, and the merging and consolidation of enterprise information solutions. In addition, domestic companies are burdened with budgets due to poor performance due to long-term operation of enterprise information solutions and expensive maintenance due to high database policy.

Therefore, companies are interested in migrating to other database systems that are inexpensive and ensure fast response speed. The required technology is the fact that the introduction of an automated database migration solution that requires less time, less cost, and accuracy in the database migration process is urgently needed, but a large part of the migration process is not yet automated. It is expensive, costly, and inaccurate.

It is an object of the present invention to provide an apparatus and method for migrating a database which can be reliably and quickly migrated from a source database to a target database using an automated migration tool.

According to an aspect of the present invention, there is provided a database migration apparatus, which generates metadata, which is attribute information of a database, from a source database, analyzes an operating environment of the database from the metadata, and calculates a migration complexity. A database analysis module for generating an analysis report of the; A data migration module for converting schema, data, and business logic from the source database by mapping in order; And an application migration module for converting source code in an application dependent on the database into object code.

The analysis report includes the number of individuals in the source database, the total number of code lines, the number of currently convertible objects and the complexity of the database migration.

The data migration module includes a synchronization module for synchronizing the structure of the source database with the structure of the target database; And a migration engine that transforms schema, data, and business logic in accordance with the synchronized structure.

The data migration module further includes a script generator that generates a script from the metadata.

The data migration module further includes an XML repository for storing schema information from the metadata.

The application migration module includes a SQL adapter for capturing SQL queries performed by the application and performing query conversion between databases.

The database migration method according to the present invention for achieving the technical problem, generating a report by generating metadata that is attribute information of the database from the source database, and analyzes the operating environment of the database from the metadata and calculates the complexity of the migration A database analysis step; A data migration step of converting schema, data, and business logic from the source database by mapping in order; And an application migration step of converting source code in an application dependent on the database into object code.

The analysis report includes the number of individuals in the database, the total number of code lines, the number of currently convertible entities and the complexity of the database.

The data migration step may include generating a script from the metadata; Synchronizing the structure of the source database with the structure of the destination database; And converting the schema, data, and business logic in order according to the structure of the synchronized database.

The application migration step includes capturing an SQL query performed by the application and performing a query conversion between databases.

In order to fully understand the present invention, the operational advantages of the present invention, and the objects achieved by the practice of the present invention, reference should be made to the accompanying drawings which illustrate preferred embodiments of the present invention and the contents described in the accompanying drawings.

Hereinafter, exemplary embodiments of the present invention will be described in detail with reference to the accompanying drawings. For each figure, like reference numerals denote like elements.

1 is a block diagram showing the configuration of a database migration apparatus according to the present invention.

Referring to FIG. 1, the database migration apparatus 100 migrates a database from a source database 110 to a destination database 120. The platform of the database may be one of Oracle, SQL Server (Microsoft), DB2 UDB (IBM), Sybase, MySQL, PostgreSQL. These are listed as examples, and the present invention is not limited thereto and may be other forms of platforms.

The database migration apparatus 100 includes a database analysis module 130, a data migration module 140, and an application migration module 150.

The database analysis module 130 generates metadata, which is attribute information of the database, from the source database 110, analyzes the operating environment of the database from the generated metadata, and calculates the complexity of migration to prepare a report in the form of a spreadsheet. .

The metadata generator 132 generates metadata from all schema objects (eg, tables, data, indexes, triggers, procedures, packages, functions, etc.) of the source database 110.

The analysis report preparing unit 134 analyzes the operating environment of the database from the metadata and calculates the complexity of the migration to prepare an analysis report in the form of a spreadsheet. The analysis report includes the number of objects in the source database, the total number of code lines, the number of currently convertible objects, and the complexity of the database migration. The analysis report can be written in the form of an Excel file. The analysis report thus prepared is provided to the user through a user interface (not shown).

The data migration module 140 converts the schema, data, and business logic from the source database 110 by mapping in order. To support the conversion of various schema objects during data migration, the same objects between databases are converted to standard SQL (Structured Query Language) and other objects between databases are converted through the emulator module.

Data migration module 140 includes synchronization module 146 and migration engine 148. The data migration module 140 may further include a script generator 142 and a repository 144.

The script generator 142 generates a script from metadata. Scripts of the target database, which are different from the source scripts of the source database, are processed through script generation. Diagnose this script for correct conversion through the script matching process. The diagnosed process is sent to the repository 144, reconfirmed in the synchronization module 146, and migrated to the destination database 120.

Repository 144 stores schema information from metadata in XML form. Repository 144 stores information during database migration.

The synchronization module 146 synchronizes the structure of the source database with the structure of the destination database.

The migration engine 148 maps and transforms schema, data, and business logic according to the synchronized structure. In the case of schema conversion, the conversion is automatically performed in consideration of the difference between the source database 110 and the destination database 120. The conversion method is converted by any one of methods such as table conversion, default conversion, and constraint conversion. do. Business logic transformation converts PL / SQL logic into T-SQL logic, for example, when migrating a database from Oracle to MS SQL.

The application migration module 150 converts source code in an application dependent on a database into object code.

The SQL adapter 152 captures SQL queries executed by the application and enables query conversion between databases. By slowing down the information performed by the SQL adapter 152 into a cache memory (not shown) and performing the same information through the cache memory directly.

This modularized database migration enables quick action by quickly identifying the location of error and the cause of error by accurate checking when an error occurs during the work procedure.

2 illustrates a flowchart of a database migration method according to the present invention.

Referring to FIG. 2, metadata, which is attribute information of a database, is generated from a source database (S200).

Analyze the operating environment of the database from the metadata and calculate the complexity of the migration to create an analysis report (step S210). The analysis report includes the number of individuals in the database, the total number of code lines, the number of currently convertible entities and the complexity of the database.

Generate a script from the metadata (step S220). Scripts of the target database, which are different from the source scripts of the source database, are processed through script generation. Diagnose this script for correct conversion through the script matching process.

Synchronize the structure of the source database and the structure of the target database (step S230).

The schema, data, and business logic are converted by mapping according to the structure of the synchronized database (step S240).

The application is migrated by converting the source code in the application dependent on the database into the object code (S250).

By verifying the migration database (step S260), the database migration is completed.

The invention can also be embodied as computer readable code on a computer readable recording medium. The computer-readable recording medium includes all kinds of recording devices in which data that can be read by a computer system is stored. Examples of computer-readable recording media include ROM, RAM, CD-ROM, magnetic tape, floppy disks, optical data storage devices, and the like, which are also implemented in the form of carrier waves (for example, transmission over the Internet). Include. The computer readable recording medium can also be distributed over network coupled computer systems so that the computer readable code is stored and executed in a distributed fashion. And functional programs, codes and code segments for implementing the present invention can be easily inferred by programmers in the art to which the present invention belongs.

Although a preferred embodiment of the present invention has been described in detail above, those skilled in the art to which the present invention pertains can make various changes without departing from the spirit and scope of the invention as defined in the appended claims. It will be appreciated that modifications or variations may be made. Accordingly, modifications to future embodiments of the present invention will not depart from the technology of the present invention.

According to the present invention, the database can be quickly and accurately migrated by an automated tool from the source database to the destination database. In addition, if the error occurs during operation using the modular database migration device, it is possible to pinpoint the error location and cause and respond quickly.

Claims (11)

A database analysis module which generates metadata, which is attribute information of a database, from a source database, analyzes an operating environment of the database from the metadata, calculates a complexity of migration, and generates a spreadsheet analysis report; A data migration module for converting schema, data, and business logic from the source database by mapping in order; And And an application migration module for converting source code in an application dependent on the database into object code. The method of claim 1, wherein the analysis report, And a complexity of the database migration, the number of objects in the source database, the total number of code lines, the number of currently convertible objects, and the complexity of the database migration. The method of claim 1, wherein the data migration module, A synchronization module for synchronizing the structure of the source database with the structure of the destination database; And And a migration engine for converting schema, data, and business logic according to the synchronized structure. The method of claim 3, wherein the data migration module, And a script generator for generating a script from the metadata. The method of claim 4, wherein the data migration module, And a repository for storing schema information from the metadata. The method of claim 1, wherein the application migration module, And a SQL adapter for capturing Structured Query Language (SQL) queries performed by the application to perform query conversion between databases. A database analysis step of generating metadata, which is attribute information of a database from a source database, analyzing an operating environment of the database from the metadata and calculating a complexity of a migration to generate a report; A data migration step of converting schema, data, and business logic from the source database by mapping in order; And And an application migration step of converting source code in an application dependent on the database into object code. The method of claim 7, wherein the analysis report, A database migration method comprising the number of objects in a database, the total number of codelines, the number of currently convertible objects and the complexity of the database. The method of claim 7, wherein the data migration step, Generating a script from the metadata; Synchronizing the structure of the source database with the structure of the destination database; And Converting the schema, data, and business logic in order according to the structure of the synchronized database. The method of claim 7, wherein the application migration step, Capturing an SQL query performed by the application and performing a query conversion between databases. A database analysis step of generating metadata, which is attribute information of a database from a source database, analyzing an operating environment of the database from the metadata and calculating a complexity of a migration to generate a report; A data migration step of converting schema, data, and business logic from the source database by mapping in order; And a program migration step of converting source code in an application dependent on the database into object code.
KR1020070025913A 2007-03-16 2007-03-16 Database migration apparatus and method KR20080084332A (en)

Priority Applications (1)

Application Number Priority Date Filing Date Title
KR1020070025913A KR20080084332A (en) 2007-03-16 2007-03-16 Database migration apparatus and method

Applications Claiming Priority (1)

Application Number Priority Date Filing Date Title
KR1020070025913A KR20080084332A (en) 2007-03-16 2007-03-16 Database migration apparatus and method

Publications (1)

Publication Number Publication Date
KR20080084332A true KR20080084332A (en) 2008-09-19

Family

ID=40024706

Family Applications (1)

Application Number Title Priority Date Filing Date
KR1020070025913A KR20080084332A (en) 2007-03-16 2007-03-16 Database migration apparatus and method

Country Status (1)

Country Link
KR (1) KR20080084332A (en)

Cited By (8)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
WO2012002968A1 (en) * 2010-07-01 2012-01-05 Hewlett-Packard Development Company, L.P. Migrating artifacts between service-oriented architecture repositories
WO2012169708A1 (en) * 2011-06-07 2012-12-13 한국과학기술정보연구원 Method and apparatus for converting metadata
KR101379855B1 (en) * 2012-10-10 2014-04-04 (주)티베로 Method and apparatus for data migration from hierarchical database of mainframe system to rehosting solution database of open system
CN111177113A (en) * 2019-12-06 2020-05-19 中国平安财产保险股份有限公司 Data migration method and device, computer equipment and storage medium
KR20200080073A (en) 2018-12-26 2020-07-06 한남대학교 산학협력단 Database migration system and database migration method using the same
CN111580862A (en) * 2020-05-15 2020-08-25 中国邮政储蓄银行股份有限公司 Data migration method and device
KR102328173B1 (en) * 2021-07-05 2021-11-17 (주)다윈아이씨티 Method, device and system for processing migration of application
KR20220052112A (en) 2020-10-20 2022-04-27 대한민국(국가기록원) Method and system for preserving relational database

Cited By (10)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
WO2012002968A1 (en) * 2010-07-01 2012-01-05 Hewlett-Packard Development Company, L.P. Migrating artifacts between service-oriented architecture repositories
US9104668B2 (en) 2010-07-01 2015-08-11 Hewlett-Packard Development Company, L.P. Migrating artifacts between service-oriented architecture repositories
WO2012169708A1 (en) * 2011-06-07 2012-12-13 한국과학기술정보연구원 Method and apparatus for converting metadata
KR101379855B1 (en) * 2012-10-10 2014-04-04 (주)티베로 Method and apparatus for data migration from hierarchical database of mainframe system to rehosting solution database of open system
KR20200080073A (en) 2018-12-26 2020-07-06 한남대학교 산학협력단 Database migration system and database migration method using the same
CN111177113A (en) * 2019-12-06 2020-05-19 中国平安财产保险股份有限公司 Data migration method and device, computer equipment and storage medium
CN111177113B (en) * 2019-12-06 2023-07-25 中国平安财产保险股份有限公司 Data migration method, device, computer equipment and storage medium
CN111580862A (en) * 2020-05-15 2020-08-25 中国邮政储蓄银行股份有限公司 Data migration method and device
KR20220052112A (en) 2020-10-20 2022-04-27 대한민국(국가기록원) Method and system for preserving relational database
KR102328173B1 (en) * 2021-07-05 2021-11-17 (주)다윈아이씨티 Method, device and system for processing migration of application

Similar Documents

Publication Publication Date Title
CN111367886B (en) Method and device for data migration in database
CN110309071B (en) Test code generation method and module, and test method and system
KR20080084332A (en) Database migration apparatus and method
US10013439B2 (en) Automatic generation of instantiation rules to determine quality of data migration
CN101719149B (en) Data synchronization method and device
EP4339802A2 (en) Methods and apparatus for integrated management of structured data from various sources and having various formats
CN103514223A (en) Data synchronism method and system of database
CN109902117B (en) Business system analysis method and device
CN105205053A (en) Method and system for analyzing database incremental logs
CN104866580A (en) Method for quickly detecting impact caused by database modification to current service
CN107766353B (en) Method and device for migrating statistical information of database
CN111813804B (en) Data query method and device, electronic equipment and storage medium
CN110032594B (en) Customizable data extraction method and device for multi-source database and storage medium
CN111046036A (en) Data synchronization method, device, system and storage medium
LU503512B1 (en) Operating method for construction of knowledge graph based on naming rule and caching mechanism
US6915313B2 (en) Deploying predefined data warehouse process models
CN109299074A (en) A kind of data verification method and system based on templating data base view
CN114281342A (en) Automatic code generation method
US20090024558A1 (en) Methods and systems for storing and retrieving rejected data
CN112231407A (en) DDL synchronization method, device, equipment and medium of PostgreSQL database
CN116226159A (en) Metadata blood-edge relationship analysis method, system, equipment and storage medium
CN114691704A (en) Metadata synchronization method based on MySQL binlog
CN114661832A (en) Multi-mode heterogeneous data storage method and system based on data quality
CN116415430B (en) Customized SysML model conversion method oriented to space science task demonstration
US20210264312A1 (en) Facilitating machine learning using remote data

Legal Events

Date Code Title Description
A201 Request for examination
E601 Decision to refuse application