Transaction commit method of distributed database system

A transaction submission and database technology, which is applied in the field of computer networks, can solve the problems of low efficiency of transaction submission in distributed systems, forced log operation times due to small amount of information transmission, etc.

Inactive Publication Date: 2010-05-12
INST OF SOFTWARE - CHINESE ACAD OF SCI
View PDF0 Cites 58 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

[0013] Aiming at the problem of low transaction submission efficiency in the current distributed system, the purpose of the present invention is to provide a distributed database system transaction submission method, which can ensure less information transmission and mandatory log operations

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 commit method of distributed database system
  • Transaction commit method of distributed database system
  • Transaction commit method of distributed database system

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0103] The present invention will be described in further detail below with reference to the accompanying drawings and an example, but the scope of the present invention is not limited in any way.

[0104] Consider the following example. A commercial chain has a central organization and n different sales outlets. The central organization is used to save employee data, the types of goods of the entire chain store and the inventory types of each point of sale, etc.; the sales store keeps the sales and inventory data of the store. If the manager wants to query all stores, find out the inventory quantity of toothbrushes in all stores, and make up the inventory of all stores with less than 300 to 300.

[0105] Suppose the data situation is as follows:

[0106] Stores 1, 2, 3, 4, and 5 contain toothpaste in inventory, and the inventory is 100, 200, 300, 400, and 500 respectively. The coordinator node transaction ID is 654321; each participant node transaction ID is 154321, 254321...

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 transaction commit method of a distributed database system, belonging to the technical field of computer network. The transaction commit method comprises the following steps: 1) a cache area is respectively allocated in memories of participant nodes and coordinator nodes and used for caching transaction logs; 2) the coordinator nodes determine the participant nodes and establishes connection with the participant nodes according to the transaction content, and simultaneously determines operation request information of the transaction; 3) the coordinator nodes send the one-step operation request messages of the transaction to the participant nodes and simultaneously records the transaction request logs of each operation request; 4) the participant nodes process local logs according to the completion condition of each operation request and send corresponding messages to the coordinator nodes; and 5) the coordinator nodes judge whether the transaction is completed according to the received messages sent by all the participant nodes, and if so, a final decision is given. Compared with the prior art, the transaction commit method greatly reduces the operation times of logs, improves system efficiency and transaction efficiency and has extremely high availability.

Description

technical field [0001] The invention relates to a method for submitting a transaction in a database system, in particular to a method for submitting a transaction in a distributed database system, and belongs to the technical field of computer networks. Background technique [0002] A distributed system is a multi-node system where data is stored in various databases. A node may be any data processing system, such as a computer system, and may be located at one site or distributed across multiple sites, connected to each other by a network such as a local or wide area network. Examples of distributed systems include database systems, mail server systems, and the like. [0003] Since a transaction may modify the data of multiple nodes in the distributed system, in order to meet the data consistency of the distributed system, regardless of whether there is a failure (such as power supply interruption, hardware conflict, etc.), the following conditions must be met: the transac...

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 INST OF SOFTWARE - CHINESE ACAD OF SCI
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