The Research And Implementation Of The Method Used To Detect SQL Server Information Sources Based On TLog

How to integrate information real-timely and effectively from diverseinformation sources becomes more and more important at information explosive times.Data integration technique is an efficient way to solve this problem.Data integration system includes monitoring intelligent agent and integrator. Thefirst thing, the monitoring intelligent agent must do, is effective capturing the changesmade to SQL Server data sources. There are a number of methods to capture changeddata of information source. TLog(Transaction Log) file analyzing is one of the mosteffective methods. The method is studied and implemented in this paper.Through reading and analyzing the TLog file of SQL Server database, we realizethe process of effectively capturing the changes made to SQL Server data sources.Our study includes the following items:Firstly, we analyze both the principle and the structure of TLog file.Secondly, we analyze the method of reading TLog.Thirdly, through expatiating the form of internal data storage of table and thestructure of data page, we analyze all kinds of TLOg in order to capture changed data.