IMI-BAS
 

BulDML at Institute of Mathematics and Informatics >
IMI >
IMI Periodicals >
Serdica Journal of Computing >
2011 >
Volume 5 Number 4 >

Please use this identifier to cite or link to this item: http://hdl.handle.net/10525/1630

Title: A Super-Dimension Approach in ROLAP Environments
Authors: Naydenova, Ina
Keywords: Combine
Composite
Dimension
Concatenation
OLAP
Issue Date: 2011
Publisher: Institute of Mathematics and Informatics Bulgarian Academy of Sciences
Citation: Serdica Journal of Computing, Vol. 5, No 4, (2011), 309p-322p
Abstract: Often the designer of ROLAP applications follows up with the question “can I create a little joiner table with just the two dimension keys and then connect that table to the fact table?” In a classic dimensional model there are two options - (a) both dimensions are modeled independently or (b) two dimensions are combined into a super-dimension with a single key. The second approach is not widely used in ROLAP environments but it is an important sparsity handling method in MOLAP systems. In ROLAP this design technique can also bring storage and performance benefits, although the model becomes more complicated. The dependency between dimensions is a key factor that the designers have to consider when choosing between the two options. In this paper we present the results of our storage and performance experiments over a real life data cubes in reference to these design approaches. Some conclusions are drawn.
URI: http://hdl.handle.net/10525/1630
ISSN: 1312-6555
Appears in Collections:Volume 5 Number 4

Files in This Item:

File Description SizeFormat
sjc-vol5-num4-2011-309p-322p.pdf158.02 kBAdobe PDFView/Open

 



Items in DSpace are protected by copyright, with all rights reserved, unless otherwise indicated.

 

Valid XHTML 1.0! DSpace Software Copyright © 2002-2009  The DSpace Foundation - Feedback