Unlock instant, AI-driven research and patent intelligence for your innovation.

Universal configurable database data migration method

A database and data technology, applied in the field of database data migration, can solve the problems of no common format definition for data description, lack of neutral data storage format, difficulty in ensuring accuracy, etc., to simplify data migration work, reduce labor costs, Guaranteed effect of accuracy

Inactive Publication Date: 2010-07-28
INSPUR TIANYUAN COMM INFORMATION SYST CO LTD
View PDF2 Cites 53 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

[0006] 1) There is no common format definition for data description between different types of databases, and there is a lack of a neutral data storage format
[0007] 2) Manual migration is extremely prone to some errors, so it is difficult to guarantee the accuracy of data migration
[0008] 3) Manually migrating data is time-consuming and laborious, especially when there are many data tables and the number of data rows in the tables is large in magnitude

Method used

the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
View more

Examples

Experimental program
Comparison scheme
Effect test

Embodiment

[0092] There are two key points in this scheme: export the data in the source database as an XML-based data dump file, and import the XML-based data dump file into the destination database.

[0093] Export the data in the source database as an XML-based data dump file

[0094] Step 1: Parse the database information configuration file DB_INFO.xml and obtain the information required for the source database connection according to the source data ID.

[0095] Step 2: Analyze the data table information configuration file TABLE_INFO.xml, obtain the data table information and write the table information to the data dump file TABLE_DATA.xml, including table name and column name information.

[0096] Step 3: Connect to the source database, construct the sql required for data export according to the table structure information, and execute the sql for data query.

[0097] Step 4: Construct the data obtained from the query one by one into the format required by the value in TABLE_DATA ...

the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
Login to View More

PUM

No PUM Login to View More

Abstract

The invention provides a universal configurable database data migration method, which comprises the following steps: exporting data in a source database into a data dump file based on XML, using defined source database connecting information to be automatically connected to the source database, then analyzing a list structure configuration file to acquire list structure information and constructing sql required by the data export by the acquired list structure information so as to inquire data according to the sql and to organize the inquired data into a format regulated by the data dump file based on the XML, and finally writing out a file; and leading the data dump file based on the XML into a target database, using defined target database connecting information to be automatically connected to the target database, then analyzing the data dump file which is exported from the source database based on the XML, acquiring list structure information and data stored in the list, further creating a list in the target database and finally constructing the sql required by the data export and executing the sql to lead the data in the target database. The use of the method of the invention only needs to complete configuration of the connection information and the list structure information of different databases, and then the device completes the data migration work among different databases so as to improve the working efficiency and also guarantee the correctness of the data.

Description

technical field [0001] The invention relates to the technical field of database data migration, in particular to a general and configurable database data migration method. Background technique [0002] With the development of information technology, the application of database technology is becoming more and more extensive. At present, the mainstream databases mainly include oracle, sqlserver, sybase, informix, etc. The diversity of databases brings data migration between different databases, and this Migration has become more and more frequent with the development of information technology. [0003] Since the data storage methods of each type of data are different and the storage format is not public, when performing data migration, various database products often can only be migrated in this type of database products through proprietary tools, while for Data migration between different types of databases Each type of database does not provide corresponding support. [00...

Claims

the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
Login to View More

Application Information

Patent Timeline
no application Login to View More
Patent Type & Authority Applications(China)
IPC IPC(8): G06F17/30
Inventor 武玉刚
Owner INSPUR TIANYUAN COMM INFORMATION SYST CO LTD