TRANSACTION PROCESSING METHOD AND APPARATUS FOR DISTRIBUTED DATABASE SYSTEM

WIPO Patent Application WO/2016/078423

A1

A transaction processing method and apparatus for a distributed database system. The method comprises: receiving, by a global transaction processing central server, a transaction structured query language (SQL) sentence submitted by a user, and generating an SQL grammar tree according to the SQL sentence (step 101); traversing the SQL grammar tree, and generating an SQL execution tree which can be executed at each database node of a distributed database system according to a distribution situation of the distributed database system (step 102); applying for a global transaction identifier (GTID) corresponding to the SQL execution tree, and traversing the SQL execution tree, and issuing the SQL sentence on an execution node of the SQL execution tree to the corresponding database node to be executed, wherein the GTID is carried in the SQL sentence (step 103); and receiving an execution result, traversing the SQL execution tree according to the execution result, and after it is determined that all the SQL sentences on the SQL execution tree are executed successfully and completely, returning the execution result to the user, and releasing the GTID (step 104).

DAI LIJIAN (CN)
JIA XINHUA (CN)
ZUO ZHUANGTAI (CN)
BAI TAO (CN)
CHEN HEDUI (CN)
ZOU HAILI (CN)
CHEN XIAOQIANG (CN)
PENG JIPING (CN)

PCT/CN2015/083399

May 26, 2016

July 06, 2015

Click for automatic bibliography generation  

ZTE CORP (CN)

G06F17/30

CN102306197A	2012-01-04
CN101093501A	2007-12-26
CN103020147A	2013-04-03
US6275843B1	2001-08-14

KANGXIN PARTNERS, P.C. (CN)
北京康信知识产权代理有限责任公司 (CN)

View/Download PDF      PDF Help

Previous Patent: VIRTUAL MACHINE CONFIGURATION INFORMATION STORAGE METHOD AND APPARATUS

Next Patent: AUTOMOBILE ADDITIONAL INTERIOR REAR VIEW MIRROR