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

Data migration method and device used for database

A database and data technology, applied in the direction of electrical digital data processing, special data processing applications, instruments, etc., can solve problems such as unusable application programs and unavailable database services, and achieve the effect of ensuring real-time performance

Active Publication Date: 2016-06-29
BEIJING JINGDONG SHANGKE INFORMATION TECH CO LTD +1
View PDF4 Cites 57 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

However, this data migration method will cause the database to be unable to provide external services for several hours or even days, making related applications unusable

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
  • Data migration method and device used for database
  • Data migration method and device used for database
  • Data migration method and device used for database

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0026] The application will be further described in detail below in conjunction with the accompanying drawings and embodiments. It should be understood that the specific embodiments described here are only used to explain related inventions, rather than to limit the invention. It should also be noted that, for the convenience of description, only the parts related to the related invention are shown in the drawings.

[0027] It should be noted that, in the case of no conflict, the embodiments in the present application and the features in the embodiments can be combined with each other. The present application will be described in detail below with reference to the accompanying drawings and embodiments.

[0028] figure 1 An exemplary system architecture 100 to which embodiments of the data migration method or apparatus for databases of the present application can be applied is shown.

[0029] Such as figure 1 As shown, the system architecture 100 may include an application ...

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 data migration method and device used for a database. One specific implementation way of the method comprises the following steps: establishing the mirror image of a source database, migrating total-amount data in the mirror image into a target database, and detecting incremental data in the source database; migrating the detected incremental data to the target database; and when all the incremental data in the source database is migrated to the target database, switching the read and write operation of the database to the target database from the source database. The implementation way realizes on-line data migration between the databases.

Description

technical field [0001] The present application relates to the technical field of computers, in particular to the technical field of databases, and in particular to a data migration method and device for databases. Background technique [0002] In the process of informatization construction, with the development of technology, the original information system is constantly replaced by a new system with more powerful functions. In the process of switching between the old and new systems, how to migrate the data from the old system to the new system is an inevitable problem. [0003] In the existing solutions, data migration is generally performed by a data administrator (Database Administrator, DBA for short). The DBA usually stops the use of the source database first, then writes a migration script to export the data to an intermediate file, and then writes an import script to import the data in the intermediate file into the target database. However, this data migration met...

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/214
Inventor 关攀攀张徐根张伟张亮
Owner BEIJING JINGDONG SHANGKE 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