臺灣博碩士論文加值系統

二十世紀末，因網際網路普及使得各家公司紛紛走向電子化。不但應用在電子商務，也應用於資訊之間的交換，藉以縮短原料供應商到客戶取得成品的時間。然而，現今公司將遭遇到眾多電子化文件充斥的問題。
XML已逐漸成為組織間在網際網路上資料交換的標準，在未來將勢必有大量的資料會以XML格式儲存著。但是，目前組織重要的營運資料，大多還是儲存在具有高成熟度、高穩定性特性的關聯式資料庫系統中。XML是一種純文字格式的檔案，欲以XML文件當做資料庫的基礎並在其中查詢資料，是一件困難的工作。為了解決此問題，本論文設計一個查詢XML文件的系統，首先將XML文件儲存到關聯式資料庫中，以便使用者可以藉由XML的查詢語言XQuery，轉換XQuery表示式到適當的SQL查詢句，再擷取出符合查詢句的XML資料。

In the last decade of the 20th century, because of the popularity of Internet, the trend is towards e-solutions for businesses. Not only apply on the electronic commerce but also on the information exchange to decrease time from material in the manufacturer to products bought by customers. However, the problem we confront today is that there are full of e-documents in businesses.
XML has already been the standard of data interchange on the Internet. In the future, a large amount of data will be represented in XML format. However, most of the critical data in businesses are still stored in relational database management systems. It is difficult to query XML databases because of its textual format. This thesis research intends to tackle this problem, and we proposed a system to manage XML documents that could be queried by the query language XQuery. XML documents are stored in relational format and the XQuery expressions are translated into appropriate SQL queries. The results of the SQL queries are transformed into XML documents.

CHAPTER 1 INTRODUCTION
CHAPTER 2 RELATED WORKS
2.1 Overview
2.2 Understanding XML
2.2.1 XML Family Technique
2.2.2 Why XML-based Document
2.2.3 XML’s Improve in IEM (Information Exchanging Modeling)
2.2.3.1 Databases of Aspect
2.2.3.2 Applications of Aspect
2.2.3.3 Presentation of Aspect
2.2.3.4 Data Communication of Aspect
2.3 XML Query Language
2.3.1 XPath
2.3.2 XQuery
2.3.2.1 Expressions
2.3.2.2 Syntax
2.4 RDBMS and SQL
2.5 Rainbow System
2.6 XISS/R System
2.7 XPERANTO System
2.8 Silkroute System
2.9 LegoDB System
CHAPTER 3 STORAGE AND RETRIEVAL SYSTEM ARCHITECTURE
3.1 Overview
3.2 System Architecture
3.3 Running XML example and limitations
3.3.1 The XML example
3.3.2 Limitations on the input documents
3.4 Overview the Components
3.4.1 Storage Components
3.4.1.1 Schema Generation
3.4.1.2 Schema Transformation
3.4.1.3 DB Loader
3.4.2 Retrieval Components
3.4.2.1 Query Translation
3.4.2.1.1 XQuery to SQL translation
3.4.2.1.2 SQL result to XML conversion
CHAPTER 4 CASE STUDY
4.1 Case Descriptions
4.2 CMMI Introduction
4.2.1 Structural Overview
4.2.2 Maturity Levels
4.3 Configuration Management (CM) Maturity Level 2
4.3.1 Establish a Configuration Management System
4.3.1.1 Typical Work Products
4.3.1.2 Subpractices
4.4 System Implementation
4.4.1 Develop Environment
4.4.2 Building Phase
4.4.3 Running Phase
CHAPTER 5 CONCLUSIONS AND FUTURE WORKS
5.1 Conclusions
5.2 Future Works
BIBLIOGRAPHY
APPENDIX XML EXAMPLE DOCUMENT
VITA

