Beijing Oceanbase Technology Co., Ltd.

Yingying Yao

Hao Liu

Yang Li

Fusheng Han

Yi Pan

Zhiyong Jiang

Yi Xiao

Implementations of this specification provide methods and apparatuses for replaying logs. One method includes: classifying a plurality of logs to be replayed into log queues, sending the log queues to a global replay queue, allocating one or more replay threads to the log queues based on rankings of the log queues in the global replay queue, wherein the one or more replay threads are configured to replay one or more current log queues of the log queues, and in response to identifying an error of a current log queue of the one or more current log queues in a replay process, allocating a replay thread of the one or more replay threads allocated to the current log queue to a log queue that immediately follows the current log queue in the global replay queue.

Log replay methods and apparatuses, data recovery methods and apparatuses, and electronic devices

A database query optimization computer-implemented method, medium, and system are disclosed. In one computer-implemented method, a data query request sent by a client device is received and parsed. An execution plan for executing the data query request is determined based on a parsing result. If the execution plan is a nested loop anti-join, whether there is a possibility that a to-be-queried field in a to-be-queried data table indicated by the data query request contains a NULL value is determined. If there is a possibility that the to-be-queried field contains a NULL value, a filter condition is generated and the execution plan is optimized based on the filter condition.

Database query optimization methods, apparatuses, and computer devices

Growing community of inventors

Hangzhou, China

Yingying Yao