发明申请
- 专利标题: Method and apparatus for refreshing materialized views
- 专利标题(中): 刷新物化视图的方法和装置
-
申请号: US10813843申请日: 2004-03-31
-
公开(公告)号: US20050235001A1公开(公告)日: 2005-10-20
- 发明人: Nitzan Peleg , Yuval Sherman
- 申请人: Nitzan Peleg , Yuval Sherman
- 主分类号: G06F7/00
- IPC分类号: G06F7/00 ; G06F17/30
摘要:
The disclosed embodiments relate to an apparatus for performing refresh operations. The apparatus comprises a base table having a first set of data entries, a materialized view having a second set of data entries that are associated with the first set of data entries in the base table. Further, a refresh log contains a set of changes that were made to the base table since the materialized view was last refreshed. A module is utilized to perform a refresh operation on the materialized view using the second set of data entries. The module is configured to access the refresh log and the materialized view, calculate delta values from the set of changes in the refresh log and the second set of data entries, apply the delta values to second set of data entries in the materialized view, and provide the delta values to a delta adaptation module for updating a second materialized view.
信息查询