摘要
介绍了MSSQLServer2000的事务日志的工作原理及特点,详细描述了一种利用MSSQLServer2000数据库提供的DBCC命令作为日志读取的接口对数据库进行日志的读取和分析的方法,并根据此方法初步实现了一个MSSQLServer2000的日志分析器。此日志分析器能够把引起数据库状态变迁的数据库更新操作(Insert、Delete和Update)及相应数据分析出来,以便利于各种相关应用。
Work principle and characteristics of transaction log MS SQL Server 2000 are introduced, and a method of log read and log analysis of MS SQL Server 2000 is described with DBCC commands provided by MS SQL Server 2000 as log reading interface in detail, and finally a log analyzer of MS SQL Server 2000 is implementation based on this method. This log analyzer can get database update manipulation (Insert, Delete and Update) that can arose database state transition and their corresponding data for many relational applications.
出处
《计算机工程与设计》
CSCD
北大核心
2006年第19期3557-3560,共4页
Computer Engineering and Design
基金
广东省科技攻关基金项目(2003C101011)