臺灣博碩士論文加值系統

隨著Internet興起、上網人口的普及、相關網路交易安全技術提升、即時線上付款與供應鏈管理機制成熟等因素，電子商務已經逐漸被大眾所接受並成為一種主流的商業經營模式。而在電子商務相關技術和應用中，e-化電子商務型錄(e-Catalog) 是電子採購與銷售作業過程中的重要元素。根據AMR的研究顯示，企業電子商務成功與否，產品資料的即時性及使用方便性佔了很大的比例，所以電子商務型錄內容管理將是企業採購、銷售與商品管理電子化發展的重要課題。而電子商務型錄內容管理則依賴資料庫Table Schema的設計，因此Table Schema設計的良莠與否攸關到整體電子商務網站的營運績效及成敗。
本論文提出新的e-化電子商務型錄資料庫結構：HHVX (Hybrid Horizontal and Vertical with XML) Table Schema，是整合Horizontal 和Vertical Schemas的設計並結合XML文件的特性所設計出來適合於關聯式資料庫應用的e-化電子商務型錄資料庫結構，可提供電子商務網站之e-化產品型錄Schema和採購車等系統較佳的設計參考與應用。然後本文將HHVX Table Schema於Microsoft SQL Server 2005與Oracle 10g等資料庫系統中進行實證，實際比較HHVX Table Schema與其他的Table Schemas之差異及其績效。由實驗的結果證明：(1) HHVX Table Schema不僅能避免儲存大量的Null值且不受Table欄位的限制。同時，相較於其他Table Schema更易於進行產品的新增、修改及刪除等維護作業。(2) 可改善產品的搜尋速度，尤其在Microsoft SQL Server 2005可提昇約80%的產品搜尋速度。總之，本論文所提出新的e-化的電子商務型錄之HHVX Table Schema，相較於其他Table Schemas的設計更能符合一個良好的e-化電子商務型錄設計要求，亦可容納且易於管理與維護多種不同類型的商品及屬性、支援具彈性的與快速的產品搜尋功能。同時，亦可進一步證明藉由Web Services提供跨平台的e-化電子商務型錄搜尋與交換之能力。

With the evolution of Internet, e-Commerce has already become one of the main-stream e-business models. Through the applications of B2B and B2C in business operation, business owners realize their dreams of on-line stores. Also, e-Catalog is key issue of e-procurement and sales operation in a e-Commerce system. However, this fast-growing e-Commerce plays a crucial role. In other words, how consumers can quickly and conveniently locate the products of their interests and how businesses can effectively manage various kinds of product information are the key factors to the success of e-Commerce. Today, most of e-Commence Web sites rely on traditional RDBMS to store various kinds of product’s catalog and information, but in supporting e-Catalog, RDBMS has already shown unacceptable extensibility and degraded performance. Hence, the purpose of this paper is to solve these issues while appreciating the advantages of RDBMS.
This paper proposes a new approach called HHVX (Hybrid Horizontal and Vertical with XML) table schema to integrate Horizontal and Vertical table schemas conjunction with XML characteristic in Native XML Support RDBMS. HHVX can be applied to e-Catalog database of e-Commerce Web site and e-shopping car systems. Based on the experimental results, the proposed HHVX can obtain better performance in maintenance and searching operations of database than other table schemas under Microsoft SQL Server 2005 and Oracle 10g. Especially, the HHVX can enhance searching performance above 80% on the Microsoft SQL Server 2005. Consequently, the final results indicate that HHVX table schema can store unlimited categories and support flexbile product attributes in RDBMS. Furthermore, HHVX table schema can also provide products searching and exchange e-Catalog information of cross platform by Web Services.

