基于日志分析的db2数据库更新检测方法的研究与实现mgvyrplb.docVIP

基于日志分析的DB2数据库更新检测方法的研究与实现 摘要 监视智能代理是数据集成系统环境中的一个重要组成部分。对其中的更新检测方法进行研究是使数据集成系统具有主动智能化性质的重要工作。通常一个有效的方法是对数据源进行无损外部改造,使改造后的信息源具有智能化持续信息支持的能力。 本文的主要工作是对提供了优秀事务日志恢复策略的DB2数据库的信息源进行研究,并在已经完成的数据库通用更新检测的框架下,通过从DB2数据库外部读取和分析其事务日志的方式来实现对其进行更新检测的过程。因而,本文的具体的研究工作包括下面几点: 1、对DB2数据库事务日志的原理及结构进行分析研究,为进一步的读取和分析工作提供基础。 2、根据DB2数据库事务日志的特性和更新检测的原理,提出针对DB2数据库的更新检测方法。 3、在以完成的数据库通用更新检测的框架下,依据DB2数据库更新检测的 特点,实现其更新检测过程。 4、在DB2事务日志更新检测方法具体实现过程,由于整体实现环境和具体读取需要的环境不同,给出解决方法并实现。 关键字:数据集成,事务日志,db2数据库,数据库更新检测。 Abstract Monitoring intelligent agent is an important portion of data integration system. It is important task to activate and intelligentize data integration system by researching the technique of updating detection in monitoring intelligent agent. Generally, an efficacious approach is to lossless reconstruct data source in exterior, which can bring intelligent and continued information support ability to data source. The present paper studies data sources of DB2 database in possession of excellent logs recover strategy. The present research realizes the course of updating detection by reading and analyzing DB2 database transaction log in the finished architectural framework of the database updating current outside detector. It includes the following items: Firstly, analyze both the principle and the structure of DB2 database transaction log, the analyzing is the basis of the task of reading and analyzing logs. Secondly, put forward the technique of updating detection of DB2 database according as the characteristic of its transaction log and the theory of updating detection Thirdly, realize the task of updating detection of DB2 database according as the special features of the technique in the architectural framework of the database updating current outside detector. Finally, an approach what resolve the conflict between the whole environment and the demand environment of reading logs is put forward and implemented during realizing the technique of upda