The patent badge is an abbreviated version of the USPTO patent document. The patent badge does contain a link to the full patent document.
The patent badge is an abbreviated version of the USPTO patent document. The patent badge covers the following: Patent number, Date patent was issued, Date patent was filed, Title of the patent, Applicant, Inventor, Assignee, Attorney firm, Primary examiner, Assistant examiner, CPCs, and Abstract. The patent badge does contain a link to the full patent document (in Adobe Acrobat format, aka pdf). To download or print any patent click here.
Patent No.:
Date of Patent:
Jan. 05, 2021
Filed:
May. 18, 2020
Advanced New Technologies Co., Ltd., Grand Cayman, KY;
Mengmeng Chen, Hangzhou, CN;
ADVANCED NEW TECHNOLOGIES CO., LTD., Grand Cayman, KY;
Abstract
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.