誌謝 i
摘要 ii
Abstract iii
目錄 iv
表目錄 vi
圖目錄 vii
第壹章、 緒論 1
第一節、 研究背景與動機 1
第二節、 研究目的與範圍 2
第三節、 研究架構與方法 3
第四節、 論文章節介紹 4
第貳章、 文獻探討及相關研究 5
第一節、 電子商務e-化產品型錄應用介紹 5
第二節、 基本電子商務e-化產品型錄Schema介紹 5
第三節、 基本XML介紹 8
第四節、 進階電子商務e-化產品型錄相關研究 11
第參章、 HHVX Table Schema設計原理與應用 13
第一節、 XML在Microsoft SQL Server 2005的功能介紹 13
第二節、 設計原理及應用 14
第肆章、 實驗內容與結果分析 19
第一節、 實驗環境與參數說明 19
第二節、 Table Schema實作之程式說明 20
第三節、 Table Schema維護實證 22
第四節、 Table Schema搜尋之程式說明 36
第五節、 Table Schema搜尋實證 37
第六節、 實驗結果分析 42
第伍章、 HHVX Table Schema 之進階應用 46
第一節、 HHVX結合XML文件的格式定義 46
第二節、 HHVX 再延伸 47
第三節、 跨平台的搜尋與交換應用 48
第陸章、 結論 51
參考文獻 52
附錄一、程式：建立Horizontal Table及資料 53
附錄二、程式：建立Binary Table及資料 59
附錄三、程式：建立Vertical Table及資料 61
附錄四、程式：建立VX Table及資料 63
附錄五、程式：建立HHVX Table及資料 65
附錄六、程式：針對Microsoft SQL Server 2005執行產品搜尋 67
附錄七、程式：針對Oracle 10g執行產品搜尋 85

[1]Agrawal Rakesh, Somani Amit, and Xu Yirong, “Storage and Querying of e-Commerce Data”, 27th International Conference on Very Large Databases (VLDB), pp. 149-158, San Francisco CA, USA, 2001.
[2]Arzucan Özgür and Taflan İ. Gündem, “Efficient Indexing Technique for XML-based Electronic Product Catalogs”, Electronic Commerce Research and Applications, 5, 1, pp. 66-77, Spring 2006.
[3]Erwin Leonardi, Sourav S. Bhowmick, “Detecting changes on unordered XML documents using relational databases: a schema-conscious approach”, 14th ACM international conference on Information and knowledge management CIKM '05, pp. 509-516, Oct. 2005.
[4]J. E. Funderburk, S. Malaika, B. Reinwald, “XML programming with SQL/XML and XQuery”, IBM Systems Journal Volume 41 Issue 4, pp. 642-665, Oct. 2002.
[5]Lee Kangchan, Min Jaehong, Park Kishik, “A Design and Implementation of XML-based Mediation Framework (XMF) for Integration of Internet Information Resources”, 35th Annual Hawaii International Conference on System Sciences 7, pp. 202-212, 2002.
[6]Lei Wang, Padmanabhan Krishnan, “An Approach to Provisioning E-Commerce Applications with Commercial Components”, pp. 323-330, IEEE International Conference on e-Business Engineering, Oct. 24-26 2006.
[7]Lim Lipyeow and Wang Min, “Managing e-Commerce Catalogs in a DBMS with Native XML Support”, IEEE International Conference on e-Business Engineering, pp. 564-571, Beijing, China, Oct. 18-21 2005.
[8]Min Wang, X. Sean Wang, “Web and e-business application: Optimizing relational store for e-catalog queries: a data mining approach”, 2002 ACM symposium on Applied computing SAC '02, pp. 1147-1152, March 2002.
[9]Shaun Pather, Geoff Erwin and Dan Remenyi, “Measuring e-Commerce effectiveness: a conceptual model”, ACM International Conference Proceeding Series Vol. 47, pp. 143-152, Sep. 17-19 2003.
[10]Wang Min, Chang Yuan chi, and Padmanabhan Sriram, “Supporting Efficient Parametric Search of e-Commerce Data: A Loosely-Coupled Solution”, 8th Conference on Extending Database Technology (EDBT), pp. 409-426, March 24-28 2002.
[11]FIPS, “FIPS 127-2 - Database Language SQL”, http://www.itl.nist.gov/fipspubs /fip127-2.htm, 1993.
[12]W3C, “Extensible Markup Language (XML) 1.0 (4th Edition)”, http://www.w3.org /TR/REC-xml, 2006.
[13]W3C, “XQuery 1.0: An XML Query Language”, http://www.w3.org/TR/xquery/, 2006.
[14]W3C, “XML Path Language (XPath) Version 1.0”, http://www.w3.org/TR/xpath, 1999.
[15]Microsoft, “SQL Server 2005 Books Online Using XML in SQL Server”, http://msdn2.microsoft.com/en-us/library/ms190936.aspx, 2005.
[16]Microsoft, “SQL Server 2005 Books Online Using Native XML Web Services in SQL Server 2005”, http://msdn2.microsoft.com/en-us/library/ms191274.aspx, 2005.
[17]Oracle, “Oracle XML DB Developer's Guide 10g Release 2 (10.2)”, http://download-west.oracle.com/docs/cd/B19306_01/appdev.102/b14259/toc.htm, 2006.