基于Web Service的數(shù)據(jù)庫(kù)同步系統(tǒng)的設(shè)計(jì)與實(shí)現(xiàn)

包括論文,設(shè)計(jì),論文字?jǐn)?shù):14089,頁數(shù):29

摘  要
結(jié)合當(dāng)前流行的Web Service和ADO.NET技術(shù)構(gòu)造了一個(gè)不受平臺(tái)限制的異構(gòu)數(shù)據(jù)庫(kù)同步系統(tǒng)。實(shí)現(xiàn)了處于Internet上的Sql Server2000向Oracle 的單向同步功能，能夠基于IP的安全身份驗(yàn)證功能,多個(gè)IP實(shí)現(xiàn)了凈量數(shù)據(jù)的傳輸。對(duì)同步的配置信息采用XML存儲(chǔ)，采用Windows應(yīng)用程序界面化配置，操作方便、易懂。
因?yàn)橥�步環(huán)境是對(duì)處于Internet上的異構(gòu)數(shù)據(jù)庫(kù)的實(shí)時(shí)同步；在設(shè)計(jì)與開發(fā)中，重點(diǎn)關(guān)注異構(gòu)數(shù)據(jù)庫(kù)的同步以及數(shù)據(jù)傳輸?shù)目煽啃裕惶接懩軐?shí)現(xiàn)可靠數(shù)據(jù)的同步，以及傳輸?shù)母咝�性。介紹了實(shí)現(xiàn)系統(tǒng)的思路以及所需的關(guān)鍵技術(shù)。系統(tǒng)用到的相關(guān)技術(shù)有捕獲技術(shù)Windows 托盤服務(wù)、多線程處理、以及網(wǎng)絡(luò)消息機(jī)制、多IP同步、同步IP權(quán)限驗(yàn)證、同步表名及字段以及字段類型的可配置、異構(gòu)數(shù)據(jù)類型的轉(zhuǎn)換、Web Service等。

關(guān)鍵詞：Web Service；異構(gòu)數(shù)據(jù)庫(kù)；同步；ADO.NET；

The Design and Implementation of Database Synchronization System Based on Web Service
Abstract
We can construct the Heterogeneous database synchronous system using Web Service. It has realized the function of one-way synchronous from SQL Server2000 to Oracle. It has some functions, the security authentication of IP, the data transmission of IP, the Synchronization configuration using XML storage and the windows application program UI which can make this system be operated easily.
Because the synchronous environment will be real-time synchronous for heterogeneous database on the Internet, in the design and implementation, this system has showed the synchronization of heterogeneous database and data transmission reliability, achieving the synchronization of reliable data, the security methods of data transmission, and the efficiency transmission. It will display the ideas of realization and the necessary critical technologies. There are some relevant technologies that this system used, for example, the capture technology, the windows tray service, multi-thread processing, and the network news mechanism, and so on.

Key words: Web Service; Heterogeneous Database; Synchronization; ADO.NET;

目  錄

1 引言 1
1.1 課題背景 1
1.2 國(guó)內(nèi)外研究現(xiàn)狀 1
1.3 本課題研究的意義 2
1.4 本課題的研究方法 2
2 Web Service數(shù)據(jù)庫(kù)同步原理 3
2.1 Web Service構(gòu)成與特點(diǎn) 3
2.1.1 Web Servcie的結(jié)構(gòu) 3
2.1.2 Web Servcie的關(guān)鍵技術(shù)---協(xié)議 3
2.1.3 Web Servcie的特點(diǎn) 4
2.1.4 Web Servcie安全 5
2.2 數(shù)據(jù)庫(kù)復(fù)制的分類 5
2.3 復(fù)制數(shù)據(jù)的類型 6
2.4 數(shù)據(jù)捕獲技術(shù) 7
2.5 沖突檢測(cè) 8
3 需求分析 9
3.1 同步環(huán)境 9
3.2 功能需求 9
3.3 性能需求 10
3.4 輸入輸出要求 10
3.5 運(yùn)行需求 10
4 方案設(shè)計(jì) 11
4.1 數(shù)據(jù)庫(kù)同步復(fù)制模型 11
4.2 數(shù)據(jù)庫(kù)設(shè)計(jì) 11
4.2.1 源結(jié)點(diǎn)Sql Server 2000表設(shè)計(jì) 11
4.2.2 目的結(jié)點(diǎn)Oracle表設(shè)計(jì) 12
4.3 模塊設(shè)計(jì) 13
4.3.1 數(shù)據(jù)捕獲部分 13
4.3.2 同步部分 13
4.3.3 沖突檢測(cè)處理部分 16
5 代碼實(shí)現(xiàn) 16
5.1 開發(fā)環(huán)境 16
5.2 關(guān)鍵代碼詳解。 16
5.2.1 數(shù)據(jù)捕獲部分 16
5.2.2 同步部分 17
6 測(cè)試 19
6.1 功能測(cè)試 19
6.2 性能測(cè)試 20
結(jié)    論 21
參考文獻(xiàn) 21
致    謝 23
聲    明 24