Abstract
Data warehouse dimension hierarchies are of paramount importance in OLAP (On-Line Analytical Processing) tools to support the decision-making process, since they allow the analysis of data at different levels of detail (i.e. levels of aggregation). This is why it is crucial to capture adequate hierarchies in the requirement analysis stage. However, operational sources may not be able to supply enough data to construct every level of these hierarchies. In this paper, we propose the application of semantic relations among WordNet concepts to enrich hierarchies by adding the required levels of aggregation. Decision makers will thus be able to achieve their information needs for analysis.
Work supported by the projects: TIN2004-00779 from the Spanish Government, GV05/220 from the Valencia Government, and PBC-05-012-2 from the Castilla-La Mancha Government. Jose-Norberto Mazón is funded by the Spanish Ministry of Science and Education under a FPU grant (AP2005-1360).
Access this chapter
Tax calculation will be finalised at checkout
Purchases are for personal use only
Preview
Unable to display preview. Download preview PDF.
References
Akoka, J., Comyn-Wattiau, I., Prat, N.: Dimension Hierarchies Design from UML Generalizations and Aggregations. In: Kunii, H.S., Jajodia, S., Sølvberg, A. (eds.) ER 2001. LNCS, vol. 2224, pp. 442–455. Springer, Heidelberg (2001)
Horner, J., Song, I.-Y., Chen, P.: An Analysis of Additivity in OLAP Systems. In: 7th ACM Int. Workshop on Data Warehousing and OLAP (DOLAP), pp. 83–91 (2004)
Horner, J., Song, I.-Y.: A Taxonomy of Inaccurate Summaries and Their Management in OLAP Systems. In: Delcambre, L.M.L., Kop, C., Mayr, H.C., Mylopoulos, J., Pastor, Ó. (eds.) ER 2005. LNCS, vol. 3716, pp. 433–448. Springer, Heidelberg (2005)
Inmon, W.: Building the Data Warehouse. John Wiley & Sons, Chichester (1996)
Luján-Mora, S., Trujillo, J., Song, I.-Y.: A UML Profile for Multidimensional Modelling in Data Warehouses. Data & Knowledge Engineering (in Press)
Mazón, J.-N., Trujillo, J., Serrano, M., Piattini, M.: Designing Data Warehouses: from Business Requirement Analysis to Multidimensional Modelling. In: Int. Workshop on Requirements Engineering for Business Needs and IT Alignment, REBNITA (2005)
Miller, G.A., Beckwith, R., Fellbaum, C., Gross, D., Miller, K.J.: WordNet: An On-Line Lexical Database. International Journal of Lexicography 3(4) (1990)
Object Management Group (OMG). Unified Modelling Language Specification 1.5 (2004), http://www.omg.org/cgi-bin/doc?formal/03-03-01
Trujillo, J., Palomar, M., Gómez, J., Song, I.Y.: Designing Data Warehouses with OO Conceptual Models. IEEE Computer 34(12), 66–75 (2001)
Yu, E.: Modelling Strategic Relationships for Process Reenginering, Ph.D. thesis. University of Toronto (1995)
Author information
Authors and Affiliations
Editor information
Editors and Affiliations
Rights and permissions
Copyright information
© 2006 Springer-Verlag Berlin Heidelberg
About this paper
Cite this paper
Mazón, JN., Trujillo, J. (2006). Enriching Data Warehouse Dimension Hierarchies by Using Semantic Relations. In: Bell, D.A., Hong, J. (eds) Flexible and Efficient Information Handling. BNCOD 2006. Lecture Notes in Computer Science, vol 4042. Springer, Berlin, Heidelberg. https://doi.org/10.1007/11788911_30
Download citation
DOI: https://doi.org/10.1007/11788911_30
Publisher Name: Springer, Berlin, Heidelberg
Print ISBN: 978-3-540-35969-2
Online ISBN: 978-3-540-35971-5
eBook Packages: Computer ScienceComputer Science (R0)