DBMS backup without suspending updates and corresponding recovery using separately stored log and data files
    1.
    发明授权
    DBMS backup without suspending updates and corresponding recovery using separately stored log and data files 有权
    DBMS备份而不会使用单独存储的日志和数据文件挂起更新和相应的恢复

    公开(公告)号:US07412460B2

    公开(公告)日:2008-08-12

    申请号:US10600221

    申请日:2003-06-19

    IPC分类号: G06F7/00 G06F17/00

    摘要: A method for performing a system level backup of a log-ahead database management system (DBMS) without suspending updates by application programs is described. The DBMS comprises a database mainline system, a backup utility and a restore utility. The data and log records are stored on separate storage volumes. Log records are written to identify objects that require special handling during the point-in-time recovery. The database engine operates normally during a backup except for suspending actions that would alter the file system catalog or write updates across a storage volume boundary; and by freezing the REDO log point in its checkpoint information. The backup utility copies the data volumes first and optionally the log volumes second while updates are allowed. The resulting inconsistencies are resolved either during a DBMS restart or during a point-in-time (PIT) recovery performed by the restore utility.

    摘要翻译: 描述了用于执行日志提前数据库管理系统(DBMS)的系统级备份而不中止应用程序的更新的方法。 DBMS包括数据库主线系统,备份实用程序和恢复实用程序。 数据和日志记录存储在不同的存储卷上。 日志记录被写入以识别在时间点恢复期间需要特殊处理的对象。 数据库引擎在备份期间正常运行,除了挂起将会更改文件系统目录或在存储卷边界上写入更新的操作; 并通过在其检查点信息中冻结REDO日志点。 备份实用程序首先复制数据卷,并可选地备份日志卷,同时允许更新。 在DBMS重新启动期间或在恢复实用程序执行的时间点(PIT)恢复期间,解决了所产生的不一致。

    Bufferpool coherency for identifying and retrieving versions of workfile
data using a producing DBMS and a consuming DBMS
    2.
    发明授权
    Bufferpool coherency for identifying and retrieving versions of workfile data using a producing DBMS and a consuming DBMS 失效
    缓冲池一致性,用于使用生成的DBMS和消耗的DBMS来识别和检索工作文件数据的版本

    公开(公告)号:US5692182A

    公开(公告)日:1997-11-25

    申请号:US539411

    申请日:1995-10-05

    IPC分类号: G06F17/30

    摘要: A system and method for a computer based system having one or more consuming DBMSs and one or more producing DBMSs such that the producing DBMSs produce workfiles for the consuming DBMSs. A producing DBMS uniquely identifies the bufferpool pages comprising a workfile, uniquely identifies the workfile, and flushes only the bufferpool pages corresponding to the workfile to a storage device. The producing DBMS further notifies the consuming DBMS that the workfile is available and receives a reply from the consuming DBMS indicating that the consuming device retrieved the data from the storage device. The consuming device receives notification from the producing DBMS, retrieves the workfile, and replies to the producing DBMS that it has retrieved the workfile.

    摘要翻译: 一种用于基于计算机的系统的系统和方法,其具有一个或多个消耗DBMS和一个或多个生成DBMS,使得生成DBMS产生用于消费DBMS的工作文件。 生产DBMS唯一地标识包括工作文件的缓冲池页面,唯一地标识工作文件,并且仅将与工作文件对应的缓冲池页面刷新到存储设备。 生产DBMS还通知消费DBMS工作文件可用并且从消费DBMS接收到指示消费设备从存储设备检索数据的应答。 消费设备从生产DBMS接收通知,检索工作文件,并回复生产DBMS已检索工作文件。

    Partial page write detection for a shared cache using a bit pattern
written at the beginning and end of each page
    4.
    发明授权
    Partial page write detection for a shared cache using a bit pattern written at the beginning and end of each page 失效
    使用在每个页面的开头和结尾写入的位模式,对共享高速缓存进行局部页写入检测

    公开(公告)号:US5455942A

    公开(公告)日:1995-10-03

    申请号:US955076

    申请日:1992-10-01

    摘要: Disk check bits refer to bit patterns stored in particular bytes of a page which are used to detect errors in writing the page to storage. Every time a page is obtained from storage, changed from the version retained in storage, and written back to storage, the check bit pattern on the changed page is altered to be different from the bit pattern on the storage page. This is because the changed page overwrites the stored page. The invention provides a method for managing the check bits in a multi-DBMS system employing a high-speed shared electronic store as a store-in cache for all pages obtained from disk storage. When a page is first obtained from disk storage by a DBMS and changed, check bit information for the page is maintained in a directory of the storing cache which indicates what the patterns are for the version of the page in the disk storage. All pages which are modified are stored in the store-in cache and are only returned to disk storage from the cache. Therefore, when a page is to be written to disk storage, the DBMS writing the page to storage processes the check bits on the page itself, changing them as required based on the check bit information stored in the directory for the page.

    摘要翻译: 磁盘检查位是指存储在页面的特定字节中的位模式,用于检测将页面写入存储器时的错误。 每次从存储中获取页面时,从存储中保留的版本中更改页面,并将其写回存储器,更改页面上的校验位模式将更改为与存储页面上的位模式不同。 这是因为更改的页面将覆盖存储的页面。 本发明提供一种用于管理采用高速共享电子商店的多DBMS系统中的校验位的方法,作为从磁盘存储器获得的所有页面的存储高速缓存。 当页首首先由DBMS从磁盘存储器中获取并更改时,检查页面的位信息是否保存在存储缓存的目录中,该目录指示磁盘存储器中页面版本的模式。 被修改的所有页面都存储在存储缓存中,只能从高速缓存返回到磁盘存储。 因此,当将页面写入磁盘存储器时,将页面写入存储器的DBMS处理页面本身的校验位,根据存储在页面目录中的校验位信息根据需要进行改变。