Resource provisioning systems and methods

1. A method comprising:

providing a plurality of processing resources associated with a data warehouse, wherein the plurality of processing resources comprising at least one processor and at least one storage device and wherein the plurality of processing resources are part of an execution platform;

receiving at least one processing request to process database data stored on a storage platform comprising a plurality of shared storage devices in association with the data warehouse, wherein the plurality of processing resources are divided into groups of processing resources;

determining that a portion of data associated with a processing request is pre-cached by a first group of the plurality of processing resources based on metadata including information regarding pre-cached data on the first group of the plurality of processing resources;

providing the processing request to the first group of the plurality of processing resources responsive to determining that the portion of data associated with the processing request is pre-cached by the first group of the plurality of processing resources;

determining that one or more of a processing capacity of the first group of the plurality of processing resources has reached a threshold processing capacity and a storage capacity associated with the plurality of computation resources has reached a threshold storage capacity; and

automatically scaling one or more of the processing capacity of the first group of the plurality of processing resources by adding additional processing resources to the data warehouse and the storage capacity of the storage platform by adding at least one additional storage device, wherein the processing capacity and the storage capacity are independently scalable and wherein the processing capacity is allocated within the execution platform.

2. The method of claim 1 , wherein adding additional processing resources comprises adding at least one additional processor to process the at least one request to process database data stored in the data warehouse.

3. The method of claim 2 , further comprising:

determining that the at least one additional processor is no longer needed; and

removing the at least one additional processor from the data warehouse.

4. The method of claim 2 , wherein adding at least one additional processor to the data warehouse is accomplished without affecting a storage capacity of the plurality of shared storage devices.

5. The method of claim 1 , wherein determining that the processing capacity has reached a threshold processing capacity comprises determining that a current query processing delay has exceeded a threshold delay.

6. The method of claim 1 , wherein each processing resource comprises a processor and a storage device.

7. The method of claim 1 , wherein the storage platform is physically separate from the plurality of processing resources.

8. The method of claim 1 , wherein the processing requests comprise a data retrieval request or a data storage request.

9. A system, comprising:

a processing device programmed to:

provide a plurality of processing resources associated with a data warehouse, wherein the plurality of processing resources comprising at least one processor and at least one storage device and wherein the plurality of processing resources are part of an execution platform;

receive at least one processing request to process database data stored on a storage platform comprising a plurality of shared storage devices in association with the data warehouse, wherein the plurality of processing resources are divided into groups of processing resources;

determine that a portion of data associated with a processing request is pre-cached by a first group of the plurality of processing resources based on metadata including information regarding pre-cached data on the first group of the plurality of processing resources;

provide the processing request to the first group of the plurality of processing resources responsive to determining that the portion of data associated with the processing request is pre-cached by the first group of the plurality of processing resources;

determine that one or more of a processing capacity of the first group of the plurality of processing resources has reached a threshold processing capacity and a storage capacity associated with the plurality of computation resources has reached a threshold storage capacity; and

automatically scale one or more of the processing capacity of the first group of the plurality of processing resources by adding additional processing resources to the data warehouse and the storage capacity of the storage platform by adding at least one additional storage device, wherein the processing capacity and the storage capacity are independently scalable and wherein the processing capacity is allocated within the execution platform.

10. The system of claim 9 , wherein adding additional processing resources comprises adding at least one additional processor to process the at least one request to process database data stored in the data warehouse.

11. The system of claim 10 , wherein the processing device is further programmed to:

determine that the at least one additional processor is no longer needed; and

remove the at least one additional processor from the data warehouse.

12. The system of claim 10 , wherein adding at least one additional processor to the data warehouse is accomplished without affecting a storage capacity of the plurality of shared storage devices.

13. The system of claim 9 , wherein determining that the processing capacity has reached a threshold processing capacity comprises determining that a current query processing delay has exceeded a threshold delay.

14. The system of claim 9 , wherein each processing resource comprises a processor and a storage device.

15. The system of claim 9 , wherein the storage platform is physically separate from the plurality of processing resources.

16. The system of claim 9 , wherein the processing requests comprise a data retrieval request or a data storage request.

17. A non-transitory computer-readable medium having instructions stored thereon that, when executed by a processor, cause the processor to:

provide a plurality of processing resources associated with a data warehouse, wherein the plurality of processing resources comprising at least one processor and at least one storage device and wherein the plurality of processing resources are part of an execution platform;

receive at least one processing request to process database data stored on a storage platform comprising a plurality of shared storage devices in association with the data warehouse, wherein:

the plurality of processing resources are divided into groups of processing resources;

determine that a portion of data associated with a processing request is pre-cached by a first group of the plurality of processing resources based on metadata including information regarding pre-cached data on the first group of the plurality of processing resources;

provide the processing request to the first group of the plurality of processing resources responsive to determining that the portion of data associated with the processing request is pre-cached by the first group of the plurality of processing resources;

determine that one or more of a processing capacity of the first group of the plurality of processing resources has reached a threshold processing capacity and a storage capacity associated with the plurality of computation resources has reached a threshold storage capacity; and

automatically scale one or more of the processing capacity of the first group of the plurality of processing resources by adding additional processing resources to the data warehouse and the storage capacity of the storage platform by adding at least one additional storage device, wherein the processing capacity and the storage capacity are independently scalable and wherein the processing capacity is allocated within the execution platform.

18. The non-transitory computer-readable medium of claim 17 , wherein adding additional processing resources comprises adding at least one additional processor to process the at least one request to process database data stored in the data warehouse.

19. The non-transitory computer-readable medium of claim 18 , wherein the instructions further cause the processor to:

determine that the at least one additional processor is no longer needed; and

remove the at least one additional processor from the data warehouse.

20. The non-transitory computer-readable medium of claim 18 , wherein adding at least one additional processor to the data warehouse is accomplished without affecting a storage capacity of the plurality of shared storage devices.

21. The non-transitory computer-readable medium of claim 17 , wherein determining that the processing capacity has reached a threshold processing capacity comprises determining that a current query processing delay has exceeded a threshold delay.

22. The non-transitory computer-readable medium of claim 17 , wherein each processing resource comprises a processor and a storage device.

23. The non-transitory computer-readable medium of claim 17 , wherein the storage platform is physically separate from the plurality of processing resources.

24. The non-transitory computer-readable medium of claim 17 , wherein the processing requests comprise a data retrieval request or a data storage request.