# US 2021/0342365 A1 · Resource provisioning systems and methods

> Agents: this data is available as JSON from the patentgrep API and MCP server — see https://patentgrep.com/llms.txt

- Number: US 2021/0342365 A1
- Document ID: US20210342365A1
- Status: Published application
- Kind: A1
- Application number: 17/378,574
- Filed: 2021-07-16
- Published: 2021-11-04
- Earliest claimed: 2014-02-19
- Assignees: Snowflake Inc.
- Applicants: Snowflake Inc.
- Inventors: Thierry Cruanes; Benoit Dageville; Marcin Zukowski
- Web page: https://patentgrep.com/patent/US20210342365A1

## CPC

- G06F 16/273: {Asynchronous replication or reconciliation}
- A61F 5/566: {Intra-oral devices}
- G06F 9/4881: {Scheduling strategies for dispatcher, e.g. round robin, multi-level priority queues}
- G06F 9/5016: {the resource being the memory}
- G06F 9/5044: {considering hardware capabilities}
- G06F 9/5083: {Techniques for rebalancing the load in a distributed system}
- G06F 9/5088: {involving task migration}
- G06F 16/128: {Details of file system snapshots on the file-level, e.g. snapshot creation, administration, deletion (error detection or correction of the data by redundancy in operations or in hardware G06F11/14, G06F11/16)}
- G06F 16/148: {File search processing}
- G06F 16/1827: {Management specifically adapted to NAS (management of storage area networks [SAN] G06F3/067)}
- G06F 16/211: {Schema design and management}
- G06F 16/221: {Column-oriented storage; Management thereof}
- G06F 16/2365: {Ensuring data consistency and integrity}
- G06F 16/24532: {of parallel queries}
- G06F 16/24545: {Selectivity estimation or determination}
- G06F 16/24552: {Database cache management}
- G06F 16/2456: {Join operations}
- G06F 16/2471: {Distributed queries}
- G06F 16/254: {Extract, transform and load [ETL] procedures, e.g. ETL data flows in data warehouses}
- G06F 16/27: Replication, distribution or synchronisation of data between databases or within a distributed database system; Distributed database system architectures therefor
- G06F 16/283: {Multi-dimensional databases or data warehouses, e.g. MOLAP or ROLAP}
- G06F 16/951: Indexing; Web crawling techniques
- G06F 16/9535: Search customisation based on user profiles and personalisation
- G06F 16/9538: Presentation of query results
- H04L 67/1095: Replication or mirroring of data, e.g. scheduling or transport for data synchronisation between network nodes
- H04L 67/1097: for distributed storage of data in networks, e.g. transport arrangements for network file system [NFS], storage area networks [SAN] or network attached storage [NAS]
- H04L 67/568: Storing data temporarily at an intermediate stage, e.g. caching
- G06F: ELECTRIC DIGITAL DATA PROCESSING (computer systems based on specific computational models G06N)
- A61F: FILTERS IMPLANTABLE INTO BLOOD VESSELS; PROSTHESES; DEVICES PROVIDING PATENCY TO, OR PREVENTING COLLAPSING OF, TUBULAR STRUCTURES OF THE BODY, e.g. STENTS; ORTHOPAEDIC, NURSING OR CONTRACEPTIVE DEVICES; FOMENTATION; TREATMENT OR PROTECTION OF EYES OR EARS; BANDAGES, DRESSINGS OR ABSORBENT PADS; FIRST-AID KITS (dental prosthetics A61C)
- H04L: TRANSMISSION OF DIGITAL INFORMATION, e.g. TELEGRAPHIC COMMUNICATION (arrangements common to telegraphic and telephonic communication H04M)

## Abstract

A method and apparatus managing a set of processors for a set of queries is described. In an exemplary embodiment, a device receives a set of queries for a data warehouse, the set of queries including one or more queries to be processed by the data warehouse. The device further provisions a set of processors from a first plurality of processors, where the set of processors to process the set of queries, and a set of storage resources to store data for the set of queries. In addition, the device monitors a utilization of the set of processors as the set of processors processes the set of queries. The device additionally updates a number of the processors in the set of processors provisioned based on the utilization/Furthermore, the device processes the set of queries using the updated set of processors.

## Claims

### Claim 1

A non-transitory computer-readable medium storing instructions which, when executed by one or more second processors of a computing device, cause the one or more second processors to:
provision a set of processors from a first plurality of processors, the set of processors to process a set of queries, a set of storage resources shared by each of the set of processors to store data for the set of queries;
change an amount of the processor resources in the set of processors based on a utilization of the set of processors as the set of processors that are processing the set of queries, wherein the changing of the set of storage resources is independent to a change in the number of processors; and
process the set of queries using the changed set of processors.

### Claim 2 (depends on 1)

The non-transitory computer-readable medium of claim 1, wherein the changing the number of processors includes at least one of increasing the number of processors in the set of processors or decreasing the number of processors in the set of processors.

### Claim 3 (depends on 1)

