A federated architecture for information management
ACM Transactions on Information Systems (TOIS)
Superviews: Virtual Integration of Multiple Databases
IEEE Transactions on Software Engineering
Data Integration in Distributed Databases
IEEE Transactions on Software Engineering
MSQL: a multidatabase language
Information Sciences: an International Journal
Language features for interoperability of databases with schematic discrepancies
SIGMOD '91 Proceedings of the 1991 ACM SIGMOD international conference on Management of data
Answering heterogeneous database queries with degrees of uncertainty
Distributed and Parallel Databases
Using semantic values to facilitate interoperability among heterogeneous information systems
ACM Transactions on Database Systems (TODS)
Refining imprecise data by integrity constraints
Data & Knowledge Engineering
An aspect of query optimization in multidatabase systems
ACM SIGMOD Record
The data warehouse toolkit: practical techniques for building dimensional data warehouses
The data warehouse toolkit: practical techniques for building dimensional data warehouses
Implementing catalog clearinghouses with XML and XSL
Proceedings of the 1999 ACM symposium on Applied computing
Integration of relations with conflicting schema structures in heterogeneous database systems
Data & Knowledge Engineering
On wrapping query languages and efficient XML integration
SIGMOD '00 Proceedings of the 2000 ACM SIGMOD international conference on Management of data
The data webhouse toolkit: building the web-enabled data warehouse
The data webhouse toolkit: building the web-enabled data warehouse
Proceedings of the 4th ACM international workshop on Data warehousing and OLAP
Data warehouse design from XML sources
Proceedings of the 4th ACM international workshop on Data warehousing and OLAP
Data Warehousing in the Real World: A Practical Guide for Building Decision Support Systems
Data Warehousing in the Real World: A Practical Guide for Building Decision Support Systems
Constructing an OLAP cube from distributed XML data
Proceedings of the 5th ACM international workshop on Data Warehousing and OLAP
Specifying OLAP Cubes on XML Data
Journal of Intelligent Information Systems
Federated databases and systems: part I --- a tutorial on their data sharing
The VLDB Journal — The International Journal on Very Large Data Bases
Federated databases and systems: part II --- a tutorial on their resource consolidation
The VLDB Journal — The International Journal on Very Large Data Bases
Searching a minimal semantically-equivalent subset of a set of partial values
The VLDB Journal — The International Journal on Very Large Data Bases
IEEE Transactions on Knowledge and Data Engineering
A Methodology for Integration of Heterogeneous Databases
IEEE Transactions on Knowledge and Data Engineering
Evaluating Aggregate Operations Over Imprecise Data
IEEE Transactions on Knowledge and Data Engineering
An Approach to Schema Integration and Query Formulation in Federated Database Systems
Proceedings of the Third International Conference on Data Engineering
Database Integration in a Distributed Heterogeneous Database System
Proceedings of the Second International Conference on Data Engineering
Integrating Heterogeneous Data Sources with XML and XQuery
DEXA '02 Proceedings of the 13th International Workshop on Database and Expert Systems Applications
SSDBM '02 Proceedings of the 14th International Conference on Scientific and Statistical Database Management
An automatic load/extract scheme for XML documents through object-relational repositories
Journal of Systems and Software
XML Documents Production for an Electronic Platform of Requests for Proposals
SRDS '99 Proceedings of the 18th IEEE Symposium on Reliable Distributed Systems
XQuery from the Experts: A Guide to the W3C XML Query Language
XQuery from the Experts: A Guide to the W3C XML Query Language
XCube: XML for data warehouses
DOLAP '03 Proceedings of the 6th ACM international workshop on Data warehousing and OLAP
IBM Systems Journal
MDX Solutions: with Microsoft SQL Server Analysis Services 2005 and Hyperion Essbase
MDX Solutions: with Microsoft SQL Server Analysis Services 2005 and Hyperion Essbase
Design of a multi-dimensional query expression for document warehouses
Information Sciences: an International Journal
A grain preservation translation algorithm: From ER diagram to multidimensional model
Information Sciences: an International Journal
Semantic enrichment of strategic datacubes
Proceedings of the ACM 11th international workshop on Data warehousing and OLAP
Design of an agent-based system for improving supply chain strategy
International Journal of Intelligent Systems Technologies and Applications
FedDW global schema architect: UML-based design tool for the integration of data mart schemas
Proceedings of the fifteenth international workshop on Data warehousing and OLAP
Hi-index | 0.00 |
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.