ScholarLens Back to search
2010•Microcomputer InformationRequires access

Research and application of transaction log mechanism based on SQL server

Zhe Chen

Open publisher page 0 citations

Abstract

This paper studies three kinds of transaction models and transaction logs implemented by SQL Server,and designs an algorithm which can detect data updates of database by processing transaction logs of SQL Server.The algorithm was applied to the data integration system.And the results of the application has proved that the algorithm is correct and effective.

About this research paper

What this paper is about

This paper studies three kinds of transaction models and transaction logs implemented by SQL Server,and designs an algorithm which can detect data updates of database by processing transaction logs of SQL Server.The algorithm was applied to the data integration system.And the results of the application has proved that the algorithm is correct and effective.

Why it matters

A significance statement is not available in the OpenAlex record.

Key contribution

A contribution statement is not available in the OpenAlex record.

Method / approach

Method details are not available in the OpenAlex metadata.

Main findings

Findings are not separately available in the OpenAlex metadata.

Limitations

Limitations are not available in the OpenAlex metadata.

Applications

Application details are not available in the OpenAlex metadata.

Available abstract

This paper studies three kinds of transaction models and transaction logs implemented by SQL Server,and designs an algorithm which can detect data updates of database by processing transaction logs of SQL Server.The algorithm was applied to the data integration system.And the results of the application has proved that the algorithm is correct and effective.

Key concepts: Computer science, Database transaction, Data Transformation Services, Database, Nested transaction, Log shipping, Transaction log, User-defined function

Related papers

Related paper 1Related paper 2Related paper 3
Back to paper searchBrowse research topicsOriginal source
Research and application of transaction log mechanism based on SQL server — Research Paper | ScholarLens