Unlock instant, AI-driven research and patent intelligence for your innovation.

Cross-heterogeneous-database data migration method and system

A technology for migrating systems and databases, applied in the field of power system automation, can solve the problems of lack of security access control, application data migration security control cannot cooperate with application programs, migration failure, etc., to reduce the probability of migration errors, simplify understanding, Increase the effect of secure access control

Inactive Publication Date: 2020-09-25
NANJING GUODIAN NANZI POWER GRID AUTOMATION CO LTD
View PDF0 Cites 2 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

There are also many differences in data migration between different databases and different versions of the same database, and even migration failures may occur. For a machine, to complete data migration between different databases, it needs to support multiple different database
In addition, there is no application-level security access control for data migration between different database platforms, and the security control for application data migration cannot be coordinated with the application program. Further improvement is needed to integrate the access control strategy with the application program.

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
  • Cross-heterogeneous-database data migration method and system
  • Cross-heterogeneous-database data migration method and system

Examples

Experimental program
Comparison scheme
Effect test

Embodiment 1

[0033] The embodiment of the present invention provides a data migration method across heterogeneous databases, which can realize smooth switching of data platform applications across heterogeneous databases. The present invention provides a unified database read-write interface, and after security access control verification, the data contents of different databases under the current database platform are standardized and dumped into xml files, and then the data is obtained by parsing the dumped xml files, and the The data is imported into the corresponding database in the target database platform through a unified database read-write interface, so as to realize the migration of the database content to another database. Each application program can read and write data through a unified database read-write interface under another database platform, realizing smooth switching of data platform applications across heterogeneous databases.

[0034] Such as figure 2 As shown, spe...

Embodiment 2

[0050] An embodiment of the present invention provides a data migration system across heterogeneous databases, including: an application program, a current database platform, a target database platform, and a database read-write interface;

[0051] The application issues a data migration command,

[0052] In response to the data migration instruction issued by the application program, use the database read-write interface connected to the current database platform to read the data in the heterogeneous databases in the current database platform, and dump the read data into xml files in a normalized manner. Files correspond to different object types;

[0053] The xml file is parsed by using a database read-write interface connected to the target database platform, and the parsed xml file is imported into a corresponding database in the target database platform to realize data migration across heterogeneous databases.

[0054] In a specific implementation manner of the embodimen...

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 cross-heterogeneous database data migration method and system. The method comprises the steps that in response to a data migration instruction of an application program, a database read-write interface connected with a current database platform is used for reading data in all heterogeneous databases in the current database platform, the read data is normalized and dumpedinto xml files, and different xml files correspond to different object types; and analyzing the xml file by utilizing a database read-write interface connected with a target database platform, and importing the analyzed xml file into a corresponding database in the target database platform to realize cross-heterogeneous database data migration. According to the method, safe migration of data underdifferent database platforms can be realized, and the migration error probability in the data migration process is reduced.

Description

technical field [0001] The invention belongs to the technical field of power system automation, and in particular relates to a data migration method and system across heterogeneous databases. Background technique [0002] With the progress of self-controllable software and hardware technology, the development of monitoring system based on self-controllable database is also becoming a trend. However, there are many differences between different databases, which bring many challenges to users, such as the implementation of different database access interfaces, the calling of SQL statements, the calling of underlying functions of different databases, and the different keywords and different data types under different databases. Each has its own characteristics, and it will become very cumbersome for developers to deal with these differences. With the increasing number of application modules, the number of application modules that need to be modified when a database interface c...

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/25
CPCG06F16/214G06F16/252G06F16/258
Inventor 陈刚王冬霞纪陵檀庭方钱伟
Owner NANJING GUODIAN NANZI POWER GRID AUTOMATION CO LTD