{"status":"ok","message-type":"work","message-version":"1.0.0","message":{"indexed":{"date-parts":[[2026,5,4]],"date-time":"2026-05-04T00:26:38Z","timestamp":1777854398069,"version":"3.51.4"},"reference-count":53,"publisher":"SAGE Publications","issue":"3","license":[{"start":{"date-parts":[[2005,6,1]],"date-time":"2005-06-01T00:00:00Z","timestamp":1117584000000},"content-version":"tdm","delay-in-days":0,"URL":"https:\/\/journals.sagepub.com\/page\/policies\/text-and-data-mining-license"}],"content-domain":{"domain":[],"crossmark-restriction":false},"short-container-title":["Journal of Information Science"],"published-print":{"date-parts":[[2005,6]]},"abstract":"<jats:p>Data warehousing has been widely adopted by contemporary enterprises. For inter-organizational information sharing, the need cannot be over-emphasized to conduct researches on the integration of heterogeneous data warehouses to overcome the challenging situations today. That makes it urgent to establish a systematic integration methodology for integrating heterogeneous data warehouses via the Internet or proprietary extranets. Traditionally, researchers usually employed a canonical format as the integration medium for logical data integrations among heterogeneous systems. In this paper, to fully utilize the power of the Internet, we propose a framework and develop a prototype to integrate heterogeneous data warehouses by XML technologies. We first formally define the elements in data warehousing and discuss various semantic conflicts occurring among heterogeneous data cubes. Then, we propose the system architecture and related resolution procedures for all kinds of semantic conflicts. For local data cubes with different schemas, we define a global XML Schema to integrate the local cube structures, and transform each local cube respectively into an XML document conforming to the global XML Schema. These transformed XML documents obtained from local cubes will be manipulated by pre-defined XQuery commands to form a unified XML document, which can be regarded as the global cube. The integrated global cube can be easily stored and manipulated in native XML databases. The proposed methodology enables global users to browse or pose multi-dimensional expressions (MDX) on the global cube to obtain a result in the same way as they perform locally.<\/jats:p>","DOI":"10.1177\/0165551505052467","type":"journal-article","created":{"date-parts":[[2005,4,11]],"date-time":"2005-04-11T12:47:25Z","timestamp":1113223645000},"page":"209-229","source":"Crossref","is-referenced-by-count":31,"title":["Integrating heterogeneous data warehouses using XML technologies"],"prefix":"10.1177","volume":"31","author":[{"given":"Frank S.C.","family":"Tseng","sequence":"first","affiliation":[{"name":"Department of Information Management, National Kaohsiung First University                         of Science and Technology, Kaohsiung, Taiwan, ROC,"}]},{"given":"Chia-Wei","family":"Chen","sequence":"additional","affiliation":[{"name":"Department of Information Management, National Kaohsiung First University                         of Science and Technology, Kaohsiung, Taiwan, ROC"}]}],"member":"179","published-online":{"date-parts":[[2005,6,1]]},"reference":[{"key":"atypb1","volume-title":"Data Warehousing in the Real World: A Practical Guide for Building Decision Support Systems","author":"S. Anahory","year":"1997"},{"issue":"5","key":"atypb2","first-page":"6","volume":"4","author":"W.H. Inmon","year":"1994","journal-title":"Data Management Review"},{"key":"atypb3","doi-asserted-by":"crossref","DOI":"10.1108\/imds.2000.100.8.406.1","volume-title":"The Data Webhouse Toolkit-Building the Web-Enabled Data Warehouse","author":"R. Kimball","year":"2000"},{"key":"atypb4","volume-title":"The Data Warehouse Toolkit: Practical Techniques for Building Dimensional Data Warehouses","author":"R. Kimball","year":"1996"},{"key":"atypb5","volume-title":"Integration Issues for Heterogeneous, Distributed, and Autonomous Data Warehouses","author":"O. Mangisengi","year":"2000"},{"key":"atypb6","doi-asserted-by":"publisher","DOI":"10.1007\/3-540-44801-2_32"},{"key":"atypb7","first-page":"40","volume-title":"Proceedings ACM Third International Workshop on Data Warehousing and OLAP (DOLAP\u201901)","author":"M. Golfarelli"},{"key":"atypb8","first-page":"22","volume-title":"ACM Fifth International Workshop on Data Warehousing and OLAP","author":"T. Niemi"},{"key":"atypb9","first-page":"195","volume-title":"14th International Conference on Scientific and Statistical Database Management (SSDBM\u201902), July 2002","author":"D. Pedersen"},{"key":"atypb10","doi-asserted-by":"publisher","DOI":"10.1016\/S0164-1212(02)00044-4"},{"key":"atypb11","first-page":"330","volume-title":"Proceedings of the 18th IEEE Symposium on Reliable Distributed Systems, 1998","author":"F. Bapst"},{"key":"atypb12","first-page":"616","volume-title":"Proceedings of the 1999 ACM Symposium on Applied Computing","author":"A.V. Royappa"},{"key":"atypb13","doi-asserted-by":"publisher","DOI":"10.1147\/sj.414.0597"},{"key":"atypb14","doi-asserted-by":"publisher","DOI":"10.1109\/TSE.1984.5010292"},{"key":"atypb15","doi-asserted-by":"publisher","DOI":"10.1109\/TSE.1987.233490"},{"key":"atypb16","first-page":"301","volume-title":"Proceedings of the IEEE International Conference on Data Engineering, 1986","author":"Y. Breitbart"},{"key":"atypb17","doi-asserted-by":"publisher","DOI":"10.1109\/TSE.1987.233497"},{"key":"atypb18","doi-asserted-by":"publisher","DOI":"10.1016\/S0169-023X(98)00005-6"},{"key":"atypb19","doi-asserted-by":"publisher","DOI":"10.1145\/4229.4233"},{"key":"atypb20","doi-asserted-by":"publisher","DOI":"10.1007\/BF01228709"},{"key":"atypb21","doi-asserted-by":"publisher","DOI":"10.1007\/BF01231702"},{"key":"atypb22","first-page":"40","volume-title":"Proceedings of the ACM SIGMOD-International Conference on Management of Data","author":"R. Krishnamurthy"},{"key":"atypb23","first-page":"477","volume-title":"Proceedings of the 3rd IEEE International. Conference on Data Engineering, 1987","author":"B. Czejdo"},{"key":"atypb24","doi-asserted-by":"publisher","DOI":"10.1016\/0020-0255(89)90024-8"},{"key":"atypb25","doi-asserted-by":"publisher","DOI":"10.1109\/PROC.1987.13777"},{"key":"atypb26","doi-asserted-by":"publisher","DOI":"10.1145\/211990.212011"},{"key":"atypb27","doi-asserted-by":"publisher","DOI":"10.1109\/69.334882"},{"key":"atypb28","first-page":"93","volume-title":"Proceedings of IEEE TENCON\u201902, 2002","author":"K.H. Lee"},{"key":"atypb29","first-page":"109","volume-title":"Second International Conference on Web Information Systems Engineering (WISE\u201901)","author":"R.M. Bruckner"},{"key":"atypb30","volume-title":"XML Topic Maps (XTM) 1.0 TopicMaps.Org Specification","author":"S. Pepper","year":"2003"},{"key":"atypb31","doi-asserted-by":"publisher","DOI":"10.1145\/342009.335395"},{"key":"atypb32","first-page":"33","volume-title":"Proceedings of the ACM 6th International Workshop on Data Warehousing and OLAP (DOLAP\u201903)","author":"W. H\u00fcmmer"},{"key":"atypb33","volume-title":"XML Schema, W3C Recommendation","author":"World Wide Web Consortium","year":"2001"},{"key":"atypb34","volume-title":"XQuery from the Experts: A Guide to the W3C XML Query Language","author":"Howard Katz","year":"2003"},{"key":"atypb35","volume-title":"XML Query(XQuery), W3C Working Draft","author":"World Wide Web Consortium","year":"2003"},{"key":"atypb36","first-page":"839","volume-title":"13th International Workshop on Database and Expert Systems Applications (DEXA\u201902)","author":"G. Gardarin"},{"issue":"1","key":"atypb37","first-page":"18","volume":"25","author":"Y. Papakonstantinou","year":"2002","journal-title":"Bulletin of the IEEE Computer Society Technical Committee on Data Engineering"},{"key":"atypb38","volume-title":"Tamino Native XML Database Management System","author":"Software AG Corporation","year":"2005"},{"key":"atypb39","volume-title":"Common Warehouse Metamodel (CWM) Version 1.0","author":"OMG","year":"2001"},{"key":"atypb40","doi-asserted-by":"publisher","DOI":"10.1023\/A:1012814015209"},{"key":"atypb41","first-page":"24","volume-title":"Proceedings of the ACM Third International Workshop on Data Warehousing and OLAP (DOLAP\u201901)","author":"J. Pokorny"},{"key":"atypb42","doi-asserted-by":"publisher","DOI":"10.1145\/176567.176570"},{"key":"atypb43","doi-asserted-by":"publisher","DOI":"10.1016\/0020-0190(79)90138-8"},{"key":"atypb44","doi-asserted-by":"publisher","DOI":"10.1109\/69.43423"},{"key":"atypb45","doi-asserted-by":"publisher","DOI":"10.1007\/BF01263049"},{"key":"atypb46","doi-asserted-by":"publisher","DOI":"10.1007\/BF01263334"},{"issue":"3","key":"atypb47","first-page":"229","volume":"11","author":"F.S.C. Tseng","year":"1993","journal-title":"Data & Knowledge Engineering"},{"key":"atypb48","doi-asserted-by":"publisher","DOI":"10.1109\/69.494166"},{"issue":"1","key":"atypb49","first-page":"51","volume":"12","author":"F.S.C. Tseng","year":"1996","journal-title":"Journal of Information Science and Engineering"},{"key":"atypb50","volume-title":"MDX Solutions with Microsoft SQL Server Analysis Services","author":"G. Spofford","year":"2001"},{"key":"atypb51","first-page":"563","volume-title":"Proceedings of the 8th Pacific Asia Conference on Information Systems: PACIS 2004, July 8-11, 2004, Shanghai, China","author":"F.S.C. Tseng"},{"key":"atypb52","author":"F.S.C. Tseng","journal-title":"Information Sciences: an International Journal"},{"key":"atypb53","author":"F.S.C. Tseng","journal-title":"Journal of Information Science and Engineering"}],"container-title":["Journal of Information Science"],"original-title":[],"language":"en","link":[{"URL":"https:\/\/journals.sagepub.com\/doi\/pdf\/10.1177\/0165551505052467","content-type":"application\/pdf","content-version":"vor","intended-application":"text-mining"},{"URL":"https:\/\/journals.sagepub.com\/doi\/pdf\/10.1177\/0165551505052467","content-type":"unspecified","content-version":"vor","intended-application":"similarity-checking"}],"deposited":{"date-parts":[[2026,4,29]],"date-time":"2026-04-29T23:06:58Z","timestamp":1777504018000},"score":1,"resource":{"primary":{"URL":"https:\/\/journals.sagepub.com\/doi\/10.1177\/0165551505052467"}},"subtitle":[],"short-title":[],"issued":{"date-parts":[[2005,6]]},"references-count":53,"journal-issue":{"issue":"3","published-print":{"date-parts":[[2005,6]]}},"alternative-id":["10.1177\/0165551505052467"],"URL":"https:\/\/doi.org\/10.1177\/0165551505052467","relation":{},"ISSN":["0165-5515","1741-6485"],"issn-type":[{"value":"0165-5515","type":"print"},{"value":"1741-6485","type":"electronic"}],"subject":[],"published":{"date-parts":[[2005,6]]}}}