会议专题

The Application of Materialization Strategies on OLAP in Column Oriented Database Systems

Coumn 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.

OLAP column stores Materialization Strategis Star Schema Benchmark

Xiaolei Dai Chunqing Li

Computer Science and Software Institution Tianjin Polytechnic University Tianjin, China

国际会议

2011 2nd International Conference on Data Storage and Data Engineering(DSDE 2011)(2011年第二届数据存储与数据工程国际会议)

西安

英文

305-308

2011-05-13(万方平台首次上网日期,不代表论文的发表时间)