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

Data migration method and device

A technology for data and data tables, applied in the database field, can solve the problems affecting the migration performance of data devices and low migration efficiency, and achieve the effect of avoiding the influence of processing performance and improving the efficiency of data migration.

Active Publication Date: 2019-12-10
HANGZHOU HIKVISION DIGITAL TECH
View PDF7 Cites 6 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 object, technical solution and advantages of the present invention clearer, the implementation manner of the present invention will be further described in detail below in conjunction with the accompanying drawings.

[0076] Before explaining the embodiment of the present invention in detail, the technical terms involved in the embodiment of the present invention will be 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, so 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 a SQL (Structured Query Language, Structured Query Language) database, and the like.

[0079] Distributed Database

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

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, and belongs to the field of databases. The method comprises the steps of obtaining data description information of to-be-migrated target data in a source data table; creating M data connections and N data processing tasks with the relational database; dividing the data description information in batches and fragments to obtain multiple batches of description information; selecting a batch of description information from the plurality of batches of description information, executing the following processing on the selected batch of description information until a plurality of batches of description information are processed: sequentially obtaining a plurality of pieces of fragmentation data corresponding to a plurality of pieces offragmentation description information included in the selected batch of description information from a source data table in parallel through M data connections, using the N data processing tasks forprocessing the fragmented data in parallel, and loading the processed fragmented data into the target data table, so that the data migration efficiency of the database can be improved, and the influence on the processing performance of the data migration device is 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 is increasing exponentially. Due to the limited storage capacity and access performance of traditional relational databases, it has gradually been unable to meet the data storage needs of users. 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 has better access performance. Based on the advantages of distributed databases, many users began to choose to migrate the data originally stored in relational databases to distributed databases. [0003] In related technologies, data in relational databases and distributed databases are usually stored in the form of data tables, and when migrating data in relational data...

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): 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