发明申请
US20050102326A1 Method and apparatus for performing conflict resolution in database logging
审中-公开
在数据库记录中执行冲突解决的方法和装置
- 专利标题: Method and apparatus for performing conflict resolution in database logging
- 专利标题(中): 在数据库记录中执行冲突解决的方法和装置
-
申请号: US10691175申请日: 2003-10-22
-
公开(公告)号: US20050102326A1公开(公告)日: 2005-05-12
- 发明人: Nitzan Peleg , Edward Bortnikov , Dror Zernik
- 申请人: Nitzan Peleg , Edward Bortnikov , Dror Zernik
- 主分类号: G06F17/30
- IPC分类号: G06F17/30
摘要:
The disclosed embodiments relate to a system and method for performing conflict resolution when refreshing a materialized view. The system may comprise a logging mechanism that maintains a refresh log, the refresh log may contain a first range and a second range that at least partially overlap, the first range and the second range each having a timestamp associated therewith. The system may also include a refresh manager that resolves conflicts between the first range and the second range that at least partially overlap by selecting portions of the first range and the second range that have the more recent timestamp and applying the selected portions of the first range and the second range to the materialized view. In another embodiment, the system may comprise a logging mechanism that maintains a refresh log, the refresh log containing a range and a single-row entry, the range and the single row entry each having a timestamp associated therewith. The system may also include a refresh manager that resolves conflicts between the range and the single-row entry by ignoring the single-row entry if the single-row entry is part of the range and if the single-row entry has the more recent timestamp and by applying the single-row entry to the materialized view if the single-row entry is not part of the range or if the range has the more recent timestamp.
信息查询