Please use this identifier to cite or link to this item:

Title: An XML-based Multidimensional Data Exchange Study
Authors: 王容
Wang, Jung
Contributors: 諶家蘭
Seng, Jia-Lang
Wang, Jung
Keywords: 資料倉儲
Data Warehouse
Multidimensional Data Model
Data Cube
Data Exchange
Date: 2003
Issue Date: 2009-09-18 19:34:48 (UTC+8)
Abstract: 在全球化趨勢與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.
Reference: 中文參考文獻
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
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
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
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
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
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,
2. The CoverPages,
3. Data,
4. Data Management Center,
5. Data Warehousing,
6. The Data Warehousing Information Center,
7. The Data Warehousing Institute,
8. DMReview,
9. Enterprise Warehousing Solutions,
10. IBM Software: Solutions: Web Services by IBM,
11. Inmon Associates,
12. ITtoolbox Data Warehouse,
13. Object Management Group,
14. The OLAP Report,
15. Ralph Kimball Associates,
16. XCube,
17. XML for Analysis (XMLA),
18. Cover Pages (2003), W3C Document Object Model,
19. Harde, G. (2003a), XML Schemata for XCubeSchema, version 0.5,
20. Harde, G. (2003b), XML Schemata for XCubeDimension, version 0.5,
21. Harde, G. (2003c), XML Schemata for XCubeFact, version 0.5,
22. Nigel, P., Richard, C. (2003), “What is OLAP?”,
23. Object Management Group (2002), Model-Driven Architecture,
24. Object Management Group (2003a), Common Warehouse Metamodel (CWM) Specification, V1.1,
25. Object Management Group (2003b), The Data Warehousing, CWM and MOF Resource Page,
26. Object Management Group (2003c), “Unified Modeling Language (UML), version 1.5”,
27. Object Management Group (2003d), XML Metadata Interchange (XMI),
28. Object Management Group (2004), Catalog of OMG Modeling and Metadata Specifications,
30. Transaction Processing Performance Council (TPC) (2003), “The TPC Benchmark™H (TPC-H) Standard Specification Revision 2.1.0”,
31. World Wide Web Consortium (W3C) (1998), “Document Object Model Level 1 Specification”,
32. W3C (2000),”Document Object Model Level 2 Core Specification”,
33. W3C (2001a), “XML Schema Part 0: Primer”,
34. W3C (2001b), “XML Schema Part 1: Structures”,
35. W3C (2001c), “XML Schema Part 2: Datatypes”,
36. W3C (2000), Document Object Model (DOM),
37. W3C (2003), XQuery 1.0: An XML Query Language,
38. W3C (2004), “Extensible Markup Language (XML) 1.0 (Third Edition)”,
39. W3C (2002), Web Services Architecture,
40. W3C (2004), Web Services Activity,
41. XMLA (2002), XML for Analysis Specification Version 1.1,
Description: 碩士
Source URI:
Data Type: thesis
Appears in Collections:[資訊管理學系] 學位論文

Files in This Item:

There are no files associated with this item.

All items in 學術集成 are protected by copyright, with all rights reserved.

社群 sharing