Design and Development of a Tool for Integrating Heterogeneous Data Warehouses

摘要: In this paper we describe the design of a tool supporting integration independently developed data warehouses, problem that arises in several common scenarios. The basic facility is test validity matching between heterogeneous dimensions, according to number desirable properties. Two strategies are then provided perform actual integration. first approach refers scenario loosely coupled integration, which just need identify information sources and drill-across queries over them. goal second derivation materialized view built by merging sources, tightly performed against view. We illustrate architecture functionality underlying techniques implement two strategies.