公开(公告)号：US11537616B1

公开(公告)日：2022-12-27

申请号：US16915928

申请日：2020-06-29

Applicant: Amazon Technologies, Inc.

Inventor： Chunbin Lin ,  Naresh Chainani ,  Gaurav Saxena ,  George Constantin Caragea ,  Mohammad Rezaur Rahman

IPC: G06F7/00 ,  G06F16/2453 ,  G06N5/04 ,  G06N20/00

Abstract: Performance measures are predicted for queries to prioritize query performance at a database system. A trained machine learning model for the database system may be applied to a query to determine a predicted performance measure for the query. The predicted performance measure may be compared with other predicted performance measures for other waiting queries to determine a priority for executing the query.

公开(公告)号：US12248473B1

公开(公告)日：2025-03-11

申请号：US18540496

申请日：2023-12-14

Applicant: Amazon Technologies, Inc.

Inventor： Zhengchun Liu ,  Gaurav Saxena ,  Balakrishnan Narayanaswamy ,  Kaihui Zheng ,  Mohammad Rezaur Rahman ,  Tim Kraska

IPC: G06F16/2453

Abstract: A future workload may be predicted for a database system using analysis of queries submitted for execution. A feature vector for a query may be determined according to a query plan for the query. If the feature vector has not been previously seen, or has not been sufficiently seen, by the database system, a machine learning inference may be used to predict performance characteristics of the query, the machine learning system trained using previous feature vectors and performance characteristics of executed queries. If the feature vector has been sufficiently seen previously by the database system, a history of performance characteristics of previous queries with similar or the same feature vector may be used to predict the performance characteristics. The predictions may then be used to configure or reconfigure processing cluster(s) of the database system.

公开(公告)号：US11762860B1

公开(公告)日：2023-09-19

申请号：US17118288

申请日：2020-12-10

Applicant: Amazon Technologies, Inc.

Inventor： Mohammad Rezaur Rahman ,  George Constantin Caragea ,  Raj Narayan Sett ,  Gaurav Saxena ,  Naresh Chainani ,  Chunbin Lin

IPC: G06F16/2455 ,  G06F16/2453 ,  G06N20/00 ,  G06F16/23 ,  G06F18/214 ,  G06F11/34

CPC classification number: G06F16/24568 ,  G06F11/3409 ,  G06F16/2308 ,  G06F16/24539 ,  G06F16/24542 ,  G06F18/214 ,  G06N20/00

Abstract: Database systems may dynamically management concurrency levels for performing queries. A query may be received at a database system and a memory usage for the query may be predicted. A determination may be made as to whether available memory is enough to satisfy the predicted memory usage for the query. If the available memory is enough to satisfy the predicted memory usage for the query, then an increase in a concurrency level for performing queries at the database system may be made. The query may be allowed to execute concurrently with other queries according to the increased concurrency level.

公开(公告)号：US20230169079A1

公开(公告)日：2023-06-01

申请号：US17547831

申请日：2021-12-10

Applicant: Amazon Technologies, Inc.

Inventor： Gaurav Saxena ,  Balakrishnan Narayanaswamy ,  Ippokratis Pandis ,  Naresh Chainani ,  Mohammad Rezaur Rahman ,  Davide Pagano ,  Fabian Oliver Nagel

IPC: G06F16/2453

CPC classification number: G06F16/24545 ,  G06F16/24537

Abstract: Scaling of query processing resources for efficient utilization and performance is implemented for a database service. A query is received via a network endpoint associated with a database managed by a database service. Respective response times predicted for the query using different query processing configurations available to perform the query are determined. Those query processing configurations with response times that exceed a variability threshold determined for the query may be excluded. A remaining query processing configuration may then be selected to perform the query.

公开(公告)号：US11868359B2

公开(公告)日：2024-01-09

申请号：US17722222

申请日：2022-04-15

Applicant: Amazon Technologies, Inc.

Inventor： Gaurav Saxena ,  Ippokratis Pandis ,  Mengchu Cai ,  Mingda Li ,  Mohammad Rezaur Rahman ,  Naresh Chainani

IPC: G06F16/245 ,  G06F16/28 ,  G06F16/2458 ,  G06F16/2455 ,  G06F9/38

CPC classification number: G06F16/2458 ,  G06F16/24561 ,  G06F16/285 ,  G06F9/3877

Abstract: A primary query engine may receive a query and determine whether the query is eligible for performance at a secondary query engine. If eligible, the primary query engine may evaluate the availability of the first query engine to perform the query. The first query engine may determine whether to assign the query to the primary query engine or to the secondary query according to availability evaluation. For queries assigned to the secondary query engine, the primary query engine may send a request to the secondary query engine to being processing of the query.

公开(公告)号：US11727003B2

公开(公告)日：2023-08-15

申请号：US17547831

申请日：2021-12-10

Applicant: Amazon Technologies, Inc.

Inventor： Gaurav Saxena ,  Balakrishnan Narayanaswamy ,  Ippokratis Pandis ,  Naresh Chainani ,  Mohammad Rezaur Rahman ,  Davide Pagano ,  Fabian Oliver Nagel

IPC: G06F16/245 ,  G06F16/2453

CPC classification number: G06F16/24545 ,  G06F16/24537

Abstract: Scaling of query processing resources for efficient utilization and performance is implemented for a database service. A query is received via a network endpoint associated with a database managed by a database service. Respective response times predicted for the query using different query processing configurations available to perform the query are determined. Those query processing configurations with response times that exceed a variability threshold determined for the query may be excluded. A remaining query processing configuration may then be selected to perform the query.

公开(公告)号：US20220237184A1

公开(公告)日：2022-07-28

申请号：US17722222

申请日：2022-04-15

Applicant: Amazon Technologies, Inc.

Inventor： Gaurav Saxena ,  Ippokratis Pandis ,  Mengchu Cai ,  Mingda Li ,  Mohammad Rezaur Rahman ,  Naresh Chainani

IPC: G06F16/2458 ,  G06F16/2455 ,  G06F16/28

Abstract: A primary query engine may receive a query and determine whether the query is eligible for performance at a secondary query engine. If eligible, the primary query engine may evaluate the availability of the first query engine to perform the query. The first query engine may determine whether to assign the query to the primary query engine or to the secondary query according to availability evaluation. For queries assigned to the secondary query engine, the primary query engine may send a request to the secondary query engine to being processing of the query.

公开(公告)号：US11308100B2

公开(公告)日：2022-04-19

申请号：US16452385

申请日：2019-06-25

Applicant: Amazon Technologies, Inc.

Inventor： Gaurav Saxena ,  Ippokratis Pandis ,  Mengchu Cai ,  Mingda Li ,  Mohammad Rezaur Rahman ,  Naresh Chainani

IPC: G06F16/245 ,  G06F16/2458 ,  G06F16/2455 ,  G06F16/28 ,  G06F9/38

Abstract: A primary query engine may receive a query and determine whether the query is eligible for performance at a secondary query engine. If eligible, the primary query engine may evaluate the availability of the first query engine to perform the query. The first query engine may determine whether to assign the query to the primary query engine or to the secondary query according to availability evaluation. For queries assigned to the secondary query engine, the primary query engine may send a request to the secondary query engine to being processing of the query.