Back to results
US 11,232,130 B2Granted
Push model for intermediate query results
AssigneeSnowflake Inc.
InventorsThierry Cruanes, Benoit Dageville, Allison Waingold Lee
Life of this patent
Estimating the term…
Abstract
A system and method for managing data storage and data access with querying data in a distributed system without buffering the results on intermediate operations in disk storage.
Claims25
A method comprising:
- processing, within a first processor, a set of data with a first parallel execution process of a query plan for a query to generate an intermediate result of the query plan;
- and
- pushing, by the first processor, during execution of the query plan, the intermediate result to a plurality of second processors for processing by a plurality of secondary parallel execution processes within the plurality of second processors that generate a plurality of second results, wherein each of the first processors and the second set of processors is decoupled from a storage platform that stores the set of data prior to the execution of the query plan.
A system comprising:
- a first processor programmed to,
- process a set of data with a first parallel execution process of a query plan for a query to generate an intermediate result of the query plan, and
- push, during execution of the query plan, the intermediate result to a plurality of second processors for concurrent processing by the plurality of secondary parallel execution processes;
- and
- the plurality of second processors programmed to generate the plurality of second results, wherein each of the first processors and the second set of processors is decoupled from a storage platform that stores the set of data prior to the execution of the query plan.
2 more elements
A non-transitory computer-readable medium storing instructions which, when executed by one or more third processors of a computing device, cause the computing device to:
- process, within a first processor, a set of data with a first parallel execution process of a query plan for a query to generate an intermediate result of the query plan;
- and
- push, by the first processor, during execution of the query plan, the intermediate result to a plurality of second processors for processing by a plurality of secondary parallel execution processes within the plurality of second processors that generate a plurality of second results, wherein each of the first processors and the second set of processors is decoupled from a storage platform that stores the set of data prior to the execution of the query plan.
Dependencies are inferred from the claim text.