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

Data Migration Method and Device

A data and data table technology, applied in the database field, can solve the problems affecting the migration performance of data devices and low migration efficiency, so as to avoid the impact of processing performance and improve the efficiency of data migration

Active Publication Date: 2022-03-25
HANGZHOU HIKVISION DIGITAL TECH
View PDF7 Cites 0 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

[0005] The embodiment of the present invention provides a data migration method and device, which can be used to solve the problems existing in related technologies that affect the migration performance of data devices and the migration efficiency is low

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
  • Data Migration Method and Device
  • Data Migration Method and Device

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0075] In order to make the objectives, technical solutions and advantages of the present invention clearer, the embodiments of the present invention will be further described in detail below with reference to the accompanying drawings.

[0076] Before explaining the embodiments of the present invention in detail, the technical terms involved in the embodiments of the present invention are explained first.

[0077] Relational Database

[0078] A relational database refers to a database based on a relational model, and a relational model refers to a two-dimensional table model. Therefore, a relational database is a data organization composed of two-dimensional tables and the connections between them. Specifically, the relational database may be an Oracle database, a DB2 database, or an SQL (Structured Query Language, structured query language) database, or the like.

[0079] Distributed Database

[0080] Distributed database refers to a logically unified database composed...

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, belonging to the field of databases. The method includes: obtaining data description information of target data to be migrated in a source data table; creating M data connections and N data processing tasks with a relational database; performing batching and fragmentation of the data description information to obtain multiple batches of description information; select a batch of description information from multiple batches of description information, and perform the following processing on the selected batch of description information until multiple batches of description information are processed: Acquire multiple slice data corresponding to multiple slice description information included in the selected batch of description information in sequence from the source data table, and process multiple slice data in parallel through N data processing tasks, and process The subsequent data fragments are loaded into the target data table. In this way, the data migration efficiency of the database can be improved, and the impact on the processing performance of the data migration device can be avoided.

Description

technical field [0001] The invention relates to the field of databases, in particular to a data migration method and device. Background technique [0002] With the development of information technology, the data that needs to be stored increases exponentially. Traditional relational databases have gradually been unable to meet the data storage needs of users due to limited storage capacity and access performance. Faced with this situation, a distributed database is currently proposed, which can use multiple data storage units to share the storage load, realize the storage of massive data, and have better access performance. Based on the advantages of distributed databases, many users begin to choose to migrate data originally stored in relational databases to distributed databases. [0003] In the related art, data in relational databases and distributed databases are usually stored in the form of data tables, and when migrating data in relational databases, a data migratio...

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 Patents(China)
IPC IPC(8): G06F16/21G06F16/28
CPCG06F16/21G06F16/28G06F17/00
Inventor 王辉李冰杰
Owner HANGZHOU HIKVISION DIGITAL TECH
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