{"status":"ok","message-type":"work","message-version":"1.0.0","message":{"indexed":{"date-parts":[[2025,6,19]],"date-time":"2025-06-19T04:12:26Z","timestamp":1750306346611,"version":"3.41.0"},"reference-count":17,"publisher":"Association for Computing Machinery (ACM)","issue":"7","license":[{"start":{"date-parts":[[2016,6,24]],"date-time":"2016-06-24T00:00:00Z","timestamp":1466726400000},"content-version":"vor","delay-in-days":0,"URL":"https:\/\/creativecommons.org\/licenses\/by-nc-nd\/4.0\/"}],"content-domain":{"domain":["dl.acm.org"],"crossmark-restriction":true},"short-container-title":["Commun. ACM"],"published-print":{"date-parts":[[2016,6,24]]},"abstract":"<jats:p>Mesa is a highly scalable analytic data warehousing system that stores critical measurement data related to Google's Internet advertising business. Mesa is designed to satisfy a complex and challenging set of user and systems requirements, including near real-time data ingestion and retrieval, as well as high availability, reliability, fault tolerance, and scalability for large data and query volumes. Specifically, Mesa handles petabytes of data, processes millions of row updates per second, and serves billions of queries that fetch trillions of rows per day. Mesa is geo-replicated across multiple datacenters and provides consistent and repeatable query answers at low latency, even when an entire datacenter fails. This paper presents the Mesa system and reports the performance and scale that it achieves.<\/jats:p>","DOI":"10.1145\/2936722","type":"journal-article","created":{"date-parts":[[2016,6,27]],"date-time":"2016-06-27T13:41:38Z","timestamp":1467034898000},"page":"117-125","update-policy":"https:\/\/doi.org\/10.1145\/crossmark-policy","source":"Crossref","is-referenced-by-count":9,"title":["Mesa"],"prefix":"10.1145","volume":"59","author":[{"given":"Ashish","family":"Gupta","sequence":"first","affiliation":[{"name":"Google, Inc."}],"role":[{"role":"author","vocabulary":"crossref"}]},{"given":"Fan","family":"Yang","sequence":"additional","affiliation":[{"name":"Google, Inc."}],"role":[{"role":"author","vocabulary":"crossref"}]},{"given":"Jason","family":"Govig","sequence":"additional","affiliation":[{"name":"Google, Inc."}],"role":[{"role":"author","vocabulary":"crossref"}]},{"given":"Adam","family":"Kirsch","sequence":"additional","affiliation":[{"name":"Google, Inc."}],"role":[{"role":"author","vocabulary":"crossref"}]},{"given":"Kelvin","family":"Chan","sequence":"additional","affiliation":[{"name":"Google, Inc."}],"role":[{"role":"author","vocabulary":"crossref"}]},{"given":"Kevin","family":"Lai","sequence":"additional","affiliation":[{"name":"Google, Inc."}],"role":[{"role":"author","vocabulary":"crossref"}]},{"given":"Shuo","family":"Wu","sequence":"additional","affiliation":[{"name":"Google, Inc."}],"role":[{"role":"author","vocabulary":"crossref"}]},{"given":"Sandeep","family":"Dhoot","sequence":"additional","affiliation":[{"name":"Google, Inc."}],"role":[{"role":"author","vocabulary":"crossref"}]},{"given":"Abhilash Rajesh","family":"Kumar","sequence":"additional","affiliation":[{"name":"Google, Inc."}],"role":[{"role":"author","vocabulary":"crossref"}]},{"given":"Ankur","family":"Agiwal","sequence":"additional","affiliation":[{"name":"Google, Inc."}],"role":[{"role":"author","vocabulary":"crossref"}]},{"given":"Sanjay","family":"Bhansali","sequence":"additional","affiliation":[{"name":"Google, Inc."}],"role":[{"role":"author","vocabulary":"crossref"}]},{"given":"Mingsheng","family":"Hong","sequence":"additional","affiliation":[{"name":"Google, Inc."}],"role":[{"role":"author","vocabulary":"crossref"}]},{"given":"Jamie","family":"Cameron","sequence":"additional","affiliation":[{"name":"Google, Inc."}],"role":[{"role":"author","vocabulary":"crossref"}]},{"given":"Masood","family":"Siddiqi","sequence":"additional","affiliation":[{"name":"Google, Inc."}],"role":[{"role":"author","vocabulary":"crossref"}]},{"given":"David","family":"Jones","sequence":"additional","affiliation":[{"name":"Google, Inc."}],"role":[{"role":"author","vocabulary":"crossref"}]},{"given":"Jeff","family":"Shute","sequence":"additional","affiliation":[{"name":"Google, Inc."}],"role":[{"role":"author","vocabulary":"crossref"}]},{"given":"Andrey","family":"Gubarev","sequence":"additional","affiliation":[{"name":"Google, Inc."}],"role":[{"role":"author","vocabulary":"crossref"}]},{"given":"Shivakumar","family":"Venkataraman","sequence":"additional","affiliation":[{"name":"Google, Inc."}],"role":[{"role":"author","vocabulary":"crossref"}]},{"given":"Divyakant","family":"Agrawal","sequence":"additional","affiliation":[{"name":"Google, Inc."}],"role":[{"role":"author","vocabulary":"crossref"}]}],"member":"320","published-online":{"date-parts":[[2016,6,24]]},"reference":[{"key":"e_1_2_1_1_1","doi-asserted-by":"publisher","DOI":"10.14778\/1687627.1687731"},{"key":"e_1_2_1_2_1","volume-title":"CIDR","author":"Baker J.","year":"2011","unstructured":"Baker , J. , Bond , C. , Megastore: Providing scalable, highly available storage for interactive services . In CIDR ( 2011 ). 223--234. Baker, J., Bond, C., et al. Megastore: Providing scalable, highly available storage for interactive services. In CIDR (2011). 223--234."},{"key":"e_1_2_1_3_1","volume-title":"OSDI","author":"Chang F.","year":"2006","unstructured":"Chang , F. , Dean , J. , Bigtable: A distributed storage system for structured data . In OSDI ( 2006 ). 205--218. Chang, F., Dean, J., et al. Bigtable: A distributed storage system for structured data. In OSDI (2006). 205--218."},{"key":"e_1_2_1_4_1","first-page":"12","volume":"4","author":"Cohen J.","year":"2011","unstructured":"Cohen , J. , Eshleman , J. , Online expansion of largescale data warehouses. PVLDB 4 , 12 ( 2011 ), 1249--1259. Cohen, J., Eshleman, J., et al. Online expansion of largescale data warehouses. PVLDB 4, 12 (2011), 1249--1259.","journal-title":"PVLDB"},{"key":"e_1_2_1_5_1","volume-title":"OSDI","author":"Corbett J.C.","year":"2012","unstructured":"Corbett , J.C. , Dean , J. , Spanner: Google's globally-distributed database . In OSDI ( 2012 ). 251--264. Corbett, J.C., Dean, J., et al. Spanner: Google's globally-distributed database. In OSDI (2012). 251--264."},{"key":"e_1_2_1_6_1","doi-asserted-by":"publisher","DOI":"10.1145\/1327452.1327492"},{"key":"e_1_2_1_7_1","unstructured":"Fikes A. Storage architecture and challenges. http:\/\/goo.gl\/pF6kmz 2010.  Fikes A. Storage architecture and challenges. http:\/\/goo.gl\/pF6kmz 2010."},{"key":"e_1_2_1_8_1","doi-asserted-by":"publisher","DOI":"10.1145\/2043556.2043559"},{"key":"e_1_2_1_9_1","doi-asserted-by":"publisher","DOI":"10.14778\/2732977.2732999"},{"key":"e_1_2_1_10_1","doi-asserted-by":"publisher","DOI":"10.14778\/2367502.2367518"},{"key":"e_1_2_1_11_1","doi-asserted-by":"publisher","DOI":"10.1145\/279227.279229"},{"key":"e_1_2_1_12_1","doi-asserted-by":"publisher","DOI":"10.14778\/2367502.2367516"},{"key":"e_1_2_1_13_1","unstructured":"Project Voldemort: A Distributed Database. http:\/\/www.project-voldemort.com\/voldemort\/.  Project Voldemort: A Distributed Database. http:\/\/www.project-voldemort.com\/voldemort\/."},{"key":"e_1_2_1_14_1","unstructured":"SAP HANA. http:\/\/www.saphana.com\/welcome.  SAP HANA. http:\/\/www.saphana.com\/welcome."},{"key":"e_1_2_1_15_1","doi-asserted-by":"publisher","DOI":"10.14778\/2536222.2536232"},{"key":"e_1_2_1_16_1","doi-asserted-by":"publisher","DOI":"10.1145\/1807167.1807278"},{"key":"e_1_2_1_17_1","volume-title":"A technical overview of the oracle exadata database machine and exadata storage server. Oracle White Paper","author":"Weiss R.","year":"2012","unstructured":"Weiss , R. A technical overview of the oracle exadata database machine and exadata storage server. Oracle White Paper . Oracle Corporation , Redwood Shores , 2012 . Weiss, R. A technical overview of the oracle exadata database machine and exadata storage server. Oracle White Paper. Oracle Corporation, Redwood Shores, 2012."}],"container-title":["Communications of the ACM"],"original-title":[],"language":"en","link":[{"URL":"https:\/\/dl.acm.org\/doi\/10.1145\/2936722","content-type":"unspecified","content-version":"vor","intended-application":"text-mining"},{"URL":"https:\/\/dl.acm.org\/doi\/pdf\/10.1145\/2936722","content-type":"unspecified","content-version":"vor","intended-application":"similarity-checking"}],"deposited":{"date-parts":[[2025,6,18]],"date-time":"2025-06-18T04:55:50Z","timestamp":1750222550000},"score":1,"resource":{"primary":{"URL":"https:\/\/dl.acm.org\/doi\/10.1145\/2936722"}},"subtitle":["a geo-replicated online data warehouse for Google's advertising system"],"short-title":[],"issued":{"date-parts":[[2016,6,24]]},"references-count":17,"journal-issue":{"issue":"7","published-print":{"date-parts":[[2016,6,24]]}},"alternative-id":["10.1145\/2936722"],"URL":"https:\/\/doi.org\/10.1145\/2936722","relation":{},"ISSN":["0001-0782","1557-7317"],"issn-type":[{"type":"print","value":"0001-0782"},{"type":"electronic","value":"1557-7317"}],"subject":[],"published":{"date-parts":[[2016,6,24]]},"assertion":[{"value":"2016-06-24","order":2,"name":"published","label":"Published","group":{"name":"publication_history","label":"Publication History"}}]}}