公开(公告)号：US11461330B2

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

申请号：US17067495

申请日：2020-10-09

Applicant: Amazon Technologies, Inc.

Inventor： Bhargava Ram Kalathuru ,  Jian Fang ,  Xing Wu ,  Yuanyuan Yue ,  Pratik Bhagwat Gawande ,  Turkay Mert Hocanin ,  Jason Douglas Denton ,  Luca Natali ,  Rahul Sharma Pathak ,  Abhishek Rajnikant Sinha ,  Sumeetkumar Veniklal Maru ,  Armen Tangamyan ,  Yufeng Jiang

IPC: G06F16/20 ,  G06F16/21 ,  G06F16/245 ,  G06F16/2453 ,  G06F16/2455 ,  G06F16/2458 ,  G06F16/248 ,  G06F16/25 ,  G06F16/27 ,  G06F9/50 ,  H04L67/10 ,  H04L67/1008 ,  H04L67/1029 ,  H04L67/1031 ,  G06F16/28 ,  G06F16/903

Abstract: Queries may be received and executed by a managed query service. A query directed to data sets that are separately stored in a remote data store may be received. Computing resources to execute the query may be provisioned from a pool of computing resources that are configured to execute queries. The query may be routed to the provisioned computing resources to execute the query. Results may be obtained from the computing resource and provided to a submitter of the query.

公开(公告)号：US10970303B1

公开(公告)日：2021-04-06

申请号：US15668677

申请日：2017-08-03

Applicant: Amazon Technologies, Inc.

Inventor： Jason Douglas Denton ,  Rahul Sharma Pathak ,  Xing Wu

IPC: G06F16/00 ,  G06F16/27 ,  G06F16/951 ,  G06F16/25

Abstract: Available capacity of resources hosted in different networks may be evaluated to select resources for the performance of a query. A query may be received via an interface for one network. The available capacity of the one network and other networks may be evaluated to select resources hosted in another network to perform the query instead of the resources in the one network. The query may then be routed to the resources in the other network and result of the query performed at the resources in the other network provided.

公开(公告)号：US20210049175A1

公开(公告)日：2021-02-18

申请号：US17006522

申请日：2020-08-28

Applicant: Amazon Technologies, Inc.

Inventor： Xing Wu ,  Bhargava Ram Kalathuru ,  Jian Fang ,  Yuanyuan Yue ,  Pratik Bhagwat Gawande ,  Turkay Mert Hocanin ,  Jason Douglas Denton ,  Luca Natali ,  Rahul Sharma Pathak ,  Abhishek Rajnikant Sinha ,  Sumeetkumar Veniklal Maru ,  Armen Tangamyan ,  Yufeng Jiang

IPC: G06F16/2453 ,  G06F16/21 ,  G06F16/248 ,  G06F16/28 ,  G06F16/2455 ,  G06F16/2458 ,  G06F16/903 ,  G06F9/50 ,  G06F16/27 ,  G06F16/20 ,  G06F16/25 ,  H04L29/08

Abstract: Query execution status may be tracked to selectively route queries to resources for execution. The completion of queries executing at computing resources obtained from a pool of computing resources configured to execute queries may be detected. Instead of returning the computing resources to the pool, the computing resources may be identified as available in resource management data. When another query is received, the resource management data may be evaluated to select an available computing resource. The query may then be routed to the selected computing resource for execution.

公开(公告)号：US10803060B2

公开(公告)日：2020-10-13

申请号：US15470829

申请日：2017-03-27

Applicant: Amazon Technologies, Inc.

Inventor： Bhargava Ram Kalathuru ,  Jian Fang ,  Xing Wu ,  Yuanyuan Yue ,  Pratik Bhagwat Gawande ,  Turkay Mert Hocanin ,  Jason Douglas Denton ,  Luca Natali ,  Rahul Sharma Pathak ,  Abhishek Rajnikant Sinha ,  Sumeetkumar Veniklal Maru ,  Armen Tangamyan ,  Yufeng Jiang

