{"status":"ok","message-type":"work","message-version":"1.0.0","message":{"indexed":{"date-parts":[[2026,2,24]],"date-time":"2026-02-24T17:15:16Z","timestamp":1771953316960,"version":"3.50.1"},"reference-count":43,"publisher":"Association for Computing Machinery (ACM)","issue":"12","content-domain":{"domain":[],"crossmark-restriction":false},"short-container-title":["Proc. VLDB Endow."],"published-print":{"date-parts":[[2019,8]]},"abstract":"<jats:p>Large organizations like YouTube are dealing with exploding data volume and increasing demand for data driven applications. Broadly, these can be categorized as: reporting and dashboarding, embedded statistics in pages, time-series monitoring, and ad-hoc analysis. Typically, organizations build specialized infrastructure for each of these use cases. This, however, creates silos of data and processing, and results in a complex, expensive, and harder to maintain infrastructure.<\/jats:p>\n          <jats:p>At YouTube, we solved this problem by building a new SQL query engine - Procella. Procella implements a superset of capabilities required to address all of the four use cases above, with high scale and performance, in a single product. Today, Procella serves hundreds of billions of queries per day across all four workloads at YouTube and several other Google product areas.<\/jats:p>","DOI":"10.14778\/3352063.3352121","type":"journal-article","created":{"date-parts":[[2019,9,18]],"date-time":"2019-09-18T18:36:11Z","timestamp":1568831771000},"page":"2022-2034","source":"Crossref","is-referenced-by-count":22,"title":["Procella"],"prefix":"10.14778","volume":"12","author":[{"given":"Biswapesh","family":"Chattopadhyay","sequence":"first","affiliation":[{"name":"Google LLC"}]},{"given":"Priyam","family":"Dutta","sequence":"additional","affiliation":[{"name":"Google LLC"}]},{"given":"Weiran","family":"Liu","sequence":"additional","affiliation":[{"name":"Google LLC"}]},{"given":"Ott","family":"Tinn","sequence":"additional","affiliation":[{"name":"Google LLC"}]},{"given":"Andrew","family":"Mccormick","sequence":"additional","affiliation":[{"name":"Google LLC"}]},{"given":"Aniket","family":"Mokashi","sequence":"additional","affiliation":[{"name":"Google LLC"}]},{"given":"Paul","family":"Harvey","sequence":"additional","affiliation":[{"name":"Google LLC"}]},{"given":"Hector","family":"Gonzalez","sequence":"additional","affiliation":[{"name":"Google LLC"}]},{"given":"David","family":"Lomax","sequence":"additional","affiliation":[{"name":"Google LLC"}]},{"given":"Sagar","family":"Mittal","sequence":"additional","affiliation":[{"name":"Google LLC"}]},{"given":"Roee","family":"Ebenstein","sequence":"additional","affiliation":[{"name":"Google LLC"}]},{"given":"Nikita","family":"Mikhaylin","sequence":"additional","affiliation":[{"name":"Google LLC"}]},{"given":"Hung-ching","family":"Lee","sequence":"additional","affiliation":[{"name":"Google LLC"}]},{"given":"Xiaoyan","family":"Zhao","sequence":"additional","affiliation":[{"name":"Google LLC"}]},{"given":"Tony","family":"Xu","sequence":"additional","affiliation":[{"name":"Google LLC"}]},{"given":"Luis","family":"Perez","sequence":"additional","affiliation":[{"name":"Google LLC"}]},{"given":"Farhad","family":"Shahmohammadi","sequence":"additional","affiliation":[{"name":"Google LLC"}]},{"given":"Tran","family":"Bui","sequence":"additional","affiliation":[{"name":"Google LLC"}]},{"given":"Neil","family":"McKay","sequence":"additional","affiliation":[{"name":"Google LLC"}]},{"given":"Selcuk","family":"Aya","sequence":"additional","affiliation":[{"name":"Google LLC"}]},{"given":"Vera","family":"Lychagina","sequence":"additional","affiliation":[{"name":"Google LLC"}]},{"given":"Brett","family":"Elliott","sequence":"additional","affiliation":[{"name":"Google LLC"}]}],"member":"320","published-online":{"date-parts":[[2019,8]]},"reference":[{"key":"e_1_2_1_1_1","doi-asserted-by":"publisher","DOI":"10.1561\/1900000024"},{"key":"e_1_2_1_2_1","doi-asserted-by":"publisher","DOI":"10.1145\/1142473.1142548"},{"key":"e_1_2_1_3_1","first-page":"496","volume-title":"VLDB '00","author":"Agrawal S.","year":"2000"},{"key":"e_1_2_1_4_1","volume-title":"In-memory query execution in Google BigQuery","author":"Ahmadi H.","year":"2016"},{"key":"e_1_2_1_5_1","doi-asserted-by":"publisher","DOI":"10.1145\/2723372.2742797"},{"key":"e_1_2_1_6_1","doi-asserted-by":"publisher","DOI":"10.14778\/3055540.3055545"},{"key":"e_1_2_1_7_1","volume-title":"A Confluence of Column Stores and Search Engines: Opportunities and Challenges","author":"Bj\u00f8rklund T. A.","year":"2016"},{"key":"e_1_2_1_8_1","volume-title":"Scientific Programming","author":"Bramas B.","year":"2017"},{"key":"e_1_2_1_9_1","doi-asserted-by":"publisher","DOI":"10.14778\/2733004.2733020"},{"key":"e_1_2_1_10_1","doi-asserted-by":"publisher","DOI":"10.1002\/spe.2325"},{"key":"e_1_2_1_11_1","doi-asserted-by":"publisher","DOI":"10.1145\/1365815.1365816"},{"key":"e_1_2_1_12_1","doi-asserted-by":"publisher","DOI":"10.1145\/2491245"},{"key":"e_1_2_1_13_1","doi-asserted-by":"publisher","DOI":"10.1145\/2882903.2903741"},{"key":"e_1_2_1_14_1","doi-asserted-by":"publisher","DOI":"10.1145\/2408776.2408794"},{"key":"e_1_2_1_15_1","doi-asserted-by":"publisher","DOI":"10.1145\/1327452.1327492"},{"key":"e_1_2_1_16_1","doi-asserted-by":"publisher","DOI":"10.5555\/1331939.1331940"},{"key":"e_1_2_1_17_1","volume-title":"Real-time Analytics at Massive Scale with Pinot","author":"Dhaval Patel K. G.","year":"2014"},{"key":"e_1_2_1_18_1","doi-asserted-by":"publisher","DOI":"10.1109\/BigData.2015.7363790"},{"key":"e_1_2_1_19_1","doi-asserted-by":"publisher","DOI":"10.1145\/3085504.3085529"},{"key":"e_1_2_1_20_1","doi-asserted-by":"publisher","DOI":"10.1109\/eScience.2018.00134"},{"key":"e_1_2_1_21_1","doi-asserted-by":"publisher","DOI":"10.1145\/2882903.2882945"},{"key":"e_1_2_1_22_1","volume-title":"Presto: Distributed SQL Query Engine for Big Data","author":"Facebook Inc.","year":"2015"},{"key":"e_1_2_1_23_1","volume-title":"Beringei: A high-performance time series storage engine","author":"Facebook Inc.","year":"2016"},{"key":"e_1_2_1_24_1","unstructured":"A. Fikes. Storage Architecture and Challenges 2010.  A. Fikes. Storage Architecture and Challenges 2010."},{"key":"e_1_2_1_25_1","volume-title":"Vitess: Database clustering system for horizontal scaling of MySQL","year":"2003"},{"key":"e_1_2_1_26_1","doi-asserted-by":"publisher","DOI":"10.1145\/2723372.2742795"},{"key":"e_1_2_1_27_1","doi-asserted-by":"publisher","DOI":"10.14778\/2732977.2732999"},{"key":"e_1_2_1_28_1","doi-asserted-by":"publisher","DOI":"10.14778\/2350229.2350259"},{"key":"e_1_2_1_29_1","doi-asserted-by":"publisher","DOI":"10.1145\/2452376.2452456"},{"key":"e_1_2_1_30_1","volume-title":"InfluxDB: The Time Series Database in the TICK Stack","author":"InfluxData Inc.","year":"2013"},{"key":"e_1_2_1_31_1","volume-title":"Is query optimization a \"solved\" problem?","year":"2014"},{"key":"e_1_2_1_32_1","volume-title":"Google's Planet Scale Monitoring Infrastructure","author":"Lupi R.","year":"2016"},{"key":"e_1_2_1_33_1","doi-asserted-by":"publisher","DOI":"10.14778\/1920841.1920886"},{"key":"e_1_2_1_34_1","volume-title":"BigQuery's next-generation columnar storage format","author":"Pasumansky Mosha","year":"2016"},{"key":"e_1_2_1_35_1","unstructured":"Nathan Marz. Lambda Architecture 2013.  Nathan Marz. Lambda Architecture 2013."},{"key":"e_1_2_1_36_1","doi-asserted-by":"publisher","DOI":"10.14778\/2824032.2824078"},{"key":"e_1_2_1_37_1","doi-asserted-by":"publisher","DOI":"10.1145\/2723372.2747645"},{"key":"e_1_2_1_38_1","volume-title":"Part 1: Add Spark to a Big Data Application with Text Search Capability","author":"Prakash Das I. I.","year":"2016"},{"key":"e_1_2_1_39_1","doi-asserted-by":"publisher","DOI":"10.14778\/3229863.3229871"},{"key":"e_1_2_1_40_1","doi-asserted-by":"publisher","DOI":"10.1145\/1376616.1376744"},{"key":"e_1_2_1_41_1","volume-title":"gRPC: a true internet-scale RPC framework is now 1.0 and ready for production deployments","author":"Talwar Varun","year":"2016"},{"key":"e_1_2_1_42_1","doi-asserted-by":"publisher","DOI":"10.1145\/2741948.2741964"},{"key":"e_1_2_1_43_1","doi-asserted-by":"publisher","DOI":"10.1145\/2588555.2595631"}],"container-title":["Proceedings of the VLDB Endowment"],"original-title":[],"language":"en","link":[{"URL":"https:\/\/dl.acm.org\/doi\/pdf\/10.14778\/3352063.3352121","content-type":"unspecified","content-version":"vor","intended-application":"similarity-checking"}],"deposited":{"date-parts":[[2022,12,28]],"date-time":"2022-12-28T10:41:19Z","timestamp":1672224079000},"score":1,"resource":{"primary":{"URL":"https:\/\/dl.acm.org\/doi\/10.14778\/3352063.3352121"}},"subtitle":["unifying serving and analytical data at YouTube"],"short-title":[],"issued":{"date-parts":[[2019,8]]},"references-count":43,"journal-issue":{"issue":"12","published-print":{"date-parts":[[2019,8]]}},"alternative-id":["10.14778\/3352063.3352121"],"URL":"https:\/\/doi.org\/10.14778\/3352063.3352121","relation":{},"ISSN":["2150-8097"],"issn-type":[{"value":"2150-8097","type":"print"}],"subject":[],"published":{"date-parts":[[2019,8]]}}}