Dissertation > Excellent graduate degree dissertation topics show

Research and Implementation of SQL Server Database Change Data Capture Based on Log Analysis

Author: ChenZhen
Tutor: LiuBo
School: Jinan University
Course: Applied Computer Technology
Keywords: transaction log SQL Server database change data capture partial rollback
CLC: TP311.13
Type: Master's thesis
Year: 2010
Downloads: 217
Quote: 3
Read: Download Dissertation

Abstract


Traditionally, Data Integration, Data Propagation, and ETL (extract, transform and load) processes run on a periodic basis (weekly, daily) and use a bulk data movement approach that moves and integrates the entire source data to a target data source. This approach is limited in its ability to deal with new trends and business requirements, some of which include continuous refreshing of a DW, near real-time business intelligence and operational data stores. Based on transaction log Change-Data-Capture (CDC) technology provides a solution to IT operational challenges and the new business models.This paper introduces the principle of transaction logs and database recovery techniques,proposes a change-data-capture method based on SQL Server database log analysis. By means of the asynchronous read transaction log, this method captures data changes.This thesis addresses the following issues:Firstly, avoid that the transaction logs not captured change data are truncated;Secondly, how to process compensation logs for partial transaction rollbacks;Thirdly, develop the right algorithm for the restart of capture process, and how to reduce restart time;Finally, to improve the efficiency of capture process.

Related Dissertations

  1. Analysis of Large Conveying Motor Build Database Software,TH222
  2. Teacher training platform for network design and implementation,TP311.52
  3. Corporate tender offer system design and implementation,TP311.52
  4. SME Sales Management System Design and Implementation,TP311.52
  5. Shanghai each sound Networks Personnel Management System Design and Implementation,TP311.52
  6. Yuhong区外经贸局Fixed Assets Management System Design and Implementation,TP311.52
  7. Design and implementation of online sales platforms tea,TP311.52
  8. The Design and Implementation of On-line Examination System Based on AJAX,TP311.52
  9. Based net hotel information management platform Design and Implementation,TP311.52
  10. The Design and Implementation of the real estate project management system,TP311.52
  11. Internet platform for the construction of art studio,TP311.52
  12. Tongliang power company Human Resource Management System Design and Implementation,TP311.52
  13. The Analysis and Design of the Material Warehouse Management Information System for Huaning Mineral Group,TP311.52
  14. Research of Data Synchronization Mechanism for Log Analysis Applied on the China LMTC Operation Platform,TP393.092
  15. Suining electronic document management system design and implementation,TP311.52
  16. Research of Data-oriented Integrated Application for SQL Server Log Analysis,TP311.13
  17. Study of the Real-time Embedded Database in Transmission Product,TP311.13
  18. Distributed parallel the database system DPSQL consistency mechanism research,TP311.13
  19. The Data Synchronization and Switch of Main Memory Database,TP311.13
  20. Restaurant Management System Research and Implementation of the mobile database data consistency,TP311.52

CLC: > Industrial Technology > Automation technology,computer technology > Computing technology,computer technology > Computer software > Program design,software engineering > Programming > Database theory and systems
© 2012 www.DissertationTopic.Net  Mobile