學術產出-Theses

Article View/Open

Publication Export

Google ScholarTM

政大圖書館

Citation Infomation

  • No doi shows Citation Infomation
題名 An XML-based Multidimensional Data Exchange Study
以XML為基礎之多維度資料交換之研究
作者 王容
Wang, Jung
貢獻者 諶家蘭
Seng, Jia-Lang
王容
Wang, Jung
關鍵詞 資料倉儲
多維度資料模式
資料方塊
中介資料
資料交換
Data Warehouse
Multidimensional Data Model
Data Cube
Metadata
XML
Data Exchange
日期 2003
上傳時間 18-Sep-2009 19:34:48 (UTC+8)
摘要 在全球化趨勢與Internet帶動速度競爭的影響下,現今的企業經常採取將旗下部門分散佈署於各地,或者和位於不同地區的公司進行合併結盟的策略,藉以提昇其競爭力與市場反應能力。由於地理位置分散的結果,這類企業當中通常存在著許多不同的資料倉儲系統;為了充分支援管理決策的需求,這些不同的資料倉儲當中的資料必須能夠進行交換與整合,因此需要有一套開放且獨立的資料交換標準,俾能經由Internet在不同的資料倉儲間交換多維度資料。然而目前所知的跨資料倉儲之資料交換解決方案多侷限於逐列資料轉換或是以純文字檔案格式進行資料轉移的方式,這些方式除缺乏效率外亦不夠系統化。在本篇研究中,將探討多維度資料交換的議題,並發展一個以XML為基礎的多維度資料交換模式。本研究並提出一個基於學名結構的方法,以此方法發展一套單一的標準交換格式,並促成分散各地的資料倉儲間形成多對多的系統化映對模式。以本研究所發展之多維度資料模式與XML資料模式間的轉換模式為基礎,並輔以本研究所提出之多維度中介資料管理功能,可形成在網路上通用且以XML為基礎的多維度資料交換過程,並能兼顧效率與品質。本研究並開發一套雛型系統,以XML為基礎來實作多維度資料交換,藉資證明此多維度資料交換模式之可行性,並顯示經由中介資料之輔助可促使多維度資料交換過程更加系統化且更富效率。
Motivated by the globalization trend and Internet speed competition, enterprise nowadays often divides into many departments or organizations or even merges with other companies that located in different regions to bring up the competency and reaction ability. As a result, there are a number of data warehouse systems in a geographically-distributed enterprise. To meet the distributed decision-making requirements, the data in different data warehouses is addressed to enable data exchange and integration. Therefore, an open, vendor-independent, and efficient data exchange standard to transfer data between data warehouses over the Internet is an important issue. However, current solutions for cross-warehouse data exchange employ only approaches either based on records or transferring plain-text files, which are neither adequate nor efficient. In this research, issues on multidimensional data exchange are studied and an XML-based Multidimensional Data Exchange Model is developed. In addition, a generic-construct-based approach is proposed to enable many-to-many systematic mapping between distributed data warehouses, introducing a consistent and unique standard exchange format. Based on the transformation model we develop between multidimensional data model and XML data model, and enhanced by the multidimensional metadata management function proposed in this research, a general-purpose XML-based multidimensional data exchange process over web is facilitated efficiently and improved in quality. Moreover, we develop an XML-based prototype system to exchange multidimensional data, which shows that the proposed multidimensional data exchange model is feasible, and the multidimensional data exchange process is more systematic and efficient using metadata.
參考文獻 中文參考文獻
1. 王祥安 (2001). 具智慧分析與Metadata交換能力之醫療資訊系統架構之研究. 屏東科技大學資訊管理系碩士論文.
2. 王瑞娟 (2002). 資料交換與查詢在XML文件與關連資料庫之間. 政治大學資訊管理學系碩士論文.
3. 沈兆陽 (2001). 資料倉儲與Analysis Services : SQL Server 2000的OLAP解決方案. 臺北市:文魁資訊.
4. 李卓翰 (2003). 資料倉儲理論與實務. 臺北市:學貫行銷.
5. 吳欽龍 (2002). Metadata管理於企業資訊之整合運用. 元智大學資訊管理學系碩士論文.
6. 林宏諭 (2001). SQL2000之決策分析:OLAP建置與應用. 臺北縣:博碩文化.
7. 陳弘馨 (2003). Excel統計資訊分析實務:樞紐分析/OLAP/Access整合應用. 臺北市:文魁資訊.
8. 葉耿志 (2003). 資料交換機制之研究─以我國動植物防檢局為例. 政治大學資訊管理研究所碩士論文.
9. 程繼瑩 (2003). 應用動態XML對映機制輔助產業資料標準轉換─以石化產業為例. 中原大學資訊管理學系碩士論文.
English References
1. Abello, A, Samos, J., & Saltor, F. (2000). A Data Warehouse Multidimensional Data Models Classification. Technical Report LSI-2000-6, Dept. Llenguages y Sistemas Informáticos, Universitat Politècnica de Catalunya.
2. Abello, A, Samos, J., and Saltor, F. (2001). A Framework for the Classification and Description of Multidimensional Data Models. Proceedings of 12th International Conference on Database and Expert Systems Applications (DEXA 2001), 668-677.
3. Auth, G., & Maur, E. (2002). A Software Architecture for XML-Based Metadata Interchange in Data Warehouse Systems. Proceedings of EDBT 2002 Workshop on XML Data Management (XMLDM), 1-14.
4. Auth, G., Maur, E., and Helfert, M. (2002). A Model-based Software Architecture for Metadata Management in Data Warehouse Systems. Proceedings of BIS 2002, 1-8.
5. Binh, N. T., Tjoa, A. M., & Mangisengi, O. (2001). MetaCube-X: An XML Metadata Foundation for Interoperability Search among Web Warehouses. Proceedings of the 3rd Intl. Workshop on Design and Management of Data Warehouses (DMDW`2001), 8.1-8.8.
6. Bontempo, C., & Zagelow, G. (1998). The IBM Data Warehouse Architecture. Communications of the ACM, 41(9), 38-48.
7. Bourret, R. (2003). XML and Databases. Retrieved January 30,2004, from http://www.rpbourret.com/xml/XMLAndDatabases.htm.
8. Carneiro, L. (2002). X-META: A Methodology for Data Warehouse Design with Metadata Management. Proceedings of the 4th Intl. Workshop DMDW`2002, 13-22.
9. Carlson, D. (2001). Modeling XML Applications with UML: Practical e-Business Applications, Taipei: Pearson Education Taiwan.
10. Chamberlin, D. (2002). XQuery: An XML Query Language, IBM Systems Journal, 41(4), 597-615.
11. Chaudhuri, S., & Dayal, U. (1997). An Overview of Data Warehousing and OLAP Technology. ACM SIGMOD Record, 26(1), 65-74.
12. Chaudhuri, S., Dayal, U., & Ganti, V. (2001). Database Technology for Decision Support Systems, IEEE Computer, 34(12), 48-55.
13. Cheng, Yi-Sheng. (2001). An Investigation of an XML Web Data Warehouse System Architecture. Unpublished Master Thesis, Department of Computer Science and Engineering, Tatung University.
14. Codd, E. F., Codd, S. B., & Salley, C. T. (1993). Providing OLAP to User-Analysts: An IT Mandate. Codd & Associates, Retrieved January 30,2004, from http://www.datawarehouse.com/iknowledge/whitepapers/hyperion_61.pdf.
15. Colossi, N., Malloy, W., & Reinwald, B. (2002). Relational extensions for OLAP. IBM Systems Journal, 41(4), 714-731.
16. Datta, A., & Thomas, H. (1999). The cube data model: a conceptual model and algebra for on-line analytical processing in data warehouse,. Decision Support Systems, 27(3), 289-301.
17. Dinter, B., Sapia, C., Hofling, G., & Blaschka, M. (1998). The OLAP Market: State of the Art and Research Issues. Proc. First International Workshop on Data Warehousing and OLAP (DOLAP’98), 22-27.
18. Dinter, B., Sapia, C., Blaschka, M., & Hofling, G. (1999). OLAP Market and Research: Initiating the Cooperation,” Journal of Computer Science and Information Management, 2(3).
19. Do, H. H. & Rahm, E. (2000). On Metadata Interoperability in Data Warehouses. Technical Report 01-2000, Department of Computer Science, University of Leipzig.
20. Fankhauser, P., & Klement, T. (2003). XML for Data Warehousing Chances and Challenges. Proc. of the 5th International Conference on Data Warehousing and Knowledge Discovery (DaWaK 2003), 1-3.
21. Gottschalk, K., Graham, S., Kreger, H., & Snell, J. (2002). Introduction to Web services architecture. IBM Systems Journal, 41(2), 170-177.
22. Gray, J., Chaudhuri, S., Bosworth, A., Layman, A., Reichart, D., & Venkatrao, M. (1997). Data Cube: A Relational Aggregation Operator Generalizing Group-By, Cross-Tab, and Sub-Totals. Data Mining and Knowledge Discovery, 1(1), 29-53.
23. Hammer, J., Garcia-Molina, H., Widom, J., Labio, W. & Zhuge, Y. (1995). The Stanford Data Warehousing Project. IEEE Data Engineering Bulletin, Special Issue on Materialized Views and Data Warehousing, 18(2), 41-48.
24. Harold, E. R. (2001). XML Bible (2nd Edition). New York: John Wiley & Sons.
25. Huang, S., & Su, C. (2002). The Development of an XML-Based Data Warehouse System. Proceeding of Third International Conference on Intelligent Data Engineering and Automated Learning (IDEAL 2002), 206-212.
26. Hummer, W., Bauer, A., & Harde, G. (2003). XCube-XML For Data Warehouses. Proceedings of Sixth International Workshop on Data Warehousing and OLAP (DOLAP’03), 33-40.
27. Hummer, W., Lehner, W., Bauer, A., & Schlesinger, L. (2002). A Decathlon in Multidimensional Modeling: Open Issues and Some Solutions. Proceedings of the 4th International Conference on Data Warehousing and Knowledge Discovery (DaWaK 2002), 275-285.
28. Hung, Yuan-Mao. (2000). A Generic Architecture for Active Data Warehouse Systems. Unpublished Master Thesis, Department of Computer Science and Engineering, Tatung University.
29. Inmon, W. H. (1996). Building the Data Warehouse (Second Edition). New York: John Wiley & Sons.
30. Inmon, W. H., Welch, J. D., & Glassey, K. L. (1997). Managing the Data Warehouse. New York: John Wiley & Sons.
31. Jarke, M., Lenzerini, M., Vassiliou, Y., & Vassiliadis, P. (2000). Fundamentals of Data Warehouses. Berlin: Springer-Verlag.
32. Katz, H., & Chamberlin, D. D. (2004). XQuery from the experts: a guide to the W3C XML query language. Boston: Addison-Wesley.
33. Kelly, T. J. (2002). Dimensional Data Modeling. Retrieved January 30,2004, from http://www.olap.it/Articoli/Dimensional%20data%20modeling.mht.
34. Kimball, R. (1996). The data warehouse toolkit: practical techniques for building dimensional data warehouses. New York: John Wiley & Sons.
35. Kimball, R. (1997). A Dimensional Modeling Manifesto. DBMS and Internet Systems, Retrieved January 30,2004, from http://www.dbmsmag.com/9708d15.html.
36. Kimball, R., Reeves, L., Ross, M., and Thornthwaite, W. (1998). The Data Warehouse Lifecycle Toolkit. New York: John Wiley & Sons.
37. Kuo, Wan-Yu. (2003). A Generic Construct based Transformation Model between UML Data Model and XML. Unpublished Master Thesis, Department of Management Information System, National Chengchi University.
38. Lee, I., Lee, M., & Yong, H. (2002). EDMIS: Metadata Interchange System for OLAP. Proceedings of First EurAsian Conference on Information and Communication Technology (EurAsia-ICT 2002), 297-305.
39. Lemi, R., Lambert, V., & Nachouki, M-P. (1997). Data Warehousing tool’s architecture: from multidimensional analysis to data mining. Proceedings of Eighth International Workshop on Database and Expert System Application, 636-643.
40. Lujan-Mora, S., Medina, E., & Trujillo J. (2002). A Web-Oriented Approach to Manage Multidimensional Models through XML Schemas and XSLT. Proceedings of EDBT Workshops 2002, 29-44.
41. Marcel, P. (1999). Modeling and querying multidimensional databases: an overview. Networking and Information Systems Journal, 2(5-6), 515-548.
42. Marco, D. (2000). Building and Managing the Meta Data Repository: A Full Lifecycle Guide. New York: John Wiley & Sons.
43. Moeller, R. A. (2001). Distributed Data Warehousing using Web Technology. New York: AMACOM.
44. Mohania, M., Samtani, S., Roddick, J., & Kambayashi, Y. (1999). Advances and Research Directions in Data Warehousing Technology. The Australian Journal of Information Systems (AJIS), 7(1), 41-59.
45. Muller, R., Stohr, T., & Rahm, E. (1999). An Integrative and Uniform Model for Metadata Management in Data Warehousing Environments. Proceedings of the Intl. Workshop on Design and Management of Data Warehouses (DMDW`99), 12-1-12-16.
46. Olsen, G. (2000). An Overview of B2B Integration. eAI Journal, 28-36.
47. Pedersen, T. B., & Jensen, C. S. (2001). Multidimensional Database Technology. IEEE Computer, 34(12), 40-46.
48. Pendse, N. (2002). Commentary: OLAP API wars. The OLAP Report, Retrieved March 14,2004, from http://www.olapreport.com/Comment_APIs.htm.
49. Poole, J., Change, D., Tolbert, D., & Mellor, D. (2001). Common Warehouse Metamodel: An Introduction to the Standard for Data Warehouse Integration. New York: John Wiley & Sons.
50. Roddick, J. F. (1995). A survey of schema versioning issues for database systems. Information and Software Technology, 37(7), 383-393.
51. Samtani, S., Mohania, M., Kumar, V., & Kambayashi, Y. (1998). Recent Advances and Research Problems in Data Warehousing. Proceedings of ER Workshops 1998, 81-92.
52. Sapia, C., Blaschka, M., and Hofling, G. (1999). An Overview of Multidimensional Data Models for OLAP. FORWISS Technical Report 1999-01.
53. Silverstone, L., Inmon, W. H., & Graziano, K. (1997). The data model resource book: a library of logical data models and data warehouse designs. New York: John Wiley & Sons.
54. Staudt, M., Vaduva, A., & Vetterli, T. (1999a). Metadata Management and Data Warehousing. Technical Report 21, Swiss Life, Information System Research.
55. Staudt, M., Vaduva, A., & Vetterli, T. (1999b). The Role of Metadata for Data Warehousing. Technical Report 99.06, Department of Information Technology, University of Zurich.
56. Thomsen, E. (1997). OLAP solutions: building multidimensional information systems. New York: John Wiley & Sons.
57. Vaduva, A., & Dittrich, K. R. (2000). Metadata Management for Data Warehousing: Between Vision and Reality. Technical Report 2000.08, Department of Information Technology, University of Zurich.
58. Vaduva, A., & Dittrich, K. R. (2001). Metadata Management for Data Warehousing: Between Vision and Reality. Proc. of the 2001 International Database Engineering & Applications Symposium (IDEAS`01), 129-138.
59. Vaisman, A. A., (1998). OLAP, Data Warehousing, and Materialized Views: a Survey. Technical Reports TR-98-015, Department of Computation, University of Buenos Aires, 1-24.
60. Valentine, C. (2002). XML Schema. San Francisco: Sybex.
61. Vassiliadis, P. (1998). Modeling Multidimensional Databases, Cubes, and Cube Operations. Proceedings of 10th International Conference on Scientific and Statistical Database Management, 53-62.
62. Vassiliadis, P. (2000). Gulliver in the land of data warehousing: practical experiences and observations of a researcher. Proceeding of the International Workshop on Design and Management of Data Warehouses (DMDW’2000), 12.1-12.16.
63. Vassiliadis, P., & Sellis, T. (1999). A Survey of Logical Models for OLAP Databases. ACM SIGMOD Record, 28(4), 64-69.
64. Vetterli, T., Vaduva, A. & Staudt, M. (2000). Metadata Standards for Data Warehousing: Open Information Model vs. Common Warehouse Metamodel. ACM SIGMOD Record, 29(3), 68-75.
65. Widom, J. (1995). Research Problems in Data Warehousing. Proceedings of the 4th Int`l Conference on Information and Knowledge Management (CIKM), 25-30.
66. Wu, M-C., & Buchmann, A. P. (1997). Research Issues in Data Warehousing. Proceedings of Datenbanksysteme in Buro, Technik und Wissenschaft (BTW’97), 61-82.
67. Wyke, R. A., & Watt, A. (2002). XML Schema Essentials. New York: John Wiley & Sons.
Internet References
1. Business Intelligence & Data Warehouse Resource Center, http://www.olap.it
2. The CoverPages, http://xml.coverpages.org
3. Data Management-ADTmag.com, http://www.adtmag.com/section.asp?section=data
4. Data Management Center, http://www.infogoal.com/dmc/dmchome.htm
5. Data Warehousing, http://www.1keydata.com/datawarehousing/datawarehouse.html
6. The Data Warehousing Information Center, http://www.dwinfocenter.org
7. The Data Warehousing Institute, http://www.dw-institute.com/index.asp
8. DMReview, http://www.dmreview.com
9. Enterprise Warehousing Solutions, http://www.ewsolutions.com
10. IBM Software: Solutions: Web Services by IBM, http://www-306.ibm.com/software/solutions/webservices/
11. Inmon Associates, http://www.billinmon.com
12. ITtoolbox Data Warehouse, http://datawarehouse.ittoolbox.com/
13. Object Management Group, http://www.omg.org
14. The OLAP Report, http://www.olapreport.com/index.htm
15. Ralph Kimball Associates, http://www.rkimball.com/
16. XCube, http://www.xcube-open.org
17. XML for Analysis (XMLA), http://www.xmla.org
18. Cover Pages (2003), W3C Document Object Model, http://xml.coverpages.org/dom.html
19. Harde, G. (2003a), XML Schemata for XCubeSchema, version 0.5, http://www.xcube-open.org/V_0_5/XCubeSchema.xsd
20. Harde, G. (2003b), XML Schemata for XCubeDimension, version 0.5, http://www.xcube-open.org/V_0_5/XCubeDimension.xsd
21. Harde, G. (2003c), XML Schemata for XCubeFact, version 0.5, http://www.xcube-open.org/V_0_5/XCubeFact.xsd
22. Nigel, P., Richard, C. (2003), “What is OLAP?”, http://www.olapreport.com/fasmi.htm
23. Object Management Group (2002), Model-Driven Architecture, http://www.omg.org/mda
24. Object Management Group (2003a), Common Warehouse Metamodel (CWM) Specification, V1.1,http://www.omg.org/technology/documents/formal/cwm.htm
25. Object Management Group (2003b), The Data Warehousing, CWM and MOF Resource Page, http://www.omg.org/cwm
26. Object Management Group (2003c), “Unified Modeling Language (UML), version 1.5”, http://www.omg.org/technology/documents/formal/uml.htm
27. Object Management Group (2003d), XML Metadata Interchange (XMI), http://www.omg.org/technology/documents/formal/xmi.htm
28. Object Management Group (2004), Catalog of OMG Modeling and Metadata Specifications, http://www.omg.org/technology/documents/modeling_spec_catalog.htm
29. SearchDatabase.com, http://searchdatabase.techtarget.com/
30. Transaction Processing Performance Council (TPC) (2003), “The TPC Benchmark™H (TPC-H) Standard Specification Revision 2.1.0”, http://www.tpc.org/tpch/spec/tpch2.1.0.pdf
31. World Wide Web Consortium (W3C) (1998), “Document Object Model Level 1 Specification”, http://www.w3.org/TR/REC-DOM-Level-1/
32. W3C (2000),”Document Object Model Level 2 Core Specification”, http://www.w3.org/TR/DOM-Level-2-Core
33. W3C (2001a), “XML Schema Part 0: Primer”, http://www.w3.org/TR/xmlschema-0/
34. W3C (2001b), “XML Schema Part 1: Structures”, http://www.w3.org/TR/xmlschema-1/
35. W3C (2001c), “XML Schema Part 2: Datatypes”, http://www.w3.org/TR/xmlschema-2/
36. W3C (2000), Document Object Model (DOM), http://www.w3.org/DOM/
37. W3C (2003), XQuery 1.0: An XML Query Language, http://www.w3.org/TR/xquery/
38. W3C (2004), “Extensible Markup Language (XML) 1.0 (Third Edition)”, http://www.w3.org/TR/2004/REC-xml-20040204
39. W3C (2002), Web Services Architecture, http://www.w3.org/TR/2002/WD-ws-arch-20021114/
40. W3C (2004), Web Services Activity, http://www.w3.org/2002/ws/
41. XMLA (2002), XML for Analysis Specification Version 1.1, http://www.xmla.org/spec/1.1/xmla1.1.doc
描述 碩士
國立政治大學
資訊管理研究所
91356024
92
資料來源 http://thesis.lib.nccu.edu.tw/record/#G0091356024
資料類型 thesis
dc.contributor.advisor 諶家蘭zh_TW
dc.contributor.advisor Seng, Jia-Langen_US
dc.contributor.author (Authors) 王容zh_TW
dc.contributor.author (Authors) Wang, Jungen_US
dc.creator (作者) 王容zh_TW
dc.creator (作者) Wang, Jungen_US
dc.date (日期) 2003en_US
dc.date.accessioned 18-Sep-2009 19:34:48 (UTC+8)-
dc.date.available 18-Sep-2009 19:34:48 (UTC+8)-
dc.date.issued (上傳時間) 18-Sep-2009 19:34:48 (UTC+8)-
dc.identifier (Other Identifiers) G0091356024en_US
dc.identifier.uri (URI) https://nccur.lib.nccu.edu.tw/handle/140.119/36781-
dc.description (描述) 碩士zh_TW
dc.description (描述) 國立政治大學zh_TW
dc.description (描述) 資訊管理研究所zh_TW
dc.description (描述) 91356024zh_TW
dc.description (描述) 92zh_TW
dc.description.abstract (摘要) 在全球化趨勢與Internet帶動速度競爭的影響下,現今的企業經常採取將旗下部門分散佈署於各地,或者和位於不同地區的公司進行合併結盟的策略,藉以提昇其競爭力與市場反應能力。由於地理位置分散的結果,這類企業當中通常存在著許多不同的資料倉儲系統;為了充分支援管理決策的需求,這些不同的資料倉儲當中的資料必須能夠進行交換與整合,因此需要有一套開放且獨立的資料交換標準,俾能經由Internet在不同的資料倉儲間交換多維度資料。然而目前所知的跨資料倉儲之資料交換解決方案多侷限於逐列資料轉換或是以純文字檔案格式進行資料轉移的方式,這些方式除缺乏效率外亦不夠系統化。在本篇研究中,將探討多維度資料交換的議題,並發展一個以XML為基礎的多維度資料交換模式。本研究並提出一個基於學名結構的方法,以此方法發展一套單一的標準交換格式,並促成分散各地的資料倉儲間形成多對多的系統化映對模式。以本研究所發展之多維度資料模式與XML資料模式間的轉換模式為基礎,並輔以本研究所提出之多維度中介資料管理功能,可形成在網路上通用且以XML為基礎的多維度資料交換過程,並能兼顧效率與品質。本研究並開發一套雛型系統,以XML為基礎來實作多維度資料交換,藉資證明此多維度資料交換模式之可行性,並顯示經由中介資料之輔助可促使多維度資料交換過程更加系統化且更富效率。zh_TW
dc.description.abstract (摘要) Motivated by the globalization trend and Internet speed competition, enterprise nowadays often divides into many departments or organizations or even merges with other companies that located in different regions to bring up the competency and reaction ability. As a result, there are a number of data warehouse systems in a geographically-distributed enterprise. To meet the distributed decision-making requirements, the data in different data warehouses is addressed to enable data exchange and integration. Therefore, an open, vendor-independent, and efficient data exchange standard to transfer data between data warehouses over the Internet is an important issue. However, current solutions for cross-warehouse data exchange employ only approaches either based on records or transferring plain-text files, which are neither adequate nor efficient. In this research, issues on multidimensional data exchange are studied and an XML-based Multidimensional Data Exchange Model is developed. In addition, a generic-construct-based approach is proposed to enable many-to-many systematic mapping between distributed data warehouses, introducing a consistent and unique standard exchange format. Based on the transformation model we develop between multidimensional data model and XML data model, and enhanced by the multidimensional metadata management function proposed in this research, a general-purpose XML-based multidimensional data exchange process over web is facilitated efficiently and improved in quality. Moreover, we develop an XML-based prototype system to exchange multidimensional data, which shows that the proposed multidimensional data exchange model is feasible, and the multidimensional data exchange process is more systematic and efficient using metadata.en_US
dc.description.tableofcontents Table of Contents
CHAPTER 1 INTRODUCTION 1
1.1 Research Motivation 1
1.2 Research Issue 2
1.3 Research Objective 3
1.4 Research Flow 4
1.5 Organization of Thesis 4
CHAPTER 2 LITERATURE REVIEW 6
2.1 Data Warehouse Systems 6
2.1.1 Data Warehouse Architecture 6
2.1.2 Data Warehouse and OLAP 8
2.1.3 Data Warehouse Research Issues 9
2.2 Multidimensional Data Modeling 10
2.2.1 Data Cube 11
2.2.2 Star Schema and Snowflake Schema 12
2.2.3 Multidimensional Data Modeling Open Issues 13
2.2.4 XML Standards for Multidimensional Data 15
2.2.5 XCube 19
2.3 Metadata Management for Data Warehousing 23
2.3.1 Classification of Data Warehouse Metadata 24
2.3.2 Metadata Repository Architecture 25
2.3.3 Metadata Interoperability and Integration 27
2.3.4 Metadata Standards for Data Warehousing 30
CHAPTER 3 RESEARCH METHOD 33
3.1 Research Structure 33
3.2 Multidimensional Data Exchange Transformation Model 36
3.2.1 The XML-based Data Cube 36
3.2.2 Transformation Between Data Cube and XML-based Data Cube 38
3.3 Research Model 40
3.4 Components of Research Model 42
3.4.1 XML-based Metadata Management Module 43
3.4.2 XML-based Data Cube Export Module 47
3.4.3 XML-based Data Cube Import Module 57
3.4.4 Repositories 61
3.5 Summary 64
CHAPTER 4 RESEARCH PROTOTYPE 65
4.1 Prototype System Architecture 65
4.2 Prototype System Platform 66
4.3 Prototype System Design 67
4.3.1 Export 68
4.3.2 Import 69
4.3.3 Maintain 70
4.4 A Simple Sample Data Set 70
4.5 Prototype System Presentation 72
4.5.1 Exporting XML-based Data Cube 72
4.5.2 Importing XML-based Data Cube 81
4.5.3 Maintenance 87
CHAPTER 5 RESEARCH DISCUSSIONS 90
5.1 Research Implications 90
5.2 Research Limitations 93
CHAPTER 6 CONCLUSIONS AND FUTURE RESEARCH DIRECTIONS 94
6.1 Concluding Remarks 94
6.2 Future Research Directions 96
REFERENCES 98
中文參考文獻 98
English References 98
Internet References 103
APPENDIX A: XML DOCUMENT SPECIFICATION 105

List of Figures
Figure 1-1 Research Flow 5
Figure 2-1 Typical Data Warehouse Architecture 7
Figure 2-2 A “Sales” Data Cube Example 11
Figure 2-3 A Star Schema 12
Figure 2-4 A Snowflake Schema 13
Figure 2-5 Hierarchical Structure of an XCubeSchema Document 21
Figure 2-6 Hierarchical Structure of an XCubeDimension Document 21
Figure 2-7 Hierarchical Structure of an XCubeFact Document 22
Figure 2-8 Metadata Spreading in the Data Warehousing Environment 24
Figure 2-9 Architectural Approach for Metadata Management 25
Figure 2-10 Metadata Exchange through Metadata File Import/Export 28
Figure 2-11 Metadata Exchange through Repository API 28
Figure 2-12 Metadata Exchange through Metadata Wrapper 29
Figure 2-13 Common Warehouse Metamodel (CWM) 31
Figure 3-1 XML-based Multidimensional Data Exchange Research Structure 34
Figure 3-2 Relationship between Data Cube and XML-based Data Cube Documents 37
Figure 3-3 Bi-directional Transformation between Data Cube and XML-based Data Cube 38
Figure 3-4 XML-based Multidimensional Data Exchange Research Structure in Detail 39
Figure 3-5 Framework of Research Model 40
Figure 3-6 Components of Modules in Research Model 43
Figure 3-7 XML-based Metadata Management Module Design 45
Figure 3-8 An Example of Multidimensional Metadata Model 46
Figure 3-9 XML-based Data Cube Export Module Design 47
Figure 3-10 A “Sales” Star Schema 48
Figure 3-11 Dimension Hierarchies 49
Figure 3-12 Transformation from Data Cube to XML-based Data Cube 50
Figure 3-13 Relationship between Data Cube and XML-based Data Cube 53
Figure 3-14 An Example of XML-based Data Cube Dimension Data Model 55
Figure 3-15 An Example of XML-based Data Cube Fact Data Model 55
Figure 3-16 XML-based Data Cube Import Module Design 57
Figure 3-17 Transformation from XML-based Data Cube to Data Cube 60
Figure 3-18 Repositories Design 62
Figure 4-1 Prototype System Architecture 66
Figure 4-2 Prototype System Design 68
Figure 4-3 Star Schema of the “Insurance Policy” Data Cube 71
Figure 4-4 Home Page of the Prototype System 72
Figure 4-5 Operational Process of Functions in Export Module 73
Figure 4-6 The Fact Table Selection Interface 73
Figure 4-7 The Measure Definition Interface 74
Figure 4-8 The Dimension Table Selection Interface 74
Figure 4-9 The Level Definition Interface 75
Figure 4-10 The Data Cube and Dimension Confirmation and Description Interface 76
Figure 4-11 The Successful Transformation Interface (Export) 77
Figure 4-12 The Successful Transformation Interface (Export) (Continued) 77
Figure 4-13 The Structure of the XML-based Data Cube Schema Script File 78
Figure 4-14 An Example of the XML-based Data Cube Schema Script File 79
Figure 4-15 The Structure of the XML-based Data Cube Dimension Document 79
Figure 4-16 The Structure of the XML-based Data Cube Fact File 80
Figure 4-17 The Successful Export Interface 81
Figure 4-18 Operational Process of Functions in Import Module 81
Figure 4-19 The Latest XML-based Data Cube List Interface 82
Figure 4-20 The Query-by-Criteria Interface 82
Figure 4-21 The Details on XML-based Data Cube Interface 83
Figure 4-22 The Successful Download Interface 84
Figure 4-23 The Successful Transformation Interface (Import) 85
Figure 4-24 The Successful Import Interface 85
Figure 4-25 The OLAP Result of Exporters’ Data Cube 86
Figure 4-26 The OLAP Result of Importers’ Data Cube 86
Figure 4-27 Index Page of the Maintain Module 87
Figure 4-28 The XML-based Data Cube Management Interface 88
Figure 4-29 The XML-based Data Cube Generation/Exchange/Maintenance Log Interface 89
Figure 4-30 The Template File Download Interface 89

List of Tables
Table 2-1 Typical OLAP Operations 8
Table 2-2 Data Warehouse Lifecycle Steps, Potential Problems and Solutions (Partial) 10
Table 2-3 One of the Open Issues on Multidimensional Modeling 14
Table 2-4 Description of XML Schemas 16
Table 2-5 Description of XML Related Techniques 16
Table 2-6 Related Works on XML-based Multidimensional Metadata and Data Exchange 17
Table 2-7 Overview of the XCube Family 20
Table 2-8 XCubeSchema Blocks 20
Table 2-9 XCubeDimension Blocks 22
Table 2-10 XCubeFact Blocks 23
Table 2-11 Classification of Data Warehouse Metadata 24
Table 2-12 Comparison of the Metadata Repository Architectures 26
Table 2-13 Comparison of the Metadata Exchange Methods 29
Table 3-1 Open Issues in Related Works and Solution of This Research 35
Table 3-2 Adoption and Extension from Related Work 35
Table 3-3 XML-based Data Cube Documents Description 38
Table 3-4 Requirements for Metadata Management 43
Table 3-5 Comparison of Star/Snowflake Schema Constructs and XML Schema Constructs 51
Table 3-6 Mapping of Star Schema and XML Schema 51
Table 3-7 Mapping of Snowflake Schema and XML Schema 52
Table 3-8 Mappings between Data Cube and XML-based Data Cube 53
Table 3-9 Description of Metadata Manipulation Function 58
Table 3-10 Relationship between Relational Tables and XML-based Data Cube Documents 60
Table 4-1 Prototype System Platform 67
zh_TW
dc.language.iso en_US-
dc.source.uri (資料來源) http://thesis.lib.nccu.edu.tw/record/#G0091356024en_US
dc.subject (關鍵詞) 資料倉儲zh_TW
dc.subject (關鍵詞) 多維度資料模式zh_TW
dc.subject (關鍵詞) 資料方塊zh_TW
dc.subject (關鍵詞) 中介資料zh_TW
dc.subject (關鍵詞) 資料交換zh_TW
dc.subject (關鍵詞) Data Warehouseen_US
dc.subject (關鍵詞) Multidimensional Data Modelen_US
dc.subject (關鍵詞) Data Cubeen_US
dc.subject (關鍵詞) Metadataen_US
dc.subject (關鍵詞) XMLen_US
dc.subject (關鍵詞) Data Exchangeen_US
dc.title (題名) An XML-based Multidimensional Data Exchange Studyzh_TW
dc.title (題名) 以XML為基礎之多維度資料交換之研究zh_TW
dc.type (資料類型) thesisen
dc.relation.reference (參考文獻) 中文參考文獻zh_TW
dc.relation.reference (參考文獻) 1. 王祥安 (2001). 具智慧分析與Metadata交換能力之醫療資訊系統架構之研究. 屏東科技大學資訊管理系碩士論文.zh_TW
dc.relation.reference (參考文獻) 2. 王瑞娟 (2002). 資料交換與查詢在XML文件與關連資料庫之間. 政治大學資訊管理學系碩士論文.zh_TW
dc.relation.reference (參考文獻) 3. 沈兆陽 (2001). 資料倉儲與Analysis Services : SQL Server 2000的OLAP解決方案. 臺北市:文魁資訊.zh_TW
dc.relation.reference (參考文獻) 4. 李卓翰 (2003). 資料倉儲理論與實務. 臺北市:學貫行銷.zh_TW
dc.relation.reference (參考文獻) 5. 吳欽龍 (2002). Metadata管理於企業資訊之整合運用. 元智大學資訊管理學系碩士論文.zh_TW
dc.relation.reference (參考文獻) 6. 林宏諭 (2001). SQL2000之決策分析:OLAP建置與應用. 臺北縣:博碩文化.zh_TW
dc.relation.reference (參考文獻) 7. 陳弘馨 (2003). Excel統計資訊分析實務:樞紐分析/OLAP/Access整合應用. 臺北市:文魁資訊.zh_TW
dc.relation.reference (參考文獻) 8. 葉耿志 (2003). 資料交換機制之研究─以我國動植物防檢局為例. 政治大學資訊管理研究所碩士論文.zh_TW
dc.relation.reference (參考文獻) 9. 程繼瑩 (2003). 應用動態XML對映機制輔助產業資料標準轉換─以石化產業為例. 中原大學資訊管理學系碩士論文.zh_TW
dc.relation.reference (參考文獻) English Referenceszh_TW
dc.relation.reference (參考文獻) 1. Abello, A, Samos, J., & Saltor, F. (2000). A Data Warehouse Multidimensional Data Models Classification. Technical Report LSI-2000-6, Dept. Llenguages y Sistemas Informáticos, Universitat Politècnica de Catalunya.zh_TW
dc.relation.reference (參考文獻) 2. Abello, A, Samos, J., and Saltor, F. (2001). A Framework for the Classification and Description of Multidimensional Data Models. Proceedings of 12th International Conference on Database and Expert Systems Applications (DEXA 2001), 668-677.zh_TW
dc.relation.reference (參考文獻) 3. Auth, G., & Maur, E. (2002). A Software Architecture for XML-Based Metadata Interchange in Data Warehouse Systems. Proceedings of EDBT 2002 Workshop on XML Data Management (XMLDM), 1-14.zh_TW
dc.relation.reference (參考文獻) 4. Auth, G., Maur, E., and Helfert, M. (2002). A Model-based Software Architecture for Metadata Management in Data Warehouse Systems. Proceedings of BIS 2002, 1-8.zh_TW
dc.relation.reference (參考文獻) 5. Binh, N. T., Tjoa, A. M., & Mangisengi, O. (2001). MetaCube-X: An XML Metadata Foundation for Interoperability Search among Web Warehouses. Proceedings of the 3rd Intl. Workshop on Design and Management of Data Warehouses (DMDW`2001), 8.1-8.8.zh_TW
dc.relation.reference (參考文獻) 6. Bontempo, C., & Zagelow, G. (1998). The IBM Data Warehouse Architecture. Communications of the ACM, 41(9), 38-48.zh_TW
dc.relation.reference (參考文獻) 7. Bourret, R. (2003). XML and Databases. Retrieved January 30,2004, from http://www.rpbourret.com/xml/XMLAndDatabases.htm.zh_TW
dc.relation.reference (參考文獻) 8. Carneiro, L. (2002). X-META: A Methodology for Data Warehouse Design with Metadata Management. Proceedings of the 4th Intl. Workshop DMDW`2002, 13-22.zh_TW
dc.relation.reference (參考文獻) 9. Carlson, D. (2001). Modeling XML Applications with UML: Practical e-Business Applications, Taipei: Pearson Education Taiwan.zh_TW
dc.relation.reference (參考文獻) 10. Chamberlin, D. (2002). XQuery: An XML Query Language, IBM Systems Journal, 41(4), 597-615.zh_TW
dc.relation.reference (參考文獻) 11. Chaudhuri, S., & Dayal, U. (1997). An Overview of Data Warehousing and OLAP Technology. ACM SIGMOD Record, 26(1), 65-74.zh_TW
dc.relation.reference (參考文獻) 12. Chaudhuri, S., Dayal, U., & Ganti, V. (2001). Database Technology for Decision Support Systems, IEEE Computer, 34(12), 48-55.zh_TW
dc.relation.reference (參考文獻) 13. Cheng, Yi-Sheng. (2001). An Investigation of an XML Web Data Warehouse System Architecture. Unpublished Master Thesis, Department of Computer Science and Engineering, Tatung University.zh_TW
dc.relation.reference (參考文獻) 14. Codd, E. F., Codd, S. B., & Salley, C. T. (1993). Providing OLAP to User-Analysts: An IT Mandate. Codd & Associates, Retrieved January 30,2004, from http://www.datawarehouse.com/iknowledge/whitepapers/hyperion_61.pdf.zh_TW
dc.relation.reference (參考文獻) 15. Colossi, N., Malloy, W., & Reinwald, B. (2002). Relational extensions for OLAP. IBM Systems Journal, 41(4), 714-731.zh_TW
dc.relation.reference (參考文獻) 16. Datta, A., & Thomas, H. (1999). The cube data model: a conceptual model and algebra for on-line analytical processing in data warehouse,. Decision Support Systems, 27(3), 289-301.zh_TW
dc.relation.reference (參考文獻) 17. Dinter, B., Sapia, C., Hofling, G., & Blaschka, M. (1998). The OLAP Market: State of the Art and Research Issues. Proc. First International Workshop on Data Warehousing and OLAP (DOLAP’98), 22-27.zh_TW
dc.relation.reference (參考文獻) 18. Dinter, B., Sapia, C., Blaschka, M., & Hofling, G. (1999). OLAP Market and Research: Initiating the Cooperation,” Journal of Computer Science and Information Management, 2(3).zh_TW
dc.relation.reference (參考文獻) 19. Do, H. H. & Rahm, E. (2000). On Metadata Interoperability in Data Warehouses. Technical Report 01-2000, Department of Computer Science, University of Leipzig.zh_TW
dc.relation.reference (參考文獻) 20. Fankhauser, P., & Klement, T. (2003). XML for Data Warehousing Chances and Challenges. Proc. of the 5th International Conference on Data Warehousing and Knowledge Discovery (DaWaK 2003), 1-3.zh_TW
dc.relation.reference (參考文獻) 21. Gottschalk, K., Graham, S., Kreger, H., & Snell, J. (2002). Introduction to Web services architecture. IBM Systems Journal, 41(2), 170-177.zh_TW
dc.relation.reference (參考文獻) 22. Gray, J., Chaudhuri, S., Bosworth, A., Layman, A., Reichart, D., & Venkatrao, M. (1997). Data Cube: A Relational Aggregation Operator Generalizing Group-By, Cross-Tab, and Sub-Totals. Data Mining and Knowledge Discovery, 1(1), 29-53.zh_TW
dc.relation.reference (參考文獻) 23. Hammer, J., Garcia-Molina, H., Widom, J., Labio, W. & Zhuge, Y. (1995). The Stanford Data Warehousing Project. IEEE Data Engineering Bulletin, Special Issue on Materialized Views and Data Warehousing, 18(2), 41-48.zh_TW
dc.relation.reference (參考文獻) 24. Harold, E. R. (2001). XML Bible (2nd Edition). New York: John Wiley & Sons.zh_TW
dc.relation.reference (參考文獻) 25. Huang, S., & Su, C. (2002). The Development of an XML-Based Data Warehouse System. Proceeding of Third International Conference on Intelligent Data Engineering and Automated Learning (IDEAL 2002), 206-212.zh_TW
dc.relation.reference (參考文獻) 26. Hummer, W., Bauer, A., & Harde, G. (2003). XCube-XML For Data Warehouses. Proceedings of Sixth International Workshop on Data Warehousing and OLAP (DOLAP’03), 33-40.zh_TW
dc.relation.reference (參考文獻) 27. Hummer, W., Lehner, W., Bauer, A., & Schlesinger, L. (2002). A Decathlon in Multidimensional Modeling: Open Issues and Some Solutions. Proceedings of the 4th International Conference on Data Warehousing and Knowledge Discovery (DaWaK 2002), 275-285.zh_TW
dc.relation.reference (參考文獻) 28. Hung, Yuan-Mao. (2000). A Generic Architecture for Active Data Warehouse Systems. Unpublished Master Thesis, Department of Computer Science and Engineering, Tatung University.zh_TW
dc.relation.reference (參考文獻) 29. Inmon, W. H. (1996). Building the Data Warehouse (Second Edition). New York: John Wiley & Sons.zh_TW
dc.relation.reference (參考文獻) 30. Inmon, W. H., Welch, J. D., & Glassey, K. L. (1997). Managing the Data Warehouse. New York: John Wiley & Sons.zh_TW
dc.relation.reference (參考文獻) 31. Jarke, M., Lenzerini, M., Vassiliou, Y., & Vassiliadis, P. (2000). Fundamentals of Data Warehouses. Berlin: Springer-Verlag.zh_TW
dc.relation.reference (參考文獻) 32. Katz, H., & Chamberlin, D. D. (2004). XQuery from the experts: a guide to the W3C XML query language. Boston: Addison-Wesley.zh_TW
dc.relation.reference (參考文獻) 33. Kelly, T. J. (2002). Dimensional Data Modeling. Retrieved January 30,2004, from http://www.olap.it/Articoli/Dimensional%20data%20modeling.mht.zh_TW
dc.relation.reference (參考文獻) 34. Kimball, R. (1996). The data warehouse toolkit: practical techniques for building dimensional data warehouses. New York: John Wiley & Sons.zh_TW
dc.relation.reference (參考文獻) 35. Kimball, R. (1997). A Dimensional Modeling Manifesto. DBMS and Internet Systems, Retrieved January 30,2004, from http://www.dbmsmag.com/9708d15.html.zh_TW
dc.relation.reference (參考文獻) 36. Kimball, R., Reeves, L., Ross, M., and Thornthwaite, W. (1998). The Data Warehouse Lifecycle Toolkit. New York: John Wiley & Sons.zh_TW
dc.relation.reference (參考文獻) 37. Kuo, Wan-Yu. (2003). A Generic Construct based Transformation Model between UML Data Model and XML. Unpublished Master Thesis, Department of Management Information System, National Chengchi University.zh_TW
dc.relation.reference (參考文獻) 38. Lee, I., Lee, M., & Yong, H. (2002). EDMIS: Metadata Interchange System for OLAP. Proceedings of First EurAsian Conference on Information and Communication Technology (EurAsia-ICT 2002), 297-305.zh_TW
dc.relation.reference (參考文獻) 39. Lemi, R., Lambert, V., & Nachouki, M-P. (1997). Data Warehousing tool’s architecture: from multidimensional analysis to data mining. Proceedings of Eighth International Workshop on Database and Expert System Application, 636-643.zh_TW
dc.relation.reference (參考文獻) 40. Lujan-Mora, S., Medina, E., & Trujillo J. (2002). A Web-Oriented Approach to Manage Multidimensional Models through XML Schemas and XSLT. Proceedings of EDBT Workshops 2002, 29-44.zh_TW
dc.relation.reference (參考文獻) 41. Marcel, P. (1999). Modeling and querying multidimensional databases: an overview. Networking and Information Systems Journal, 2(5-6), 515-548.zh_TW
dc.relation.reference (參考文獻) 42. Marco, D. (2000). Building and Managing the Meta Data Repository: A Full Lifecycle Guide. New York: John Wiley & Sons.zh_TW
dc.relation.reference (參考文獻) 43. Moeller, R. A. (2001). Distributed Data Warehousing using Web Technology. New York: AMACOM.zh_TW
dc.relation.reference (參考文獻) 44. Mohania, M., Samtani, S., Roddick, J., & Kambayashi, Y. (1999). Advances and Research Directions in Data Warehousing Technology. The Australian Journal of Information Systems (AJIS), 7(1), 41-59.zh_TW
dc.relation.reference (參考文獻) 45. Muller, R., Stohr, T., & Rahm, E. (1999). An Integrative and Uniform Model for Metadata Management in Data Warehousing Environments. Proceedings of the Intl. Workshop on Design and Management of Data Warehouses (DMDW`99), 12-1-12-16.zh_TW
dc.relation.reference (參考文獻) 46. Olsen, G. (2000). An Overview of B2B Integration. eAI Journal, 28-36.zh_TW
dc.relation.reference (參考文獻) 47. Pedersen, T. B., & Jensen, C. S. (2001). Multidimensional Database Technology. IEEE Computer, 34(12), 40-46.zh_TW
dc.relation.reference (參考文獻) 48. Pendse, N. (2002). Commentary: OLAP API wars. The OLAP Report, Retrieved March 14,2004, from http://www.olapreport.com/Comment_APIs.htm.zh_TW
dc.relation.reference (參考文獻) 49. Poole, J., Change, D., Tolbert, D., & Mellor, D. (2001). Common Warehouse Metamodel: An Introduction to the Standard for Data Warehouse Integration. New York: John Wiley & Sons.zh_TW
dc.relation.reference (參考文獻) 50. Roddick, J. F. (1995). A survey of schema versioning issues for database systems. Information and Software Technology, 37(7), 383-393.zh_TW
dc.relation.reference (參考文獻) 51. Samtani, S., Mohania, M., Kumar, V., & Kambayashi, Y. (1998). Recent Advances and Research Problems in Data Warehousing. Proceedings of ER Workshops 1998, 81-92.zh_TW
dc.relation.reference (參考文獻) 52. Sapia, C., Blaschka, M., and Hofling, G. (1999). An Overview of Multidimensional Data Models for OLAP. FORWISS Technical Report 1999-01.zh_TW
dc.relation.reference (參考文獻) 53. Silverstone, L., Inmon, W. H., & Graziano, K. (1997). The data model resource book: a library of logical data models and data warehouse designs. New York: John Wiley & Sons.zh_TW
dc.relation.reference (參考文獻) 54. Staudt, M., Vaduva, A., & Vetterli, T. (1999a). Metadata Management and Data Warehousing. Technical Report 21, Swiss Life, Information System Research.zh_TW
dc.relation.reference (參考文獻) 55. Staudt, M., Vaduva, A., & Vetterli, T. (1999b). The Role of Metadata for Data Warehousing. Technical Report 99.06, Department of Information Technology, University of Zurich.zh_TW
dc.relation.reference (參考文獻) 56. Thomsen, E. (1997). OLAP solutions: building multidimensional information systems. New York: John Wiley & Sons.zh_TW
dc.relation.reference (參考文獻) 57. Vaduva, A., & Dittrich, K. R. (2000). Metadata Management for Data Warehousing: Between Vision and Reality. Technical Report 2000.08, Department of Information Technology, University of Zurich.zh_TW
dc.relation.reference (參考文獻) 58. Vaduva, A., & Dittrich, K. R. (2001). Metadata Management for Data Warehousing: Between Vision and Reality. Proc. of the 2001 International Database Engineering & Applications Symposium (IDEAS`01), 129-138.zh_TW
dc.relation.reference (參考文獻) 59. Vaisman, A. A., (1998). OLAP, Data Warehousing, and Materialized Views: a Survey. Technical Reports TR-98-015, Department of Computation, University of Buenos Aires, 1-24.zh_TW
dc.relation.reference (參考文獻) 60. Valentine, C. (2002). XML Schema. San Francisco: Sybex.zh_TW
dc.relation.reference (參考文獻) 61. Vassiliadis, P. (1998). Modeling Multidimensional Databases, Cubes, and Cube Operations. Proceedings of 10th International Conference on Scientific and Statistical Database Management, 53-62.zh_TW
dc.relation.reference (參考文獻) 62. Vassiliadis, P. (2000). Gulliver in the land of data warehousing: practical experiences and observations of a researcher. Proceeding of the International Workshop on Design and Management of Data Warehouses (DMDW’2000), 12.1-12.16.zh_TW
dc.relation.reference (參考文獻) 63. Vassiliadis, P., & Sellis, T. (1999). A Survey of Logical Models for OLAP Databases. ACM SIGMOD Record, 28(4), 64-69.zh_TW
dc.relation.reference (參考文獻) 64. Vetterli, T., Vaduva, A. & Staudt, M. (2000). Metadata Standards for Data Warehousing: Open Information Model vs. Common Warehouse Metamodel. ACM SIGMOD Record, 29(3), 68-75.zh_TW
dc.relation.reference (參考文獻) 65. Widom, J. (1995). Research Problems in Data Warehousing. Proceedings of the 4th Int`l Conference on Information and Knowledge Management (CIKM), 25-30.zh_TW
dc.relation.reference (參考文獻) 66. Wu, M-C., & Buchmann, A. P. (1997). Research Issues in Data Warehousing. Proceedings of Datenbanksysteme in Buro, Technik und Wissenschaft (BTW’97), 61-82.zh_TW
dc.relation.reference (參考文獻) 67. Wyke, R. A., & Watt, A. (2002). XML Schema Essentials. New York: John Wiley & Sons.zh_TW
dc.relation.reference (參考文獻) Internet Referenceszh_TW
dc.relation.reference (參考文獻) 1. Business Intelligence & Data Warehouse Resource Center, http://www.olap.itzh_TW
dc.relation.reference (參考文獻) 2. The CoverPages, http://xml.coverpages.orgzh_TW
dc.relation.reference (參考文獻) 3. Data Management-ADTmag.com, http://www.adtmag.com/section.asp?section=datazh_TW
dc.relation.reference (參考文獻) 4. Data Management Center, http://www.infogoal.com/dmc/dmchome.htmzh_TW
dc.relation.reference (參考文獻) 5. Data Warehousing, http://www.1keydata.com/datawarehousing/datawarehouse.htmlzh_TW
dc.relation.reference (參考文獻) 6. The Data Warehousing Information Center, http://www.dwinfocenter.orgzh_TW
dc.relation.reference (參考文獻) 7. The Data Warehousing Institute, http://www.dw-institute.com/index.aspzh_TW
dc.relation.reference (參考文獻) 8. DMReview, http://www.dmreview.comzh_TW
dc.relation.reference (參考文獻) 9. Enterprise Warehousing Solutions, http://www.ewsolutions.comzh_TW
dc.relation.reference (參考文獻) 10. IBM Software: Solutions: Web Services by IBM, http://www-306.ibm.com/software/solutions/webservices/zh_TW
dc.relation.reference (參考文獻) 11. Inmon Associates, http://www.billinmon.comzh_TW
dc.relation.reference (參考文獻) 12. ITtoolbox Data Warehouse, http://datawarehouse.ittoolbox.com/zh_TW
dc.relation.reference (參考文獻) 13. Object Management Group, http://www.omg.orgzh_TW
dc.relation.reference (參考文獻) 14. The OLAP Report, http://www.olapreport.com/index.htmzh_TW
dc.relation.reference (參考文獻) 15. Ralph Kimball Associates, http://www.rkimball.com/zh_TW
dc.relation.reference (參考文獻) 16. XCube, http://www.xcube-open.orgzh_TW
dc.relation.reference (參考文獻) 17. XML for Analysis (XMLA), http://www.xmla.orgzh_TW
dc.relation.reference (參考文獻) 18. Cover Pages (2003), W3C Document Object Model, http://xml.coverpages.org/dom.htmlzh_TW
dc.relation.reference (參考文獻) 19. Harde, G. (2003a), XML Schemata for XCubeSchema, version 0.5, http://www.xcube-open.org/V_0_5/XCubeSchema.xsdzh_TW
dc.relation.reference (參考文獻) 20. Harde, G. (2003b), XML Schemata for XCubeDimension, version 0.5, http://www.xcube-open.org/V_0_5/XCubeDimension.xsdzh_TW
dc.relation.reference (參考文獻) 21. Harde, G. (2003c), XML Schemata for XCubeFact, version 0.5, http://www.xcube-open.org/V_0_5/XCubeFact.xsdzh_TW
dc.relation.reference (參考文獻) 22. Nigel, P., Richard, C. (2003), “What is OLAP?”, http://www.olapreport.com/fasmi.htmzh_TW
dc.relation.reference (參考文獻) 23. Object Management Group (2002), Model-Driven Architecture, http://www.omg.org/mdazh_TW
dc.relation.reference (參考文獻) 24. Object Management Group (2003a), Common Warehouse Metamodel (CWM) Specification, V1.1,http://www.omg.org/technology/documents/formal/cwm.htmzh_TW
dc.relation.reference (參考文獻) 25. Object Management Group (2003b), The Data Warehousing, CWM and MOF Resource Page, http://www.omg.org/cwmzh_TW
dc.relation.reference (參考文獻) 26. Object Management Group (2003c), “Unified Modeling Language (UML), version 1.5”, http://www.omg.org/technology/documents/formal/uml.htmzh_TW
dc.relation.reference (參考文獻) 27. Object Management Group (2003d), XML Metadata Interchange (XMI), http://www.omg.org/technology/documents/formal/xmi.htmzh_TW
dc.relation.reference (參考文獻) 28. Object Management Group (2004), Catalog of OMG Modeling and Metadata Specifications, http://www.omg.org/technology/documents/modeling_spec_catalog.htmzh_TW
dc.relation.reference (參考文獻) 29. SearchDatabase.com, http://searchdatabase.techtarget.com/zh_TW
dc.relation.reference (參考文獻) 30. Transaction Processing Performance Council (TPC) (2003), “The TPC Benchmark™H (TPC-H) Standard Specification Revision 2.1.0”, http://www.tpc.org/tpch/spec/tpch2.1.0.pdfzh_TW
dc.relation.reference (參考文獻) 31. World Wide Web Consortium (W3C) (1998), “Document Object Model Level 1 Specification”, http://www.w3.org/TR/REC-DOM-Level-1/zh_TW
dc.relation.reference (參考文獻) 32. W3C (2000),”Document Object Model Level 2 Core Specification”, http://www.w3.org/TR/DOM-Level-2-Corezh_TW
dc.relation.reference (參考文獻) 33. W3C (2001a), “XML Schema Part 0: Primer”, http://www.w3.org/TR/xmlschema-0/zh_TW
dc.relation.reference (參考文獻) 34. W3C (2001b), “XML Schema Part 1: Structures”, http://www.w3.org/TR/xmlschema-1/zh_TW
dc.relation.reference (參考文獻) 35. W3C (2001c), “XML Schema Part 2: Datatypes”, http://www.w3.org/TR/xmlschema-2/zh_TW
dc.relation.reference (參考文獻) 36. W3C (2000), Document Object Model (DOM), http://www.w3.org/DOM/zh_TW
dc.relation.reference (參考文獻) 37. W3C (2003), XQuery 1.0: An XML Query Language, http://www.w3.org/TR/xquery/zh_TW
dc.relation.reference (參考文獻) 38. W3C (2004), “Extensible Markup Language (XML) 1.0 (Third Edition)”, http://www.w3.org/TR/2004/REC-xml-20040204zh_TW
dc.relation.reference (參考文獻) 39. W3C (2002), Web Services Architecture, http://www.w3.org/TR/2002/WD-ws-arch-20021114/zh_TW
dc.relation.reference (參考文獻) 40. W3C (2004), Web Services Activity, http://www.w3.org/2002/ws/zh_TW
dc.relation.reference (參考文獻) 41. XMLA (2002), XML for Analysis Specification Version 1.1, http://www.xmla.org/spec/1.1/xmla1.1.doczh_TW