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

公开(公告)号：US11036708B2

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

申请号：US16200600

申请日：2018-11-26

Applicant: Amazon Technologies, Inc.

Inventor： Tate Andrew Certain ,  Yannis Papakonstantinou ,  Allan Henry Vermeulen ,  Christopher Richard Jacques de Kadt

IPC: G06F16/22 ,  G06F16/18 ,  G06F16/2452

Abstract: A database management system receives a request to create an index for a virtual view of a database table. In response to the request, the database management system identifies relationships between the columns of the virtual view and columns of the database table. The database management system generates an index on the database table, where columns are included in the generated index based on the identified relationships and the definition of the virtual view. Queries of the virtual view are assisted by the generated index of the underlying table.

公开(公告)号：US20210165803A1

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

申请号：US16699547

申请日：2019-11-29

Applicant: Amazon Technologies, Inc.

Inventor： Rohan Deshpande ,  Yannis Papakonstantinou ,  Omer Ahmed Zaki ,  Karthik Gurumoorthy Subramanya Bharathy ,  Rajib Dugar ,  Shivateja Reddy Ummenthala

IPC: G06F16/26 ,  G06F16/23

Abstract: A materialized view created by a materialized view management platform may be replicated across many different target systems. The materialized view management platform allows users to specify different target systems. To create the materialized view in the different target systems, the materialized view management platform can translate the materialized view into different formats in order to store the materialized view in the different formats. Updates to the different instances of the materialized view are then made to keep the different materialized view formats in the different target systems up-to-date.

公开(公告)号：US20210165783A1

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

申请号：US16699512

申请日：2019-11-29

Applicant: Amazon Technologies, Inc.

Inventor： Rohan Deshpande ,  Yannis Papakonstantinou ,  Omer Ahmed Zaki ,  Karthik Gurumoorthy Subramanya Bharathy ,  Rajib Dugar ,  Shivateja Reddy Ummenthala

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

Abstract: Materialized views may be generated at a managed materialized view platform that accepts data streams as a source. When updating a materialized view with a data stream as a source, a stored portion of the stream is used to maintain a history of changes to be made. When a join operation needs to utilize the data stream source to determine an update to the materialized view, the data stream is preserved to complete the join and update the materialized view.

公开(公告)号：US20210165782A1

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

申请号：US16699486

申请日：2019-11-29

Applicant: Amazon Technologies, Inc.

Inventor： Rohan Deshpande ,  Yannis Papakonstantinou ,  Omer Ahmed Zaki ,  Karthik Gurumoorthy Subramanya Bharathy ,  Rajib Dugar ,  Shivateja Reddy Ummenthala

IPC: G06F16/23 ,  G06F16/242 ,  G06F16/21

Abstract: Managed materialized views may be generated from across heterogeneous data sources. A request to create a materialized view may be received and performed by a materialized view management platform, which may obtain and generate the materialized view from different data sources and store the materialized view in a target system. Changes to the data sources may be obtained at the materialized view management platform and updates to the materialized view may be determined. The materialized view in the target system may be updated.

公开(公告)号：US20240143576A1

公开(公告)日：2024-05-02

申请号：US18466718

申请日：2023-09-13

Applicant: Amazon Technologies, Inc.

Inventor： Yannis Papakonstantinou ,  Tate Andrew Certain

IPC: G06F16/23 ,  G06F16/242 ,  G06F16/25

CPC classification number: G06F16/2365 ,  G06F16/2448 ,  G06F16/254

Abstract: A new type system may be added to a type registry for a data processing service. A request to add the new type system may be received that describes the new type system for a data store. The new type system may be used to perform a data processing job that accesses the data store to obtain or store data as a source or target data store.

公开(公告)号：US11934389B2

公开(公告)日：2024-03-19

申请号：US17722224

申请日：2022-04-15

Applicant: Amazon Technologies, Inc.

Inventor： Rohan Deshpande ,  Yannis Papakonstantinou ,  Omer Ahmed Zaki ,  Karthik Gurumoorthy Subramanya Bharathy ,  Rajib Dugar ,  Shivateja Reddy Ummenthala

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

CPC classification number: G06F16/2393 ,  G06F16/219 ,  G06F16/2282 ,  G06F16/2456 ,  G06F16/24568

Abstract: Materialized views may be generated at a managed materialized view platform that accepts data streams as a source. When updating a materialized view with a data stream as a source, a stored portion of the stream is used to maintain a history of changes to be made. When a join operation needs to utilize the data stream source to determine an update to the materialized view, the data stream is preserved to complete the join and update the materialized view.

公开(公告)号：US11899659B2

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

申请号：US16699530

申请日：2019-11-29

Applicant: Amazon Technologies, Inc.

Inventor： Rohan Deshpande ,  Yannis Papakonstantinou ,  Omer Ahmed Zaki ,  Karthik Gurumoorthy Subramanya Bharathy ,  Rajib Dugar ,  Shivateja Reddy Ummenthala

IPC: G06F16/242 ,  G06F16/21 ,  G06F16/23 ,  G06F11/34

CPC classification number: G06F16/2445 ,  G06F11/3495 ,  G06F16/21 ,  G06F16/2393

Abstract: The maintenance of a materialized view created and managed by a materialized view management platform may be dynamically adjusted. The performance of updates to a materialized view are monitored to trigger different events to make adjustments to the performance of subsequent updates. The materialized view management platform can adequately scale to handle changes to data sources as inputs to the maintenance of the materialized view, as well as make other adjustments handle various changes in the capability of the target data store to receive updates to the materialized view (e.g., target data store outages).

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