发明名称 |
Method and system for incremental database maintenance |
摘要 |
The present invention is a method and system for incrementally maintaining a database having at least one materialized view based on at least one table. When changes to the table are received, a change table based on the received changes is generated. The generated change table is propagated upwards to form a higher-level change table and the materialized view is updated by applying the higher-level change table to the materialized view using a refresh operation. In one aspect, the change table includes a plurality of tuples representing the changes and the materialized view includes a plurality of tuples. The refresh operation has two parameters, a join condition and an update function specification. The materialized view is updated by finding all tuples in the materialized view that match the tuple in the change table, using the join condition, for each tuple in the change table and updating each found tuple in the materialized view by performing operations indicated by the update function specification.
|
申请公布号 |
US6484159(B1) |
申请公布日期 |
2002.11.19 |
申请号 |
US19990315161 |
申请日期 |
1999.05.20 |
申请人 |
AT&T CORP.;SAVERA SYSTEMS, INC. |
发明人 |
MUMICK INDERPAL SINGH;GUPTA HIMANSHU |
分类号 |
G06F17/30;(IPC1-7):G06F17/30 |
主分类号 |
G06F17/30 |
代理机构 |
|
代理人 |
|
主权项 |
|
地址 |
|