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

fYear

2011

fDate

27-29 May 2011

Firstpage

305

Lastpage

308

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;

fLanguage

English

Publisher

ieee

Conference_Titel

Communication Software and Networks (ICCSN), 2011 IEEE 3rd International Conference on

Conference_Location

Xi´an

Print_ISBN

978-1-61284-485-5

Type

conf

DOI

10.1109/ICCSN.2011.6014447

Filename

6014447