| With the rapid development of network technology and the increasing maturity of distributed computing, enterprise database applications are constantly toward a distributed, large-scale direction. However, because different enterprises or different departments of enterprises, according to their needs or because of historical or technical reasons at different times using database systems of different data models, resulting in the data synchronization of heterogeneous databases has become a bottleneck in enterprise management and development. As the diversity of practical applications, though many database systems provide database synchronization, but sometimes not well meet the application needs, so companies need to customize the database synchronization software. SQL Server database, AD (Active Directory) database together constitute ChinaLMTC Platform's personnel information database. However, the essential difference between the two databases, causing them to have problems in data synchronization. In this context, to address the data synchronization problem in ChinaLMTC platform, this paper presents a proposed solution.This paper mainly read analysis SQL Server database log and Windows messaging technology and complete it in SQL Server database and Active Directory database to achieve both accurate and efficient real-time database synchronization. Through the study the paper solve the problem that the update operation log extracted from the database buffer pool can not be recognized, and also address data inconsistencies of heterogeneous database in ChinaLMTC platforms. Based on log analysis solution for data synchronization faster and more accurate complete the data synchronization of two above-mentioned heterogeneous databases than the database vendor's synchronization solution between the database and synchronization technology. The system development environment is.NET 3.5 technology platform, using SQL Server 2005 database and Microsoft Visual Studio 2008 development tools.The first two chapters of this article give a brief overview of background and significance of the subject, research status, and log analysis of data related technologies and theoretical basis of synchronization. The related technologies include:DBCC LOG read analysis techniques, buffer pool technology, Active Directory Interface services technology, Windows messaging technology. The third chapter made a detailed analysis of the introduction of the log data synchronization theory and the practice. The last two chapters give a simple summary of operating results and test results for the theory applied to ChinaLMTC operating platform. |
PDF Full Text Request