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
国际会议
西安
英文
305-308
2011-05-13(万方平台首次上网日期,不代表论文的发表时间)