摘 要
隨著Internet的發(fā)展和人們對(duì)數(shù)據(jù)標(biāo)準(zhǔn)性、平臺(tái)無(wú)關(guān)性的要求越來(lái)越高，XML(Extensible Markup Language)得到了廣泛的應(yīng)用,同時(shí)人們對(duì)于XML的存儲(chǔ)方式提出了更高的要求。
本課題意在設(shè)計(jì)一種將XML數(shù)據(jù)存入關(guān)系數(shù)據(jù)庫(kù)中的方法，并按照該方法開(kāi)發(fā)一個(gè)XML數(shù)據(jù)裝入關(guān)系數(shù)據(jù)庫(kù)的軟件。
本文首先對(duì)XML的基本知識(shí)進(jìn)行介紹，隨后討論用關(guān)系數(shù)據(jù)庫(kù)存儲(chǔ)XML數(shù)據(jù)的原因，并對(duì)目前已經(jīng)提出的一些XML文檔在關(guān)系數(shù)據(jù)庫(kù)中的存儲(chǔ)方式進(jìn)行研究討論，在此基礎(chǔ)上提出一個(gè)無(wú)模式的XML文檔對(duì)于關(guān)系數(shù)據(jù)庫(kù)的存儲(chǔ)方法。這個(gè)方法將XML數(shù)據(jù)分為文檔、元素、屬性、文本四種節(jié)點(diǎn)，并將這四種節(jié)點(diǎn)映射為數(shù)據(jù)庫(kù)中四個(gè)關(guān)系表。另外將DOM樹(shù)中的元素節(jié)點(diǎn)關(guān)系映射為一個(gè)數(shù)據(jù)庫(kù)關(guān)系表，這五個(gè)表是本課題中數(shù)據(jù)庫(kù)設(shè)計(jì)的核心。五個(gè)表中包含的屬性信息要求方便于DOM接口和SAX接口兩種方式訪問(wèn)。
提出存儲(chǔ)方法后，我們將利用這種存儲(chǔ)方法開(kāi)發(fā)一個(gè)關(guān)系數(shù)據(jù)庫(kù)中XML數(shù)據(jù)裝入系統(tǒng)。文章后半部分將詳細(xì)說(shuō)明該軟件的需求分析、設(shè)計(jì)、具體開(kāi)發(fā)細(xì)節(jié)以及測(cè)試。該軟件的測(cè)試結(jié)果驗(yàn)證了這種存儲(chǔ)方法能夠有效的將無(wú)模式的XML文檔存入關(guān)系數(shù)據(jù)庫(kù)。

關(guān)鍵詞：關(guān)系數(shù)據(jù)庫(kù)、XML

Abstract
With the development of Internet and the people’s higher and higher requirement for data’s standardization and its independent of platform,XML(extensible markup language) is widely used,in the mean time the higher requirement for the storage of XML data is asked.
This research group designed a method to store XML data into RDB(Relational Data Base) of which the technology have been very mature and widely used.Then we developed an application that can store the XML data into RDB using this method.
At first this article will introduce basical knowledge of XML,and then discuss why store XML data using RDB.After that we’ll research and discuss the some methods for storing XML data into RDB that have been put forward.Based on them we’ll design a storage method from non-schema XML data to RDB.We classified XML data as four kind of nodes such as Document,Element,Atribute and Text.These four nodes are mapped to four tables in the RDB and we mapped the DOM Tree into a table too.The five tables is the core of the RDB design.The attribute information involved in the tables is required that both DOM and SAX interface can be easy to get information from the tables.
After giving the method we designed we’ll develop an application that can storing the XML data into RDB using that method.It’s requirement analyse,design details and test result well be described in the second half part of the article.The test result will show that using the storage method we can storing the non-schema XML data into the RDB effectively.

Key words:RDB(Relational Data Base),XML

目    錄
摘 要 1
Abstract 2
目    錄 3
1 緒  論 5
1.1  課題背景及研究意義 5
1.2  XML知識(shí)簡(jiǎn)介 5
1.2.1 XML 5
1.2.2 DTD和Schema 7
1.2.3 DOM 7
1.2.4 SAX 9
1.3 基于關(guān)系數(shù)據(jù)庫(kù)的XML存儲(chǔ)技術(shù) 10
1.3.1 現(xiàn)存的基于關(guān)系數(shù)據(jù)庫(kù)的XML存儲(chǔ)技術(shù) 10
1.3.2 一個(gè)模式驅(qū)動(dòng)映射實(shí)例 10
1.4 作者的工作 11
1.5 本章小結(jié) 11
2 無(wú)模式映射的設(shè)計(jì) 12
2.1方案設(shè)計(jì)要求 12
2.2設(shè)計(jì)思想 12
2.3方案詳細(xì)設(shè)計(jì) 12
2.3.1 E-R圖(實(shí)體集中只畫(huà)主碼) 13
2.3.2 實(shí)體集和聯(lián)系 13
2.3.3 設(shè)計(jì)方法與策略 14
2.3.4 數(shù)據(jù)庫(kù)基本表設(shè)計(jì) 16
2.3.5數(shù)據(jù)庫(kù)優(yōu)化 16
2.3.6數(shù)據(jù)字典 16
2.4 本章總結(jié) 18
3 關(guān)系數(shù)據(jù)庫(kù)中XML裝入系統(tǒng) 19
3.1 任務(wù)概述 19
3.2 設(shè)計(jì)思想概述 19
3.3 需求規(guī)定 20
3.3.1 系統(tǒng)用例圖 20
3.3.2 用例事件流 20
3.3.3 開(kāi)發(fā)環(huán)境需求 20
3.4 系統(tǒng)設(shè)計(jì) 21
3.4.1 系統(tǒng)體系結(jié)構(gòu) 21
3.4.2 序列圖設(shè)計(jì) 21
3.4.3 類(lèi)設(shè)計(jì) 23
3.4.4 類(lèi)關(guān)系圖 29
3.4.5 算法的實(shí)現(xiàn)策略 30
3.4.6 異常處理 31
3.5 系統(tǒng)測(cè)試 32
3.5.1 系統(tǒng)功能測(cè)試 32
3.5.2 測(cè)試總結(jié) 37
3.5.3 與模式映射XML-RDB裝入系統(tǒng)的分析對(duì)比 37
3.6 本章小節(jié) 38
結(jié) 論 39
致 謝 40
參考文獻(xiàn) 41