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

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

公开(公告)号：US20220300492A1

公开(公告)日：2022-09-22

申请号：US17805676

申请日：2022-06-06

Applicant: Amazon Technologies, Inc.

Inventor： Yannis Papakonstantinou ,  Vuk Ercegovac ,  Andre Hernich ,  Enrico Siragusa ,  Gaurav Saxena

IPC: G06F16/23 ,  G06F16/22 ,  G06F16/242

Abstract: Stored procedures are generated to perform incremental updates to a materialized view for a database. When a request to create a materialized view is received, one or more internal tables are created from the database. A stored procedure is generated that when executed will update the materialized view of the database. The stored procedure may obtain changes to the database that were not included in the internal tables and update the internal tables to include the obtained changes. The stored procedure may be performed automatically and in response to requests.

公开(公告)号：US11354304B1

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

申请号：US16698827

申请日：2019-11-27

Applicant: Amazon Technologies, Inc.

Inventor： Yannis Papakonstantinou ,  Vuk Ercegovac ,  Andre Hernich ,  Enrico Siragusa ,  Gaurav Saxena

IPC: G06F16/23 ,  G06F16/22 ,  G06F16/242

Abstract: Stored procedures are generated to perform incremental updates to a materialized view for a database. When a request to create a materialized view is received, one or more internal tables are created from the database. A stored procedure is generated that when executed will update the materialized view of the database. The stored procedure may obtain changes to the database that were not included in the internal tables and update the internal tables to include the obtained changes. The stored procedure may be performed automatically and in response to requests.

公开(公告)号：US11327970B1

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

申请号：US16364055

申请日：2019-03-25

Applicant: Amazon Technologies, Inc.

Inventor： Mingda Li ,  Gaurav Saxena ,  Naresh Chainani

IPC: G06F16/2453 ,  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.

公开(公告)号：US11256684B1

公开(公告)日：2022-02-22

申请号：US16698823

申请日：2019-11-27

Applicant: Amazon Technologies, Inc.

Inventor： Yannis Papakonstantinou ,  Vuk Ercegovac ,  Andre Hernich ,  Enrico Siragusa ,  Gaurav Saxena

IPC: G06F16/23 ,  G06F16/22 ,  G06F16/242

Abstract: Algebraic operations are applied to change result sets for source tables to update a materialized view of a database incrementally. A procedure is determined for updating a materialized view that generates result sets for changes to source tables for a materialized view. The procedure performs one or more operations to update the materialized view using the result sets as operands in a relational algebra operator in the procedure to include the changes in the result sets in the materialized view.

公开(公告)号：US10313710B1

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

申请号：US15664246

申请日：2017-07-31

Applicant: Amazon Technologies, Inc.

Inventor： Kent Haakan Karlsson ,  Gaurav Saxena

IPC: H04N7/173 ,  H04N21/234 ,  H04N21/8547 ,  H04N21/6379 ,  H04N21/2187

Abstract: Techniques are described for synchronizing encoding processes between encoders. Timestamps are compared between encoders such that offsets can be determined and used by encoders to encode fragments for the same segments of media content.