Database system, and transaction management method and apparatus

    公开(公告)号:US12197425B2

    公开(公告)日:2025-01-14

    申请号:US18146947

    申请日:2022-12-27

    Abstract: A database system is provided, including a first global transaction manager (GTM), a first data node) DN, and a coordinator node (CN). The CN is configured to send a query to the first DN. The first DN is configured to, in response to the query, determine a target commit sequence number (CSN), determine a committed transaction on the first DN based on the target CSN, and determine a query result corresponding to the query based on the committed transaction. The target CSN is allocated by the first GTM. The target CSN is used to distinguish between the committed transaction and an active transaction on the first DN. The active transaction is a transaction that is being executed. In addition, a corresponding transaction management method is provided. The CSN is used to replace an active transaction linked list. This reduces network traffic and improves concurrency and scalability of the database system.

    Clock synchronization method, apparatus, and system in distributed system

    公开(公告)号:US12287666B2

    公开(公告)日:2025-04-29

    申请号:US18175365

    申请日:2023-02-27

    Abstract: This application discloses a clock synchronization method and a related apparatus in a distributed system. The distributed system includes a plurality of nodes, and the plurality of nodes include a master node and a plurality of slave nodes. The master node obtains a plurality of local clock offsets, where each of the plurality of local clock offsets indicates a clock offset between two nodes in the distributed system. The master node determines a global clock offset of a target slave node relative to the master node based on the plurality of local clock offsets, and sends the global clock offset to the target slave node. The target slave node obtains a clock reference value of a local clock, and then performs clock synchronization based on the clock reference value and the global clock offset.

    DATABASE SYSTEM, AND TRANSACTION MANAGEMENT METHOD AND APPARATUS

    公开(公告)号:US20230136417A1

    公开(公告)日:2023-05-04

    申请号:US18146947

    申请日:2022-12-27

    Abstract: A database system is provided, including a first global transaction manager (GTM), a first data node) DN, and a coordinator node (CN). The CN is configured to send a query to the first DN. The first DN is configured to, in response to the query, determine a target commit sequence number (CSN), determine a committed transaction on the first DN based on the target CSN, and determine a query result corresponding to the query based on the committed transaction. The target CSN is allocated by the first GTM. The target CSN is used to distinguish between the committed transaction and an active transaction on the first DN. The active transaction is a transaction that is being executed. In addition, a corresponding transaction management method is provided. The CSN is used to replace an active transaction linked list. This reduces network traffic and improves concurrency and scalability of the database system.

Patent Agency Ranking