公开(公告)号：US20210165789A1

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

申请号：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 ,  G06F11/34

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

公开(公告)号：US11874828B2

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

申请号：US17466347

申请日：2021-09-03

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/242

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

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.

公开(公告)号：US11544286B2

公开(公告)日：2023-01-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.

公开(公告)号：US11308079B2

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

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

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.

公开(公告)号：US20220058187A1

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

申请号：US17466347

申请日：2021-09-03

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/242

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.

公开(公告)号：US11113273B2

公开(公告)日：2021-09-07

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

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.

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

公开(公告)号：US20220253433A1

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

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

公开(公告)号：US20220171759A1

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

申请号：US17362729

申请日：2021-06-29

Applicant: Amazon Technologies, Inc.

Inventor： Himanshu Jindal ,  Shivateja Reddy Ummenthala ,  Almann Tsutomu Goo ,  Yannis Papakonstantinou ,  Lewis Bruck ,  Tate Andrew Certain ,  Pulkit Maheshwari

IPC: G06F16/23

Abstract: Schema incompatibilities are generating views at target data stores are detected. A view definition may be received at a view management system that specifies data to obtain from source data stores and identifies a target data store to store the view. The view management system may identify an incompatibility between a schema for the data, specified in the view definition, with a type system for the target data store. The view management system may provide an indication of the incompatibility with the type system for the target data store.