Google Research

Dremel: A Decade of Interactive SQL Analysis at Web Scale

  • Andrey Gubarev
  • Dan Delorey
  • Geoffrey Michael Romer
  • Hossein Ahmadi
  • Jeff Shute
  • Jing Jing Long
  • Matt Tolton
  • Mosha Pasumansky
  • Narayanan Shivakumar
  • Sergey Melnik
  • Slava Min
  • Theo Vassilakis
PVLDB (2020), pp. 3461-3472


Google's Dremel was one of the first systems to combine a set of architectural principles that have become a common practice in today's cloud-native analytical systems, such as disaggregated storage and compute, in situ analysis, and columnar storage for semistructured data. In this paper, we discuss how these ideas evolved in the past decade and became the foundation for Google BigQuery.

Learn more about how we do research

We maintain a portfolio of research projects, providing individuals and teams the freedom to emphasize specific types of work