Research Of Data-oriented Integrated Application For SQL Server Log Analysis

In today's information explosion,how to integrate the information to the client timely and efficiently from the distributed autonomous and heterogenous multiple remote sources is becoming more and more important.Data integration technology is to resolve this issue and put forward an effective way.Data integration system includes monitor and integrator.The leading task that the monitor should do is effective capturing the changes from data sources.There are a lot of methods to capture changed data of information sources.Transaction Log analyzing is one of the most effective methods.The method is studied and implemented in this paper.The main task of this paper is to study the information source of SQL Server. Through reading and analyzing the transaction log of SQL Server,we realize the process of effectively capturing the data changes from SQL Server data sources.Our study includes the following items:Firstly,SQL Server database transaction logs and the principles of the structureSecondly,analyse several logs of the SQL Server databaseThirdly,study the read manner of SQL Server transaction logFourthly,read and analyse the transaction log when turning on the replication serviceFinally,the application for SQL Server's log reading and analyzing in the data integrated system...