A Solution to Ragged Dimension Problem in OLAP

One problem facing many existing OLAP (On-Line Analytical Process) systems is the so-called ragged dimensions. Ragged dimensions occur if the logical parents of some members in a dimension hierarchy are two or more levels apart. In other words, there exist empty holes in the dimension hierarchy. The...

Full description

Saved in:
Bibliographic Details
Published inAdvances in Natural Computation pp. 1001 - 1005
Main Authors Yuan, Lin, Zou, Hengming, Li, Zhanhuai
Format Book Chapter Conference Proceeding
LanguageEnglish
Published Berlin, Heidelberg Springer Berlin Heidelberg 2005
Springer
SeriesLecture Notes in Computer Science
Subjects
Applied sciences
Artificial intelligence
Computer science; control theory; systems
Dimension Hierarchy
Exact sciences and technology
Information systems. Data bases
Memory organisation. Data processing
Predicate Formula
Province Level
Query Processing
Software
Total Sale
Aggregation
Data processing
Multidimensional database
On line
Database query
Query processing
Online AccessGet full text
ISBN9783540283201
354028320X
3540283234
9783540283232
ISSN0302-9743
1611-3349
DOI10.1007/11539902_128

Cover

More Information
Summary:One problem facing many existing OLAP (On-Line Analytical Process) systems is the so-called ragged dimensions. Ragged dimensions occur if the logical parents of some members in a dimension hierarchy are two or more levels apart. In other words, there exist empty holes in the dimension hierarchy. The problems caused by ragged dimension are two-fold. First, aggregation of measure data could be incorrect. Second, the pre-computation strategy, the most prevalent technique used to speed up query processing in current OLAP system, could be rendered invalid. This paper proposes a simple yet efficient solution to remedy the ragged dimension problem for existing OLAP systems.
ISBN:9783540283201
354028320X
3540283234
9783540283232
ISSN:0302-9743
1611-3349
DOI:10.1007/11539902_128