Management of heterogeneous and autonomous database systems
Management of heterogeneous and autonomous database systems
Extending OLAP querying to external object databases
Proceedings of the ninth international conference on Information and knowledge management
The Clio project: managing heterogeneity
ACM SIGMOD Record
Data integration: a theoretical perspective
Proceedings of the twenty-first ACM SIGMOD-SIGACT-SIGART symposium on Principles of database systems
Foundations of Databases: The Logical Level
Foundations of Databases: The Logical Level
The Data Warehouse Toolkit: The Complete Guide to Dimensional Modeling
The Data Warehouse Toolkit: The Complete Guide to Dimensional Modeling
On relationships offering new drill-across possibilities
Proceedings of the 5th ACM international workshop on Data Warehousing and OLAP
Specifying OLAP Cubes on XML Data
Journal of Intelligent Information Systems
A Logical Approach to Multidimensional Databases
EDBT '98 Proceedings of the 6th International Conference on Extending Database Technology: Advances in Database Technology
A survey of approaches to automatic schema matching
The VLDB Journal — The International Journal on Very Large Data Bases
Evaluating XML-extended OLAP queries based on a physical algebra
Proceedings of the 7th ACM international workshop on Data warehousing and OLAP
Integrating heterogeneous multidimensional databases
SSDBM'2005 Proceedings of the 17th international conference on Scientific and statistical database management
A grain preservation translation algorithm: From ER diagram to multidimensional model
Information Sciences: an International Journal
Two approaches to the integration of heterogeneous data warehouses
Distributed and Parallel Databases
Analysing multi-dimensional data across autonomous data warehouses
DaWaK'06 Proceedings of the 8th international conference on Data Warehousing and Knowledge Discovery
Hi-index | 0.00 |
In this paper we describe the design of a tool supporting the integration of independently developed data warehouses, a problem that arises in several common scenarios. The basic facility of the tool is a test of the validity of a matching between heterogeneous dimensions, according to a number of desirable properties. Two strategies are then provided to perform the actual integration. The first approach refers to a scenario of loosely coupled integration, in which we just need to identify the common information between sources and perform drill-across queries over them. The goal of the second approach is the derivation of a materialized view built by merging the sources, and refers to a scenario of tightly coupled integration in which queries are performed against the view. We illustrate architecture and functionality of the tool and the underlying techniques that implement the two integration strategies.