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

公开(公告)号：US20180060394A1

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

申请号：US15470843

申请日：2017-03-27

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: G06F17/30

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: 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.

公开(公告)号：US10936589B1

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

申请号：US15705140

申请日：2017-09-14

Applicant: Amazon Technologies, Inc.

Inventor： Marc Howard Beitchman ,  Andrew Edward Caldwell ,  Adam S. Hartman

IPC: G06F16/24 ,  G06F16/2453 ,  G06F16/27

Abstract: The capabilities of individual nodes that process a query may be evaluated to perform query planning. An operation of a plan to perform a query can be identified for assignment to a node based on the capabilities of nodes to perform the query operation. A node may be selected based on the difference between the selected node's capability to perform the query operation and other nodes capabilities to perform the operation. Capability-based selection can be performed at runtime, in some embodiments, in order to make query operation assignments based on further information obtained as a result of performing prior operations in the query.

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