The non-transitory computer-readable medium of claim 1, wherein the instructions further cause the one or more second processors to:
monitor a utilization of the set of storage resources as the set of queries are processed, and
update an amount of the storage resources in the set of storage resources provisioned based on the utilization, wherein the updating of the set of storage resources is independent to a change in the number of processors.

### Claim 4 (depends on 1)

The non-transitory computer-readable medium of claim 1, wherein the instructions further cause the one or more second processors to:
monitor a utilization of the set of processors as the set of queries are processed.

### Claim 5 (depends on 4)

The non-transitory computer-readable medium of claim 4, wherein the utilization is selected from the group consisting of a number of queries running concurrently, a percentage of maximum load, and query processing delay.

### Claim 6 (depends on 1)

The non-transitory computer-readable medium of claim 1, wherein the instructions further cause the one or more second processors to:
receive an additional query for the set of queries.

### Claim 7 (depends on 6)

The non-transitory computer-readable medium of claim 6, determining a change in the set of processors in response to receiving the additional query.

### Claim 8 (depends on 1)

The non-transitory computer-readable medium of claim 1, wherein the instructions further cause the one or more second processors to:
optimize at least one of the queries in the set of queries.

### Claim 9 (depends on 1)

The non-transitory computer-readable medium of claim 1, wherein the set of queries are queries for a relational database.

### Claim 10 (depends on 8)

The non-transitory computer-readable medium of claim 8, wherein the relational database is a structured query language database.

### Claim 11

A method comprising:
provisioning a set of processors from a first plurality of processors, the set of processors to process a set of queries, a set of storage resources shared by each of the set of processors to store data for the set of queries;
changing an amount of the processor resources in the set of processors based on a utilization of the set of processors as the set of processors that are processing the set of queries, wherein the changing of the set of storage resources is independent to a change in the number of processors; and
processing the set of queries using the changed set of processors.

### Claim 12 (depends on 11)

The method of claim 11, wherein the changing the number of processors includes at least one of increasing the number of processors in the set of processors or decreasing the number of processors in the set of processors.

### Claim 13 (depends on 11)

The method of claim 11, further comprising:
monitoring a utilization of the set of storage resources as the set of queries are processed by, and
updating an amount of the storage resources in the set of storage resources provisioned based on the utilization, wherein the updating of the set of storage resources is independent to a change in the number of processors.

### Claim 14 (depends on 11)

The method of claim 11, further comprising:
monitoring a utilization of the set of processors as the set of queries are processed.

### Claim 15 (depends on 14)

The method of claim 14, wherein the utilization is selected from the group consisting of a number of queries running concurrently, a percentage of maximum load, and query processing delay.

### Claim 16 (depends on 11)

The method of claim 11, further comprising:
receiving an additional query for the set of queries.

### Claim 17 (depends on 15)

The method of claim 15, determining a change in the set of processors in response to receiving the additional query.

### Claim 18 (depends on 11)

The method of claim 11, further comprising:
optimizing at least one of the queries in the set of queries.

### Claim 19 (depends on 11)

The method of claim 11, wherein the set of queries are for a relational database.

### Claim 20 (depends on 18)

The method of claim 18, wherein the relational database is a structured query language database.

### Claim 21

A system comprising:
a set of storage resources;
a resource manager to:
provision the set of storage resources from a plurality of storage resources, the set of storage resources shared by each of a set of plurality of processing units to store data for the set of queries; and
change an amount of the storage resources in the set of storage resources based on a utilization of the storage capacity of the set of storage resources as the set of storage resources that are used in processing the set of queries, wherein the changing of the set of storage resources is independent to a change in a number of processing units in the plurality of processing units; and
the plurality of processing units to process the set of queries using the changed amount of storage resources.

### Claim 22 (depends on 21)

The system of claim 21, wherein the resource manager changes the amount of storage resources by increasing the amount of storage resources in the set of storage resources.

### Claim 23 (depends on 21)

The system of claim 21, wherein the resource manager changed the amount of storage resources by decreasing the amount of storage resources in the set of storage resources.

### Claim 24 (depends on 21)

The system of claim 21, wherein the resource manager further to:
monitor a utilization of the set of storage resources as the set of queries are processed.

### Claim 25 (depends on 21)

The system of claim 21, wherein the utilization is selected from the group consisting of a number of queries running concurrently, a percentage of maximum load, and query processing delay.

### Claim 26 (depends on 21)

The system of claim 21, wherein the resource manager further to receive an additional query for the set of queries.

### Claim 27 (depends on 25)

The system of claim 25, wherein the resource manager determines a change in the set of storage resources in response to receiving the additional query.

### Claim 28 (depends on 21)

The system of claim 21, wherein the resource manager further to optimize at least one of the queries in the set of queries.

### Claim 29 (depends on 21)

The system of claim 21, wherein the set of queries are for a relational database.

### Claim 30 (depends on 28)

The system of claim 28, wherein the relational database is a structured query language database.
