Empowering the OLAP Technology to Support Complex Dimension Hierarchies

doi:10.4018/jdwm.2007100102

Reference Hub

This research has been cited in:

Article
Hierarchy Classification for Data Warehouse: A SurveyProcedia Technology10.1016/j.protcy.2012.10.055
Chapter
A Unified Object Constraint Model for Designing and Implementing Multidimensional SystemsJournal on Data Semantics XIII10.1007/978-3-642-03098-7_2
Article
A survey on summarizability issues in multidimensional modelingData & Knowledge Engineering10.1016/j.datak.2009.07.010
Conference
Scalable test data generation from multidimensional modelsProceedings of the ACM SIGSOFT 20th International Symposium on the Foundations of Software Engineering10.1145/2393596.2393637
Chapter
Conceptual Multidimensional Modeling for Data Warehouses: A SurveyProceedings of the 3rd International Conference on Frontiers of Intelligent Computing: Theory and Applications (FICTA) 201410.1007/978-3-319-11933-5_33
Conference
The Dimensional Analysis of Data Flow Programs That Include Multidimensional and User-Defined Functions2022 IEEE International Conference on Big Data (Big Data)10.1109/BigData55660.2022.10020739
Chapter
Document-Oriented Data Warehouses: Complex Hierarchies and SummarizabilityAdvances in Ubiquitous Networking 210.1007/978-981-10-1627-1_53
Chapter
Multidimensional Data Modeling for Business Process AnalysisConceptual Modeling - ER 200710.1007/978-3-540-75563-0_4
Article
Quality metrics emphasizing dimension hierarchy sharing in multidimensional models for data warehouse: a theoretical and empirical evaluationInternational Journal of System Assurance Engineering and Management10.1007/s13198-017-0641-5
Conference
Faceted Search in Business Intelligence on the Cloud2013 IEEE International Conference on Green Computing and Communications and IEEE Internet of Things and IEEE Cyber, Physical and Social Computing10.1109/GreenCom-iThings-CPSCom.2013.148
Chapter
Quality Metrics for Data Warehouse Multidimensional Models with Focus on Dimension Hierarchy SharingAdvances in Intelligent Informatics10.1007/978-3-319-11218-3_39
Chapter
Discovering Dynamic Classification Hierarchies in OLAP DimensionsFoundations of Intelligent Systems10.1007/978-3-642-34624-8_48
Article
Integrating Star and Snowflake Schemas in Data WarehousesInternational Journal of Data Warehousing and Mining10.4018/jdwm.2012100102

Empowering the OLAP Technology to Support Complex Dimension Hierarchies

Svetlana Mansmann, Marc H. Scholl

Source Title: International Journal of Data Warehousing and Mining (IJDWM)3(4)

Cite Article Cite Article

MLA

Mansmann, Svetlana, and Marc H. Scholl. "Empowering the OLAP Technology to Support Complex Dimension Hierarchies." IJDWM vol.3, no.4 2007: pp.31-50. http://doi.org/10.4018/jdwm.2007100102

APA

Mansmann, S. & Scholl, M. H. (2007). Empowering the OLAP Technology to Support Complex Dimension Hierarchies. International Journal of Data Warehousing and Mining (IJDWM), 3(4), 31-50. http://doi.org/10.4018/jdwm.2007100102

Chicago

Mansmann, Svetlana, and Marc H. Scholl. "Empowering the OLAP Technology to Support Complex Dimension Hierarchies," International Journal of Data Warehousing and Mining (IJDWM) 3, no.4: 31-50. http://doi.org/10.4018/jdwm.2007100102

Export Reference

Favorite Full-Issue Download

View Full Text PDF

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 wellbehaved 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 on-demand data display. The power of our approach is exemplified using a real-world study from the domain of academic administration.

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.

Username or email: *

Password: *

Forgot individual login password?

Create individual account

Empowering the OLAP Technology to Support Complex Dimension Hierarchies

MLA

APA

Chicago

Export Reference

Abstract

Request Access