Abstract: A managed query execution platform, and methods thereof are provided. The, managed query execution platform includes a plurality of computing machines; a plurality of storage devices; and a communication fabric configured to allow communication of the plurality of computing machines with the plurality of storage devices over a storage communication protocol, wherein the plurality of storage devices are configured to maintain at least one indexed view, and wherein the plurality of computing machines are configured to execute queries on the at least one indexed view.
Type:
Grant
Filed:
October 10, 2019
Date of Patent:
May 31, 2022
Assignee:
Varada Ltd.
Inventors:
Tal Ben Moshe, Kobi Luz, David Krakov, Roman Vainbrand
Abstract: A query execution fabric is provided. The a plurality of computing machines; and a plurality of storage devices communicatively connected to the plurality of computing machines using a storage communication protocol and configured to maintain a plurality of indexed views comprising index information and a plurality of data chunks, wherein the index information includes at least one local index per data chunk and at least one global index per each of the indexed views of the plurality of indexed views, and wherein each of the plurality of computing machines is configured to: verify a global index to locate segments of the plurality of indexed views; and verify a plurality of local indexes to locate the data chunks containing values related to a plurality of statements.
Type:
Application
Filed:
December 13, 2021
Publication date:
May 26, 2022
Applicant:
Varada Ltd.
Inventors:
Tal BEN MOSHE, Kobi LUZ, David KRAKOV, Roman VAINBRAND, Shlomi ALFASI
Abstract: A system and method for executing queries on an indexed view are presented. The method includes processing an input query directed to data maintained by the indexed view to generate a plurality of statements responsive to the input query, wherein the indexed view includes index information and a plurality data chunks; verifying a global index to locate segments of the indexed view; verifying a plurality of local indexes to locate data chunks containing values related to the plurality of statements, wherein the index information includes at least one local index per data chunk and at least one global index per the entire indexed view; processing the plurality of statements by accessing the data chunks containing values related to the plurality of statements; and responding to the input query based on the accessed data chunks.
Type:
Grant
Filed:
October 10, 2019
Date of Patent:
January 18, 2022
Assignee:
Varada Ltd.
Inventors:
Tal Ben Moshe, Kobi Luz, David Krakov, Roman Vainbrand, Shlomi Alfasi
Abstract: A system and method for executing queries on an indexed view are presented. The method includes processing an input query directed to data maintained by the indexed view to generate a plurality of statements responsive to the input query, wherein the indexed view includes index information and a plurality data chunks; verifying a global index to locate segments of the indexed view; verifying a plurality of local indexes to locate data chunks containing values related to the plurality of statements, wherein the index information includes at least one local index per data chunk and at least one global index per the entire indexed view; processing the plurality of statements by accessing the data chunks containing values related to the plurality of statements; and responding to the input query based on the accessed data chunks.
Type:
Application
Filed:
October 10, 2019
Publication date:
April 16, 2020
Applicant:
Varada Ltd.
Inventors:
Tal BEN MOSHE, Kobi LUZ, David KRAKOV, Roman VAINBRAND, Shlomi ALFASI
Abstract: A managed query execution platform, and methods thereof are provided. The, managed query execution platform includes a plurality of computing machines; a plurality of storage devices; and a communication fabric configured to allow communication of the plurality of computing machines with the plurality of storage devices over a storage communication protocol, wherein the plurality of storage devices are configured to maintain at least one indexed view, and wherein the plurality of computing machines are configured to execute queries on the at least one indexed view.
Type:
Application
Filed:
October 10, 2019
Publication date:
April 16, 2020
Applicant:
Varada Ltd.
Inventors:
Tal BEN MOSHE, Kobi Luz, David Krakov, Roman Vainbrand