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

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.

Active Publication Date: 2017-05-31
POWER DISPATCHING CONTROL CENT OF GUANGDONG POWER GRID CO LTD +1
View PDF3 Cites 9 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

[0005] The purpose of the present invention is to provide an online data migration method supporting heterogeneous time-series databases, so as to solve the technical problem that the data online migration method of the existing database cannot realize data migration between different databases

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
  • Online data migration method in support of heterogeneous timing sequence database
  • Online data migration method in support of heterogeneous timing sequence database
  • Online data migration method in support of heterogeneous timing sequence database

Examples

Experimental program
Comparison scheme
Effect test

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

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

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

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
CPCG06F16/214G06F16/27
Inventor 林玥廷徐展强向德军卢建刚邹光球李志金谢小鹏向春波胡加庆邓黎明封伟雄谢鹏
Owner POWER DISPATCHING CONTROL CENT OF GUANGDONG POWER GRID CO LTD
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