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

Heterogeneous-database-replication parallel execution system and method based on synchronization of commit-point timelines

A database and timeline technology, applied in the direction of electrical digital data processing, special data processing applications, instruments, etc., can solve problems such as low replication efficiency, achieve the effect of improving replication efficiency and solving low replication efficiency

Inactive Publication Date: 2017-05-31
TRAVELSKY +1
View PDF6 Cites 24 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

It adopts parallel replication of heterogeneous databases based on timeline synchronization of submission points, which solves the technical problem of low replication efficiency caused by serial execution of transactions in the target database

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
  • Heterogeneous-database-replication parallel execution system and method based on synchronization of commit-point timelines
  • Heterogeneous-database-replication parallel execution system and method based on synchronization of commit-point timelines
  • Heterogeneous-database-replication parallel execution system and method based on synchronization of commit-point timelines

Examples

Experimental program
Comparison scheme
Effect test

Embodiment 1

[0046] Such as Figure 5 , the log receiving thread receives the transaction log sequence of the source database:

[0047]The execution process of W1(a)W2(b)W3(c)W1(d)W2(e)C1W2(a)W3(d)W2(f)C2W3(a)C3. Among them, Wi(a) indicates that transaction i performs a write operation on data item a, and Ci indicates the commit operation of transaction i.

[0048] There are three commit operations in the log sequence, which divide the sequence into three segments as commit point timeline fences, and all operations in each segment can be executed in parallel.

[0049] The first commit operation encountered by the log receiving thread is C1. At this time, all operations W1(a)W1(d)C1 of transaction 1 are taken out from the log cached in memory and handed over to a certain execution thread for execution. The subsequent commit operation is C2. Similarly, all operations W2(b)W2(e)W2(a)W2(f)C2 of transaction 2 are taken out and handed over to an execution thread for execution. Finally, all ope...

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 heterogeneous-database-replication parallel execution system and method based on synchronization of commit-point timelines. The system includes a source database, a target database and a replication system. The system and method have the advantages that for preventing destination-end events from execution failure, a traditional data replication system based on logs serially executes logs of various events according to the time sequences (LSN numbers) of the logs and does not consider the probability of the parallel execution of events. According to the system and method, commit-point timelines are adopted to form fences, the characteristic that all upload operations between two timelines do not colloid with one another is adopted, the operations are executed at the destination end in parallel, the replication efficiency is greatly improved, and the technical problem of the low replication efficiency caused by the serial execution of events in the target database is solved.

Description

technical field [0001] The invention relates to a heterogeneous database replication parallel execution method, in particular to a heterogeneous database replication parallel execution system and method based on submission point timeline synchronization. Background technique [0002] With the widespread application of enterprise information systems, information systems have become the key to maintaining business operations. The diversified business types of enterprises lead to increasingly complex data access requirements, and the sharp increase in data volume also causes the database server to be overwhelmed. Enterprises urgently need to improve the availability of information systems, ensure business continuity, and minimize losses caused by disasters or failures. For this reason, data replication of distributed heterogeneous databases is a commonly used technical means. [0003] At present, the transaction log of the source database is extracted to obtain the data opera...

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/30
Inventor 彭明田付铨孙峰王尧陈琦周英飚
Owner TRAVELSKY
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