{"status":"ok","message-type":"work","message-version":"1.0.0","message":{"indexed":{"date-parts":[[2026,2,20]],"date-time":"2026-02-20T04:19:24Z","timestamp":1771561164689,"version":"3.50.1"},"reference-count":24,"publisher":"Association for Computing Machinery (ACM)","issue":"6","license":[{"start":{"date-parts":[[2011,6,1]],"date-time":"2011-06-01T00:00:00Z","timestamp":1306886400000},"content-version":"vor","delay-in-days":0,"URL":"https:\/\/www.acm.org\/publications\/policies\/copyright_policy#Background"}],"content-domain":{"domain":["dl.acm.org"],"crossmark-restriction":true},"short-container-title":["Commun. ACM"],"published-print":{"date-parts":[[2011,6]]},"abstract":"<jats:p>Dremel is a scalable, interactive ad hoc query system for analysis of read-only nested data. By combining multilevel 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.<\/jats:p>","DOI":"10.1145\/1953122.1953148","type":"journal-article","created":{"date-parts":[[2011,6,6]],"date-time":"2011-06-06T11:51:38Z","timestamp":1307361098000},"page":"114-123","update-policy":"https:\/\/doi.org\/10.1145\/crossmark-policy","source":"Crossref","is-referenced-by-count":80,"title":["Dremel"],"prefix":"10.1145","volume":"54","author":[{"given":"Sergey","family":"Melnik","sequence":"first","affiliation":[{"name":"Google, Inc."}]},{"given":"Andrey","family":"Gubarev","sequence":"additional","affiliation":[{"name":"Google, Inc."}]},{"given":"Jing Jing","family":"Long","sequence":"additional","affiliation":[{"name":"Google, Inc."}]},{"given":"Geoffrey","family":"Romer","sequence":"additional","affiliation":[{"name":"Google, Inc."}]},{"given":"Shiva","family":"Shivakumar","sequence":"additional","affiliation":[{"name":"Google, Inc."}]},{"given":"Matt","family":"Tolton","sequence":"additional","affiliation":[{"name":"Google, Inc."}]},{"given":"Theo","family":"Vassilakis","sequence":"additional","affiliation":[{"name":"Google, Inc."}]}],"member":"320","published-online":{"date-parts":[[2011,6]]},"reference":[{"key":"e_1_2_1_1_1","first-page":"2","volume":"2","author":"Abadi D. J.","year":"2009","unstructured":"Abadi , D. J. , Boncz , P. A. , Harizopoulos , S. Column -oriented database systems. VLDB 2 , 2 ( 2009 ). Abadi, D. J., Boncz, P. A., Harizopoulos, S. Column-oriented database systems. VLDB 2, 2 (2009).","journal-title":"VLDB"},{"key":"e_1_2_1_2_1","doi-asserted-by":"publisher","DOI":"10.5555\/551350"},{"key":"e_1_2_1_3_1","first-page":"1","volume":"2","author":"Abouzeid A.","year":"2009","unstructured":"Abouzeid , A. , Bajda-Pawlikowski , K. , Abadi , D. J. , Rasin , A. , Silberschatz , A. Hadoop DB: An architectural hybrid of MapReduce and DBMS technologies for analytical workloads. VLDB 2 , 1 ( 2009 ). Abouzeid, A., Bajda-Pawlikowski, K., Abadi, D. J., Rasin, A., Silberschatz, A. HadoopDB: An architectural hybrid of MapReduce and DBMS technologies for analytical workloads. VLDB 2, 1 (2009).","journal-title":"VLDB"},{"key":"e_1_2_1_4_1","first-page":"10","volume":"1","author":"Bar-Yossef Z.","year":"2002","unstructured":"Bar-Yossef , Z. , Jayram , T. S. , Kumar , R. , Sivakumar , D. , Trevisan , L. Counting distinct elements in a data stream. In RANDOM , 2002 , 1 -- 10 . Bar-Yossef, Z., Jayram, T. S., Kumar, R., Sivakumar, D., Trevisan, L. Counting distinct elements in a data stream. In RANDOM, 2002, 1--10.","journal-title":"RANDOM"},{"key":"e_1_2_1_5_1","doi-asserted-by":"crossref","DOI":"10.1007\/978-3-031-01722-3","volume-title":"The Datacenter as a Computer: An Introduction to the Design of Warehouse-Scale Machines. Morgan &amp","author":"Barroso L. A.","year":"2009","unstructured":"Barroso , L. A. , H\u00f6lzle , U. The Datacenter as a Computer: An Introduction to the Design of Warehouse-Scale Machines. Morgan &amp ; Claypool Publishers , 2009 . Barroso, L. A., H\u00f6lzle, U. The Datacenter as a Computer: An Introduction to the Design of Warehouse-Scale Machines. Morgan &amp; Claypool Publishers, 2009."},{"key":"e_1_2_1_6_1","unstructured":"BigQuery. http:\/\/code.google.com\/apis\/bigquery.  BigQuery. http:\/\/code.google.com\/apis\/bigquery."},{"key":"e_1_2_1_7_1","first-page":"2","volume":"1","author":"Chaiken R.","year":"2008","unstructured":"Chaiken , R. , Jenkins , B. , Larson , P. -?., Ramsey , B. , Shakib , D. , Weaver , S. , Zhou , J. SCOPE: Easy and efficient parallel processing of massive data sets. VLDB 1 , 2 ( 2008 ). Chaiken, R., Jenkins, B., Larson, P.-?., Ramsey, B., Shakib, D., Weaver, S., Zhou, J. SCOPE: Easy and efficient parallel processing of massive data sets. VLDB 1, 2 (2008).","journal-title":"VLDB"},{"key":"e_1_2_1_8_1","doi-asserted-by":"publisher","DOI":"10.1145\/1806596.1806638"},{"key":"e_1_2_1_9_1","volume-title":"OSDI","author":"Chang F.","year":"2006","unstructured":"Chang , F. , Dean , J. , Ghemawat , S. , Hsieh , W. C. , Wallach , D. A. , Burrows , M. , Chandra , T. , Fikes , A. , Gruber , R. Bigtable : A distributed storage system for structured data . In OSDI , 2006 . Chang, F., Dean, J., Ghemawat, S., Hsieh, W. C., Wallach, D. A., Burrows, M., Chandra, T., Fikes, A., Gruber, R. Bigtable: A distributed storage system for structured data. In OSDI, 2006."},{"key":"e_1_2_1_10_1","doi-asserted-by":"publisher","DOI":"10.1145\/67544.66952"},{"key":"e_1_2_1_11_1","doi-asserted-by":"publisher","DOI":"10.1145\/1498759.1498761"},{"key":"e_1_2_1_12_1","volume-title":"OSDI","author":"Dean J.","year":"2004","unstructured":"Dean , J. , Ghemawat , S. MapReduce : Simplified data processing on large clusters . In OSDI , 2004 . Dean, J., Ghemawat, S. MapReduce: Simplified data processing on large clusters. In OSDI, 2004."},{"key":"e_1_2_1_13_1","doi-asserted-by":"publisher","DOI":"10.1145\/1629175.1629198"},{"key":"e_1_2_1_14_1","doi-asserted-by":"publisher","DOI":"10.1145\/945445.945450"},{"key":"e_1_2_1_15_1","unstructured":"Hadoop Apache Project. http:\/\/hadoop.apache.org.  Hadoop Apache Project. http:\/\/hadoop.apache.org."},{"key":"e_1_2_1_16_1","volume-title":"http:\/\/wiki.apache.org\/hadoop\/Hive","author":"Hive","year":"2009","unstructured":"Hive . http:\/\/wiki.apache.org\/hadoop\/Hive , 2009 . Hive. http:\/\/wiki.apache.org\/hadoop\/Hive, 2009."},{"key":"e_1_2_1_17_1","doi-asserted-by":"publisher","DOI":"10.1145\/342009.335405"},{"key":"e_1_2_1_18_1","doi-asserted-by":"publisher","DOI":"10.14778\/1920841.1920886"},{"key":"e_1_2_1_19_1","doi-asserted-by":"publisher","DOI":"10.1145\/1376616.1376726"},{"key":"e_1_2_1_20_1","doi-asserted-by":"publisher","DOI":"10.1145\/1007568.1007686"},{"key":"e_1_2_1_21_1","doi-asserted-by":"publisher","DOI":"10.1155\/2005\/962135"},{"key":"e_1_2_1_22_1","unstructured":"Protocol Buffers: Developer Guide. Available at http:\/\/code.google.com\/apis\/protocolbuffers\/docs\/overview.html.  Protocol Buffers: Developer Guide. Available at http:\/\/code.google.com\/apis\/protocolbuffers\/docs\/overview.html."},{"key":"e_1_2_1_23_1","doi-asserted-by":"publisher","DOI":"10.1145\/1629175.1629197"},{"key":"e_1_2_1_24_1","volume-title":"OSDI","author":"Yu Y.","year":"2008","unstructured":"Yu , Y. , Isard , M. , Fetterly , D. , Budiu , M. , Erlingsson , \u00da., Gunda , P. K. , Currey , J. Dryad LINQ : A system for general-purpose distributed data-parallel computing using a high-level language . In OSDI , 2008 . Yu, Y., Isard, M., Fetterly, D., Budiu, M., Erlingsson, \u00da., Gunda, P. K., Currey, J. DryadLINQ: A system for general-purpose distributed data-parallel computing using a high-level language. In OSDI, 2008."}],"container-title":["Communications of the ACM"],"original-title":[],"language":"en","link":[{"URL":"https:\/\/dl.acm.org\/doi\/10.1145\/1953122.1953148","content-type":"unspecified","content-version":"vor","intended-application":"text-mining"},{"URL":"https:\/\/dl.acm.org\/doi\/pdf\/10.1145\/1953122.1953148","content-type":"unspecified","content-version":"vor","intended-application":"similarity-checking"}],"deposited":{"date-parts":[[2025,6,18]],"date-time":"2025-06-18T10:59:41Z","timestamp":1750244381000},"score":1,"resource":{"primary":{"URL":"https:\/\/dl.acm.org\/doi\/10.1145\/1953122.1953148"}},"subtitle":["interactive analysis of web-scale datasets"],"short-title":[],"issued":{"date-parts":[[2011,6]]},"references-count":24,"journal-issue":{"issue":"6","published-print":{"date-parts":[[2011,6]]}},"alternative-id":["10.1145\/1953122.1953148"],"URL":"https:\/\/doi.org\/10.1145\/1953122.1953148","relation":{},"ISSN":["0001-0782","1557-7317"],"issn-type":[{"value":"0001-0782","type":"print"},{"value":"1557-7317","type":"electronic"}],"subject":[],"published":{"date-parts":[[2011,6]]},"assertion":[{"value":"2011-06-01","order":2,"name":"published","label":"Published","group":{"name":"publication_history","label":"Publication History"}}]}}