Resource provisioning systems and methods
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.
1. A method comprising:
provisioning processing resources of an execution platform, the execution platform to process a set of queries using a storage platform that is shared with the execution platform;
changing a number of the processing resources provisioned for the execution platform, wherein the changing of the number of the processing resources is independent to a change of the storage platform; and
processing the set of queries using the changed number of the processing resources.
2. The method of claim 1 , further comprising:
monitoring a utilization of the changed number of the processing resources as the changed number of the processing resources processes the set of queries.
3. The method of claim 1 , wherein the changing the number of processing resources includes increasing the number of processing resources.
4. The method of claim 1 , wherein the changing the number of processing resources includes decreasing the number of processing resources.
5. The method of claim 1 , further comprising:
determining a change in the number of processing resources in response to receiving an additional query.
6. The method of claim 1 , further comprising:
optimizing at least one of the queries in the set of queries.
7. The method of claim 1 , wherein the set of queries are queries for a relational database.
8. The method of claim 1 , further comprising:
provisioning the processing resources from plurality of processing resources.
9. The method of claim 1 , wherein the resource manager further to:
monitor a utilization of the changed number of the processing resources as the changed number of the processing resources processes the set of queries.
10. The method of claim 1 , further comprising:
receiving the set of queries.
11. A system comprising:
a set of storage resources;
a resource manager implemented in a processor, which executes to:
provision processing resources of an execution platform, the execution platform to process a set of queries using a storage platform that is shared with the execution platform;
change a number of the processing resources provisioned for the execution platform, wherein the changing of the number of the processing resources is independent to a change of the storage platform; and
process the set of queries using the changed number of the processing resources.
12. The system of claim 11 , wherein the resource manager updates changes the number of processing resources by increasing the number of processing resources.
13. The system of claim 11 , wherein the resource manager updates changes the number of processing resources by decreasing the number of processing resources.
14. The system of claim 11 , wherein the resource manager further to receive the set of queries.
15. The system of claim 11 , wherein the resource manager further to optimize at least one of the queries in the set of queries.
16. The system of claim 15 , wherein the set of queries are queries for a relational database, and wherein the relational database is a structured query language database.
17. The system of claim 11 , wherein the resource manager further to:
provision the processing resources from a plurality of processing resources.
18. The system of claim 11 , wherein the resource manager determines a change in the number of processing resources in response to receiving an additional query.
19. A non-transitory computer-readable medium storing instructions which, when executed by one or processors of a computing device, cause the one or more processors to:
provision processing resources of an execution platform, the execution platform to process a set of queries using a storage platform that is shared with the execution platform;
change a number of the processing resources provisioned for the execution platform, wherein the changing of the number of the processing resources is independent to a change of the storage platform; and
process the set of queries using the changed number of the processing resources.
20. The non-transitory computer-readable medium of claim 19 , wherein the changing the number of processing resources includes increasing the number of processing resources.
21. The non-transitory computer-readable medium of claim 19 , wherein the changing the number of processing resources includes decreasing the number of processing resources.