Welcome to the InfoSci Platform
Empowering the OLAP Technology to Support Complex Dimension Hierarchies

Empowering the OLAP Technology to Support Complex Dimension Hierarchies

Svetlana Mansmann
Copyright: © 2009 |Pages: 21
ISBN13: 9781605660981|ISBN10: 1605660981|ISBN13 Softcover: 9781616926045|EISBN13: 9781605660998
DOI: 10.4018/978-1-60566-098-1.ch022
Cite Chapter Cite Chapter

MLA

Mansmann, Svetlana. "Empowering the OLAP Technology to Support Complex Dimension Hierarchies." Selected Readings on Database Technologies and Applications, edited by Terry Halpin, IGI Global, 2009, pp. 450-470. https://doi.org/10.4018/978-1-60566-098-1.ch022

APA

Mansmann, S. (2009). Empowering the OLAP Technology to Support Complex Dimension Hierarchies. In T. Halpin (Ed.), Selected Readings on Database Technologies and Applications (pp. 450-470). IGI Global. https://doi.org/10.4018/978-1-60566-098-1.ch022

Chicago

Mansmann, Svetlana. "Empowering the OLAP Technology to Support Complex Dimension Hierarchies." In Selected Readings on Database Technologies and Applications, edited by Terry Halpin, 450-470. Hershey, PA: IGI Global, 2009. https://doi.org/10.4018/978-1-60566-098-1.ch022

Export Reference

Mendeley
Favorite

Abstract

Comprehensive data analysis has become indispensable in a variety of domains. OLAP (On-Line Analytical Processing) systems tend to perform poorly or even fail when applied to complex data scenarios. The restriction of the underlying multidimensional data model to admit only homogeneous and balanced dimension hierarchies is too rigid for many real-world applications and, therefore, has to be overcome in order to provide adequate OLAP support. We present a framework for classifying and modeling complex multidimensional data, with the major effort at the conceptual level as to transform irregular hierarchies to make them navigable in a uniform manner. The properties of various hierarchy types are formalized and a two-phase normalization approach is proposed: heterogeneous dimensions are reshaped into a set of well-behaved homogeneous subdimensions, followed by the enforcement of summarizability in each dimension’s data hierarchy. Mapping the data to a visual data browser relies solely on metadata, which captures the properties of facts, dimensions, and relationships within the dimensions. The navigation is schema-based, that is, users interact with dimensional levels with ondemand data display. The power of our approach is exemplified using a real-world study from the domain of academic administration.

Request Access

You do not own this content. Please login to recommend this title to your institution's librarian or purchase it from the IGI Global bookstore.