[1]Cook, James H., “XML Sets Stage for Efficient Knowledge Management”, IT Professional, May –June 2000, pp. 55-57.
[2]Schmidt, A., S. Manegold, and M. Kersten, “Integrated querying of XML data in RDBMSs”, Proceedings of the 2003 ACM symposium on Applied computing, 2003, pp. 509-514.
[3]Schmidt, A., M. Kersten, M. Windhouwer, and F. Waas, “Efficient Relational Storage and Retrieval of XML Documents”, Proceedings of the Third International Workshop on the Web and Databases (WebDB 2000), Dallas, Texas, USA, May 2000, pp. 47-52.
[4]Kasukawa, Takeya, Hideo Matsuda, Michio Nakanishi, and Akihiro Hashimoto, “A New Method for Maintaining Semi-Structured Data Described in XML”, Proceedings of IEEE Pacific Rim Conference on Communications, Computers, and Signal Processing, August 1999, pp. 258-261.
[5]Bertino, Elisa, and Barbara Catania, “Integrating XML and Databases”, IEEE Internet Computing, Vol: 5 Issue: 4, July-Aug 2001, pp. 84-88.
[6]Bourret, R., C. Bornhovd, and A. Buchmann, “A Generic Load/Extract Utility for Data Transfer Between XML Documents and Relational Databases”, Second International Workshop on Advance Issues of E-Commerce and Web-Based Information Systems (WECWIS 2000), June 2000, pp. 134-143.
[7]Roy, J., and A. Ramanujan, “XML: Data’s Universal Language”, IT Professional, Vol:2 Issue:3, May-June 2000, pp. 32-36.
[8]Royappa, Andrew V., “Implementing Catalog Clearinghouses with XML and XSL”, Proc. Proceedings of the 1999 ACM symposium on Applied computing, 1999, pp. 616-621.
[9]Seligman, L., and A. Roenthal, “XML’s Impact on Databases and Data Sharing”, Computer, IEEE, June 2001, pp. 59-67.
[10]Cleveland, F. M., “Information Exchange Modeling (IEM) and Extensible Markup Language (XML) Technologies”, Power Engineering Society Winter Meeting, 2000. IEEE, Jan 2000, pp. 145-150.
[11]McGovern, James, Per Bothner, Kurt Cagle, James Linn, and Vaidyanathan Nagarajan, XQuery Kick Start, ISBN: 0672324792, SAMS, 2003.
[12]Chamberlin, Don, Jonathan Robie, and Daniela Florescu, “Quilt: An XML Query Language for Heterogeneous Data Sources”, Proceedings of WebDB 2000 Conference, in Lecture Notes in Computer Science, Springer-Verlag, 2000, pp.1-10.
[13]Ullman, Jeffrey D., and Jennifer Widom, A first course in database systems, ASIN: 0138613370, Prentice Hall, 1997.
[14]Zhang, X., Mukesh Mulchandani, Steffen Christ, Brian Murphy, and E. A. Rundensteiner, “Rainbow: mapping-driven XQuery processing system”, Proceedings of the 2002 ACM SIGMOD international conference on Management of data, 2002, p. 614.
[15]Zhang, X., and E. A. Rundensteiner, “XAT: XML Algebra for the Rainbow System”, Technical Report WPI-CS-TR-02-24, Worcester Polytechnic Institute, July 2002.
[16]Harding, Philip J., Quanzhong Li, and Bongki Moon, “XISS/R: XML Indexing and Storage System Using RDBMS”. Proceedings of the 29th VLDB Conference, Berlin, Germany, September 2003, pp. 1073-1076.
[17]Carey, Michael, Jerry Kiernan, Jayavel Shanmugasundaram, Eugene Shekita, and Subbu Subramanian. “XPERANTO: A Middleware for Publishing Object-Relational Data as XML Documents”. Proceedings of the 26th VLDB Conference, Cairo, Egypt, September 2000, pp. 646-648.
[18]Shanmugasundaram, J., E. Shekita, J. Kiernan, R. Krishnamurthy, and J. Funderburk, “Querying XML Views of Relational Data”, Proceedings of the 27th VLDB Conference, Rome, Italy, 2001, pp. 261-270.
[19]Fernandez, Mary, Wang-Chiew Tan, and Suciu Dan, “SilkRoute: Trading between Relations and XML”, Proceedings of the Ninth International World-wide Web Conference (WWW'9), Amsterdam, May 2000, pp. 723-745.
[20]Bohannon, P., J. Freire, J. R. Haritsa, M. Ramanath, P. Roy, and J. Simeon, “LegoDB: Customizing Relational Storage for XML Documents”, Proceedings of the 28th VLDB Conference, Hong Kong, China, 2002, pp. 1091-1094.
[21]Roy, P., J. Simeon, P. Bohannon, and J. Freire, “From XML schema to relations: A cost-based approach to XML storage”, Proceedings of the 18th International Conference on Data Engineering, Feb-March 2002, pp.64-75.
[22]Manolescu, I., D. Florescu, and D. Kossmann, “Answering XML Queries on Heterogeneous Data Sources”. Proceedings of the 27th VLDB Conference, Rome, Italy, 2001, pp. 241-250.
[23]Miller, M. J., F. Pulgar-Vidal, and D. M. Ferrin, “Achieving higher levels of CMMI maturity using simulation”, Proceedings of the Winter Simulation Conference, Dec 2002, pp.8-11.
[24]Standard CMMI Appraisal Method for process Improvement (SCAMPI) Version1.1: Method Definition Document, SEI, 2002.
[25]CMMI (Capability Maturity Model Integration) Web site, http://www.sei.cmu.edu/cmmi/.
[26]W3C, XML, http://www.w3.org/XML, 1998.
[27]W3C, XQuery 1.0 and XPath 2.0 Formal Semantics, W3C Working Draft, http://www.w3.org/TR/xquery-semantics/, February 2004.
[28]W3C, XML Path Language (XPath) Version 1.0, http://www.w3.org/TR/xpath, November 1999.
[29]W3C, XML Query Data Model, W3C Working Draft, http://www.w3.org/TR/xpath-datamodel/, November 2003.
[30]W3C, XQuery 1.0: An XML Query Language, W3C Working Draft, http://www.w3.org/TR/xquery/, November 2003.