Research in data warehouse modeling and design: dead or alive?
DOLAP '06 Proceedings of the 9th ACM international workshop on Data warehousing and OLAP
Two approaches to the integration of heterogeneous data warehouses
Distributed and Parallel Databases
Integrated Model-Driven Development of Goal-Oriented Data Warehouses and Data Marts
ER '08 Proceedings of the 27th International Conference on Conceptual Modeling
Towards the definition of spatial data warehouses integrity constraints with spatial OCL
DOLAP '10 Proceedings of the ACM 13th international workshop on Data warehousing and OLAP
Journal of Database Management
| Hi-index | 0.00 |
We address the problem of integrating a federation ofdimensional data marts. This problem arises when, e.g., alarge organization (or a federation thereof) needs to combine independently developed data warehouses. We show that this problem can be tackled in a systematic way because of two main reasons. First, data marts are structuredin a rather uniform way, along dimensions and facts. Second, data quality in data marts is usually higher than in generic databases, since they are obtained by reconcilingseveral data sources. Our scenario of reference is a federation (i.e., a logical integration) of various data marts, which we need to query in a unified way, that is, by meansof drill-across operations. We propose a novel notion of dimension compatibility and characterize its general property. We then show the significance of dimension compatibility in performing drill-across queries over autonomousdata marts. We also discuss general strategies for the integration of data marts.