Beijing Oceanbase Technology Co., Ltd.

Ant Financial (hang Zhou) Network Technology Co., Ltd.

Advanced New Technologies Co., Ltd.

Ant Financial Network Technology Co., Ltd.

Mengmeng Chen

A computer-implemented database access method includes receiving, by a server, a database access statement including a target identifying parameter; parsing the database access statement to determine the target identifying parameter; determining a statement type of the database access statement; obtaining a pre-stored execution plan group corresponding to the statement type, the pre-stored execution plan group including one or more execution plans for accessing a database corresponding to the database access statement, in which each execution plan corresponds to a different respective identifying parameter; selecting a target execution plan from the pre-stored execution plan group based on the target identifying parameter; and executing the target execution plan.

Database query plan selection

Disclosed herein are methods, systems, and apparatus, including computer programs encoded on computer storage media, for distributed data processing. One of the methods includes: generating a first Bloom filter based on data of a local device, and sending the first Bloom filter to a remote device; receiving a second Bloom filter from the remote device, wherein the second Bloom filter is generated by the remote device based on data of the remote device; filtering data of the local device by using the first Bloom filter and the second Bloom filter to produce successfully filtered data and unsuccessfully filtered data; and performing a join operation on unsuccessfully filtered data.

Distributed join operation processing method, apparatus, device, and storage medium

The specification provides a system, method, and storage medium for executing an outer join command on a first table and a second table in a distributed database. The method may comprise: broadcasting the first data set to a plurality of database nodes storing the second data set; dividing the plurality of database nodes into a first subset and a second subset; obtaining, an OUTER JOIN result based on the first data set broadcasted to each database node of the first subset and the portion of the second data set stored therein; obtaining, an INNER JOIN result based on the first data set broadcasted to each database node of the second subset and the portion of the second data set stored therein; and returning a result to the OUTER JOIN command by aggregating the OUTER JOIN result and the INNER JOIN result.

Method and system for outer join of database tables

The specification provides a system, method, and storage medium for executing an outer join command on a first table and a second table in a distributed database. The method may comprise: broadcasting the first table to a plurality of second nodes storing the second table; selecting one or more second nodes from the plurality of second nodes; obtaining, by each of the selected one or more second nodes, an outer join result after executing an outer join operation; obtaining, by each of the plurality of second nodes other than the selected one or more second nodes, an inner join result; removing a row with (1) a join key value and (2) a NULL value from the outer join result when the inner join result comprises another row with the join key; and returning, after the removal, a result to the outer join command by aggregating the outer join result and the inner join result.

Growing community of inventors

Hangzhou, China

Mengmeng Chen