Patents by Inventor Omer PERI

Omer PERI has filed for patents to protect the following inventions. This listing includes patent applications that are pending as well as patents that have already been granted by the United States Patent and Trademark Office (USPTO).

  • ELIMINATING MANY-TO-MANY JOINS BETWEEN DATABASE TABLES
    Publication number: 20220197950
    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.
    Type: Application
    Filed: March 9, 2022
    Publication date: June 23, 2022
    Applicant: Sisense Ltd.
    Inventors: Omer PERI, Eldad FARKASH
  • Eliminating many-to-many joins between database tables
    Patent number: 11347796
    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.
    Type: Grant
    Filed: August 11, 2016
    Date of Patent: May 31, 2022
    Assignee: Sisense Ltd.
    Inventors: Omer Peri, Eldad Farkash
  • ELIMINATING MANY-TO-MANY JOINS BETWEEN DATABASE TABLES
    Publication number: 20180046669
    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.
    Type: Application
    Filed: August 11, 2016
    Publication date: February 15, 2018
    Inventors: Omer PERI, Eldad FARKASH