Burst performance of a database query may be determined according to a size of the database query. A query to a database may be received. A size may be determined for the query. If the size is less than a size threshold assigned to a first query engine, then the query may be performed at the first query engine. If the size is greater than or equal to the size threshold assigned to the first query engine, then the query may be performed at a second query engine.
Legal claims defining the scope of protection, as filed with the USPTO.
3. The system of claim 2, wherein the provisioning of the second query engine from the pool of query engines is performed in response to the receipt of the second query at the first query engine.
8. The method of claim 5, further comprising provisioning the second query engine from a pool of query engines for burst query performance.
9. The method of claim 8, wherein the provisioning of the second query engine from the pool of query engines is performed in response to receiving the query at the first query engine.
10. The method of claim 8, wherein the provisioning of the second query engine from the pool of query engines is performed in response to determining a predicted burst performance event for the database based, at least in part, on a plurality of previously received queries to the database.
11. The method of claim 8, further comprising releasing the second query engine from performing queries to the database responsive to a exceeding a user-specified limitation for burst query performance.
13. The method of claim 5, wherein performing the second query to the database at the second query engine comprises obtaining data to perform the query at the second query engine from data of the database stored separately from the database.
17. The non-transitory, computer-readable storage medium of claim 14, wherein the program instructions cause the one or more computing devices to further implement provisioning the second query engine from a pool of query engines for burst query performance.
18. The non-transitory, computer-readable storage medium of claim 17, wherein the provisioning of the second query engine from the pool of query engines is performed in response to detecting a user scheduled event to provision the second query engine.
19. The non-transitory, computer-readable storage medium of claim 17, wherein the provisioning of the second query engine from the pool of query engines is performed in order to satisfy a user-specified performance criteria for the first query engine.
20. The non-transitory, computer-readable storage medium of claim 14, wherein the first query engine is a primary processing cluster implemented as part of a data warehouse service offered by a provider network that stores the database, wherein the second query engine is a burst processing cluster implemented as part of the provider network, and wherein in causing the performance of the second query at the burst processing cluster, the program instructions cause the one or more computing devices to implement accessing data of the database via another service of the provider network.
Cooperative Patent Classification codes for this invention. Click any code to explore related patents in that topic.
August 13, 2018
June 18, 2024
Browse 5M+ US patents with plain-English claim translations and AI-generated analysis.