{"status":"ok","message-type":"work","message-version":"1.0.0","message":{"indexed":{"date-parts":[[2026,6,1]],"date-time":"2026-06-01T20:36:33Z","timestamp":1780346193032,"version":"3.54.1"},"reference-count":24,"publisher":"Association for Computing Machinery (ACM)","issue":"11","content-domain":{"domain":[],"crossmark-restriction":false},"short-container-title":["Proc. VLDB Endow."],"published-print":{"date-parts":[[2013,8,27]]},"abstract":"<jats:p>F1 is a distributed relational database system built at Google to support the AdWords business. F1 is a hybrid database that combines high availability, the scalability of NoSQL systems like Bigtable, and the consistency and usability of traditional SQL databases. F1 is built on Spanner, which provides synchronous cross-datacenter replication and strong consistency. Synchronous replication implies higher commit latency, but we mitigate that latency by using a hierarchical schema model with structured data types and through smart application design. F1 also includes a fully functional distributed SQL query engine and automatic change tracking and publishing.<\/jats:p>","DOI":"10.14778\/2536222.2536232","type":"journal-article","created":{"date-parts":[[2014,6,24]],"date-time":"2014-06-24T12:17:57Z","timestamp":1403612277000},"page":"1068-1079","source":"Crossref","is-referenced-by-count":178,"title":["F1"],"prefix":"10.14778","volume":"6","author":[{"given":"Jeff","family":"Shute","sequence":"first","affiliation":[{"name":"Google, Inc."}],"role":[{"vocabulary":"crossref","role":"author"}]},{"given":"Radek","family":"Vingralek","sequence":"additional","affiliation":[{"name":"Google, Inc."}],"role":[{"vocabulary":"crossref","role":"author"}]},{"given":"Bart","family":"Samwel","sequence":"additional","affiliation":[{"name":"Google, Inc."}],"role":[{"vocabulary":"crossref","role":"author"}]},{"given":"Ben","family":"Handy","sequence":"additional","affiliation":[{"name":"Google, Inc."}],"role":[{"vocabulary":"crossref","role":"author"}]},{"given":"Chad","family":"Whipkey","sequence":"additional","affiliation":[{"name":"Google, Inc."}],"role":[{"vocabulary":"crossref","role":"author"}]},{"given":"Eric","family":"Rollins","sequence":"additional","affiliation":[{"name":"Google, Inc."}],"role":[{"vocabulary":"crossref","role":"author"}]},{"given":"Mircea","family":"Oancea","sequence":"additional","affiliation":[{"name":"Google, Inc."}],"role":[{"vocabulary":"crossref","role":"author"}]},{"given":"Kyle","family":"Littlefield","sequence":"additional","affiliation":[{"name":"Google, Inc."}],"role":[{"vocabulary":"crossref","role":"author"}]},{"given":"David","family":"Menestrina","sequence":"additional","affiliation":[{"name":"Google, Inc."}],"role":[{"vocabulary":"crossref","role":"author"}]},{"given":"Stephan","family":"Ellner","sequence":"additional","affiliation":[{"name":"Google, Inc."}],"role":[{"vocabulary":"crossref","role":"author"}]},{"given":"John","family":"Cieslewicz","sequence":"additional","affiliation":[{"name":"Google, Inc."}],"role":[{"vocabulary":"crossref","role":"author"}]},{"given":"Ian","family":"Rae","sequence":"additional","affiliation":[{"name":"University of Wisconsin-Madison and Google, Inc."}],"role":[{"vocabulary":"crossref","role":"author"}]},{"given":"Traian","family":"Stancescu","sequence":"additional","affiliation":[{"name":"Google, Inc."}],"role":[{"vocabulary":"crossref","role":"author"}]},{"given":"Himani","family":"Apte","sequence":"additional","affiliation":[{"name":"Google, Inc."}],"role":[{"vocabulary":"crossref","role":"author"}]}],"member":"320","published-online":{"date-parts":[[2013,8]]},"reference":[{"key":"e_1_2_1_1_1","unstructured":"Apache Foundation. Apache HBase. http:\/\/hbase.apache.org\/."},{"key":"e_1_2_1_2_1","doi-asserted-by":"publisher","DOI":"10.5555\/140592.140595"},{"key":"e_1_2_1_3_1","first-page":"223","volume-title":"CIDR","author":"Baker J.","year":"2011","unstructured":"J. Baker et al. Megastore: Providing scalable, highly available storage for interactive services. In CIDR, pages 223-234, 2011."},{"key":"e_1_2_1_4_1","doi-asserted-by":"publisher","DOI":"10.1145\/223784.223785"},{"key":"e_1_2_1_5_1","doi-asserted-by":"publisher","DOI":"10.1145\/343477.343502"},{"key":"e_1_2_1_6_1","doi-asserted-by":"publisher","DOI":"10.5555\/1267308.1267323"},{"key":"e_1_2_1_7_1","doi-asserted-by":"publisher","DOI":"10.5555\/2387880.2387905"},{"key":"e_1_2_1_8_1","doi-asserted-by":"publisher","DOI":"10.1145\/2445583.2445588"},{"key":"e_1_2_1_9_1","doi-asserted-by":"publisher","DOI":"10.1145\/1807128.1807130"},{"key":"e_1_2_1_10_1","doi-asserted-by":"publisher","DOI":"10.5555\/1251254.1251264"},{"key":"e_1_2_1_11_1","doi-asserted-by":"publisher","DOI":"10.1145\/1294261.1294281"},{"key":"e_1_2_1_12_1","doi-asserted-by":"publisher","DOI":"10.1109\/69.50905"},{"key":"e_1_2_1_13_1","doi-asserted-by":"publisher","DOI":"10.1145\/360363.360369"},{"key":"e_1_2_1_14_1","volume-title":"Google Faculty Summit","author":"Fikes A.","year":"2010","unstructured":"A. Fikes. Storage architecture and challenges. Google Faculty Summit, July 2010."},{"key":"e_1_2_1_15_1","doi-asserted-by":"publisher","DOI":"10.1145\/342009.335422"},{"key":"e_1_2_1_16_1","unstructured":"Google Inc. Protocol buffers. https:\/\/developers.google.com\/protocol-buffers\/."},{"key":"e_1_2_1_17_1","doi-asserted-by":"publisher","DOI":"10.1145\/2465351.2465363"},{"key":"e_1_2_1_18_1","doi-asserted-by":"publisher","DOI":"10.1145\/279227.279229"},{"key":"e_1_2_1_19_1","doi-asserted-by":"publisher","DOI":"10.5555\/1924943.1924961"},{"key":"e_1_2_1_20_1","volume-title":"Online, asynchronous schema change in F1. PVLDB, 6(11)","author":"Rae I.","year":"2013","unstructured":"I. Rae et al. Online, asynchronous schema change in F1. PVLDB, 6(11), 2013."},{"key":"e_1_2_1_21_1","doi-asserted-by":"publisher","DOI":"10.1145\/49346.49347"},{"key":"e_1_2_1_22_1","doi-asserted-by":"publisher","DOI":"10.1145\/2213836.2213954"},{"key":"e_1_2_1_23_1","doi-asserted-by":"publisher","DOI":"10.1145\/1721654.1721659"},{"key":"e_1_2_1_24_1","doi-asserted-by":"publisher","DOI":"10.5555\/378243"}],"container-title":["Proceedings of the VLDB Endowment"],"original-title":[],"language":"en","link":[{"URL":"https:\/\/dl.acm.org\/doi\/pdf\/10.14778\/2536222.2536232","content-type":"unspecified","content-version":"vor","intended-application":"similarity-checking"}],"deposited":{"date-parts":[[2024,10,23]],"date-time":"2024-10-23T22:35:39Z","timestamp":1729722939000},"score":1,"resource":{"primary":{"URL":"https:\/\/dl.acm.org\/doi\/10.14778\/2536222.2536232"}},"subtitle":["a distributed SQL database that scales"],"short-title":[],"issued":{"date-parts":[[2013,8]]},"references-count":24,"journal-issue":{"issue":"11","published-print":{"date-parts":[[2013,8,27]]}},"alternative-id":["10.14778\/2536222.2536232"],"URL":"https:\/\/doi.org\/10.14778\/2536222.2536232","relation":{},"ISSN":["2150-8097"],"issn-type":[{"value":"2150-8097","type":"print"}],"subject":[],"published":{"date-parts":[[2013,8]]}}}