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.

Date of Patent:
May. 31, 2022

Filed:

Aug. 11, 2016
Applicant:

Sisense Ltd., Ramat Gan, IL;

Inventors:

Omer Peri, Ra'anana, IL;

Eldad Farkash, Tel-Aviv, IL;

Assignee:

Sisense Ltd., Ramat Gan, IL;

Attorney:
Primary Examiner:
Int. Cl.
CPC ...
G06F 16/901 (2019.01); G06F 16/2453 (2019.01);
U.S. Cl.
CPC ...
G06F 16/9024 (2019.01); G06F 16/24544 (2019.01);
Abstract

A method, computer system and computer program product, the method comprising: upon receiving a database query comprising at least a first and a second join operations: storing the database query in the memory; identifying by the processor within the database query the first join operation, wherein the first join operation is a many-to-many join operation or a one-to-many join operation between a first table and a second table, in which fields of the second table are used only for filtering rows from the first table or for joining with another table; and converting by the processor the first join operation to an enhanced operation which eliminates returning at least two matches for at least one row from the first table when the database query is executed.


Find Patent Forward Citations

Peri, Omer. (2022). Eliminating many-to-many joins between database tables (U.S. Patent No. 11347796). U.S. Patent and Trademark Office. https://idiyas.com/patent/badge/11347796

Data source: USPTO (United States Patent and Trademark Office) public patent records. Weekly synchronization. How IDiyas builds this profile

Loading…