臺灣博碩士論文加值系統

此論文之研究重點為XML資料庫之搜尋與擷取技術，希望能掌握此一最新技術，增加往後對XML-based資料之執行效益。對目前XML技術中與XQuery相關的如Schema與Xpath作一介紹，同時將目前對XML文件具有搜尋機制的XML DOM、XSLT與ＸＱuery作一比較。
現今，為了儲存和管理XML的文件，有兩種主要的處理方式，一是儲存在關聯式資料庫中，再者就是儲存在新發展的原生型XML資料庫(Native XML database)中。至於何種方式較為適合現今之商務資訊系統，截至目前為止，還沒有定論。雖然目前已有許多研究人員積極投入相關的研究，迄今在原生型XML資料庫中的效能評估仍然不完整。
本網站系統以二層式資料結構的題庫系統為實例，以XML文件為資料庫，ASP & DOM的相互合作，為發展網頁的工具，研究XML文件資料庫的應用。由研究發現XML文件直接當資料庫使用可減少資料轉換關聯式資料庫的負擔，但為顧及查詢與擷取資料的效率，資料庫的儲存需考慮儲存檔案的適當大小與文件結構不可太複雜，以提高網路的效率及提高查詢的速度，經過實驗驗証了此系統之功能及有效性。

This thesis focused on the search and retrieval of XML database system. An introduction about XML technology related to XQuery such as Schema and XPath. is presented. At the same time, a comparison is made between XML DOM and XSLT, which are major search engines for XML documents.
Nowadays, there are two ways to store and manage XML documents. One way is to store in the “relation database”; the other is to store in the newly-developed “Native XML database”. Up to now, there is no conclusion which one is a better way to apply to contemporary commerce information system. Although many researchers have gone into this kind of study, the functional evaluation of the Native XML database is still incomplete.
A prototype XML database system is developed using examination question system as an example. A two-tier client server architecture is used.. Interactive cooperation of ASP and DOM are used to develop web pages and to study the application of XML database. From this study, we can find that using XML documents can reduce the task of translating data into relational database. However, considering the efficiency in searching and retrieval the size of the XML documents should be properly designed and the structure of XML documents should not be too complicated. Through experiments, we validate the functionalities and effectiveness of the system.

中文摘要 i
英文摘要 ii
誌謝 iii
目錄 iv
圖目錄 vi
表目錄 viii
範例目錄 ix
第一章　緒論 1
第二章　背景知識 4
2.1　XML文件和結構 4
2.2　文件格式定義 6
2.2.1　DTD介紹 7
2.2.2　XML Schema介紹 8
2.2.3　DTD與Schema的比較 13
2.3　XML Path的概念與架構 14
2.3.1　XML Path的基本語法 14
2.3.2　XML Path的例子說明 15
2.3.3　 XML Path的函數 16
2.4　XML XSLT的概念與架構 18
2.4.1　XSLT的概念 18
2.4.2　IE瀏覽器與XSLT 18
2.4.3　XSLT的文件結構 19
2.4.4　XSLT的樣版與樣式 20
2.4.5　利用XSLT搜尋正確的資料 21
2.5　XML DOM的概念與架構 22
2.5.1　DOM運作方式與流程 23
2.5.2　DOM的物件和使用方法 23
2.5.3　DOM的搜尋機制 25
2.6　XML Xquery的概念與架構 26
2.6.1　XQuery表示法 26
2.6.2　XQuery提供之運算元 29
2.6.3　XQuery之函式 30
2.6.4　應用範例 30
2.6.5　XQuery核心函式、操作 32
2.7　DOM、XSLT和Xquery的比較 35
第三章　XML資料庫 36
3.1　XML檔案 36
3.2　關聯式資料庫的方式 36
3.2.1　儲存XML文件至RDB中 37
3.2.2　從RDB中轉回XML文件 40
3.3　原生型XML資料庫 41
第四章　系統實作探討－線上測驗系統和查詢系統架構 44
4.1　系統的規劃與建置模式 44
4.2　系統檔案的規劃與結構 47
4.3　系統設計與實施 49
第五章　結論與未來未來研究方向探討 62
參考文獻 63
附錄 67
自傳 80

