vXML數(shù)據(jù)裝入關(guān)系數(shù)據(jù)庫(kù)的軟件畢業(yè)論文.doc

北京工業(yè)大學(xué)畢業(yè)設(shè)計(jì)（論文）1摘要隨著Internet的發(fā)展和人們對(duì)數(shù)據(jù)標(biāo)準(zhǔn)性、平臺(tái)無(wú)關(guān)性的要求越來(lái)越高，XML(ExtensibleMarkupLanguage)得到了廣泛的應(yīng)用,同時(shí)人們對(duì)于XML的存儲(chǔ)方式提出了更高的要求。本課題意在設(shè)計(jì)一種將XML數(shù)據(jù)存入關(guān)系數(shù)據(jù)庫(kù)中的方法，并按照該方法開發(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樹中的元素節(jié)點(diǎn)關(guān)系映射為一個(gè)數(shù)據(jù)庫(kù)關(guān)系表，這五個(gè)表是本課題中數(shù)據(jù)庫(kù)設(shè)計(jì)的核心。五個(gè)表中包含的屬性信息要求方便于DOM接口和SAX接口兩種方式訪問(wèn)。提出存儲(chǔ)方法后，我們將利用這種存儲(chǔ)方法開發(fā)一個(gè)關(guān)系數(shù)據(jù)庫(kù)中XML數(shù)據(jù)裝入系統(tǒng)。文章后半部分將詳細(xì)說(shuō)明該軟件的需求分析、設(shè)計(jì)、具體開發(fā)細(xì)節(jié)以及測(cè)試。該軟件的測(cè)試結(jié)果驗(yàn)證了這種存儲(chǔ)方法能夠有效的將無(wú)模式的XML文檔存入關(guān)系數(shù)據(jù)庫(kù)。關(guān)鍵詞：關(guān)系數(shù)據(jù)庫(kù)、XML北京工業(yè)大學(xué)畢業(yè)設(shè)計(jì)（論文）2AbstractWiththedevelopmentofInternetandthepeopleshigherandhigherrequirementfordatasstandardizationanditsindependentofplatform,XML(extensiblemarkuplanguage)iswidelyused,inthemeantimethehigherrequirementforthestorageofXMLdataisasked.ThisresearchgroupdesignedamethodtostoreXMLdataintoRDB(RelationalDataBase)ofwhichthetechnologyhavebeenverymatureandwidelyused.ThenwedevelopedanapplicationthatcanstoretheXMLdataintoRDBusingthismethod.AtfirstthisarticlewillintroducebasicalknowledgeofXML,andthendiscusswhystoreXMLdatausingRDB.AfterthatwellresearchanddiscussthesomemethodsforstoringXMLdataintoRDBthathavebeenputforward.Basedonthemwelldesignastoragemethodfromnon-schemaXMLdatatoRDB.WeclassifiedXMLdataasfourkindofnodessuchasDocument,Element,AtributeandText.ThesefournodesaremappedtofourtablesintheRDBandwemappedtheDOMTreeintoatabletoo.ThefivetablesisthecoreoftheRDBdesign.TheattributeinformationinvolvedinthetablesisrequiredthatbothDOMandSAXinterfacecanbeeasytogetinformationfromthetables.AftergivingthemethodwedesignedwelldevelopanapplicationthatcanstoringtheXMLdataintoRDBusingthatmethod.Itsrequirementanalyse,designdetailsandtestresultwellbedescribedinthesecondhalfpartofthearticle.Thetestresultwillshowthatusingthestoragemethodwecanstoringthenon-schemaXMLdataintotheRDBeffectively.Keywords:RDB(RelationalDataBase),XML北京工業(yè)大學(xué)畢業(yè)設(shè)計(jì)（論文）3目錄摘要.1Abstract.2目錄.31緒論.51.1課題背景及研究意義.51.2XML知識(shí)簡(jiǎn)介.51.2.1XML.51.2.2DTD和Schema.71.2.3DOM.71.2.4SAX.81.3基于關(guān)系數(shù)據(jù)庫(kù)的XML存儲(chǔ)技術(shù).91.3.1現(xiàn)存的基于關(guān)系數(shù)據(jù)庫(kù)的XML存儲(chǔ)技術(shù).101.3.2一個(gè)模式驅(qū)動(dòng)映射實(shí)例.101.4作者的工作.111.5本章小結(jié).112無(wú)模式映射的設(shè)計(jì).122.1方案設(shè)計(jì)要求.122.2設(shè)計(jì)思想.122.3方案詳細(xì)設(shè)計(jì).122.3.1E-R圖(實(shí)體集中只畫主碼).132.3.2實(shí)體集和聯(lián)系.132.3.3設(shè)計(jì)方法與策略.142.3.4數(shù)據(jù)庫(kù)基本表設(shè)計(jì).162.3.5數(shù)據(jù)庫(kù)優(yōu)化.162.3.6數(shù)據(jù)字典.162.4本章總結(jié).183關(guān)系數(shù)據(jù)庫(kù)中XML裝入系統(tǒng).193.1任務(wù)概述.193.2設(shè)計(jì)思想概述.193.3需求規(guī)定.203.3.1系統(tǒng)用例圖.203.3.2用例事件流.203.3.3開發(fā)環(huán)境需求.213.4系統(tǒng)設(shè)計(jì).213.4.1系統(tǒng)體系結(jié)構(gòu).213.4.2序列圖設(shè)計(jì).213.4.3類設(shè)計(jì).233.4.4類關(guān)系圖.293.4.5算法的實(shí)現(xiàn)