TY - JOUR AU - Melnik, Sergey AU - Gubarev, Andrey AU - Long, Jing Jing AU - Romer, Geoffrey AU - Shivakumar, Shiva AU - Tolton, Matt AU - Vassilakis, Theo T1 - Dremel: interactive analysis of web-scale datasets JO - Proceedings of the VLDB Endowment PY - 2010/10 VL - 3 IS - 1-2 SP - 330 EP - 339 UR - http://dl.acm.org/citation.cfm?id=1920841.1920886 M3 - KW - google KW - analysis KW - interactive KW - search KW - dremel KW - web L1 - SN - N1 - N1 - AB - Dremel is a scalable, interactive ad-hoc query system for analysis of read-only nested data. By combining multi-level execution trees and columnar data layout, it is capable of running aggregation queries over trillion-row tables in seconds. The system scales to thousands of CPUs and petabytes of data, and has thousands of users at Google. In this paper, we describe the architecture and implementation of Dremel, and explain how it complements MapReduce-based computing. We present a novel columnar storage representation for nested records and discuss experiments on few-thousand node instances of the system. ER -