[1] “HTML 4.01 Specification”, W3C Recommen- dation,December 1999.
[2] “Standard Generalized Markup Language (SGML)”, ISO 8879:1986.
[3] “Extensible Markup Language (XML) 1.0 (Second Edition)”, W3C Recommendation,October 2000.
[4] “Extensible Stylesheet Language (XSL) Version 1.0”, W3C Recommendation, October 2001.
[5] “Unicode 3.2.0”, Unicode Consortium, March 2002.
[6] “XHTML 1.0: The Extensible HyperText Markup Language, a Reformulation of HTML 4 in XML 1.0”, W3C Recommendation, January 2000.
[7] ”Mathematical Markup Language (MathML™) 1.01 Specification”, W3C Recommendation, July 1999.
[8] J. S. Leung, Yong Peng, Heu-Wun Leung and Hin-Wing Yeung, “Herbal Medicine Markup Language (HMML): an XML-based Specification Language for Knowledge Management in Herbal Medicine”, Proceeding of the Second International Conference on the Practical Application of Knowledge Management, London, UK, April 1999.
[9] “Wireless Application Protocol Wireless Markup Language Spec., Version 1.2”, WAP Forum, WAP WML Version 4, Nov. 1999.
[10] “Voice eXtensible Markup Language (VoiceXML™)”, Version 1.0 W3C Note, May 2000.
[11] “Scalable Vector Graphics 1.0 Specification”, W3C Recommendation, Sept. 2001.
[12] “Synchronized Multimedia Integration Language 2.0 Specification”, W3C Recommendation, Aug. 2001.
[13] “e-Business for XML Specification.”
[14] “Rosattanet Standards”, http://www.rosettanet.org/ standards, 2002.
[15] B. Thuraisingham, “XML Databases and the Semantic Web”, CRC Press, pp. 155–169 , 2002
[16] 吳正隆,”以XML為資料擷取介面之審計系統實作”,2002年６月
[17] “XML Schema Part 0: Primer”, W3C Recommendation, 2 May 2001
[18] “XML Schema Part 1: Structures”, W3C Recommendation, 2 May 2001
[19] “XML Schema Part 2: Datatypes”, W3C Recommendation, 02 May 2001
[20] “XML Path Language (XPath)Version 1.0”, W3C Recommendation, 16 November 1999
[21] “XSL Transformations (XSLT) Version 1.0”, W3C Recommendation,16 November 1999
[22] “XQuery 1.0: An XML Query Language”, W3C Working Draft, 02 May 2003
[23] “XML Query Use Cases”, W3C Working Draft, 02 May 2003
[24] “XQuery 1.0 and XPath 2.0 Formal Semantics”, W3C Working Draft, 2 May 2003
[25] “XQuery 1.0 and XPath 2.0 Data Model”, W3C Working Draft, 16 August 2002
[26] Ronald Bourret, ”XML and Databases”,
http://www.rpbourret.com/xml/XMLAndDatabases.htm
[27] E. Bertino and B. Catania,”Integrating XML and DataBase”,
IEEE Internet Computing,Volume: 5 Issue:4,July-Aug,P.84-P.88,2001
[28] “Relational database for querying XML documents:limitationa and opportunities”,
In Proceedings of VLDB,Edinburgh,UK,P.302-P.314,September,1999
[29] “Sorting XML in Relational Databases”,Igor Dayen,
http://www.xml.com/pub/a/2001/06/20/databases.html
[30] Dan Suciu,“On Database Theory and XML”,ACM SIGMOD Special Section on Advanced XML Data Processing,Volume 30, Number 3 September 2001
[31] Ronald Bourret,”Mapping DTDs to Databases”,
http://www.xml.com/lpt/2001/05/09/dtdtodbs.html
[32] B.Cooper,N. Sample,M. .Franklin, G. Hjaltason, and M. Shadmon,”A fast index for semistructured data”,Proceedings of the 27th VLDB Conference,Roma,Italy,2001
[33] D.Florescu and D. Kossmann,”Storing and Querying XML data using an RDBMS”,
IEEE Data Engineering Bulletin. Vol.22 , No. 3,P27-P34,1999
[34] D.Florescu,D. Kossman,”A Performance Evaluation of Alternative Mapping Schemes for Storing XML Data in Relational Database”,Rapport de Recherche No.3680 Inria,Rocquencourt,France,May 1999
[35] Feng Tian,David J. Dewitt,Jianjun Chen,and Chun Zhang, “The Design and Performance Evaluation of Various XML Storage Strategies” , Computer Sciences Department at the University of Wisconsin-Madison, Submitted for publication.
[36] M. Carey, D. Florescu, Z. Ives, Y. Lu, J. Shanmugasundaram, E. Shekita, and S. subramanian, “XPERANTO:publishing object-relational data as XML”, In Proceedings of WedDB, Dallas Tx,May 2000
[37] Jayavel Shanmugasundaram, Eugene Shekita, Jerry Kiernan, rajasekar Krishnamurthy, Efstratios Viglas, Jeffrey Naughton and Igor Tatarinov, “A General Technique for Querying XML Documents using a Relation Database System”, ACM SIGMOD Special Section on Advanced XML Data Processing, Vol.30 No3, September,2001
[38] B. Chaudhri:Benchmarks,2000
[39] Timo Bohme and Erhard Rahm, “XMach-1:A benchmark for XML Data Management”,Proceedings of German database conference BTW,2001
[40] “Document Object Model (DOM) Level 1 Specification Version 1.0”,
W3C Recommendation 1, October 1998
[41] 陳長念,陳勤意,活用XML,知城數位出版,台北,2001
[42] 周坤約、洪博文、歐翼德 譯,專業XML程式設計第二版,碁峯資訊,台北,2002
[43] 黃中杰、王天利 編著,XML 新網頁語言開發手冊,知城數位出版,台北,2001
[44] 陳錦輝,XML與ASP網站實作大全,金禾資訊,台北,2001
[45] 悠瑪數位科技 編著,XML 技術入門指南,儒林出版,台北,2002
[46] 陳會安,XML網頁製作徹底研究 第二版,旗標出版,台北,2002
[47] 陳建勳 編著,XSLT快速入門,博碩文化出版,台北,2001
[48] 位元文化 編著,XML技術實務,文魁出版,台北,2001