公开(公告)号：US20190171763A1

公开(公告)日：2019-06-06

申请号：US15833658

申请日：2017-12-06

Applicant: Futurewei Technologies, Inc.

Inventor： Le Cai ,  Jianjun Chen ,  Mason Sharp ,  Yu Chen ,  Jun Chen ,  Jason Yang Sun ,  Yongyan Wang

IPC: G06F17/30 ,  G06F11/14

Abstract: A system and method for improved online transaction processing (OLTP) in a sharded database is provided. Overhead associated with a global transaction manager is reduced and scalability improved by determining whether incoming queries are single-shard transactions or multi-shard transactions. For multi-shard transactions, a distributed transaction ID (DXID) is requested from the GTM, and then forwarded with the query to one or more data notes. For single-shard transactions, the query is sent to a data node without requesting a DXID from the GTM.

公开(公告)号：US20180107703A1

公开(公告)日：2018-04-19

申请号：US15373240

申请日：2016-12-08

Applicant: Futurewei Technologies, Inc.

Inventor： Mason Sharp

IPC: G06F17/30

CPC classification number: G06F16/2365 ,  G06F9/46 ,  G06F16/2379

Abstract: A method for maintaining consistency in distributed databases includes receiving, by a coordinator from an application server, a transaction initiation message for a transaction. Additionally, the method includes determining whether to generate a distributed transaction identifier (DXID) for the transaction, including determining whether the transaction will be performed on a single data node or on multiple data nodes, determining to generate the DXID in response to determining that the transaction will be performed on the multiple data nodes, and generating, by the coordinator, the DXID corresponding to the transaction in response to determining to generate the DXID for the transaction. The method also includes sending, by the coordinator directly to a first data node, the DXID, sending, by the coordinator directly to a second data node, the DXID, and performing the transaction using the DXID.

公开(公告)号：US10810268B2

公开(公告)日：2020-10-20

申请号：US15833658

申请日：2017-12-06

Applicant: Futurewei Technologies, Inc.

Inventor： Le Cai ,  Jianjun Chen ,  Mason Sharp ,  Yu Chen ,  Jun Chen ,  Jason Yang Sun ,  Yongyan Wang

IPC: G06F16/951 ,  G06F11/14

Abstract: A system and method for improved online transaction processing (OLTP) in a sharded database is provided. Overhead associated with a global transaction manager is reduced and scalability improved by determining whether incoming queries are single-shard transactions or multi-shard transactions. For multi-shard transactions, a distributed transaction ID (DXID) is requested from the GTM, and then forwarded with the query to one or more data notes. For single-shard transactions, the query is sent to a data node without requesting a DXID from the GTM.