Out-of-place materialized view refresh
AssigneeOracle International Corporation
InventorsLuping Ding, Tsae-Feng Yu, Andrew Witkowski
Life of this patent
Estimating the term…
Abstract
Techniques are provided for performing a refresh or update of a materialized view without modifying the materialized view. Such a refresh is referred to as an out-of-place materialized view refresh. An out-of-place materialized view refresh involves creating one or more outside tables into which data will be inserted. During the refresh, the materialized view may be accessible for query processing, even though the materialized view contains “stale” data. After the insertion, the one or more outside tables are made accessible for query processing and future queries will target the one or more outside tables instead of the materialized view.
Claims22
A method comprising:
- determining to update a materialized view;
- in response to determining to update the materialized view:
- creating a database object that is separate from the materialized view;
- generating data for insertion into the database object;
- inserting the data into the database object;
- causing the database object to be accessible for query processing in place of the materialized view;
- wherein the method is performed by one or more computing devices.
One or more storage media storing instructions which, when executed by one or more processors, cause:
- determining to update a materialized view;
- in response to determining to update the materialized view:
- creating a database object that is separate from the materialized view;
- generating data for insertion into the database object;
- inserting the data into the database object;
- causing the database object to be accessible for query processing in place of the materialized view.
Dependencies are inferred from the claim text.