Invention Grant
- Patent Title: Automatically refreshing materialized views according to performance benefit
-
Application No.: US17118408Application Date: 2020-12-10
-
Publication No.: US11609910B1Publication Date: 2023-03-21
- Inventor: Yannis Papakonstantinou , Vuk Ercegovac , Gaurav Saxena , Balakrishnan Narayanaswamy , Enrico Siragusa , Mario Guerriero
- Applicant: Amazon Technologies, Inc.
- Applicant Address: US WA Seattle
- Assignee: Amazon Technologies, Inc.
- Current Assignee: Amazon Technologies, Inc.
- Current Assignee Address: US WA Seattle
- Agency: Kowert, Hood, Munyon, Rankin & Goetzel, P.C.
- Agent S. Scott Foster
- Main IPC: G06F16/00
- 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.
Information query
