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

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 device for data cross-platform migration, which can realize almost lossless data migration without any intermediate storage process

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 application software cross-platform migration, and in particular is 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 the tables, and stored procedures (primary keys, foreign keys, indexes, etc.) to another database server and making it fully operational. The other database server can be Running on a different machine, it can be running on a different operating system, or it can be another database management system. There are many reasons for data migration, either because the application system it supports has been 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 is located It is necessary to upgrade a series of basic software such as hardware and operating system, and so on. The entire migration...

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