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

Transaction granularity synchronizing method of database

A database and data technology, applied in the direction of database distribution/replication, data processing application, structured data retrieval, etc., to achieve the effect of ensuring transmission efficiency, improving efficiency, and reducing transmission volume

Inactive Publication Date: 2016-05-18
CHINA REALTIME DATABASE
View PDF5 Cites 4 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

[0005] The purpose of the present invention is to address the deficiencies in the prior art and solve the problem of how to efficiently perform database synchronous replication while ensuring data consistency and integrity in the network environment of the State Grid Corporation of China to meet the complex data exchange requirements of the business system , providing a database transaction granularity synchronization method

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
  • Transaction granularity synchronizing method of database
  • Transaction granularity synchronizing method of database
  • Transaction granularity synchronizing method of database

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0017] The present invention will be further described in detail below in conjunction with the embodiments and with reference to the accompanying drawings.

[0018] An embodiment of the present invention is used in the network of the State Grid Corporation of China. Through this embodiment, data synchronization between databases of various business systems in the electric power industry is completed. The technical solution adopted in this embodiment mainly includes two parts: firstly, the integration and transmission of the log is based on a "transaction" as a unit, and there is no need to deal with a complicated "rollback" mechanism. Using this technology, it can better maintain the consistency and integrity of data replication while having high performance. Secondly, the instant message bus is selected for the transmission of database logs. Because the State Grid Corporation plans to use the instant message bus subsystem for data transmission, the data security can be guara...

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

This invention discloses a transaction granularity synchronizing method of a database, relating to the field of power system informatization and automation. The method comprises the following steps: using ''transaction'' as a unit of the integration and transmission of a log; without processing a complex ''rollback'' mechanism, performing efficient database synchronization on the premise of ensuring consistency and integrity; and applying an instant message bus to ensure the data security and have a higher transmission speed simultaneously. The method provided by the invention is beneficial for improving the efficiency of the synchronous replication of the database, and has a good application prospect.

Description

technical field [0001] The invention belongs to the field of power system informatization and automation, and mainly relates to a method for real-time synchronous data exchange between databases. Background technique [0002] With the construction of the SG-ERP project of the State Grid Corporation of China, the State Grid Corporation of China has built relevant application systems in the aspects of three sets and five centers, two centers, information platforms, comprehensive analysis and decision-making, etc., and the information system architecture is more complex. In order to ensure data consistency between different business systems, the problem of data exchange between business systems must be solved, and real-time synchronization between business system databases is one of the feasible ways to solve this problem. [0003] The traditional principle of database replication is to extract the redo log (redolog) or archive log (archive log) of the source database, then tra...

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): G06F17/30G06Q50/06
CPCG06F13/426G06F16/258G06F16/27G06Q50/06
Inventor 朱礼程曹健
Owner CHINA REALTIME DATABASE
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