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:
Oct. 22, 2024
Filed:
May. 23, 2023
Ocient Holdings Llc, Chicago, IL (US);
Samuel Peter Bove, Chicago, IL (US);
Jason Arnold, Chicago, IL (US);
Susmita Saha, Chicago, IL (US);
Sarah Kate Schieferstein, Chicago, IL (US);
Max Guthmann, Chicago, IL (US);
Ellis Mihalko Saupe, University City, MO (US);
Greg R. Dhuse, Chicago, IL (US);
Ocient Holdings LLC, Chicago, IL (US);
Abstract
A database system is operable to determine a query for execution. The database system can execute a left join operation for the query based on receiving a plurality of left input rows, and forwarding all of the plurality of left input rows are forwarded. It is determined whether any right input rows match with each given left input row based on a hash map. When one right input row is identified as matching with the given left input row, a value of right input row is copied and emitted in conjunction with the given left input row. When no right input rows are identified as matching with the given left input row, a null value is emitted in conjunction with the given left input row.