IPC: G06F16/20 ,  G06F16/21 ,  G06F16/245 ,  G06F16/2453 ,  G06F16/2455 ,  G06F16/2458 ,  G06F16/248 ,  G06F16/25 ,  G06F16/27 ,  G06F16/28 ,  G06F16/903 ,  G06F9/50 ,  H04L29/08

Abstract: Queries may be received and executed by a managed query service. A query directed to data sets that are separately stored in a remote data store may be received. Computing resources to execute the query may be provisioned from a pool of computing resources that are configured to execute queries. The query may be routed to the provisioned computing resources to execute the query. Results may be obtained from the computing resource and provided to a submitter of the query.

公开(公告)号：US10762086B2

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

申请号：US15470841

申请日：2017-03-27

Applicant: Amazon Technologies, Inc.

Inventor： Xing Wu ,  Bhargava Ram Kalathuru ,  Jian Fang ,  Yuanyuan Yue ,  Pratik Bhagwat Gawande ,  Turkay Mert Hocanin ,  Jason Douglas Denton ,  Luca Natali ,  Rahul Sharma Pathak ,  Abhishek Rajnikant Sinha ,  Sumeetkumar Veniklal Maru ,  Armen Tangamyan ,  Yufeng Jiang

IPC: G06F7/00 ,  G06F16/2453 ,  G06F16/21 ,  G06F16/248 ,  G06F16/28 ,  G06F16/2455 ,  G06F16/2458 ,  G06F16/903 ,  G06F9/50 ,  G06F16/27 ,  G06F16/20 ,  G06F16/25 ,  H04L29/08 ,  G06F16/245

Abstract: Query execution status may be tracked to selectively route queries to resources for execution. The completion of queries executing at computing resources obtained from a pool of computing resources configured to execute queries may be detected. Instead of returning the computing resources to the pool, the computing resources may be identified as available in resource management data. When another query is received, the resource management data may be evaluated to select an available computing resource. The query may then be routed to the selected computing resource for execution.

公开(公告)号：US20200233869A1

公开(公告)日：2020-07-23

申请号：US16839849

申请日：2020-04-03

Applicant: Amazon Technologies, Inc.

Inventor： Pratik Bhagwat Gawande ,  Sumeetkumar Veniklal Maru ,  Bhargava Ram Kalathuru ,  Jian Fang ,  Xing Wu ,  Yuanyuan Yue ,  Turkay Mert Hocanin ,  Jason Douglas Denton ,  Luca Natali ,  Rahul Sharma Pathak ,  Abhishek Rajnikant Sinha ,  Armen Tangamyan ,  Yufeng Jiang ,  Marc Howard Beitchman ,  Andrew Edward Caldwell

IPC: G06F16/2453 ,  H04L29/08 ,  G06F9/50 ,  G06F16/903 ,  G06F16/2455 ,  G06F16/2458 ,  G06F16/28 ,  G06F16/248 ,  G06F16/21 ,  G06F16/25 ,  G06F16/20 ,  G06F16/27

Abstract: The configuration of computing resources for executing queries may be selected. A comparison of the configuration of computing resources that executed previous queries may be made to select the configuration of computing resources for a received query. A historical query execution model maybe applied, in some embodiments, to determine a resource configuration for computing resources to execute a query. The computing resources may be selected from available computing resources according to the determined resource configuration.

公开(公告)号：US11803546B2

公开(公告)日：2023-10-31

申请号：US15588373

申请日：2017-05-05

Applicant: Amazon Technologies, Inc.

Inventor： Rahul Sharma Pathak ,  Jason Douglas Denton ,  Abhishek Rajnikant Sinha

IPC: G06F16/2453 ,  G06F16/2458 ,  G06F16/27 ,  G06F16/2455 ,  G06F16/903 ,  G06F16/25 ,  G06F16/21 ,  G06F16/248 ,  G06F16/28 ,  G06F9/50 ,  G06F16/20 ,  H04L67/1008 ,  H04L67/1029 ,  H04L67/10 ,  H04L67/1031 ,  G06F16/245

