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

Claim 0:
1. A method comprising:
receiving 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 first set of processors and cache resources corresponding to the first set of processors;
distributing, by a second set of processors, the set of queries to the set of virtual warehouses to be executed by the first set of processors using a set of statistics associated with the first set of processors, wherein:
the set of statistics is accumulated from a previously executed query by the first set of processors;
the set of statistics is stored separately from the cache resources corresponding to the first set of processors; and
the first set of processors is stateless with respect to the set of statistics;

creating, 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 first set of processors, wherein a first subset of the first set of processors comprises minimal cache resources and a second subset of the first set of processors comprises cache resources providing faster input-output operations; and

redistributing, as a result of the creating, the set of queries across the set of virtual warehouses.