Journal
DATA & KNOWLEDGE ENGINEERING
Volume 68, Issue 12, Pages 1452-1469Publisher
ELSEVIER
DOI: 10.1016/j.datak.2009.07.010
Keywords
Multidimensional modeling; Summarizability; Data warehouse; Data analysis
Funding
- Spanish Ministry of Education and Science [TIN2007-67078, AP2005-1360]
- Castilla-La Mancha Ministry of Education and Science (Spain) [PAC08-0157-0668]
Ask authors/readers for more resources
The development of a data warehouse (DW) system is based on a conceptual multidimensional model, which provides a high level of abstraction in accurately and expressively describing real-world situations. Once this model is designed, the corresponding logical representation must be obtained as the basis of the implementation of the DW according to one specific technology. However, even though a good conceptual multidimensional model is designed underneath a DW, there is a semantic gap between this model and its logical representation. In particular, this gap complicates an adequate treatment of summarizability issues, which in turn may lead to erroneous results of data analysis tools. Research addressing this topic has produced only partial solutions, and individual terminology used by different parties hinders further progress. Consequently, based on a unifying vocabulary, this survey sheds light on (i) the weak and strong points of current approaches for modeling complex multidimensional structures that reflect real-world situations in a conceptual multidimensional model and (ii) existing mechanisms to avoid summarizability problems when conceptual multidimensional models are being implemented. (C) 2009 Elsevier B.V. All rights reserved,
Authors
I am an author on this paper
Click your name to claim this paper and add it to your profile.
Reviews
Recommended
No Data Available