Systems and methods for automated maintenance and repair of database and file systems
    1.
    发明授权
    Systems and methods for automated maintenance and repair of database and file systems 有权
    用于数据库和文件系统的自动维护和修复的系统和方法

    公开(公告)号:US07143120B2

    公开(公告)日:2006-11-28

    申请号:US10837932

    申请日:2004-05-03

    IPC分类号: G06F17/30 G06F11/07

    摘要: The present invention relates generally to database and file system management and, more particularly, to automatic database and file system maintenance and repair to ensure data reliability. Various aspects of the present invention relate to responding and correcting data corruptions at a data page level for all data page types, as well as to recovery (including rebuild or restore operations) for various scenarios including, without limitation, index page corruptions (clustered and non-clustered), data page corruptions, and page corruptions in the log file.

    摘要翻译: 本发明一般涉及数据库和文件系统管理,更具体地涉及自动数据库和文件系统的维护和修复,以确保数据的可靠性。 本发明的各个方面涉及响应和纠正针对所有数据页面类型的数据页级别的数据损坏,以及针对各种场景的恢复(包括重建或恢复操作),包括但不限于索引页损坏(聚集和 非群集),数据页损坏和日志文件中的页面损坏。

    Systems and methods for automatic maintenance and repair of enitites in a data model
    3.
    发明授权
    Systems and methods for automatic maintenance and repair of enitites in a data model 有权
    在数据模型中自动维护和修复enitites的系统和方法

    公开(公告)号:US07366740B2

    公开(公告)日:2008-04-29

    申请号:US10903187

    申请日:2004-07-30

    IPC分类号: G06F17/30 G06F7/00

    摘要: The present invention is directed a logical consistency checker (LCC) working alone or in conjunction with a physical consistency checker (PCC) and/or a data reliability system (DRS) for a database files system of a hardware/software interface system. Logical data correction pertains to logical data corruptions for entities (e.g., items, extensions, and/or relationships in an item-based operating system, where an item-based operating system is one example of an item-based hardware/software interface system). In this regard, a LCC analyses and corrects logical damage to entities representatively stored in the data store in order to ensure that all such entities in said data store are both consistent and conform to the data model rules.

    摘要翻译: 本发明涉及一种单独或与硬件/软件接口系统的数据库文件系统的物理一致性检查器(PCC)和/或数据可靠性系统(DRS)一起工作的逻辑一致性检验器(LCC)。 逻辑数据校正涉及实体的逻辑数据损坏(例如,基于项目的操作系统中的项目,扩展和/或关系,其中基于项的操作系统是基于项目的硬件/软件接口系统的一个示例) 。 在这方面,LCC分析并纠正代表性地存储在数据存储中的实体的逻辑损害,以便确保所述数据存储中的所有这些实体都是一致的并且符合数据模型规则。

    Page recovery using volume snapshots and logs
    4.
    发明授权
    Page recovery using volume snapshots and logs 有权
    使用卷快照和日志进行页面恢复

    公开(公告)号:US07814057B2

    公开(公告)日:2010-10-12

    申请号:US11099021

    申请日:2005-04-05

    IPC分类号: G06F7/00

    摘要: Systems and methods are disclosed that facilitate providing page-level database restore functionality upon detection of a corruption event. Updates to a data page in a database can trigger generation of a snapshot of the data page, and an update log can be maintained that stores information related to page updates. Subsequent snapshots can be generated at predetermined intervals and can trigger truncation of a log segment and initiation of a new log segment. Upon detection of page corruption, a most-recent uncorrupt snapshot of the corrupt page can be identified, copied to the location of the corrupt page in the database, and modified according to the log segment associated with the uncorrupt snapshot to make the page current as of the corrupting event, all of which can be performed to restore the database without having to take the database offline.

    摘要翻译: 公开了在检测到腐败事件时便于提供页面级数据库恢复功能的系统和方法。 对数据库中的数据页的更新可以触发数据页快照的生成,并且可以维护存储与页面更新相关的信息的更新日志。 随后的快照可以以预定的间隔生成并且可以触发日志段的截断和新的日志段的启动。 在检测到页面损坏时,可以识别损坏的页面的最新的不破坏的快照,将其复制到数据库中的损坏页面的位置,并根据与非破坏快照关联的日志段进行修改,以使页面当前为 的破坏事件,所有这些都可以执行以恢复数据库,而不必使数据库脱机。