Method and system for high-performance affair modification in copying surroundings of database system

A high-performance, database technology, applied to the high-performance modification transaction and system field in the replication environment of the database system

Inactive Publication Date: 2009-07-22
NOKIA SOLUTIONS & NETWORKS GMBH ＆ CO KG
View PDF0 Cites 4 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

Although snapshot replication is the easiest type to set up and maintain, this type of replication requires all data to be copied every time the table is refreshed

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
  • Method and system for high-performance affair modification in copying surroundings of database system
  • Method and system for high-performance affair modification in copying surroundings of database system
  • Method and system for high-performance affair modification in copying surroundings of database system

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0022] The method of the present invention still uses the transaction log propagation from the master to the slave, combined below Figure 1 to Figure 3 Describe in detail the flow of the system when processing update and query requests. Such as figure 1 As shown, when the master receives a request from the client to modify the entry E, the master dispatches a transaction T to modify the entry E. Then, the master propagates the log of transaction T to other replicas and waits for replies from other replica nodes. Finally, the client is notified whether the modification is successful or not according to the transaction result modified by the master.

[0023] Such as figure 2 As shown in , when the slave receives the transaction log from the master, the slave first looks for the "out-of-sync object" bucket to determine whether there is an entry affected by the transaction in the bucket. If the entry is in the storage segment, set the result of the update transaction to fail...

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 relates to a method which is used for providing high performance modification affairs in a replication environment of a database system and a system thereof. In the invention, affair logs are transmitted to slave parts from main parts, and a synchronous process is realized between the main parts and the slave parts or among the slave parts. When the affairs go fault at the main parts, an asynchronous object storing segment is introduced to keep items influenced by the fault affairs at the slave parts. With the invention adopted, modification affairs with better properties are provided in the replication environment of the database system, the return obsolescence is ensured to never happen at the client end.

Description

technical field [0001] The present invention generally relates to a method that provides better performance of modify transactions within a replicated environment of a database system, while ensuring that clients never return stale results. And the invention also relates to a system for implementing the method Background technique [0002] Today, replication technology is widely used in database systems. Replication technology can balance the workload by redirecting some read requests to the replica side. And most importantly, replication technology makes the system highly available and avoids single points of failure. [0003] The problem with replicated environments is data consistency between replicators, which means that the system should ensure that clients get the latest results for any queries once the system has successfully returned the previous update transaction. [0004] Various methods exist to solve the above-mentioned problems. One such approach is the Ato...

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 NOKIA SOLUTIONS & NETWORKS GMBH ＆ CO KG
Who we serve
  • R&D Engineer
  • R&D Manager
  • IP Professional
Why Eureka
  • Industry Leading Data Capabilities
  • Powerful AI technology
  • Patent DNA Extraction
Social media
Try Eureka
PatSnap group products

Browse by: Latest US Patents, China's latest patents, Technical Efficacy Thesaurus, Application Domain, Technology Topic.

© 2024 PatSnap. All rights reserved.Legal|Privacy policy|Modern Slavery Act Transparency Statement|Sitemap