用于高效混合OLAP的属性值重排序
Attribute Value Reordering For Efficient Hybrid OLAP
摘要:
数据立方体的规范化是属性值的排序。对于密集块和稀疏块存储方式不同的大型多维数组,适当的规范化可以提高存储效率。我们表明,即使对于1x 3块,计算最佳归一化也是NP难的,尽管我们找到了1x 2块的精确算法。当维度几乎统计独立时,我们证明了维度属性频率排序是最佳的归一化,对于大小为n^d的数据立方体,时间为O(d n log(n))。当维度不是独立的时,我们提出并评估了几种算法。混合OLAP(HOOLDER)存储机制的效率已经比ROOLDER高出19%-30%,但规范化可以进一步提高9%-13%,总增益比ROOLDER高29%-44%。
英文摘要:
The normalization of a data cube is the ordering of the attribute values. For large multidimensional arrays where dense and sparse chunks are stored differently, proper normalization can lead to improved storage efficiency. We show that it is NP-hard to compute an optimal normalization even for 1x3 chunks, although we find an exact algorithm for 1x2 chunks. When dimensions are nearly statistically independent, we show that dimension-wise attribute frequency sorting is an optimal normalization and takes time O(d n log(n)) for data cubes of size n^d. When dimensions are not independent, we propose and evaluate several heuristics. The hybrid OLAP (HOLAP) storage mechanism is already 19%-30% more efficient than ROLAP, but normalization can improve it further by 9%-13% for a total gain of 29%-44% over ROLAP.
机构、总结、中文摘要均由AI分析而来,可能存在错误,请以论文正文为准。