臺灣博碩士論文加值系統

現今多媒體資訊已成為網際網路上的主流，許多網路上的活動與多媒體資訊息息相關，例如人們可在線上觀看即時的球賽，聽網路廣播，開視訊會議，還有網路教學也朝多媒體教材內容發展，然而對於日益膨脹的多媒體資訊卻缺乏一個可管理查詢的管道，所以我們建構一個XML多媒體資料庫系統，提供可管理和查詢多媒體資訊的介面。藉由XML的特性我們可以表達記錄多媒體資訊的內容，然而XML的查詢效能並不理想，所以我們將資料儲存在關聯式的資料庫內以提高效能。在資料儲存方面是以XML-DBMS為基礎將XML文件的內容轉換至關聯式資料庫，並針對元素間的關係、資料的來源以及關聯式資料庫保留字的問題加以改善。在查詢資料方面我們設計了XML Query Format來做查詢，並利用Relation-Indexing Table檢驗Query中的元素關係，以避免大量無效的查詢動作。最後我們以XML多媒體資料庫結合WMCPS(Web-based Multimedia Courseware Presentation System)的多媒體播放系統可以建構一個網路教學的多媒體課程教材之查詢播放系統。

Today multimedia information has already become the trunk stream of internet. Most internet activities such as online real-time ball game, internet broadcasting, video conference and e-Learning are closely linked to multimedia information. However, we don’t have a system to manage and query the multimedia information which is quickly increasing. To support an interface which can manage and query the multimedia information, we build a XML Multimedia Database System. XML documents can record multimedia information, but the performance of querying XML documents is not good enough. To enhance the performance of querying, we store data in relational database system. The translation between XML documents and relational database is based on XML-DBMS, and we improve the problems of XML-DBMS, e.g. the relations of elements, data source and the reserved words of relational database. We also design XML Query Format for querying. To avoid ineffectual query, we use Relation-Indexing Table for checking the relations of elements in XML Query Format. Finally we integrate XML Multimedia Database System with WMCPS (Web-based Multimedia Courseware Presentation System) which is a multimedia presentation system to construct an e-Learning Multimedia Courseware Querying and Presentation System.

第一章 緒論 1
1.1 前言 1
1.2 研究動機 1
1.3 研究目的 2
1.4 論文架構 2
第二章 文獻探討 4
2.1 XML 4
2.2 DTD 5
2.3 XPATH 8
2.4 XML QUERY LANGUAGE 8
2.5 搜尋與查詢 10
2.6 SMIL 12
2.7 XML與RDBMS 13
第三章 XML與資料庫 15
3.1 多媒體資料轉換 15
3.2 多媒體資料查詢 23
第四章 系統實作 28
4.1 系統架構 28
4.2 範例說明 29
第五章 多媒體應用 33
5.1 WMCPS 33
5.2 多媒體查詢播放系統 33
第六章 結論與未來展望 36
參考文獻 36
附錄A 39

[1] http://www.w3.org/TR/REC-xml/
[2] http://www.w3.org/TR/smil20/
[3] http://www.w3.org/XML/Schema/
[4] http://www.w3.org/TR/xsl/
[5] J. M. Hsu, R. H. Hwang, Y. J. Lin, J. M. Chen and J. C. Hwang,”Web-based Multimedia Courseware Presentation System for E-Learning,” NCS2001, 2001, pp.139-144.
[6] http://www.w3.org/TR/xpath/
[7] http://www.w3.org/TR/xptr/
[8] http://www.w3.org/TR/xlink/
[9] http://www.w3.org/DOM/
[10] S. Flesca, S. Greco and E. Zumpano, “Modeling and querying XML-data*,” Database Engineering and Applications Symposium, 2000, pp.275-283.
[11] D. Konopnicki and O. Shmueli, “A comprehensive framework for querying and integrating WWW data and services, “ in Proc. of IFCIS International Conference on Cooperative Information Systems, 1999, pp.172 —183.
[12] http://www.saxproject.org/
[13] http://www.as400.ibm.com/developer/java/xml/xml_parser2.html
[14] http://xml.apache.org/index.html
[15] http://www.w3.org/TR/xquery/
[16] http://www.almaden.ibm.com/cs/people/chamberlin/quilt_euro.html
[17] N. Fuhr , K. Gross, “XIRQL: a query language for information retrieval in XML documents,” in Proc. of 24th annual international ACM SIGIR conference on Research and development in information retrieval September, 2001.
[18] S. Park and H. Kim ,”A new query processing technique for XML based on signature,” in Proc. of 7th International Conference on Database Systems for Advanced Applications, 2001, pp.22 -29.
[19] H. Kato, K. Oyama, M. Yoshikawa and S. Uemura,”A query optimization for XML document views constructed by aggregations,” Database Applications in Non-Traditional Environments, 2000 , pp.189 -196.
[20] D. Florescu, D. Kossmann and I. Manolescu, “Integrating keyword search into XML query processing,” Computer Networks, Volume 33, Issue 2-6, June 2000, pp. 119-135.
[21] J. E. Wolff, H. Florke and A. B. Cremers,” Searching and Browsing Collections of Structural Information, “ in Proc. of IEEE Advances in Digital Libraries, USA, May, 2000, pp.142-150.
[22] E. Kotsakis and K. Bohm, “XML Schema Directory: a data structure for XML data processing,” in Proc. of the First International Conference on Web Information Systems Engineering, Volume 1, 2000, pp.63-69.
[23] M. Fernández, W. C. Tan and D. Suciu, “SilkRoute: trading between relations and XML,”, Computer Networks, Volume 33, Issue 2-6, June 2000, pp.724-745.
[24] E. Spertus and L. A. Stein, ” Squeal: a structured query language for the Web,” Computer Networks, Volume 33, Issue 2-6, June 2000, pp.95-103.
[25] E. Kapsammer, G.. Kappel and W. Retschitzegger, “Architectural Issues for Integrating XML and Relational Database Systems - The X-Ray Approach,” XML Technologies and Software Engineering (XSE2001) Toronto, Canada (co-located with ICSE2001), 15 May 2001.
[26] E. Kapsammer, G.. Kappel and W. Retschitzegger, “X-Ray-Towards Integrating XML and Relational Database Systems,” in Proc. of 19th International Conference on Conceptual Modeling (ER), Salt Lake City, USA, Oct., 2000.
[27] http://www.rpbourret.com/xmldbms/index.htm