公开(公告)号：US12130796B2

公开(公告)日：2024-10-29

申请号：US17535832

申请日：2021-11-26

Applicant: HUAWEI TECHNOLOGIES CO., LTD.

Inventor： Ronen Grosman ,  Emad Boctor ,  Ping Chen ,  Chaoyi Kuang ,  Yuk Kuen Chan ,  Hoi Ieng Lao

IPC: G06F16/23 ,  G06F16/21 ,  G06F16/215

CPC classification number: G06F16/2308 ,  G06F16/215 ,  G06F16/219 ,  G06F16/2386

Abstract: A method and system for implementing concurrency control in a database system includes receiving a request from a node for handling by a GTM. Registering the request in a slot in a tracking array where each of the slots represents one of the requests for handling by the GTM. A slot is acquired, and a segment of the tracking array is scanned to determine a batch of pending requests. The batch is used to produce an aggregate request and the aggregate request includes an aggregate increment of a total number of commit requests of the batch. The aggregate request is sent to the GTM using one of a plurality of pre-established connections. A response is received from the GTM that includes a current value of an incremented timestamp. The incremented timestamp is distributed to the requests of the batch and the lock is released.

公开(公告)号：US11520747B2

公开(公告)日：2022-12-06

申请号：US16700459

申请日：2019-12-02

Applicant: HUAWEI TECHNOLOGIES CO., LTD.

Inventor： Yuk Kuen Chan ,  Wenbin Ma ,  Emad Boctor ,  Huaxin Zhang

IPC: G06F16/178 ,  G06F16/18 ,  G06F16/22 ,  G06F16/23 ,  G06F9/54

Abstract: The disclosed systems and methods are directed for detecting and resolving write-write conflicts among a plurality of transactions received from master nodes of a multi-writer database system. The method includes receiving a plurality of REDO logs and storing the plurality of REDO logs in a buffer, each REDO log associated with the one of the plurality of transactions, selecting one REDO log of the plurality of REDO logs; persisting the transaction associated with the one REDO log in a local storage when a write-write conflict is detected between the one REDO log and at least one other REDO log of the plurality of REDO logs prior to committing the transaction associated with the one REDO log; and transmitting a status of the transaction associated with the one REDO log to a global transaction manager (GTM).