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

Data migration method and device, electronic device and readable storage medium

A data and database technology, applied in the direction of electrical digital data processing, special data processing applications, instruments, etc., can solve problems such as unavailable source databases

Active Publication Date: 2018-09-25
BEIJING KINGSOFT CLOUD NETWORK TECH CO LTD +2
View PDF5 Cites 4 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

[0005] However, when the existing technology migrates data containing a large number of non-transactional tables, the data in the source database will be in a read lock state for a long time, resulting in the source database being unavailable for a long time

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, electronic device and readable storage medium
  • Data migration method and device, electronic device and readable storage medium
  • Data migration method and device, electronic device and readable storage medium

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0077] The following will clearly and completely describe the technical solutions in the embodiments of the present invention with reference to the accompanying drawings in the embodiments of the present invention. Obviously, the described embodiments are only some, not all, embodiments of the present invention. Based on the embodiments of the present invention, all other embodiments obtained by persons of ordinary skill in the art without making creative efforts belong to the protection scope of the present invention.

[0078] The application of the present invention provides a data migration method, device, electronic equipment and computer-readable storage medium. The above method can be applied to a terminal or a server. The present invention is described by taking the application to a server as an example, and other situations are similar. The server (hereinafter referred to as the target server) applied to the above method first adds a read lock to the target non-transa...

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 embodiment of the invention provides a data migration method and device, an electronic device and a readable storage medium. The method comprises the steps that current target non-transaction tables to be migrated are obtained from non-transaction tables included in a source database, read locks are added for the target non-transaction tables, the target non-transaction tables are migrated toa target database, the read locks of the target non-transaction tables are released, first log records corresponding to the target non-transaction tables are obtained after migration of the target non-transaction tables is completed, and modification operation is conducted on the target non-transaction tables in the target database according to the first log records. By applying the embodiment, the read locks are added only for the current target non-transaction tables to be migrated and are released after the migration of the target non-transaction tables is completed, and the phenomenon canbe avoided that source databases are not available for a long time.

Description

technical field [0001] The present invention relates to the technical field of data migration, in particular to a data migration method, device, electronic equipment and readable storage medium. Background technique [0002] The database can organize and store a large amount of data that needs to be shared in a certain way, so as to manage and maintain the data quickly and conveniently. In the process of using the database, it is sometimes necessary to migrate data in one database (ie, the source database) to another database (ie, the target database). For example, when the server hardware of the source database needs to be upgraded, the data in the source database needs to be migrated to the target database of the new server hardware. [0003] Data in a database is usually stored in the form of tables, which can be divided into transaction tables and non-transaction tables. Transactional tables are used to store data that requires high security and consistency, and non-tr...

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 KINGSOFT CLOUD NETWORK 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