Sqream Technologies Ltd.

Ami Gal

Kostya Varakin

Ori Netzer

Oz Katz

Konstatin Varakin

Ori Katz Oz

According to some embodiments is disclosed a method for controlling and scheduling operation of at least one SQL operator on data chunk. The method comprising the step of: receiving SQL query, accessing data chunk blocks, receive meta data statistics and SQL query, analyzing the query selectivity, result size and Frequency moments calculation during the query execution run-time and choosing the right device to execute the each operator of the query according to analysis and predict results size.

System and a method for executing SQL-like queries with add-on accelerators

The present invention discloses a method for real time execution of SQL queries on data stream using HWA units. The method comprising the step of: receiving data stream and injecting directly in to the one more HWA units, receiving SQL query and identifying SQL query type, statistically real time analyzing multiple data streams and calculating statistics coefficients and characteristics of data stream, creating metadata based on statistical analysis in case the calculated statistics coefficients and characteristics obey predefined rules and using created metadata for SQL execution based on SQL identified SQL type in case the calculated statistics coefficients and characteristics obey predefined rules. The steps of statistical data analysis and creation of meta data are performed by the HWA.

Method for executing queries on streaming data using graphic processing units

A method for pre-processing and processing query operation on multiple data chunk on vector enabled architecture. The method includes receiving a user query having at least one a data item, accessing data chunk blocks having an enhanced data structure representation. The enhanced data structure representation includes data recursive presentation of data chunk boundaries and bloom filter bitmask of data chunks. The method further includes searching simultaneously at multiple data chunk blocks utilizing the recursive presentation of data chunk boundaries using a HardWare Accelerator (HWA), identifying data item address by comparing a calculated Bloom filter bitmask of the requested data item to a calculated bitmask of the respective data chunks simultaneously by using multiple HWAs, and executing query on respective data chunks.

Method for pre-processing and processing query operation on multiple data chunk on vector enabled architecture

The present invention discloses a method for executing an SQL operator on compressed data chunk. The method comprising the step of: receiving SQL operator, accessing compressed data chunk blocks, receive e full set of derivatives of the compression scheme, check compression rules based on the compression scheme and relevant operator for approving SQL operation on compressed data and in case of approval applying respective SQL operator on relevant compressed data chunks.

System and a method for executing SQL basic operators on compressed data without decompression process

The invention relates to a system for parallel execution of database queries over one or more Central Processing Units (CPUs), and one or more Multi Core Processor, (MCPs), the system comprises (a) a query analyzer for dividing the query to plurality of sub-queries, and for computing and assigning to each sub-query a target address of either a CPU of an MCP; (b) a query compiler for creating an Abstract Syntax Tree (AST) and OpenCL primitives only for those sub-queries that are targeted to an MCP, and for conveying both the remaining sub-queries, and the AST and the OpenCL code to a virtual machine, and (A) a Virtual Machine (VM) which comprises: a task bank, a buffers; a scheduler. The virtual machine combines said sub-query results by the CPUs and said primitive results by said MCPs to a final query result.

Growing community of inventors

Kfar HaOranim, Israel

Ami Gal