公开(公告)号：US20140280028A1

公开(公告)日：2014-09-18

申请号：US13826501

申请日：2013-03-14

Applicant: ORACLE INTERNATIONAL CORPORATION

Inventor： Luping Ding ,  Tsae-Feng Yu

IPC: G06F17/30

CPC classification number: G06F17/30457 ,  G06F17/30383

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.

Abstract translation: 提供了用于选择性刷新物化视图的技术。 物化视图的一部分被刷新（或更新），而实体化视图的其他部分不被刷新。 因此，物化视图的其他部分可以包含不准确地反映物化视图所基于的基表中的当前数据的“陈旧”数据。 在一种技术中，用户指示要刷新的物化视图的部分。 在另一技术中，用户指示物化视图的多个部分，并且自动确定应首先刷新哪个部分。 可以考虑将关于指示关于对一个或多个基表的不同部分所做的更改以及/或读取数据的数据进行更改的数据，该数据指示有关读取到物化视图的不同部分的读取的信息，以确定要刷新的实例化视图的哪个部分。

公开(公告)号：US10120899B2

公开(公告)日：2018-11-06

申请号：US13826501

申请日：2013-03-14

Applicant: Oracle International Corporation

Inventor： Luping Ding ,  Tsae-Feng Yu

IPC: G06F17/30

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.

公开(公告)号：US09454572B2

公开(公告)日：2016-09-27

申请号：US13826726

申请日：2013-03-14

Applicant: Oracle International Corporation

Inventor： Luping Ding ,  Tsae-Feng Yu ,  Andrew Witkowski

IPC: G06F17/30 ,  G06F7/00

CPC classification number: G06F17/30457 ,  G06F17/30383 ,  G06F17/30418

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.

Abstract translation: 提供了用于执行物化视图的刷新或更新而不修改实例化视图的技术。 这种刷新被称为不合适的物化视图刷新。 不合适的物化视图刷新涉及创建一个或多个外部表，数据将被插入到其中。 在刷新期间，即使物化视图包含“过时”数据，物化视图也可以访问查询处理。 插入后，一个或多个外部表格可访问以进行查询处理，并且将来的查询将针对一个或多个外部表格而不是物化视图。

公开(公告)号：US20140280029A1

公开(公告)日：2014-09-18

申请号：US13826726

申请日：2013-03-14

Applicant: ORACLE INTERNATIONAL CORPORATION

Inventor： Luping Ding ,  Tsae-Feng Yu ,  Andrew Witkowski

IPC: G06F17/30

CPC classification number: G06F17/30457 ,  G06F17/30383 ,  G06F17/30418

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.

Abstract translation: 提供了用于执行物化视图的刷新或更新而不修改实例化视图的技术。 这种刷新被称为不合适的物化视图刷新。 不合适的物化视图刷新涉及创建一个或多个外部表，数据将被插入到其中。 在刷新期间，即使物化视图包含“过时”数据，物化视图也可以访问查询处理。 插入后，一个或多个外部表格可访问以进行查询处理，并且将来的查询将针对一个或多个外部表格而不是物化视图。