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

Asynchronous collecting method for maintaining consistency of database replicas

A database and consistent technology, applied in electrical digital data processing, special data processing applications, instruments, etc., can solve problems such as expansion, unrecoverable, permanent data errors, etc., to overcome dependence and reduce network stability. , The effect of preventing the scope of data inconsistency from continuing to expand

Active Publication Date: 2012-04-04
NARI TECH CO LTD +1
View PDF3 Cites 15 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

However, the online synchronization method has strict requirements on the network environment. Once multiple databases are modified concurrently when the network is blocked, it is easy to cause data inconsistency. Even if the network is restored, it may not be restored to a consistent state, resulting in permanent data errors.
Subsequent data modification in an already inconsistent database involves many constraints such as keywords in the table, indexes, and trigger relationships between tables, and may also cause the scope of data inconsistency to expand
Such catastrophic consequences are the last thing system developers and project implementers want to see

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
  • Asynchronous collecting method for maintaining consistency of database replicas
  • Asynchronous collecting method for maintaining consistency of database replicas

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0030] The realization of the asynchronous collection method that the present invention proposes mainly comprises 6 steps:

[0031] Step 1: Split the data in the database. According to the requirements of the application, the model data is divided into the following four categories at the relational level / tuple level, or horizontally / vertically / compositely:

[0032] 1. The data stored only in the full copy, this part of the data is called centralized data;

[0033] 2. It is only stored in a certain local copy, and only one copy of this part of the data is saved globally. This part of the data is called partitioned data;

[0034] 3. Stored in the full copy and each partial copy, and requires consistent data in all the above-mentioned copies, this part of the data is called redundant data;

[0035] 4. Data stored in local partial and full replicas.

[0036] The first type of data has access requirements only at the node where the full replica is located, and the second type of...

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 an asynchronous collecting method for maintaining consistency of database replicas, comprising the steps of: 1) dividing a database differential replica into a complete replica type and a partial replica type; dividing the data into splinters according to the application requirement and storing them into two types of data replicas; 2) comparing the database contents to find the differential data in the complete replica and the partial replica, before modifying the local data, renewing the data and synchronizing the data from the complete replica to the partial replica;3) after modifying the local data, executing a committing operation, and synchronizing the data from the partial replica to the complete replica. The asynchronous collecting method provided by the invention supports multi-database concurrent changes, overcomes the dependence on the dump file and greatly reduces the dependence on the network stability compared with the online synchronous method realized via an application software.

Description

technical field [0001] The invention relates to an asynchronous method for maintaining data consistency between database differential copies based on the idea of ​​imputation, and belongs to the technical field of power system database management. Background technique [0002] In a geographically dispersed large-scale monitoring system, model data are mostly distributed in different databases. Common distribution strategies are: centralized: data is stored in a centralized manner; partitioned: data is stored in a decentralized manner, but the data cannot be repeated; redundant: each node stores a complete copy of data; hybrid: a mixture of the above three , which is the most complicated and flexible way, that is, the differential copy of the database to which the present invention is applicable. [0003] Consistency maintenance methods for such differential replicas can be divided into two categories: offline synchronization and online synchronization. [0004] A simple...

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