Method and apparatus for operating database

    公开(公告)号:US11640474B2

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

    申请号:US16455394

    申请日:2019-06-27

    Inventor: Hao Song Baohua Lai

    Abstract: Enclosed are a method and apparatus for operating a database. The method includes: performing, in response to determining a user indicated by a user identifier having a permission to operate on data targeted by a database operation statement, a digital signature on the database operation statement using a user private key to obtain signature information, generating transaction information according to the database operation statement, the signature information and the user identifier, and storing the generated transaction information into a local transaction information buffer pool; and selecting, in response to competing for a transaction information block recording permission using a preset consensus algorithm, transaction information in the local transaction information buffer pool to generate a block, parsing and executing a database operation statement in each piece of selected transaction information, concatenating the generated block to a local blockchain, and broadcasting the generated block to other database servers.

    Distributed database transaction processing method, device based on GPS atomic clock server

    公开(公告)号:US10567549B2

    公开(公告)日:2020-02-18

    申请号:US16282438

    申请日:2019-02-22

    Abstract: A distributed database transaction processing method and device based on a GPS atomic clock, the method includes: receiving a plurality of transaction requests by the first node server; determining a concurrency conflict between transaction requests received by the first node server; obtaining start time of each transaction in a case that the concurrency conflict exists, wherein the start time is local time of the second node server when the transaction request is sent; and local time of the second node server is synchronized with time of the GPS atomic clock server in an area which the second node server locates; processing all transactions by the first node server according to the sequence of the start time of each transaction. Throughput of distributed database system can be increased and an arrangement complexity of servers is reduced.

Patent Agency Ranking