公开(公告)号：US06546402B1

公开(公告)日：2003-04-08

申请号：US09586809

申请日：2000-06-05

申请人： Kevin Scott Beyer ,  Roberta Jo Cochrane ,  Bruce Gilbert Lindsay ,  Kenneth Mark Salem

发明人： Kevin Scott Beyer ,  Roberta Jo Cochrane ,  Bruce Gilbert Lindsay ,  Kenneth Mark Salem

IPC分类号： G06F1730

CPC分类号： G06F17/30457 ,  G06F17/30383 ,  G06F17/30451 ,  Y10S707/954 ,  Y10S707/99952

摘要： A method and system for refreshing materialized join views includes asynchronously evaluating changes to the base tables, i.e., evaluating changes for an intended time tintended at an evaluation time teval that is later than the intended time. Changes made to the base table between the intended time tintended and evaluation time teval are recursively compensated for. The results of the evaluating and compensating are then applied to the materialized view to refresh the view.

摘要翻译： 用于刷新物化连接视图的方法和系统包括异步地评估对基表的更改，即评估在比预期时间晚的评估时间teval所期望的期望时间的改变。 递归地补偿预期时间和计时时间之间对基准表的变化。 然后将评估和补偿的结果应用于物化视图以刷新视图。