公开(公告)号：US11347796B2

公开(公告)日：2022-05-31

申请号：US15234732

申请日：2016-08-11

申请人： SISENSE LTD.

发明人： Omer Peri ,  Eldad Farkash

IPC分类号： G06F16/901 ,  G06F16/2453

摘要： 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.

公开(公告)号：US11561981B2

公开(公告)日：2023-01-24

申请号：US16680698

申请日：2019-11-12

申请人： Sisense Ltd.

发明人： Shai Roitman ,  Eldad Farkash

IPC分类号： G06F16/2455 ,  G06F16/22 ,  H04L9/06

摘要： A system and method for accelerating relational functions between tables. The method includes: determining a plurality of first index values for a plurality of first unique keys in a first column of a first table; determining a plurality of second index values for a plurality of second unique keys in a second column of a second table; generating a hashed third table based on the first column of the first table and the plurality of first index values; generating a hashed fourth table based on the second column of the first table and the plurality of first index values; and generating a fifth table by performing a JOIN operation between the third table and the fourth table based on at least one third column, wherein each of third column includes a plurality of third unique keys that are common between the third table and the fourth table.

公开(公告)号：US11334581B2

公开(公告)日：2022-05-17

申请号：US15377016

申请日：2016-12-13

申请人： Sisense Ltd.

发明人： Adi Azaria ,  Amir Orad ,  Guy Levy Yurista ,  Guy Boyangu ,  Eldad Farkash ,  Ophir Marko

IPC分类号： G06F16/2458

摘要： A system and method for providing sensory analytics responses. The method comprises collecting raw data from a plurality of data sources; extracting, from the collected raw data, a subset of the raw data to be analyzed; generating, based on the extracted subset of the raw data, an analytics dataset, wherein the analytics dataset includes a performance indicator; determining, based on at least one received input, at least one query; determining, based on the generated analytics dataset, a response to the at least one query, wherein the response includes at least one sensory output; and causing projection of the determined at least one sensory output.