臺灣博碩士論文加值系統

隨著企業全球化與網際網路的日漸普及，網際網路上的資料倉儲系統已經漸漸地取代傳統集中式的資料倉儲系統，成為資料倉儲架構的主流。透過網際網路，管理者可以更容易取得與分享分散式系統上的資訊，隨著資訊來源的多元化，資料倉儲系統的資訊品質與廣度也會提升，更能幫助管理者制訂宏觀的決策。然而，利用主從式架構的資料倉儲，卻有著許多相容性與成本上的問題。因此本研究將利用XML來建立Web-based的資料倉儲系統，藉由XML的彈性化、自我定義、自我描述、低成本等優點，改善主從式架構系統所不可避免的缺點。
同時，我們使用了pull和push的方法來決定哪些資料可以分享在網路上或是透過E-mail的方式傳送給一般的使用者，如此一來不但可以提升系統的容量及速度，而且還可以提高系統的安全性，以解決傳統資料倉儲系統上的缺失。另外，本系統架構不但可以使用原有的client/server資料倉儲系統也可以使用網路的資料倉儲系統。
最後，我們透過一個實例的執行來驗證我們這個系統架構的正確性，並且我們也用了一個雛形系統來證實這個系統的可行性。

Along with the enterprise globalization and Internet popularization, the web-based Data Warehouse system has gradually replaced the traditional Data Warehouse system and becomes the mainstream structure of the Data Warehouse. Through the Internet, the manager can easily obtain and share the data on the distribution system. Through the multiple data source collections, the quality and broad base of Data Warehouse can be increased and thus help managers to make more decisive policies. But utilizing the basic client/server structure of Data Warehouse can increase many tolerances and cost based problems. This paper will use the XML to establish the web-based Data Warehouse system and utilize the advantage of its flexibility, self-definition, self-description and low cost to improve the unavoidable defect of the client/server Data Warehouse system. We also use pull and push method approaches to determine what information can be shared on the Internet or delivery through e-mail. It can not only improve the scalability and speed, but also enhance the system security. Therefore, it can solve the challenges on the traditional DW system. In addition, this architecture can use for the traditional client/server DW system and web-based DW system. The last, we use a case study to prove validity of this system architecture and we also create a prototype system to prove feasibility of this system architecture.

摘　要I
AbstractII
誌　謝III
Table of ContentsIV
List of FiguresVI
List of TablesVIII
Chapter 1 Introduction1
1.1 Overview1
1.2 Research Motivation and Objectives5
1.3 Research Methodology8
1.4 Organization of the Thesis9
Chapter 2 Related Work10
2.1 The Data Warehouse and Technology10
2.1.1 The Publish and Subscribe Technology12
2.1.2 Data Cube15
2.1.3 Data Warehouse Architectures18
2.2 Development of the Metadata Model23
2.2.1 Metadata Interchange Specification (MDIS)24
2.3 XML Technology27
2.3.1 XSLT Technology28
2.3.2 DOM Technology31
Chapter 3 The XML-based Data Warehouse Architecture34
3.1 The Architecture34
3.2 The Methodology to Develop the System37
3.3 The Metadata of XML Star Schema40
3.4 Step 1: Build XML Star Schema45
3.5 Step 2: Build XML Data Cube48
3.6 XML OLAP Wrapper53
3.6.1 XSLT Template55
3.6.2 XML OLAP Control Operations57
3.6.3 XSLT Processor Object65
3.7 Summary68
Chapter 4 Case Study: A Production Market Database69
Chapter 5 System Implementation and Evaluation80
5.1 Cube Browser81
5.2 Web Data Warehouse Engine83
5.3 Cube Database86
5.4 System Evaluation87
Chapter 6 Conclusion and Future Work89
6.1 Conclusion89
6.2 Research Limitations91
6.3 Future Work92
Bibliography94
Appendix A. The Authors’s Publication List98
Appendix B. The System Application Code99

