公开(公告)号：US11593367B1

公开(公告)日：2023-02-28

申请号：US17489532

申请日：2021-09-29

Applicant: Amazon Technologies, Inc.

Inventor： Ippokratis Pandis ,  Matthew James Perron

IPC: G06F16/245 ,  G06F16/2453

Abstract: When a query is received by a stateful data processing service, the service determines, for each table scan (and associated operations) of a query, whether to select the table scan for execution by a stateless data processing service. The selected table scans are sent to the stateless data processing service for execution, and results are received by the stateful data processing service. The stateful data processing service may also execute other table scans of the query locally, against a local data cache. If the data is not present in the local data cache, then the stateful data processing service will copy the table data into the local data cache before executing the table scan. A query result based on the remote and/or local table scans may then be returned to the client.

公开(公告)号：US20200050694A1

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

申请号：US16102545

申请日：2018-08-13

Applicant: Amazon Technologies, Inc.

Inventor： Bhaven Avalani ,  Andrew Edward Caldwell ,  Naresh Chainani ,  Martin Grund ,  Anurag Windlass Gupta ,  Frederick Ryan Johnson ,  Ippokratis Pandis ,  Michail Petropoulos ,  Srividhya Srinivasan

IPC: G06F17/30

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

公开(公告)号：US12298977B1

公开(公告)日：2025-05-13

申请号：US17810293

申请日：2022-06-30

Applicant: Amazon Technologies, Inc.

Inventor： Fabian Oliver Nagel ,  Chunbin Lin ,  Ippokratis Pandis ,  Naresh Chainani ,  Mengchu Cai ,  Krishna Chaitanya Gudipati ,  Sanjay Wangoo ,  Qichen Zhang ,  Nikolaos Armenatzoglou

IPC: G06F15/16 ,  G06F16/2453

Abstract: Dynamic selection of topologies for database data may be performed for performing queries. Different possible query plans for different assignments of topologies are determined for a query. One of the query plans is selected according to a cost-based model that assigns costs to different uses of the different topologies. The query is then performed using the selected query plan.

公开(公告)号：US12169491B1

公开(公告)日：2024-12-17

申请号：US17936344

申请日：2022-09-28

Applicant: Amazon Technologies, Inc.

Inventor： Nemanja Boric ,  Venkatraman Govindaraju ,  Demala Palliye Gurunnanselage Shermal Ruwantha Fernando ,  Naresh Chainani ,  Ippokratis Pandis ,  Kiran Kumar Chinta ,  Hui Shi ,  Hanna Loboda

IPC: G06F16/00 ,  G06F16/2453 ,  G06F16/2455

Abstract: Dynamic plan interpretation may be implemented to perform queries. A query is received at a database system. A plan to perform the query is generated. For at least a portion of the plan to perform the query, a domain-specific language may be applied to interpret and execute the portion of the plan to perform the query using one or more previously compiled executors instead of generating and compiling code to execute the portion of the plan. Returning a result of the query according to the execution of the plan.

公开(公告)号：US12013856B2

公开(公告)日：2024-06-18

申请号：US16102545

申请日：2018-08-13

Applicant: Amazon Technologies, Inc.

Inventor： Bhaven Avalani ,  Andrew Edward Caldwell ,  Naresh Chainani ,  Martin Grund ,  Anurag Windlass Gupta ,  Frederick Ryan Johnson ,  Ippokratis Pandis ,  Michail Petropoulos ,  Srividhya Srinivasan

IPC: G06F16/24 ,  G06F16/2453 ,  G06F16/2455 ,  G06F16/28

CPC classification number: G06F16/2455 ,  G06F16/2453 ,  G06F16/283 ,  G06F16/285

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

公开(公告)号：US11853301B1

公开(公告)日：2023-12-26

申请号：US16370614

申请日：2019-03-29

Applicant: Amazon Technologies, Inc.

Inventor： Ippokratis Pandis ,  Naresh Chainani ,  Kiran Kumar Chinta ,  Venkatraman Govindaraju ,  Andrew Edward Caldwell ,  Naveen Muralimanohar ,  Martin Grund ,  Fabian Oliver Nagel ,  Nikolaos Armenatzoglou

IPC: G06F16/00 ,  G06F16/2455 ,  G06F16/2458 ,  G06F16/22 ,  G06F16/2453 ,  G06F16/242

CPC classification number: G06F16/24552 ,  G06F16/2255 ,  G06F16/2443 ,  G06F16/2445 ,  G06F16/2458 ,  G06F16/24539

Abstract: Compiled portions of code generated to perform a query plan at a query engine may be shared with other query engines. A data store, separate from the query engines, may store compiled portions of query code generated for different queries. If a query engine does not have a locally stored compiled portion of query code, then the separate data store may be accessed in order to obtain a compiled portion of query code, allowing reuse of compiled query code across different queries engines for queries directed to different databases.

公开(公告)号：US11321330B1

公开(公告)日：2022-05-03

申请号：US16140420

申请日：2018-09-24

Applicant: Amazon Technologies, Inc.

Inventor： Ippokratis Pandis ,  Panagiotis Parchas ,  Michail Petropoulos ,  Fabian Oliver Nagel ,  Yannis Papakonstantinou

IPC: G06F16/00 ,  G06F16/2458 ,  G06F16/28 ,  G06F16/22 ,  G06F16/2453

Abstract: A query that references nested data may have sub-expressions included in a subquery for nested data to perform the query. A first query engine may rewrite the query to include one or more sub-expressions that reference the nested data into a subquery for the nested data as part of generating a plan to perform the query. A second query engine may then be caused to perform the subquery for the nested data. A result of the query may be inclusive of the performance of the subquery at the second query engine.

公开(公告)号：US11216457B1

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

申请号：US15389318

申请日：2016-12-22

Applicant: Amazon Technologies, Inc.

Inventor： Ippokratis Pandis ,  Yannis Papakonstantinou

IPC: G06F16/2453 ,  G06F16/22 ,  G06F16/2455

Abstract: Join operations may be selectively assigned from local data processing to remote data processing. Aggregation queries directed to distributed data sets may have query plans generated that include join operations. Some join operations may be executed locally while others may be assigned for remote execution at a remote data processing engine. Join operations may be identified and evaluated for remote execution according to a processing constraint for the remote data processing engine. For those join operations that satisfy the remote data processing engine, the query plan may be modified to assign the join operation for remote execution. A result for the aggregation query may be generated according to the modified query plan and the result sent in response to the aggregation query.

公开(公告)号：US10713247B2

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

申请号：US15476273

申请日：2017-03-31

Applicant: Amazon Technologies, Inc.

Inventor： Michail Petropoulos ,  Ippokratis Pandis

IPC: G06F16/2453 ,  G06F16/33 ,  G06F16/2458

Abstract: Queries received at a query engine may be executed for structured data and not-structured data. A query execution plan may be generated for the query that includes stateless operations to apply the query to the not-structured data at remote query processing engines. The remote query processing engines may perform the stateless operations and return results to the query engine. The query engine may generate a result for the query based on the results received from the remote query engine as well as results determined as part of applying the query to structured data. The result to the query may be returned.

公开(公告)号：US12222908B2

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

申请号：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 ,  G06F16/23

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.