{"status":"ok","message-type":"work","message-version":"1.0.0","message":{"indexed":{"date-parts":[[2025,11,18]],"date-time":"2025-11-18T11:48:37Z","timestamp":1763466517340},"reference-count":53,"publisher":"Association for Computing Machinery (ACM)","issue":"12","content-domain":{"domain":[],"crossmark-restriction":false},"short-container-title":["Proc. VLDB Endow."],"published-print":{"date-parts":[[2014,8]]},"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 queryability, 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.14778\/2732977.2732999","type":"journal-article","created":{"date-parts":[[2015,5,12]],"date-time":"2015-05-12T15:37:52Z","timestamp":1431445072000},"page":"1259-1270","source":"Crossref","is-referenced-by-count":56,"title":["Mesa"],"prefix":"10.14778","volume":"7","author":[{"given":"Ashish","family":"Gupta","sequence":"first","affiliation":[{"name":"Google, Inc."}]},{"given":"Fan","family":"Yang","sequence":"additional","affiliation":[{"name":"Google, Inc."}]},{"given":"Jason","family":"Govig","sequence":"additional","affiliation":[{"name":"Google, Inc."}]},{"given":"Adam","family":"Kirsch","sequence":"additional","affiliation":[{"name":"Google, Inc."}]},{"given":"Kelvin","family":"Chan","sequence":"additional","affiliation":[{"name":"Google, Inc."}]},{"given":"Kevin","family":"Lai","sequence":"additional","affiliation":[{"name":"Google, Inc."}]},{"given":"Shuo","family":"Wu","sequence":"additional","affiliation":[{"name":"Google, Inc."}]},{"given":"Sandeep Govind","family":"Dhoot","sequence":"additional","affiliation":[{"name":"Google, Inc."}]},{"given":"Abhilash Rajesh","family":"Kumar","sequence":"additional","affiliation":[{"name":"Google, Inc."}]},{"given":"Ankur","family":"Agiwal","sequence":"additional","affiliation":[{"name":"Google, Inc."}]},{"given":"Sanjay","family":"Bhansali","sequence":"additional","affiliation":[{"name":"Google, Inc."}]},{"given":"Mingsheng","family":"Hong","sequence":"additional","affiliation":[{"name":"Google, Inc."}]},{"given":"Jamie","family":"Cameron","sequence":"additional","affiliation":[{"name":"Google, Inc."}]},{"given":"Masood","family":"Siddiqi","sequence":"additional","affiliation":[{"name":"Google, Inc."}]},{"given":"David","family":"Jones","sequence":"additional","affiliation":[{"name":"Google, Inc."}]},{"given":"Jeff","family":"Shute","sequence":"additional","affiliation":[{"name":"Google, Inc."}]},{"given":"Andrey","family":"Gubarev","sequence":"additional","affiliation":[{"name":"Google, Inc."}]},{"given":"Shivakumar","family":"Venkataraman","sequence":"additional","affiliation":[{"name":"Google, Inc."}]},{"given":"Divyakant","family":"Agrawal","sequence":"additional","affiliation":[{"name":"Google, Inc."}]}],"member":"320","published-online":{"date-parts":[[2014,8]]},"reference":[{"key":"e_1_2_1_1_1","unstructured":"HBase. http:\/\/hbase.apache.org\/.  HBase. http:\/\/hbase.apache.org\/."},{"key":"e_1_2_1_2_1","unstructured":"LevelDB. http:\/\/en.wikipedia.org\/wiki\/LevelDB.  LevelDB. http:\/\/en.wikipedia.org\/wiki\/LevelDB."},{"key":"e_1_2_1_3_1","unstructured":"MySQL. http:www.mysql.com.  MySQL. http:www.mysql.com."},{"key":"e_1_2_1_4_1","unstructured":"Project Voldemart: A Distributed Database. http:\/\/www.project-voldemort.com\/voldemort\/.  Project Voldemart: A Distributed Database. http:\/\/www.project-voldemort.com\/voldemort\/."},{"key":"e_1_2_1_5_1","unstructured":"SAP HANA. http:\/\/www.saphana.com\/welcome.  SAP HANA. http:\/\/www.saphana.com\/welcome."},{"key":"e_1_2_1_6_1","doi-asserted-by":"publisher","DOI":"10.14778\/1687627.1687731"},{"key":"e_1_2_1_7_1","doi-asserted-by":"publisher","DOI":"10.1145\/253260.253355"},{"key":"e_1_2_1_8_1","doi-asserted-by":"publisher","DOI":"10.1145\/1559845.1559866"},{"key":"e_1_2_1_9_1","doi-asserted-by":"publisher","DOI":"10.1016\/S0306-4379(02)00051-0"},{"key":"e_1_2_1_10_1","doi-asserted-by":"publisher","DOI":"10.1145\/1989323.1989414"},{"key":"e_1_2_1_11_1","first-page":"223","volume-title":"Highly Available Storage for Interactive Services. In CIDR","author":"Baker J.","year":"2011","unstructured":"J. Baker , C. Bond , : Providing Scalable , Highly Available Storage for Interactive Services. In CIDR , pages 223 -- 234 , 2011 . J. Baker, C. Bond, et al. Megastore: Providing Scalable, Highly Available Storage for Interactive Services. In CIDR, pages 223--234, 2011."},{"key":"e_1_2_1_12_1","first-page":"205","volume-title":"OSDI","author":"Chang F.","year":"2006","unstructured":"F. Chang , J. Dean , : A Distributed Storage System for Structured Data . In OSDI , pages 205 -- 218 , 2006 . F. Chang, J. Dean, et al. Bigtable: A Distributed Storage System for Structured Data. In OSDI, pages 205--218, 2006."},{"key":"e_1_2_1_13_1","doi-asserted-by":"publisher","DOI":"10.14778\/3402755.3402765"},{"key":"e_1_2_1_14_1","doi-asserted-by":"publisher","DOI":"10.1145\/248603.248616"},{"key":"e_1_2_1_15_1","doi-asserted-by":"publisher","DOI":"10.1145\/1042046.1042049"},{"key":"e_1_2_1_16_1","doi-asserted-by":"publisher","DOI":"10.14778\/3402755.3402759"},{"key":"e_1_2_1_17_1","doi-asserted-by":"publisher","DOI":"10.14778\/1454159.1454167"},{"key":"e_1_2_1_18_1","first-page":"251","volume-title":"OSDI","author":"Corbett J. C.","year":"2012","unstructured":"J. C. Corbett , J. Dean , : Google's Globally-Distributed Database . In OSDI , pages 251 -- 264 , 2012 . J. C. Corbett, J. Dean, et al. Spanner: Google's Globally-Distributed Database. In OSDI, pages 251--264, 2012."},{"key":"e_1_2_1_19_1","doi-asserted-by":"publisher","DOI":"10.1145\/1327452.1327492"},{"key":"e_1_2_1_20_1","doi-asserted-by":"publisher","DOI":"10.1145\/1294261.1294281"},{"key":"e_1_2_1_21_1","doi-asserted-by":"publisher","DOI":"10.1145\/276304.276328"},{"key":"e_1_2_1_22_1","unstructured":"A. Fikes. Storage Architecture and Challenges. http:\/\/goo.gl\/pF6kmz 2010.  A. Fikes. Storage Architecture and Challenges. http:\/\/goo.gl\/pF6kmz 2010."},{"key":"e_1_2_1_23_1","doi-asserted-by":"publisher","DOI":"10.1145\/945445.945450"},{"key":"e_1_2_1_24_1","doi-asserted-by":"publisher","DOI":"10.1145\/2043556.2043559"},{"key":"e_1_2_1_25_1","first-page":"152","volume-title":"et al","author":"Gray J.","year":"1996","unstructured":"J. Gray , A. Bosworth , et al . Data Cube : A Relational Aggregation Operator Generalizing Group-By , Cross-Tabs and Sub-Totals. In IEEE ICDE, pages 152 -- 159 , 1996 . J. Gray, A. Bosworth, et al. Data Cube: A Relational Aggregation Operator Generalizing Group-By, Cross-Tabs and Sub-Totals. In IEEE ICDE, pages 152--159, 1996."},{"key":"e_1_2_1_26_1","doi-asserted-by":"publisher","DOI":"10.5555\/645503.656261"},{"key":"e_1_2_1_27_1","doi-asserted-by":"publisher","DOI":"10.1145\/233269.233333"},{"key":"e_1_2_1_28_1","doi-asserted-by":"publisher","DOI":"10.1145\/1807167.1807227"},{"key":"e_1_2_1_29_1","doi-asserted-by":"publisher","DOI":"10.1145\/304182.304186"},{"key":"e_1_2_1_30_1","doi-asserted-by":"publisher","DOI":"10.1145\/212433.220201"},{"key":"e_1_2_1_31_1","doi-asserted-by":"publisher","DOI":"10.1109\/TKDE.2004.42"},{"key":"e_1_2_1_32_1","first-page":"778","volume-title":"VLDB","author":"Lakshmanan L. V. S.","year":"2002","unstructured":"L. V. S. Lakshmanan , J. Pei , : How to Summarize the Semantics of a Data Cube . In VLDB , pages 778 -- 789 , 2002 . L. V. S. Lakshmanan, J. Pei, et al. Quotient cube: How to Summarize the Semantics of a Data Cube. In VLDB, pages 778--789, 2002."},{"key":"e_1_2_1_33_1","doi-asserted-by":"publisher","DOI":"10.1145\/872757.872768"},{"key":"e_1_2_1_34_1","doi-asserted-by":"publisher","DOI":"10.14778\/2367502.2367518"},{"key":"e_1_2_1_35_1","doi-asserted-by":"publisher","DOI":"10.1145\/279227.279229"},{"key":"e_1_2_1_36_1","doi-asserted-by":"publisher","DOI":"10.14778\/2367502.2367516"},{"key":"e_1_2_1_37_1","doi-asserted-by":"publisher","DOI":"10.14778\/1920841.1920886"},{"key":"e_1_2_1_38_1","doi-asserted-by":"publisher","DOI":"10.1145\/253260.253276"},{"key":"e_1_2_1_39_1","doi-asserted-by":"publisher","DOI":"10.1145\/342009.335393"},{"key":"e_1_2_1_40_1","doi-asserted-by":"publisher","DOI":"10.1145\/320473.320484"},{"key":"e_1_2_1_41_1","doi-asserted-by":"publisher","DOI":"10.14778\/2536222.2536232"},{"key":"e_1_2_1_42_1","doi-asserted-by":"publisher","DOI":"10.1145\/564691.564745"},{"key":"e_1_2_1_43_1","first-page":"318","volume-title":"VLDB","author":"Srivastava D.","year":"1996","unstructured":"D. Srivastava , S. Dar , Answering Queries with Aggregation Using Views . In VLDB , pages 318 -- 329 , 1996 . D. Srivastava, S. Dar, et al. Answering Queries with Aggregation Using Views. In VLDB, pages 318--329, 1996."},{"key":"e_1_2_1_44_1","first-page":"553","volume-title":"VLDB","author":"Stonebraker M.","year":"2005","unstructured":"M. Stonebraker , D. J. Abadi , : A Column-oriented DBMS . In VLDB , pages 553 -- 564 , 2005 . M. Stonebraker, D. J. Abadi, et al. C-Store: A Column-oriented DBMS. In VLDB, pages 553--564, 2005."},{"key":"e_1_2_1_45_1","doi-asserted-by":"publisher","DOI":"10.14778\/1687553.1687609"},{"key":"e_1_2_1_46_1","first-page":"996","volume-title":"Hive - A Petabyte Scale Data Warehouse Using Hadoop","author":"Thusoo A.","year":"2010","unstructured":"A. Thusoo , J. Sarma , Hive - A Petabyte Scale Data Warehouse Using Hadoop . In IEEE ICDE , pages 996 -- 1005 , 2010 . A. Thusoo, J. Sarma, et al. Hive - A Petabyte Scale Data Warehouse Using Hadoop. In IEEE ICDE, pages 996--1005, 2010."},{"key":"e_1_2_1_47_1","doi-asserted-by":"publisher","DOI":"10.1145\/1807167.1807278"},{"key":"e_1_2_1_48_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":"R. Weiss . A Technical Overview of the Oracle Exadata Database Machine and Exadata Storage Server. Oracle White Paper . Oracle Corporation , Redwood Shores , 2012 . R. Weiss. A Technical Overview of the Oracle Exadata Database Machine and Exadata Storage Server. Oracle White Paper. Oracle Corporation, Redwood Shores, 2012."},{"key":"e_1_2_1_49_1","doi-asserted-by":"publisher","DOI":"10.1145\/2463676.2463714"},{"key":"e_1_2_1_50_1","doi-asserted-by":"publisher","DOI":"10.14778\/2367502.2367525"},{"key":"e_1_2_1_51_1","doi-asserted-by":"publisher","DOI":"10.1145\/2463676.2465288"},{"key":"e_1_2_1_52_1","first-page":"136","volume-title":"VLDB","author":"Yang J.","year":"1997","unstructured":"J. Yang , K. Karlapalem , Algorithms for Materialized View Design in Data Warehousing Environment . In VLDB , pages 136 -- 145 , 1997 . J. Yang, K. Karlapalem, et al. Algorithms for Materialized View Design in Data Warehousing Environment. In VLDB, pages 136--145, 1997."},{"key":"e_1_2_1_53_1","doi-asserted-by":"publisher","DOI":"10.5555\/382006.383204"}],"container-title":["Proceedings of the VLDB Endowment"],"original-title":[],"language":"en","link":[{"URL":"https:\/\/dl.acm.org\/doi\/pdf\/10.14778\/2732977.2732999","content-type":"unspecified","content-version":"vor","intended-application":"similarity-checking"}],"deposited":{"date-parts":[[2022,12,28]],"date-time":"2022-12-28T11:23:12Z","timestamp":1672226592000},"score":1,"resource":{"primary":{"URL":"https:\/\/dl.acm.org\/doi\/10.14778\/2732977.2732999"}},"subtitle":["geo-replicated, near real-time, scalable data warehousing"],"short-title":[],"issued":{"date-parts":[[2014,8]]},"references-count":53,"journal-issue":{"issue":"12","published-print":{"date-parts":[[2014,8]]}},"alternative-id":["10.14778\/2732977.2732999"],"URL":"https:\/\/doi.org\/10.14778\/2732977.2732999","relation":{},"ISSN":["2150-8097"],"issn-type":[{"value":"2150-8097","type":"print"}],"subject":[],"published":{"date-parts":[[2014,8]]}}}