Data cross-platform migration method and device

A cross-platform, data technology, applied in the field of data cross-platform migration methods and devices, to achieve the effect of reducing difficulty, easy analysis, and simple analysis

Inactive Publication Date: 2013-12-11
BEIHANG UNIV
View PDF2 Cites 68 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

[0012] Aiming at the problems currently faced in implementing data migration, the present invention proposes a method and devi

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 cross-platform migration method and device
  • Data cross-platform migration method and device
  • Data cross-platform migration method and device

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0053] The present invention will be further described in detail with reference to the accompanying drawings and embodiments.

[0054]The invention provides a data cross-platform migration method and device, which are used to migrate data located in a database system on a certain platform to a database system on another heterogeneous platform. The technology adopted in the present invention is mainly: creating the information of the source data platform as a SrcDatabase object, creating the information of the target data platform as a DesDatabase object, and then calling the execute method to complete the entire migration process. The specific execution process of the execute method is to first obtain a Table object from the source database through the obtained SrcDatabase object, pass it to the transfer (Transfer) module for corresponding format conversion, and then pass the converted information to SQL (Structured Query Language, Structured Query Language) statement construc...

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 cross-platform migration method and a data cross-platform migration device, which are used for data migration between different database systems. The device comprises a source data information module, a target data information module, a conversion module, an SQL (Structured Query Language) Engine, a data packet encapsulation, transmission and analysis module and an SQL statement execution module. The information on a source data platform and the information on a target data platform are described through the source data information module and the target data information module, a table is acquired from the source database to generate a Table object, the Table object is subjected to format conversion by the conversion module according to an XML (Extensible Markup Language) file for describing the mapping relation of fields between the databases, the converted information is constructed into an SQL statement by the SQL Engine, the SQL statement is encapsulated and transmitted to the platform where the target database is positioned, and the SQL statement is executed on the target platform to finish data migration. The method and the device realize smooth and lossless migration of the data between different databases of a heterogeneous platform.

Description

technical field [0001] The invention belongs to the field of cross-platform migration of application software, in particular to a data cross-platform migration method and device. Background technique [0002] Data migration refers to migrating the database and all its table structures, data in tables, and stored procedures (primary key, foreign key, index, etc.) to another database server, and it can be fully run. Another database server can be Running on a different machine, either on a different operating system or another database management system. There are many reasons for data migration, either because the application system it supports is migrated to another platform, or because the existing database system needs to be upgraded to a higher version, or because the platform where the data resides It is necessary to upgrade a series of basic software such as hardware and operating system, and so on. The entire migration process involves many steps and factors. Data m...

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 BEIHANG UNIV
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