[1]A.Gupta, V. Harinarayan, and D. Quass, “Aggregate-Query Processing in Data Warehousing Environments”, In Proceedings of the 21st International VLDB Conference, 1995.
[2] Jaideep Srivastava ; Ping-Yao Chen, “Warehouse Creation: A Potential Roadblock to Data Warehousing”, IEEE Transactions on Knowledge and Data Engineering, Vol. 11, No. 1, January/February 1999.
[3]L. Chen, and M. N. Frolick, “Web-Basd DataWarehousing: Fundamentals, Challenges, and Solutions”, Information Systems Management, spring 2000.
[4] Tom Hammergren, “Data Warehousing on the Internet”, International Thomson Computer Press, 1998, ISBN 1-85032-857-9.
[5] Rob Mattison, “Web Warehousing and Knowledge Management”, McGraw-Hill, 1999, ISBN 0-07-041103-4.
[6] R. A. Moeller, “Distributed Data Warehousing Using Web Technology”, AMACOM, 2001, ISBN 0-8144-0588-6.
[7]Huang, S. T. and Lin, Y. Z., “Actual Application Examples for Building Data Warehouse”, The Fifth Seminar on Information Research Management, 1999.
[8] Bontempo C. and Zagelow G., “The IBM Data Warehouse Architecture”, communication of the ACM, Vol. 41. No.9, 1998.
[9] Liu, J. ; Vincent, M., “An Architecture for Data Warehouse Systems”, TENCON '98. 1998 IEEE Region 10 International Conference, Dec. 1998, pp.107-110.
[10] Hammer J., Garcia-Molina H., Widom J., Labio W., and Zhuge Y., “The Stanford Data Warehousing Project”, In IEEE Quart. Bull. Data Eng. 18(2),1995, pp. 41-48.
[11] Labio W., Zhuge Y., Wiener J., Gupta H., Garcia-Molina H., and Widom J., “The WHIPS Prototype for Data Warehouse Creation and Maintenance”, In Proc. ACM SIGMOD Int. Conf. On Management of Data, 1997, pp.370-378.
[12]Surajit Chaudhuri; Umeshwar Dayal, “An Overview of Data Warehousing and OLAP Technology”, ACM SIGMOD Record, Vol.26, No. 1, 1997.
[13]Kurz, A.; Min Tjoa, A., “Data Warehousing within Intranet: Prototype of a Web-based Executive Information System”, Database and Expert Systems Applications, 1997, pp.627 — 632.
[14]Michael Franklin ; Stan Zdonik, “Data In Your Face: Push Technology in Perspective”, ACM SIGMOD, 1998.
[15] Pourabbas Elaheh, and Rafanelli Maurizio, “Hierarchies and Relative Operators in the OLAP Environment”, ACM SIGMOD, Vol. 29, Num. 1, 2000.
[16] Gray J., Chaudhuri S., Bosworth A., Layman A., Reichart D., and Venkatrao M., “Data Cube: A Relational Aggregation Operator Generalizing Group-By, Gross-Tab, and Sub-Totals”, Data Mining and Knowledge Discovery 1, 29-53, 1997.
[17]Anindya Datta ; Helen Thomas, “The Cube Data Model: A conceptual Model and Algebra for On-line Analytical Processing in Data Warehouse”, Decision Support Systems, Vol.27, 1999, pp. 289-301.
[18]J. Han and S. Nishio, “Generalization-based data mining in OODB using an object cube model”, Data and Knowledge Engineering, vol.25 1998.
[19] Zyl, J.; Vincent, M.; Mobania, M., “Representation Of Metadata In A Data　Warehouse”, Proceedings of the 10th International Conference on Global Connectivity in Energy, Computer, communication and control, 1998.
[20] Meta-Data Council, “Meta-Data Interchange Specification (MDIS),” Version1.1, http://www.he.net/~Meta-Data, 1997.
[21]Cheng J. ; Xu. J., “XML and DB2”, Proceedings of 16th International Conference on Data Engineering, 2000.
[22] Jon Bosak ; Tim Bray, “XML and the Second-Generation Web”, Scientific American, May 1999, http://www.sciam.com/1999/0599issue/0599bosak.html
[23] Jon Bosak, “XML, Java, and the future of the Web”, Sun Microsystems, March 10, 1997.
[24]Huang,S. M. ; Kwan, I. ; Yen, C. ; Hsueh,H. Y., ”Developing an XML Gateway for Business-to-Business Commerce”, Proceedings of The 1st International Conference on Web Information Systems Engineering, 2000.
[25]Bert Meltzer ; Robert Glushko, “XML and Electronic Commerce : Enabling the Network Economy”, SIGMOD Record, Vol27, No.4, December 1998.
[26]Commerce Net, “The Impact of XML on EDI”, http://www.nii.org.tw/CNT/info/Report/19980503.htm, 1998.
[27]Robin Cover, “Microsoft Support for XML”, April 01,1998, http://www.oasis-open.org/cover/xmlMicrosoft.html.
[28]Roy, J. ; Ramanujun, A., “Building an XML application: key management issues”, Proceedings of XML Europe 2000 Conference, 2000.
[29]Ceponkus, A. ; Hoodbhoy, F., “Applied XML: A Toolkit for Programmers”, Wiley (pub.), 2000, ISBN: 0-471-34402-8.
[30] David Hunter, “Beginning XML”, Wrox Press Ltd., 2000. ISBN: 1-861003-41-2.
[31]Khun Yee Fung, “XSLT: Working with XML and HTML”, Addison-Wesley, 2000, ISBN: 0-201-71103-6.
[32]Lauren Wood, “Programming the Web: The W3C DOM Specification, SoftQuad Software Inc.”, IEEE Internet Computing, January-February 1999, pp. 48-54.
[33] W3C, “Document Object Model Level 1 Specification”, http://www.w3.org/TR/REC-DOM-Level-1/, Oct. 1998.
[34] Suzuki, J.; Yamamoto, Y., “Toward the Interoperable Software Design Models: Quartet of UML, XML, DOM and CORBA”, Software Engineering Standards, 1999, Proceedings, Fourth IEEE International Symposium and Forum on, 1999, pp.163-172.
[35] Shi-Ming Huang, Yu-Chung Hung, Irene Kwan and Yuan-Mao Hung, “Developing an Active Data Warehouse System”, 2000, 17th International CODATA Conference 15-19 October, 2000, Baveno, Italy.
[36]David Wells, “Wrappers”, Object Services and Consulting, http://www.objs.com/survey/wrap.htm, April 1996.
[37]Ling Liu ; Wei Han ; David Buttler ; Calton Pu ; Wei Tang, “An XML-based Wrapper Generator for Web Information Extraction”, SIGMOD Record, December 1999.
[38] Stroulia, E.; Thomson, J.; Situ, G., “Constructing XML-speaking Wrappers for WEB Applications: Towards an Interoperating WEB”, Proceeding on Seventh Working Conference, 2000, pp.59 —68.
[39]V. Christophides ; S. Cluet ; J. Simeon, “On Wrapping Query Languages and Efficient XML Integration”, ACM SIGMOD Record, 2000.
[40] David A. Stamper, Business Data Communications, The Benjamin/Cummings Publishing Company, Inc., 1991, pp.283, pp.458-460, ISBN 0-8053-7720-4.
[41] Charles Parker; Thomas Case, Management Information Systems: Strategy and Action, Mitchell McGRAW-Hill, 1989, pp.677-679, pp.815-816, ISBN 0-07-113581-2.
[42] Ishikawa, H.; Kubota, K.; Kanemasa, Y.; Noguchi, Y., “The design of a query language for XML data”, Database and Expert Systems Applications, 1999.