公开(公告)号：US12210524B1

公开(公告)日：2025-01-28

申请号：US18067498

申请日：2022-12-16

Applicant: Amazon Technologies, Inc.

Inventor： Enrico Siragusa ,  Gaurav Saxena ,  Mario Guerriero ,  Christoforos Svingos

IPC: G06F16/2453 ,  G06F16/23

Abstract: A materialized view created from one or more shared producer tables in separate producer clusters may be stored in a consumer cluster. The materialized view May undergo faster a refresh using an incremental refresh by obtaining snapshots of the producer table and incrementally refreshing based on deltas obtained by the snapshot. The materialized view may undergo various checks to determine whether the materialized view in the consumer resource is refreshable or unrefreshable based on schema compatibility. The materialized view may undergo further checks to determine whether the materialized view in the consumer resource is available or unavailable for incremental refresh based on detection of schema/data rearrangement operations on the producer table.

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