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. 12, 2021
Filed:
May. 25, 2018
Oracle International Corporation, Redwood Shores, CA (US);
Yi Pan, Hangzhou, CN;
Srikanth Bellamkonda, Mountain View, CA (US);
Madhuri Kandepi, Cupertino, CA (US);
Oracle International Corporation, Redwood Shores, CA;
Abstract
According to embodiments, a multi-node database management system allows consumer processes ('consumers') implementing a portion of a distributed data-combination operation to independently send a STOP notification to corresponding producer processes ('producers'). Upon a given consumer determining that the consumer requires no further information from corresponding producers, the consumer sends a STOP notification to the producers. When a given consumer sends out a STOP notification, the producers drop any data destined for the given consumer and also stops preparing data for and sending rows to the given consumer. Furthermore, once the producers receive STOP notifications from all of the consumers corresponding to the producers, the producers stop the current sub plan execution immediately without requiring completion of the sub plan. Thus, embodiments significantly improve the query execution performance by avoiding scanning and distributing data that is not needed for execution of the distributed operation.