Abstract: In an embodiment, a query system sends compact code to a database service for expansion of the compact code to partially-expanded code and expanded code. In an embodiment, a hash value is generated based on the partially-expanded code and indexed in memory with the expanded code. In an embodiment, a hash value is received as part of a command and expanded code is identified based on the hash value and sent to a database service.
Type:
Grant
Filed:
December 23, 2021
Date of Patent:
October 3, 2023
Assignee:
SISENSE SF, INC.
Inventors:
Steven Griffith, Ilge Akkaya, Audrey McGowan, Chris Tice, Jason Freidman, Jeff Watts
Abstract: In an embodiment, a query system sends compact code to a database service for expansion of the compact code to partially-expanded code and expanded code. In an embodiment, a hash value is generated based on the partially-expanded code and indexed in memory with the expanded code. In an embodiment, a hash value is received as part of a command and expanded code is identified based on the hash value and sent to a database service.
Type:
Application
Filed:
December 23, 2021
Publication date:
April 21, 2022
Applicant:
Sisense SF, Inc.
Inventors:
Steven GRIFFITH, Ilge AKKAYA, Audrey MCGOWAN, Chris TICE, Jason FREIDMAN, Jeff WATTS
Abstract: In an embodiment, a query system sends compact code to a database service for expansion of the compact code to partially-expanded code and expanded code. In an embodiment, a hash value is generated based on the partially-expanded code and indexed in memory with the expanded code. In an embodiment, a hash value is received as part of a command and expanded code is identified based on the hash value and sent to a database service.
Type:
Application
Filed:
December 23, 2021
Publication date:
April 21, 2022
Applicant:
Sisense SF, Inc.
Inventors:
Steven GRIFFITH, Ilge AKKAYA, Audrey MCGOWAN, Chris TICE, Jason FREIDMAN, Jeff WATTS
Abstract: In an embodiment, a query system sends compact code to a database service for expansion of the compact code to partially-expanded code and expanded code. In an embodiment, a hash value is generated based on the partially-expanded code and indexed in memory with the expanded code. In an embodiment, a hash value is received as part of a command and expanded code is identified based on the hash value and sent to a database service.
Type:
Application
Filed:
December 10, 2021
Publication date:
March 31, 2022
Applicant:
Sisense Inc.
Inventors:
Steven Griffith, Ilge Akkaya, Audrey McGowan, Chris Tice, Jason Freidman, Jeff Watts
Abstract: A system and method for representing query elements in an artificial neural network. The 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 number of distinct query elements among the plurality of query elements is greater than a number of distinct vectors among the plurality of vectors.
Abstract: A computerized system (e.g. implementing a database management system, abbreviated as DBMS) and a method of operating the system is disclosed for allowing predictive execution of instructions and/or queries. As disclosed herein, in predictive execution mode (also referred to herein as “predictive mode”), instructions and/or queries are executed by the computerized system (e.g. a DBMS) before a request to execute the instructions and/or queries is received from an external entity (e.g. host).
Type:
Grant
Filed:
October 6, 2016
Date of Patent:
December 10, 2019
Assignee:
Sisense Ltd.
Inventors:
Jonathan Goldfeld, Ariel Yaroshevich, Eldad Farkash
Abstract: A system and method for generating training sets for training neural networks. The method includes determining a segmentation based on a column from a columnar database table; generating a group-by query based on the segmentation; generating a plurality of reduced queries based on the group-by query; executing the group-by query on a table of a database to obtain a result table, wherein the result table includes a plurality of results, wherein each result corresponds to a respective reduced query of the plurality of reduced queries; and generating a plurality of training query pairs by pairing each reduced query with its corresponding reduced result.
Abstract: In an embodiment, a query system sends compact code to a database service for expansion of the compact code to partially-expanded code and expanded code. In an embodiment, a hash value is generated based on the partially-expanded code and indexed in memory with the expanded code. In an embodiment, a hash value is received as part of a command and expanded code is identified based on the hash value and sent to a database service.
Type:
Grant
Filed:
December 10, 2021
Date of Patent:
September 26, 2023
Assignee:
SISENSE SF, INC.
Inventors:
Steven Griffith, Ilge Akkaya, Audrey McGowan, Chris Tice, Jason Freidman, Jeff Watts
Abstract: In an embodiment, a query system sends compact code to a database service for expansion of the compact code to partially-expanded code and expanded code. In an embodiment, a hash value is generated based on the partially-expanded code and indexed in memory with the expanded code. In an embodiment, a hash value is received as part of a command and expanded code is identified based on the hash value and sent to a database service.
Type:
Grant
Filed:
December 23, 2021
Date of Patent:
April 9, 2024
Assignee:
SISENSE SF, INC.
Inventors:
Steven Griffith, Ilge Akkaya, Audrey McGowan, Chris Tice, Jason Freidman, Jeff Watts
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 system and method for representing query elements in an artificial neural network. The 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 number of distinct query elements among the plurality of query elements is greater than a number of distinct vectors among the plurality of vectors.
Abstract: A system and method for efficient cache space utilization by a processing circuitry having a cache. The method includes determining, among a plurality of instructions executed by the processing circuitry, a cacheable block of instructions for execution by the processing circuitry, wherein the cacheable block of instructions has an input, an output, and an intermediary result confined locally to the cacheable block of instructions; generating a unified instruction based on the cacheable block of instructions, wherein the unified instruction results in the same output as the cacheable block of instructions when the same input is received; and storing the unified instruction in the cache.
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 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 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 generating training sets for training neural networks. The method includes receiving a plurality of query pairs, wherein each of the plurality of query pairs includes a query and a real result previously determined for the query; determining at least one variable element of each query in the plurality of received query pairs; determining a variance for the at least determined variable element of each query in the plurality of received query pairs; and generating a training set based on the determined variable element, the determined variance, and the previously determined real result.
Type:
Application
Filed:
December 29, 2017
Publication date:
February 14, 2019
Applicant:
Sisense Ltd.
Inventors:
Nir REGEV, Guy LEVY YURISTA, Adi AZARIA, Amir ORAD
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:
Application
Filed:
December 29, 2017
Publication date:
February 14, 2019
Applicant:
Sisense Ltd.
Inventors:
Adi AZARIA, Amir ORAD, Nir REGEV, Guy LEVY YURISTA
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:
Application
Filed:
December 13, 2016
Publication date:
January 11, 2018
Applicant:
Sisense Ltd.
Inventors:
Adi AZARIA, Amir ORAD, Guy LEVY YURISTA, Guy BOYANGU, Eldad FARKASH, Ophir MARKO
Abstract: A system and method for efficient cache space utilization by a processing circuitry having a cache. The method includes determining, among a plurality of instructions executed by the processing circuitry, a cacheable block of instructions for execution by the processing circuitry, wherein the cacheable block of instructions has an input, an output, and an intermediary result confined locally to the cacheable block of instructions; generating a unified instruction based on the cacheable block of instructions, wherein the unified instruction results in the same output as the cacheable block of instructions when the same input is received; and storing the unified instruction in the cache.
Abstract: A system and method for generating training sets for training neural networks. The method includes determining a segmentation based on a column from a columnar database table; generating a group-by query based on the segmentation; generating a plurality of reduced queries based on the group-by query; executing the group-by query on a table of a database to obtain a result table, wherein the result table includes a plurality of results, wherein each result corresponds to a respective reduced query of the plurality of reduced queries; and generating a plurality of training query pairs by pairing each reduced query with its corresponding reduced result.