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

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