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

Transaction processing method and device of distributed database system

A transaction processing and database technology, applied in the computer field, which can solve problems such as support, data consistency support and processing data redistribution

Active Publication Date: 2016-05-25
ZTE CORP +1
View PDF4 Cites 51 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

[0004] Performance and data scalability are the business drivers for building distributed databases. Distributed databases can provide business with data and performance expansion, but it also brings a series of problems, such as the support of distributed stored procedures and data consistency. compatibility, support and processing of distributed transactions, data redistribution, etc.

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 processing method and device of distributed database system
  • Transaction processing method and device of distributed database system
  • Transaction processing method and device of distributed database system

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0061] Exemplary embodiments of the present disclosure will be described in more detail below with reference to the accompanying drawings. Although exemplary embodiments of the present disclosure are shown in the drawings, it should be understood that the present disclosure may be embodied in various forms and should not be limited by the embodiments set forth herein. Rather, these embodiments are provided for more thorough understanding of the present disclosure and to fully convey the scope of the present disclosure to those skilled in the art.

[0062] In order to solve the above-mentioned problems in the prior art, the present invention provides a method and device for transaction processing of a distributed database system based on a global transaction identifier (GlobalTransactionIdentifier, referred to as GTID), which involves transaction operations of a distributed multi-node database, All need to apply for a GTID. Even if the transaction is distributed on different no...

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 processing method and device of a distributed database system. The method comprises the following steps: receiving a transaction SQL (Structured Query Language) statement handed by a user via a global transaction processing central server, and generating a SQL syntax tree according to the SQL statement; traversing the SQL syntax tree, and generating a SQL execution tree which can be executed in each database node of the distributed database system according to the distribution situation of the distributed database system; applying for a GTID (Global Transaction ID) corresponding to the SQL execution tree, traversing the SQL execution tree, and issuing the SQL statement on the execution node of the SQL execution tree to be executed on the corresponding database node, wherein the GTID is carried in the SQL statement; and receiving an execution result, traversing the SQL execution tree according to the execution result, returning the execution result to a user after a determination result shows that all SQL statements on the SQL execution tree finish being executed, and releasing the GTID.

Description

technical field [0001] The invention relates to the field of computer technology, in particular to a transaction processing method and device of a distributed database system. Background technique [0002] Online transaction processing system (Online Transaction Processing, referred to as OLTP) is a very transactional system, generally a highly available online system. Such a system often handles more than hundreds or thousands of transactions per second, while the execution volume of query statements (select) is thousands or even tens of thousands per second. Typical OLTP systems include e-commerce systems, banking systems, and securities systems. For example, the DB2 business data database used by domestic banks is a typical OLTP database. As the business becomes bigger and bigger, the amount of data will increase, and the calculation will become more and more complex, and the demand for performance, reliability, and scalability will become stronger and stronger. At this ...

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
CPCG06F16/00
Inventor 代利坚贾新华左庄太白涛陈河堆邹海丽陈小强彭继平
Owner ZTE CORP
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