Title :
The application of materialization strategies on OLAP in column oriented database systems
Author :
Dai, Xiaolei ; Li, Chunqing
Author_Institution :
Comput. Sci. & Software Instn., Tianjin Polytech. Univ., Tianjin, China
Abstract :
Column stores have been widely applied in mass data processing for its great superiority compared to row stores, especially in the field of Online Analytical Processing(OLAP) which requires a significant response speed of query and meanwhile less storage space. Materialization strategies is a very practical query optimization technology used in column stores. In this paper, a detailed introduction to the concept of materialization strategies is made based on the research on storage character and data processing features. And then combining with the Star Schema Benchmark (SSB), two materialization strategies are applied on the complex query of OLAP which shows a remarkable improvement on response speed.
Keywords :
data mining; database management systems; query processing; storage management; OLAP; column oriented database system; column stores; data processing; materialization strategies; online analytical processing; query optimization technology; query response speed; star schema benchmark; Hardware; Material storage; Medical services; Software; Materialization; OLAP; Star Schema Benchmark; Strategis; column stores;
Conference_Titel :
Communication Software and Networks (ICCSN), 2011 IEEE 3rd International Conference on
Conference_Location :
Xi´an
Print_ISBN :
978-1-61284-485-5
DOI :
10.1109/ICCSN.2011.6014447
