Online data migration method in support of heterogeneous timing sequence database

A database and data technology, applied in the computer field, can solve the problem of failing to realize data migration of different databases, and achieve the effect of ensuring versatility and compatibility, and the effect of small system cutting.

CN106777126AActive Publication Date: 2017-05-31POWER DISPATCHING CONTROL CENT OF GUANGDONG POWER GRID CO LTD +1
3 Cites 9 Cited by

Patent Information

Authority / Receiving Office
CN · China
Current Assignee / Owner
Publication Date
2017-05-31

Smart Images

  • Figure 1
    Figure 1
  • Figure 2
    Figure 2
  • Figure 3
    Figure 3
Patent Text Reader

Abstract

The invention provides an online data migration method in support of a heterogeneous timing sequence database, solving the defects of incapability of crossing timing sequence database types, incapability of crossing networks and long application offline time of methods for migrating data through data recovery. The method includes deploying a target database X-DB, determining a time cutoff point, deploying a multichannel data agent, connecting the multichannel data agent to the target database X-DB, setting low priority and temporary disability, storing timing sequence data into a source database and an X-DB operation log, staring a source data and historical data pump to extract a data package from a required starting time to the time cutoff point, compressing and transmitting the historical data package and the operation log, performing historical data recovery by an X-DB data pickup device, performing log registration, creating a log stop identification after all piled logs are transmitted and recovered, interrupting the source database, starting an X-DB node, stopping log creation by the multichannel data agent, and selecting the X-DB database according to configuration rules to switch the target database automatically.
Need to check novelty before this filing date? Find Prior Art

Description

technical field

[0001] The invention relates to the field of computers, in particular to an online data migration method supporting heterogeneous time series databases. Background technique

[0002] The informatization of the power industry is a process of continuous development and improvement. New technologies are constantly being applied in the power industry, especially database technology has been greatly developed in recent years. The development of technology has led to the elimination of the original system or technology. In order to maximize the Protecting existing assets often requires migrating historical data from systems that have been retired, as well as data migration between different types of databases.

[0003] Each business system established in the development process usually has its own time series database. These databases usually have different platforms and types, forming a data island. In order to ensure the order, manageability and consistency of th...

Examples

Embodiment Construction

[0051] The embodiments of the present invention will be described in detail below with reference to the accompanying drawings, but the present invention can be implemented in various ways defined and covered by the claims.

[0052] figure 1 It is a flowchart of the conventional time series data migration method. During the migration process, the application needs to be offline, and the time series database is limited to the same type. The specific process includes the following steps:

[0053] 1. Deploy the target database;

[0054] 2. Application shutdown (offline);

[0055] 3. Export the source database;

[0056] 4. Export data or file package transfer;

[0057] 5. The target database instance imports the data package;

[0058] 6. Modify the timing database connection of the application configuration;

[0059] 7. Enable the new time series database.

[0060] A data online migration method that supports heterogeneous time series databases, such as figure 2 shown, inc...