System and method for purging database update image files after completion of associated transactions.
    1.
    发明公开
    System and method for purging database update image files after completion of associated transactions. 有权
    系统和方法删除数据库更新的图像文件的关联交易完成后,

    公开(公告)号:EP1093055A2

    公开(公告)日:2001-04-18

    申请号:EP00309068.5

    申请日:2000-10-16

    Abstract: A primary computer system has a database, application programs that modify the local database, and a transaction manager that stores audit records in a local image trail reflecting those application program modifications to the local database. In a remote backup system, a Receiver process receives audit records from the primary system. The audit records include audit update and audit backout records indicating database updates and database backouts generated by transactions executing on the primary system. The Receiver stores the audit update and audit backout records in one or more image trails. For each image trail there is an Updater process that applies to a backup database volume the database updates and backouts indicated by the audit update and audit backout records in the image trail. The remote backup system periodically executes a file purge procedure, which identifies the oldest transaction table from among the transaction tables in the last image trail file accessed for each of the image trails. Then, for each image trail, the file purge procedure accesses the image trial files in a predefined chronological order and for each accessed image trail file it compares a first set of newest transaction identifiers in the file's transaction table with a second set of oldest transaction identifiers in the identified oldest transaction table. The procedure purges the accessed image trail file only when all of the transaction identifiers in the first set are older than corresponding transaction identifiers in the second set.

    Abstract translation: 的主计算机系统有一个数据库,应用程序做了修改本地数据库,事务管理器在本地易扑反映这些应用程序修改本地数据库中没有存储的审计记录。 在远程备份系统中,接收机处理从主系统接收审核记录。审计记录包括审计更新和审计退出记录指示由主系统上执行的事务生成的数据库的更新和数据库重新出局,接收机存储该审计更新和审计 退出记录在一个或多个图像路径。 对于每一个图像线索有一个更新processthat适用于备份数据库卷数据库更新,并在图像跟踪审计更新和审计退出记录显示回奏。 远程备份系统周期性地执行一文件清洗过程,该过程从访问的针对每个图像的小径在负载易扑文件事务表中识别最旧的事务表。 然后,对于每个图像线索,文件吹扫程序访问在一个预定义的时间顺序和每个访问的易扑文件它比较第一组最新事务标识符的在文件的交易表与第二组最古老的事务标识符的图像审判文件 确定了最古老的交易表。 该程序清除被访问的易扑FILESONLY当所有第一组的事务标识符比在第二组对应的事务标识符老。

    System and method for purging database update image files after completion of associated transactions.
    2.
    发明授权
    System and method for purging database update image files after completion of associated transactions. 有权
    系统和方法删除数据库更新的图像文件的关联交易完成后,

    公开(公告)号:EP1093055B1

    公开(公告)日:2005-03-23

    申请号:EP00309068.5

    申请日:2000-10-16

    Abstract: A primary computer system has a database, application programs that modify the local database, and a transaction manager that stores audit records in a local image trail reflecting those application program modifications to the local database. In a remote backup system, a Receiver process receives audit records from the primary system. The audit records include audit update and audit backout records indicating database updates and database backouts generated by transactions executing on the primary system. The Receiver stores the audit update and audit backout records in one or more image trails. For each image trail there is an Updater process that applies to a backup database volume the database updates and backouts indicated by the audit update and audit backout records in the image trail. The remote backup system periodically executes a file purge procedure, which identifies the oldest transaction table from among the transaction tables in the last image trail file accessed for each of the image trails. Then, for each image trail, the file purge procedure accesses the image trial files in a predefined chronological order and for each accessed image trail file it compares a first set of newest transaction identifiers in the file's transaction table with a second set of oldest transaction identifiers in the identified oldest transaction table. The procedure purges the accessed image trail file only when all of the transaction identifiers in the first set are older than corresponding transaction identifiers in the second set.

    System and method for purging database update image files after completion of associated transactions.
    3.
    发明公开
    System and method for purging database update image files after completion of associated transactions. 有权
    系统和方法删除数据库更新的图像文件的关联交易完成后,

    公开(公告)号:EP1093055A3

    公开(公告)日:2002-04-03

    申请号:EP00309068.5

    申请日:2000-10-16

    Abstract: A primary computer system has a database, application programs that modify the local database, and a transaction manager that stores audit records in a local image trail reflecting those application program modifications to the local database. In a remote backup system, a Receiver process receives audit records from the primary system. The audit records include audit update and audit backout records indicating database updates and database backouts generated by transactions executing on the primary system. The Receiver stores the audit update and audit backout records in one or more image trails. For each image trail there is an Updater process that applies to a backup database volume the database updates and backouts indicated by the audit update and audit backout records in the image trail. The remote backup system periodically executes a file purge procedure, which identifies the oldest transaction table from among the transaction tables in the last image trail file accessed for each of the image trails. Then, for each image trail, the file purge procedure accesses the image trial files in a predefined chronological order and for each accessed image trail file it compares a first set of newest transaction identifiers in the file's transaction table with a second set of oldest transaction identifiers in the identified oldest transaction table. The procedure purges the accessed image trail file only when all of the transaction identifiers in the first set are older than corresponding transaction identifiers in the second set.

Patent Agency Ranking