DaWaII: a Tool for the Integration of Autonomous Data Marts

DaWaII (Data Warehouse IntegratIon) is a tool for supporting the various activities related to the integration of multidimensional databases. This problem arises in common scenarios where there is the need to combine independently developed data warehouses. The basic facility of the tool is a support for testing the validity of a matching between heterogeneous dimensions, according to a number of desirable properties. Two different strategies are then provided by the tool 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 the original sources. 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 the practical techniques implementing the two strategies and...

• Type: Conference
• Year: 2006
• Where: ICDE
• Authors: Luca Cabibbo, Ivan Panella, Riccardo Torlone
• Keywords: Actual Integration, Approach Refers, Data Warehouse IntegratIon, Database, ICDE 2006