Pre-image logging for database recovery
    12.
    发明申请
    Pre-image logging for database recovery 有权
    用于数据库恢复的映像前记录

    公开(公告)号:US20070005664A1

    公开(公告)日:2007-01-04

    申请号:US11171746

    申请日:2005-06-30

    IPC分类号: G06F17/30

    摘要: In order to provide recovery for a database stored on storage not meeting the WAL protocol requirements, for example, storage including a temporary cache and a second storage (e.g. an IDE disk with a temporary cache and a hard disk), a log is created including, for each changed page, a pre-image of the page before changes were effected. The log also includes one or more change log records logging changes made to the page. Periodic checkpoints occur in which the cached pages are flushed to the disk. Recovery proceeds with a redo pass through the active log and then with an undo pass, undoing any transactions that have not been committed.

    摘要翻译: 为了为存储在不符合WAL协议要求的存储器上的数据库提供恢复,例如,包括临时缓存和第二存储(例如,具有临时高速缓存和硬盘的IDE磁盘)的存储,创建日志,包括 对于每个更改的页面,在进行更改之前页面的前图像。 日志还包括记录对页面所做更改的一个或多个更改日志记录。 发生定期检查点,其中缓存的页面被刷新到磁盘。 恢复进行重做通过活动日志,然后使用撤消通行,撤消任何尚未提交的事务。