Patent ID: 11966417
Assignee: SNOWFLAKE INC.
Field: Computer technology (Electrical engineering)
Classification: CPC G  A  H | IPC A  G  H

Claim 14:
15. A system comprising:
a memory; and
a processing device operatively coupled to the memory, the processing device to:
receive a set of queries to be processed by a set of virtual warehouses, wherein each virtual warehouse of the set of virtual warehouses includes a set of processors and cache resources corresponding to the set of processors;
distribute, by the processing device, the set of queries to the set of virtual warehouses to be executed by the set of processors using a set of statistics associated with the processing device, wherein:
the set of statistics is accumulated from a previously executed query by the set of processors;
the set of statistics is stored separately from the cache resources corresponding to the set of processors; and
the set of processors is stateless with respect to the set of statistics;

create, during the processing of the set of queries by the set of virtual warehouses, a new virtual warehouse, wherein:
cache resources associated with the new virtual warehouse are populated with data files associated with the set of queries at the time the virtual warehouse is created; and
the cache resources vary among the set of processors, wherein a first subset of the set of processors comprises minimal cache resources and a second subset of the set of processors comprises cache resources providing faster input-output operations; and

redistribute, as a result of the creation, the set of queries across the set of virtual warehouses.