公开(公告)号：US12189649B2

公开(公告)日：2025-01-07

申请号：US17535446

申请日：2021-11-24

Applicant: Amazon Technologies, Inc.

Inventor： Ippokratis Pandis ,  Naresh Chainani ,  Sebastian Hillig ,  Christos Stavrakakis ,  Eric Ray Hotinger ,  Bruce William McGaughy ,  William Michael McCreedy ,  Yan Leshinsky

IPC: G06F16/27 ,  G06F16/2453

Abstract: Database query processing may be scaled using additional processing clusters. A database query is received at a processing cluster. A determination is made as to whether additional processing clusters will be used to process the database query. Operations to cause compute nodes of the processing cluster to instruct operations at the additional processing clusters are included in a plan generated to perform database queries determined to use additional processing clusters. The plan is executed to be perform the database query causing compute nodes of the processing cluster to send instructions to corresponding additional processing clusters in order to generate and return a response to the database 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.

公开(公告)号：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.

公开(公告)号：US11727004B2

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

申请号：US17662623

申请日：2022-05-09

Applicant: Amazon Technologies, Inc.

Inventor： Mingda Li ,  Gaurav Saxena ,  Naresh Chainani

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

CPC classification number: G06F16/24549 ,  G06N5/04 ,  G06N20/00

Abstract: Context dependent execution time prediction may be applied to redirect queries to additional query processing resources. A query to a database may be received at a first query engine. A prediction model for executing queries at the first query engine may be applied to determine predicted query execution time for the first query engine. A prediction model for executing queries at a second query engine may also be applied to determine predicted query execution time for the second query engine. One of the query engines may be selected to perform the query based on a comparison of the predicted query execution times.

公开(公告)号：US20230171163A1

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

申请号：US17810195

申请日：2022-06-30

Applicant: Amazon Technologies, Inc.

Inventor： Krishna Chaitanya Gudipati ,  Sanjay Wangoo ,  Fabian Oliver Nagel ,  Ippokratis Pandis ,  Gokul Soundararajan ,  Aditya Subrahmanyan ,  Induja Sreekanthan ,  Yao Xiao ,  Ankil Shah ,  Yehan Zhang ,  Siyi Zhang ,  Vaishali Ravindra Narkhede ,  Naresh Chainani

IPC: H04L41/12 ,  G06F11/14

CPC classification number: H04L41/12 ,  G06F11/1469 ,  G06F11/1464 ,  G06F2201/80

Abstract: Online restore may be performed between databases with different topologies while applying a custom data distribution. A request to restore a database into a different topology of nodes may be received. A plan to move different portions of the database from a current topology to the new topology made using a general distribution scheme. The plan may be performed to move the different portions of the database into the new topology and the database made available for access using the new topology. A background process may be applied to modify the distribution of the database at the new topology to match a custom distribution scheme that was implemented at the current topology.

公开(公告)号：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.

公开(公告)号：US20230169048A1

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

申请号：US17535940

申请日：2021-11-26

Applicant: Amazon Technologies, Inc.

Inventor： Ippokratis Pandis ,  Eric Ray Hotinger ,  Bruce William McGaughy ,  Naresh Chainani ,  Neeraja Rentachintala ,  Zhixing Ma ,  Pulkit Jagdishchandra Bhavsar ,  Chao Duan ,  William Michael McCreedy ,  Pavel Sokolov ,  Sanjay Wangoo

IPC: G06F16/21 ,  G06F11/34 ,  G06F16/23

CPC classification number: G06F16/21 ,  G06F11/3423 ,  G06F16/2393 ,  G06F16/2358

Abstract: Idle periods may be for management actions at processing clusters for managed databases. A leader node of a processing cluster for a managed database may monitor a network endpoint at a proxy service associated with a database managed by the database service. An idle period for the database may be detected. A management action for the processing cluster may be determined to be performed during the detected idle period. The leader node may cause the determined management action to be performed.