US 2014/0280028 A1 · SELECTIVE MATERIALIZED VIEW REFRESH

Abstract

Techniques are provided for selectively refreshing a materialized view. A portion of a materialized view is refreshed (or updated) while other portions of the materialized view are not refreshed. Thus, the other portions of the materialized view may contain “stale” data that does not accurately reflect current data in the base table(s) upon which the materialized view is based. In one technique, a user indicates the portion of the materialized view that is to be refreshed. In another technique, a user indicates a plurality of portions of a materialized view and it is automatically determined which portion should be refreshed first. Change data that indicates information about changes made to different portions of one or more base tables and/or read data that indicates information about reads to different portions of the materialized view may be taken into account to determine which portion of a materialized view to refresh.

Claims20

Dependent claims

One or more storage media storing instructions which, when executed by one or more processors, cause:

determining to update a materialized view that comprises a plurality of portions that includes a first portion and a second portion that is different than the first portion;
determining that the first portion and the second portion each corresponds to respective one or more portions, of one or more base tables that are associated with the materialized view, that include changes that are not yet reflected in the materialized view;
in response to determining to update the materialized view, updating the first portion of the materialized view without updating the second portion of the materialized view.

Dependencies are inferred from the claim text.

Selective materialized view refresh

Life of this patent

Selective materialized view refresh

Life of this patent

Abstract

Claims20