Sweet KIWI: Statistics-Driven OLAP Acceleration using Query Column Sets

KIWI is a SQL-on-Hadoop system enabling batch and interactive analytics for big data. In database systems, materialized views, stored pre-computed results for queries, are one of the most commonly used techniques to improve the query processing speed. However, the key challenge in using materialized views is maintaining their freshness as base data changes. This paper introduces a new approach for accelerating OLAP query processing using query workload statistics and query column sets instead of materialized views. We present an architecture of SQL-on-Hadoop system using query column sets of original tables in database. The experimental results demonstrate that our system can provide improved perfor

• Type: Journal
• Year: 2016
• Where: EDBT
• Authors: Sung-Soo Kim, Taewhi Lee, Moonyoung Chung, Jongho Won
• Keywords: Database, EDBT 2016