Snowflake inc. (20240256570). CACHING SYSTEMS AND METHODS

CACHING SYSTEMS AND METHODS

Organization Name

snowflake inc.

Inventor(s)

Thierry Cruanes of San Mateo CA US

Benoit Dageville of Foster City CA US

Marcin Zukowski of San Mateo CA US

CACHING SYSTEMS AND METHODS

This abstract first appeared for US patent application 20240256570 titled 'CACHING SYSTEMS AND METHODS

Original Abstract Submitted

example caching systems and methods are described. in one implementation, a method receives a set of queries to be processed by a set of virtual warehouses. the method distributes the set of queries to the set of virtual warehouses to be executed and creates, 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 processors, wherein a first subset of the processors comprises minimal cache resources and a second subset of processors comprises cache resources providing faster input-output operations. the method redistributes the set of queries across the set of virtual warehouses.