Resource provisioning systems and methods
First Claim
1. A system comprising:
- an execution platform configured to access a plurality of remote storage devices, the plurality of remote storage devices collectively storing database data, the execution platform including a plurality of virtual warehouses that each share the plurality of remote storage devices, retrieve data from the plurality of remote storage devices, and execute one or more queries received from client devices against the database data, each virtual warehouse including a cache configured to store data retrieved from the remote storage devices and a processor that is independent of the remote storage devices; and
a resource manager coupled to the execution platform and configured to;
determine predicted data processing requests based on previous patterns of previously received data processing requests from a particular client at a particular time;
monitor data processing requests including received data processing requests and the predicted data processing requests;
monitor resource utilization in the plurality of virtual warehouses;
determine whether additional virtual warehouses are needed based on the data processing requests and the resource utilization in the plurality of virtual warehouses; and
responsive to determining that an additional virtual warehouse is needed, provision a new virtual warehouse without increasing an amount of storage in the plurality of remote storage devices.
2 Assignments
0 Petitions
Accused Products
Abstract
Example resource provisioning systems and methods are described. In one implementation, an execution platform accesses multiple remote storage devices. The execution platform includes multiple virtual warehouses, each of which includes a cache to store data retrieved from the remote storage devices and a processor that is independent of the remote storage devices. A resource manager is coupled to the execution platform and monitors received data processing requests and resource utilization. The resource manager also determines whether additional virtual warehouses are needed based on the data processing requests and the resource utilization. If additional virtual warehouses are needed, the resource manager provisions a new virtual warehouse.
-
Citations
20 Claims
-
1. A system comprising:
-
an execution platform configured to access a plurality of remote storage devices, the plurality of remote storage devices collectively storing database data, the execution platform including a plurality of virtual warehouses that each share the plurality of remote storage devices, retrieve data from the plurality of remote storage devices, and execute one or more queries received from client devices against the database data, each virtual warehouse including a cache configured to store data retrieved from the remote storage devices and a processor that is independent of the remote storage devices; and a resource manager coupled to the execution platform and configured to; determine predicted data processing requests based on previous patterns of previously received data processing requests from a particular client at a particular time; monitor data processing requests including received data processing requests and the predicted data processing requests; monitor resource utilization in the plurality of virtual warehouses; determine whether additional virtual warehouses are needed based on the data processing requests and the resource utilization in the plurality of virtual warehouses; and responsive to determining that an additional virtual warehouse is needed, provision a new virtual warehouse without increasing an amount of storage in the plurality of remote storage devices. - View Dependent Claims (2, 3, 4, 5, 6, 7, 8, 9)
-
-
10. A method comprising:
-
determining predicted data processing requests based on previous patterns of previously received data processing requests from a particular client at a particular time; monitoring data processing requests including received data processing requests and the predicted data processing requests, wherein the data processing requests are associated with data stored in a plurality of remote storage devices collectively storing database data; monitoring resource utilization in a plurality of virtual warehouses, wherein each virtual warehouse includes a cache configured to store data retrieved from the remote storage devices and a processor that is independent of the remote storage devices, wherein the plurality of virtual warehouses each share the plurality of remote storage devices, retrieve data from the plurality of remote storage devices, and execute queries against the database data; determining whether additional virtual warehouses are needed based on the data processing requests and the resource utilization in the plurality of virtual warehouses; and creating a new virtual warehouse responsive to determining that an additional virtual warehouse is needed without increasing an amount of storage in the plurality of remote storage devices. - View Dependent Claims (11, 12, 13, 14, 15, 16, 17)
-
-
18. A system comprising:
-
means for accessing a plurality of remote storage devices collectively storing database data, the means for accessing includes a plurality of virtual warehouses that each share the plurality of remote storage devices, retrieve data from the plurality of remote storage devices, and execute one or more queries received from client devices against the database data, each virtual warehouse including a cache configured to store data retrieved from the remote storage devices and a processor that is independent of the remote storage devices; and means for managing resources coupled to the means for accessing and configured to; determine predicted data processing requests based on previous patterns of previously received data processing requests from a particular client at a particular time; monitor data processing requests including received data processing requests and the predicted data processing requests; monitor resource utilization in the plurality of virtual warehouses; determine whether additional virtual warehouses are needed based on the data processing requests and the resource utilization in the plurality of virtual warehouses; and responsive to determining that an additional virtual warehouse is needed, provision a new virtual warehouse that share the plurality of remote storage devices and execute one or more queries received from client devices against the database data. - View Dependent Claims (19, 20)
-
Specification