Solution for Data Growth Problem of MOLAP
Jian Xu, Yong Luo, Xin Zhou · Applied Mechanics and Materials · 2013
Because MOLAP uses Multi-dimensional database (MDDB) to store data, there are limits to implement OLAP, such as data growth. Also, there is a close relationship between the influencing factor of MOLAP data growth and OLAP model, and the models will influence the size of cubes, also the performance and expansibility of OLAP system. This paper studies the approaches of MOLAP data storage organization, aggregate levels of dimension, compound growth factor (CGF), the relationship of query performance and percentage pre-calculated, and giving a brief analysis to how to use CGF to ravel out the data growth of MOLAP.