Looking for breakthrough ideas for innovation challenges? Try Patsnap Eureka!

Method for online data migration among different types of databases

A database and data technology, applied in the direction of database distribution/replication, digital data processing, structured data retrieval, etc., can solve the problems of high data error rate, occupying more tools, and complicated operation, so as to improve the efficiency of data reading. , reduce the amount of data, and ensure the effect of accuracy

Inactive Publication Date: 2017-12-01
ZHENGZHOU YUNHAI INFORMATION TECH CO LTD
View PDF5 Cites 16 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

The disadvantage is that the data extracted through ODBC or JDBC must first pass through the host where the tool is located and then be forwarded to the target database. Due to the limitation of network bandwidth, the efficiency is low, and the extraction process will occupy more memory of the host where the tool is located, resulting in a long migration process.
[0006] The above migration methods have disadvantages such as low export and import efficiency, cumbersome operations, high data error rate, long business downtime, and long migration time, which brings great difficulties to data migration between heterogeneous databases.

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

Image

Smart Image Click on the blue labels to locate them in the text.
Viewing Examples
Smart Image
  • Method for online data migration among different types of databases
  • Method for online data migration among different types of databases
  • Method for online data migration among different types of databases

Examples

Experimental program
Comparison scheme
Effect test

Embodiment 1

[0044] Methods for online data migration between different types of databases, including,

[0045] Create client software, which is installed on the database host to realize direct interaction with the database, extract, convert, insert and update data in the database, and complete data transmission and interaction between different clients;

[0046] The database host includes a source database host and a target database host;

[0047] The table data types of the source database in the source database host and the target database in the target database host are different, and the client software automatically performs data type conversion after extracting the data;

[0048] The client software automatically detects the type and version of the source database and the target database, and for the different types of data that exist in the two databases, the client software automatically converts the extracted data into data suitable for the target database, Then insert in the ta...

Embodiment 2

[0067] In order to make the purpose, technical scheme and advantages of the present invention clearer, the components and functions of the present invention are further described in detail:

[0068] 1) Software media

[0069] This software releases corresponding platform media for AIX, HPUX, LINUX, WINDOWS, K-UX and other platforms, and installs client software and server software according to different platforms. The client software is installed under the same user as the database, and the user's database-related environment variables are correctly configured to be able to connect to the database. Data synchronization is performed directly between the two clients, and the data does not need to pass through the management terminal.

[0070] 2) Server configuration

[0071] Configure the client software that connects to the source and target database hosts in the management interface. After correctly connecting to the client software, the database running on the host, as wel...

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 discloses a method for online data migration among different types of databases. The method includes the steps: creating client software mounted on a database host, realizing direct interaction with the databases, extracting, converting, inserting and updating data in the databases and transmitting and interacting the data among different clients; creating server software installed in a manager host, configuring migration information, comparing different client table HASH data and monitoring migration progress and resource occupancy conditions in real time; rapidly synchronizing whole-volume and incremental data in abnormal databases by the client software and the server software, and verifying data consistency of two abnormal databases after synchronization. Compared with the prior art, the method has the advantages that data migration of different types of databases is finished, migration efficiency is improved, migration steps are simplified, and technical requirements for data migration engineers are reduced.

Description

technical field [0001] The invention relates to the technical field of computer software databases, in particular to a method for online data migration between different types of databases. Background technique [0002] At present, there are probably the following methods for data migration between databases: [0003] Method 1: The way to generate DMP binary files. This method is generally used for data migration between databases of the same type. Data is exported to a DMP binary file in the source database and then imported in the target database. The advantage of this method is that the export and import operations are relatively simple, but the disadvantage is that data migration can only be performed between databases of the same type. [0004] Method 2: Export the source database table into a smooth file (text file), and then use the smooth file to import the table data into the target database. The advantage of this method is that data can be migrated between diffe...

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
CPCG06F16/27G06F16/214
Inventor 马国良
Owner ZHENGZHOU YUNHAI INFORMATION TECH CO LTD
Who we serve
  • R&D Engineer
  • R&D Manager
  • IP Professional
Why Patsnap Eureka
  • Industry Leading Data Capabilities
  • Powerful AI technology
  • Patent DNA Extraction
Social media
Patsnap Eureka Blog
Learn More
PatSnap group products

Browse by: Latest US Patents, China's latest patents, Technical Efficacy Thesaurus, Application Domain, Technology Topic, Popular Technical Reports.

© 2024 PatSnap. All rights reserved.Legal|Privacy policy|Modern Slavery Act Transparency Statement|Sitemap|About US| Contact US: help@patsnap.com