CPC classification number: G06F16/24545 ,  G06F9/50 ,  G06F9/505 ,  G06F9/5022 ,  G06F9/5044 ,  G06F9/5055 ,  G06F9/5061 ,  G06F9/5088 ,  G06F16/20 ,  G06F16/211 ,  G06F16/248 ,  G06F16/2455 ,  G06F16/2471 ,  G06F16/24549 ,  G06F16/24553 ,  G06F16/25 ,  G06F16/27 ,  G06F16/282 ,  G06F16/90335 ,  H04L67/10 ,  H04L67/1008 ,  H04L67/1029 ,  H04L67/1031 ,  G06F9/5027 ,  G06F16/245 ,  G06F2209/501 ,  G06F2209/503 ,  G06F2209/508 ,  G06F2209/5011

Abstract: Interruptible computing resources for executing queries may be selected. When queries are received, the probability that query can complete execution at interruptible computing resources may be determined. Computing resources to process the query may be selected based on the probability. For queries that are performed on computing resources that are interrupted, interruption handling techniques may retry the query on other computing resources or complete the query on other computing resources, in some embodiments.

公开(公告)号：US11055352B1

公开(公告)日：2021-07-06

申请号：US15617901

申请日：2017-06-08

Applicant: Amazon Technologies, Inc.

Inventor： Marc Howard Beitchman ,  Andrew Edward Caldwell ,  Rahul Sharma Pathak

IPC: G06F16/9032 ,  G06F16/14 ,  G06F16/903

Abstract: Optimized query plans may be generated independent of the query engine that performs the optimized query plan. A request to generate an optimized query plan for a query may be received and a type of engine for performing the query may be identified. An initial plan may be generated in an engine-specific format for the type of engine that is translated into an optimization plan format. An analysis of the initial plan optimization plan format may be performed to generate an optimized query plan. The optimized query plan may be translated into the engine-specific format and sent in response to the request for the optimized query plan.

公开(公告)号：US10282350B1

公开(公告)日：2019-05-07

申请号：US13924271

申请日：2013-06-21

Applicant: Amazon Technologies, Inc.

Inventor： Rahul Sharma Pathak

IPC: G06F16/22 ,  G06F16/21 ,  G06F16/2453

Abstract: A method is described for monitoring data store performance and recommending a data store structure for a data store. The method may include analyzing a data store structure to determine whether the data store structure corresponds to a set of criteria, analyzing a query executed against the data store structure to determine performance of the query with respect to the data store structure and providing a proposed data store structure to a customer based at least on part on the analysis of the data store structure and analysis of the query.

公开(公告)号：US20180060395A1

公开(公告)日：2018-03-01

申请号：US15588373

申请日：2017-05-05

Applicant: Amazon Technologies, Inc.

Inventor： Rahul Sharma Pathak ,  Jason Douglas Denton ,  Abhishek Rajnikant Sinha

IPC: G06F17/30 ,  G06F9/50

CPC classification number: G06F16/24545 ,  G06F9/50 ,  G06F9/5022 ,  G06F9/5027 ,  G06F9/5044 ,  G06F9/505 ,  G06F9/5055 ,  G06F9/5061 ,  G06F9/5088 ,  G06F16/20 ,  G06F16/211 ,  G06F16/245 ,  G06F16/24549 ,  G06F16/2455 ,  G06F16/24553 ,  G06F16/2471 ,  G06F16/248 ,  G06F16/25 ,  G06F16/27 ,  G06F16/282 ,  G06F16/90335 ,  G06F2209/501 ,  G06F2209/5011 ,  G06F2209/503 ,  G06F2209/508 ,  H04L29/08135 ,  H04L29/08171 ,  H04L29/08261 ,  H04L29/0827 ,  H04L67/10 ,  H04L67/1008 ,  H04L67/1029 ,  H04L67/1031

Abstract: Interruptible computing resources for executing queries may be selected. When queries are received, the probability that query can complete execution at interruptible computing resources may be determined. Computing resources to process the query may be selected based on the probability. For queries that are performed on computing resources that are interrupted, interruption handling techniques may retry the query on other computing resources or complete the query on other computing resources, in some embodiments.