Abstract: A system and method for displaying data using temporal granularities. The method includes determining at least one first dataset of a plurality of datasets based on at least one temporal data requirement, wherein the plurality of datasets is generated based on a data model, wherein each of the plurality of datasets is generated based further on a distinct temporal granularity of a plurality of temporal granularities, wherein the distinct temporal granularity of each of the at least one first dataset meets at least one of the at least one temporal data requirement; and querying the determined at least one first dataset in order to obtain at least one query result.
Abstract: 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.
Type:
Grant
Filed:
December 13, 2016
Date of Patent:
May 17, 2022
Assignee:
Sisense Ltd.
Inventors:
Adi Azaria, Amir Orad, Guy Levy Yurista, Guy Boyangu, Eldad Farkash, Ophir Marko
Abstract: A system and method for representing query elements in an artificial neural network. A method includes generating a translation table based on a plurality of query elements, wherein the translation table maps a plurality of vectors to the plurality of query elements, wherein each of the plurality of vectors is mapped to at least one query element of the plurality of query elements, wherein a first vector of the plurality of vectors is mapped to at least two query elements of the plurality of query elements; converting a plurality of input query elements into respective numerical representations using the translation table; and generating a result for a database query based on the numerical representations.
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.
Abstract: A system and method for partitioning data based on authorization rules. The method includes initiating a plurality of data nodes, each data node including a dataset generated based on a shared data model, wherein each of the plurality of data nodes corresponds to at least one authorization rule, wherein each authorization rule authorizes at least one user identifier to access a respective data node of the plurality of data nodes; and configuring an extract, transform, and load (ETL) application service to extract data from a data source and to load data from the data source to the dataset stored on a first data node of the plurality of data nodes when the at least one first authorization rule authorizes a requesting user to access the first data node.
Abstract: A system and method for generating approximations of query results. The method includes sending a received query to a neural network, wherein the received query is executable on a target data set; receiving from the neural network a predicted result to the received query; providing the predicted result as a first output to a device having initiated the received query; determining a real result of the query from a data set stored in the database when the predicted result is insufficiently accurate; and providing the real result as a second output to a device having initiated the received query.
Type:
Grant
Filed:
December 29, 2017
Date of Patent:
May 3, 2022
Assignee:
Sisense Ltd.
Inventors:
Adi Azaria, Amir Orad, Nir Regev, Guy Levy Yurista
Abstract: A system and method for increasing the accuracy of generated approximations of query results. The method includes sending a received query to a first neural network and a second neural network; receiving from the first neural network a first predicted result to the received query; providing the first predicted result as a first output to a device having initiated the received query; receiving from the second neural network a second predicted result to the received query; and providing the second predicted result as a second output to the device having initiated the received query, wherein the first neural network requires less computational resources than the second neural network, and whereby the first output is provided before the second output.
Type:
Application
Filed:
December 29, 2017
Publication date:
February 14, 2019
Applicant:
Sisense Ltd.
Inventors:
Amir ORAD, Nir REGEV, Guy LEVY YURISTA, Adi AZARIA
Abstract: A system and method for partitioning data based on authorization rules. The method includes initiating a plurality of data nodes, each data node including a dataset generated based on a shared data model, wherein each of the plurality of data nodes corresponds to at least one authorization rule, wherein each authorization rule authorizes at least one user identifier to access a respective data node of the plurality of data nodes; and configuring an extract, transform, and load (ETL) application service to extract data from a data source and to load data from the data source to the dataset stored on a first data node of the plurality of data nodes when the at least one first authorization rule authorizes a requesting user to access the first data node.
Abstract: A system and method for partitioning data based on authorization rules. The method includes initiating a plurality of data nodes, each data node including a dataset generated based on a shared data model, wherein each of the plurality of data nodes corresponds to at least one authorization rule, wherein each authorization rule authorizes at least one user identifier to access a respective data node of the plurality of data nodes; and configuring an extract, transform, and load (ETL) application service to extract data from a data source and to load data from the data source to the dataset stored on a first data node of the plurality of data nodes when the at least one first authorization rule authorizes a requesting user to access the first data node.
Abstract: A system and method for improving cache efficiency. A method includes selecting at least one cacheable query node of a plurality of query nodes from a semantic knowledge graph, wherein the semantic knowledge graph includes the plurality of query nodes and a plurality of edges, each edge connecting two of the plurality of query nodes and having a connecting score, wherein the connecting score of each edge indicates a strength of relationship between the two nodes connected by the edge; storing a result of executing a query generated based on the at least one cacheable query node in a cache; and generating a query execution plan based on the at least one cacheable query node, wherein the generated query execution plan includes at least one instruction for query execution using the stored result.
Type:
Application
Filed:
September 9, 2020
Publication date:
December 31, 2020
Applicant:
Sisense Ltd.
Inventors:
Inna TOKAREV SELA, Yael LEV, Guy BOYANGU, Yuval SHOKLAR
Abstract: A system and method for generating data visualizations. The method includes generating an enriched data layer based on a plurality of knowledge graphs, the plurality of knowledge graphs including a plurality of first nodes, the enriched data layer including a plurality of second nodes, wherein each of the plurality of second nodes is connected via an edge to at least one of the plurality of first nodes; and generating a data visualization based on the enriched data layer and a request for data, wherein the request for data indicates a type of data corresponding to at least one of the plurality of second nodes, wherein the data visualization is generated using data represented by at least one of the plurality of first nodes connected to the at least one of the plurality of second nodes.
Type:
Grant
Filed:
October 29, 2020
Date of Patent:
July 11, 2023
Assignee:
SISENSE LTD.
Inventors:
Inna Tokarev Sela, Yael Lev, Guy Boyangu, Yuval Shkolar, Amnon Lotenberg
Abstract: A system and method for providing local approximations of query results are provided. The method includes querying a primary neural network with at least one test query, wherein the at least one test query includes a real test result derived from executing the at least one training query on a data set; receiving from the primary neural network a predicted test result in response to the at least one test query; sending, based on the predicted test result, a model of a primary neural network to a local machine; and storing the model of a local neural network of the local machine, wherein the local neural network is configured to generate a prediction in response to a user query received by the local machine.
Type:
Application
Filed:
December 29, 2017
Publication date:
February 14, 2019
Applicant:
Sisense Ltd.
Inventors:
Guy LEVY YURISTA, Adi AZARIA, Amir ORAD, Nir REGEV
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.
Abstract: 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.
Abstract: A system and method for generating data visualizations. The method includes generating an enriched data layer based on a plurality of knowledge graphs, the plurality of knowledge graphs including a plurality of first nodes, the enriched data layer including a plurality of second nodes, wherein each of the plurality of second nodes is connected via an edge to at least one of the plurality of first nodes; and generating a data visualization based on the enriched data layer and a request for data, wherein the request for data indicates a type of data corresponding to at least one of the plurality of second nodes, wherein the data visualization is generated using data represented by at least one of the plurality of first nodes connected to the at least one of the plurality of second nodes.
Type:
Application
Filed:
October 29, 2020
Publication date:
February 11, 2021
Applicant:
Sisense Ltd.
Inventors:
Inna TOKAREV SELA, Yael LEV, Guy BOYANGU, Yuval SHKOLAR, Amnon LOTENBERG
Abstract: A system and method for increasing the accuracy of generated approximations of query results. The method includes sending a received query to a first neural network and a second neural network; receiving from the first neural network a first predicted result to the received query; providing the first predicted result as a first output to a device having initiated the received query; receiving from the second neural network a second predicted result to the received query; and providing the second predicted result as a second output to the device having initiated the received query, wherein the first neural network requires less computational resources than the second neural network, and whereby the first output is provided before the second output.
Type:
Grant
Filed:
December 29, 2017
Date of Patent:
May 5, 2020
Assignee:
Sisense Ltd.
Inventors:
Amir Orad, Nir Regev, Guy Levy Yurista, Adi Azaria
Abstract: A system and method for providing visual data for user interfaces based on a knowledge graph. A method includes identifying at least one second node with respect to a first node based on connections between nodes of a knowledge graph, wherein the knowledge graph includes the first node and the at least one second node, wherein the first node represents a dimension of interest; selecting at least one third node from among the at least one second node by determining a correlation between the first node and each of the at least one second node; determining a new value for a dimension of each of the at least one third node based on a target value such that the correlation of the third node to the first node is maintained while achieving the target value; and generating visual data for an action item user interface based on the new values.
Abstract: A system and method for providing an improved user interface for executing data operations. The method includes: identifying a first node and a second node, wherein the first node is selected from a first connections graph and the second node is selected from a second connections graph, wherein each node is associated with a user account having a plurality of attributes, wherein the first and second nodes share at least one common attribute; generating an influence indicator for each of the first node and the second node; identifying a data operation executed by the first node on a dataset when the influence indicator of the first node is higher than the influence indicator of the second node, wherein the identified data operation is not executed by the second node; and sending, to a device of the second node, a notification indicating the identified data operation.
Type:
Grant
Filed:
April 26, 2018
Date of Patent:
December 28, 2021
Assignee:
Sisense Ltd.
Inventors:
Amir Orad, Guy Boyangu, Adi Azaria, Leon Gendler
Abstract: 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.
Abstract: A system and method for providing an improved user interface for executing data operations. The method includes: identifying a first node and a second node, wherein the first node is selected from a first connections graph and the second node is selected from a second connections graph, wherein each node is associated with a user account having a plurality of attributes, wherein the first and second nodes share at least one common attribute; generating an influence indicator for each of the first node and the second node; identifying a data operation executed by the first node on a dataset when the influence indicator of the first node is higher than the influence indicator of the second node, wherein the identified data operation is not executed by the second node; and sending, to a device of the second node, a notification indicating the identified data operation.
Type:
Application
Filed:
April 26, 2018
Publication date:
November 1, 2018
Applicant:
Sisense Ltd.
Inventors:
Amir ORAD, Guy BOYANGU, Adi AZARIA, Leon GENDLER