Huawei Technologies Co., Limited

Jijun Wen

Yuanyuan Nie

Wei Wang

Jian Li

Chuanting Wang

Liangchun Xiong

Zhongqing Xu

Dongwang Sun

Bo Shang

Wentao Xu

Chunxin Yang

An active transaction list synchronization method and apparatus comprising a first node that records, in a transaction list incremental log buffer, a transaction list incremental log that is obtained after last active transaction list synchronization, where the transaction list incremental log indicates a change of a transaction recorded in an active transaction list of the first node and includes an added-transaction log and a committed-transaction log, wherein the added-transaction log indicates a transaction is added to the active transaction list, wherein the committed-transaction log indicates a transaction is deleted from the active transaction list. When performing group commit on transactions recorded in the committed-transaction log, the first node sends the transaction list incremental log to at least one second node.

Active transaction list synchronization method and apparatus

A transaction execution method, apparatus, and system is disclosed. The method is applied to a CN of an OLTP cluster database, and the method includes: receiving a page request message sent by a first PN, where the first PN has a first transaction configured, the first transaction includes at least one operation, and the page request message includes an identifier of a to-be-processed page and an identifier of the first PN; if the to-be-processed page indicated by the identifier of the to-be-processed page is the same as a hot page in a preset hot page set, determining a target operation corresponding to the to-be-processed page, where the preset hot page set includes at least one hot page; executing the target operation on the to-be-processed page to obtain an execution result; and sending the execution result to the first PN indicated by the identifier of the first PN.

Transaction execution method, apparatus, and system

A multi-version concurrency control method in a database and a database system, where the database system sets a data page link of a page, where the data page link includes a page pointer, and a page pointer is used to point to another version page prior to a last operation on the version page. Hence, when a page in the database is read, and when a timestamp of a current version page is greater than a timestamp of a read transaction, page-level rollback may be directly performed according to a data page link of the page that is requested to read to roll back to a page that needs to be read, which facilitates queries for data on each version page in the database, and the database system may implement record rollback efficiently.

Multi-version concurrency control method in database and database system

A data scanning method and apparatus are provided. The method includes analyzing a data scanning condition carried in a received data scanning request and determining at least one target data partition used to store data, acquiring a scanning cost of the target data partition, where the scanning cost includes waiting time of data scanning, allocating the target data partition to a processing resource according to the scanning cost so as to execute parallel data scanning, and acquiring a scanning result returned by the processing resource. In the present invention, statistics information of a data partition is collected, a scanning cost is acquired, and a target-data-partition operation group is appropriately allocated to a processing resource, thereby shortening waiting time of the whole data scanning.

Data scanning method and apparatus

Embodiments of the present invention disclose a data restoration method, including: after a transaction is submitted, saving a generated transaction log to a buffer of a current node, and backing up the transaction log to a buffer of at least one backup node except the current node; writing the transaction log saved in the buffer of the current node or the transaction log backed up in the buffer of the backup node into a transaction log file in a disk, where the transaction log file in the disk is used for restoring data of the current node; and restoring, based on the transaction log file in the disk, lost data of the current node when a data loss event occurs in the current node. By means of the present invention, a risk of system data can be reduced, and durability, safety, and reliability of the system data can be improved.

Data restoration method and system

A data processing method and apparatus, which relate to the computer field and are capable of effectively improving scalability of a database system. The data processing method includes: receiving source code of an external routine, where the source code of the external routine is compiled by using an advanced programming language; compiling the source code to obtain intermediate code, where the intermediate code is a byte stream identifiable to a virtual machine on any operating platform; converting, according to an instruction set on the operating platform, the intermediate code into machine code capable of running on the operating platform; and storing the machine code to a database. The data processing method and apparatus provided by the embodiments of the present invention are used to process data.

Growing community of inventors

Beijing, China

Jijun Wen