发明申请
US20050235001A1 Method and apparatus for refreshing materialized views 审中-公开
刷新物化视图的方法和装置

  • 专利标题: Method and apparatus for refreshing materialized views
  • 专利标题(中): 刷新物化视图的方法和装置
  • 申请号: US10813843
    申请日: 2004-03-31
  • 公开(公告)号: US20050235001A1
    公开(公告)日: 2005-10-20
  • 发明人: Nitzan PelegYuval Sherman
  • 申请人: Nitzan PelegYuval Sherman
  • 主分类号: G06F7/00
  • IPC分类号: G06F7/00 G06F17/30
Method and apparatus for refreshing materialized views
摘要:
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.
信息查询
0/0