公开(公告)号：US20200034472A1

公开(公告)日：2020-01-30

申请号：US16047458

申请日：2018-07-27

Applicant: Futurewei Technologies, Inc.

Inventor： Le Cai ,  Jianjun Chen ,  Yang Sun ,  Xiaolin Du ,  Jun Chen ,  Yu Chen ,  Chunfeng Pei

IPC: G06F17/30

Abstract: A database system comprises a persistent storage device, a log node including a memory and a processor, and a plurality of database nodes. A database node includes a cache memory configured to store a database instance, and a processor configured to initiate a database transaction by sending a snapshot request to the log node, the snapshot request including a list of pages that were either replaced or newly loaded in the cache memory. The log node processor is configured to send a snapshot response to the database node, wherein the snapshot response includes a snapshot of the database and a list of changed pages of the database instances. The database node processor is configured to update the status of the pages in cached memory according to the snapshot response and perform the database transaction.

公开(公告)号：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.

公开(公告)号：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.