Data migration method of distributed database and distributed database migration system

A migration system and database technology, applied in the field of distributed database data migration method and a distributed database migration system, can solve problems such as inability to guarantee data consistency, database heterogeneity, etc.

Active Publication Date: 2012-01-25
BEIJING FEINNO COMM TECH
View PDF3 Cites 26 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

[0008] Solution 2 can solve the problem of database heterogeneity, but i

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 of distributed database and distributed database migration system
  • Data migration method of distributed database and distributed database migration system
  • Data migration method of distributed database and distributed database migration system

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0026] The solution of the invention mainly solves the data migration problem in the distributed database, and can ensure that the use of the application system is not affected during the data migration process, and the usability of the data is guaranteed. The specific idea is: migrate specific user data from one distributed sub-database to another according to requirements, and lock the user data during the migration process to ensure the consistency of user data. During the migration process, the user's data still points to the original database, and after the migration is successful, it points to the target database; if the migration fails, the user's original data will not change, and the data in the target database will be deleted, ensuring data availability and no garbage data.

[0027] In order to make the object, technical solution and advantages of the present invention clearer, the present invention will be described in detail below in conjunction with the accompanyi...

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 of a distributed database and a distributed database migration system. The method comprises the following steps of: inquiring a search library according to a user identification (ID) of an appointed user to obtain position information of the appointed user data, and setting a corresponding lock sign as valid; obtaining the appointed user data according to the obtained position information, and writing the appointed user data in a target sub-library; if the writing-in is successful, modifying the position information of the user data in the sub-library as the position information of the written-in target sub-library, and setting the lock signal corresponding to the user ID of the appointed user as invalid, wherein the user data is in the search library and corresponds to the appointed user ID; if the writing-in is failure, setting the lock sign corresponding to the user ID of the appointed user as invalid, and deleting the appointed user data written in the target sub-library. By adoption of the technical scheme of the invention, the availability and consistency of the user data in the migration process can be ensured and the user service cannot be interrupted.

Description

technical field [0001] The invention relates to the field of computer technology, in particular to a distributed database data migration method and a distributed database migration system. Background technique [0002] In some application systems with a large amount of data, it is necessary to distribute massive data in multiple sub-databases according to a certain algorithm. [0003] With the passage of time and the increase of data, the distribution of data may no longer be balanced, resulting in excessive pressure on some sub-databases, while the pressure on some sub-databases is too small. At this time, it is necessary to migrate the data from the sub-database with high pressure to the sub-database with low pressure, or add a new sub-database and migrate the data to the newly added sub-database. [0004] There are two main types of existing data migration solutions: [0005] Solution 1: The database itself provides data import and export functions. For example, Oracle,...

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
IPC IPC(8): G06F17/30
Inventor 高磊李春雷
Owner BEIJING FEINNO COMM TECH
Who we serve
  • R&D Engineer
  • R&D Manager
  • IP Professional
Why Eureka
  • Industry Leading Data Capabilities
  • Powerful AI technology
  • Patent DNA Extraction
Social media
Try Eureka
PatSnap group products

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

© 2024 PatSnap. All rights reserved.Legal|Privacy policy|Modern Slavery Act Transparency Statement|Sitemap