ADJUSTING A TIMING TO PROCESS QUERIES
A system and method of scaling capacity of data warehouses to user-defined levels. The method includes determining a performance associated with processing one or more queries. The method includes receiving a request to process data stored on a storage platform. The method includes adjusting, by a processing device based on the performance, a timing associated with the processing of the one or more queries to adjust a different timing associated with processing the request.
1 . A method comprising:
determining a performance associated with processing one or more queries;
receiving a request to process data stored on a storage platform; and
adjusting, by a processing device based on the performance, a timing associated with the processing of the one or more queries to adjust a different timing associated with processing the request.
2 . The method of claim 1 , further comprising:
adding at least one additional processor to a processing platform to process the one or more queries; or
adding at least one additional storage device to the storage platform.
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 processing platform.
4 . The method of claim 2 , wherein adding the at least one additional processor to the processing platform is accomplished without affecting a storage capacity of the storage platform.
5 . The method of claim 2 , wherein the storage platform is physically separate from the processing platform.
6 . The method of claim 1 , wherein adjusting the timing associated with the processing of the one or more queries further comprises:
delaying the timing associated with the processing of the one or more queries.
7 . The method of claim 1 , wherein adjusting the timing associated with the processing of the one or more queries comprises determining that a current query processing delay would exceed a threshold delay.
8 . The method of claim 1 , wherein the request comprises a data retrieval request or a data storage request.
9 . A system, comprising:
a memory; and
a processing device, operatively coupled to the memory, to:
determine a performance associated with processing one or more queries;
receive a request to process data stored on a storage platform; and
adjust, based on the performance, a timing associated with the processing of the one or more queries to adjust a different timing associated with processing the request.
10 . The system of claim 9 , wherein the processing device is further to:
add at least one additional processor to a processing platform to process the one or more queries; or
add at least one additional storage device to the storage platform.
11 . The system of claim 10 , wherein the processing device is further to:
determine that the at least one additional processor is no longer needed; and
remove the at least one additional processor from the processing platform.
12 . The system of claim 10 , wherein to add the at least one additional processor to the processing platform is accomplished without affecting a storage capacity of the storage platform.
13 . The system of claim 10 , wherein the storage platform is physically separate from the processing platform.
14 . The system of claim 9 , wherein to adjust the timing associated with the processing of the one or more queries, the processing device is further to:
delay the timing associated with the processing of the one or more queries.
15 . The system of claim 9 , wherein to adjust the timing associated with the processing of the one or more queries, the processing device is further to determine that a current query processing delay would exceed a threshold delay.
16 . The system of claim 9 , wherein the request comprises a data retrieval request or a data storage request.
17 . A non-transitory computer-readable medium storing instructions that, when executed by a processing device, cause the processing device to:
determine a performance associated with processing one or more queries;
receive a request to process data stored on a storage platform; and
adjust, by the processing device based on the performance, a timing associated with the processing of the one or more queries to adjust a different timing associated with processing the request.
18 . The non-transitory computer-readable medium of claim 17 , wherein the instructions, when executed by the processing device, further cause the processing device to:
add at least one additional processor to a processing platform to process the one or more queries; or
add at least one additional storage device to the storage platform.
19 . The non-transitory computer-readable medium of claim 18 , wherein the instructions, when executed by the processing device, further cause the processing device to:
determine that the at least one additional processor is no longer needed; and
remove the at least one additional processor from the processing platform.
20 . The non-transitory computer-readable medium of claim 19 , wherein adding the at least one additional processor to the processing platform is accomplished without affecting a storage capacity of the storage platform.
21 . The non-transitory computer-readable medium of claim 18 , wherein the storage platform is physically separate from the processing platform.
22 . The non-transitory computer-readable medium of claim 18 , wherein the instructions, when executed by the processing device, further cause the processing device to:
delay the timing associated with the processing of the one or more queries.
23 . The non-transitory computer-readable medium of claim 17 , wherein the instructions, when executed by the processing device, further cause the processing device to:
determine that a current query processing delay would exceed a threshold delay.
24 . The non-transitory computer-readable medium of claim 17 , wherein the request comprises a data retrieval request or a data storage request.