公开(公告)号：US11609910B1

公开(公告)日：2023-03-21

申请号：US17118408

申请日：2020-12-10

Applicant: Amazon Technologies, Inc.

Inventor： Yannis Papakonstantinou ,  Vuk Ercegovac ,  Gaurav Saxena ,  Balakrishnan Narayanaswamy ,  Enrico Siragusa ,  Mario Guerriero

IPC: G06F16/00 ,  G06F16/2453 ,  G06F16/23

Abstract: Materialized views for a database system may be automatically refreshed according to performance benefits. Materialized views may be ordered according to determined performance benefits for the materialized views indicating the performance benefit obtained when a materialized view is used to perform a query at the database system. Materialized views may be selected for refresh operations according to the ordering based on a capacity of the database system to perform refresh operations.

公开(公告)号：US11657069B1

公开(公告)日：2023-05-23

申请号：US17105214

申请日：2020-11-25

Applicant: Amazon Technologies, Inc.

Inventor： Balakrishnan Narayanaswamy ,  Gokul Soundararajan ,  Jiayuan Chen ,  Yannis Papakonstantinou ,  Vuk Ercegovac ,  George Constantin Caragea ,  Sriram Krishnamurthy ,  Nikolaos Koulouris

IPC: G06F16/28 ,  G06F16/24 ,  G06F16/2458 ,  G06N20/00 ,  G06F16/2453 ,  G06F8/41

CPC classification number: G06F16/283 ,  G06F8/447 ,  G06F16/2465 ,  G06F16/2471 ,  G06F16/24535 ,  G06F16/24542 ,  G06N20/00

Abstract: A database system may use a machine learning model creation system to create a machine learning model from data stored in the database system responsive to a request from a client. The database system may obtain an executable version of the machine learning model, based on an uncompiled hardware agnostic version of the machine learning model, according to the hardware configuration of one or more computing resources selected by the database system to perform requests to the database system that invoke the machine learning model to generate predictions.

公开(公告)号：US11550787B1

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

申请号：US17118307

申请日：2020-12-10

Applicant: Amazon Technologies, Inc.

Inventor： Andre Hernich ,  Vuk Ercegovac ,  Gaurav Saxena ,  Panagiotis Parchas ,  Yannis Papakonstantinou ,  Balakrishnan Narayanaswamy ,  Enrico Siragusa

IPC: G06F16/2453 ,  G06F16/2455

Abstract: Match rules for rewriting queries to use materialized views may be dynamically generated by a database system. A database system may generate rules that indicate whether a given query can use a materialized view and how to rewrite the given query to use the materialized view. A query may be received and the rules may be applied to the query to determine that the query can use the materialized view and to rewrite the query to use the materialized view. The rewritten query can then be executed.

公开(公告)号：US11243956B1

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

申请号：US16508206

申请日：2019-07-10

Applicant: Amazon Technologies, Inc.

Inventor： Yannis Papakonstantinou ,  Vuk Ercegovac

IPC: G06F16/2455 ,  G06F16/23 ,  G06F16/22 ,  G06F16/21

Abstract: Databases may enforce foreign key constraints for efficient materialized view updates. A materialized view may be created for a database. Updates to the database may be received and performed according to a foreign key constraint enforced with respect to the updates. An update to the materialized view may be performed to make the materialized view consistent with the updates to the database. Performance of a join operation to update the materialized view that would return a result violating the foreign key constraint may be excluded from the update to the materialized view.

公开(公告)号：US11868347B1

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

申请号：US16698843

申请日：2019-11-27

Applicant: Amazon Technologies, Inc.

Inventor： Yannis Papakonstantinou ,  Balakrishnan Narayanaswamy ,  Christos Faloutsos ,  Vuk Ercegovac

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

CPC classification number: G06F16/24534 ,  G06F16/162 ,  G06F16/2282 ,  G06F16/2393 ,  G06F16/2455

Abstract: Queries that reference materialized views may be rewritten to compensate for stale materialized views. A query may be received that references a materialized view. A determination may be made as to whether the materialized view is stale. For a stale materialized view, the query may be rewritten to generate a query plan that obtains changes made to base tables for the materialized view not included in the stale materialized view and considers the change(s) when generating a result for the query from the materialized view. The rewritten query may then be performed to provide a result as if the materialized view were up-to-date.

公开(公告)号：US11841848B2

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

申请号：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

CPC classification number: G06F16/2393 ,  G06F16/2282 ,  G06F16/2445

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.

公开(公告)号：US11636124B1

公开(公告)日：2023-04-25

申请号：US17105201

申请日：2020-11-25

Applicant: Amazon Technologies, Inc.

Inventor： Balakrishnan Narayanaswamy ,  Gokul Soundararajan ,  Jiayuan Chen ,  Yannis Papakonstantinou ,  Vuk Ercegovac ,  George Constantin Caragea ,  Sriram Krishnamurthy ,  Nikolaos Koulouris

IPC: G06F16/00 ,  G06F16/2458 ,  G06F16/2453 ,  G06K9/62 ,  G06N20/00 ,  G06F16/28

Abstract: A database system may include a machine learning model which may be used to perform various data analytics for data stored in the database system. In response to a request to invoke the machine learning model to generate a prediction from data stored in the database system, the database system may perform one or more optimization operations, as part of a query plan, to prepare the data to make it suitable for use by the machine learning model.

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

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