会员体验
专利管家(专利管理)
工作空间(专利管理)
风险监控(情报监控)
数据分析(专利分析)
侵权分析(诉讼无效)
联系我们
交流群
官方交流:
QQ群: 891211   
微信请扫码    >>>
现在联系顾问~
热词
    • 4. 发明授权
    • System and method for discriminatory replaying of log files during tablespace recovery in a database management system
    • 在数据库管理系统中的表空间恢复期间,用于区分性地重播日志文件的系统和方法
    • US07099897B2
    • 2006-08-29
    • US10425804
    • 2003-04-29
    • Matthew Albert HurasDale Murray McInnisEffi OfarMichael Jeffrey WinerRoger LQ. Zheng
    • Matthew Albert HurasDale Murray McInnisEffi OfarMichael Jeffrey WinerRoger LQ. Zheng
    • G06F17/30
    • G06F17/30368Y10S707/99953
    • A system and an associated method selectively process log files for enhancing performance of tablespace recovery by processing only those log files required, and for selecting which log file to process during recovery for both redo and rollback phases of recovery. The system and method skip the processing of log files that do not contain records of interest for the tablespace being recovered and determines whether a log file contains anything that needs to be played, in particular for the recovery of a subsystem in the database, such as a tablespace. Pre processing of the log files is not done, rather including tablespace ID correlated with log file ID information is collected while the log files are created. The cross-correlated information is used during tablespace recovery to selectively determine which of the log files to process. Some log files may be skipped in cases where not all of the database system is being recovered. A sub set of the database can be recovered, such as a tablespace, and which log files to process is determined based on a lock instruction.
    • 系统和相关方法通过仅处理所需的日志文件,并选择在恢复期间进行恢复时要处理的日志文件来选择性地处理日志文件以增强表空间恢复的性能。 系统和方法跳过不包含要恢复的表空间的感兴趣记录的日志文件的处理,并确定日志文件是否包含任何需要播放的内容,特别是用于恢复数据库中的子系统,例如 一个表空间。 日志文件的预处理未完成,而在创建日志文件时收集与日志文件ID信息相关的表空间ID。 在表空间恢复期间使用交叉相关信息来选择性地确定要处理哪些日志文件。 在没有全部数据库系统正在恢复的情况下,可能会跳过某些日志文件。 可以恢复数据库的子集,例如表空间,以及基于锁定指令确定要处理哪些日志文件。