{"status":"ok","message-type":"work","message-version":"1.0.0","message":{"indexed":{"date-parts":[[2026,9,4]],"date-time":"2026-09-04T00:43:40Z","timestamp":1788482620686,"version":"build-2803163510"},"reference-count":71,"publisher":"Association for Computing Machinery (ACM)","issue":"4","license":[{"start":{"date-parts":[[2017,12,1]],"date-time":"2017-12-01T00:00:00Z","timestamp":1512086400000},"content-version":"vor","delay-in-days":0,"URL":"https:\/\/www.acm.org\/publications\/policies\/copyright_policy#Background"}],"content-domain":{"domain":[],"crossmark-restriction":false},"short-container-title":["Proc. VLDB Endow."],"published-print":{"date-parts":[[2017,12]]},"abstract":"<jats:p>Hot standby systems often have to trade safety (i.e., not losing committed work) and freshness (i.e., having access to recent updates) for performance. Guaranteeing safety requires synchronous log shipping that blocks the primary until the log records are durably replicated in one or multiple backups; maintaining freshness necessitates fast log replay on backups, but is often defeated by the dual-copy architecture and serial replay: a backup must generate the \"real\" data from the log to make recent updates accessible to read-only queries.<\/jats:p>\n          <jats:p>\n            This paper proposes\n            <jats:italic>Query Fresh<\/jats:italic>\n            , a hot standby system that provides both safety and freshness while maintaining high performance on the primary. The crux is an append-only storage architecture used in conjunction with fast networks (e.g., InfiniBand) and byte-addressable, non-volatile memory (NVRAM). Query Fresh avoids the dual-copy design and treats the log as the database, enabling lightweight, parallel log replay that does not block the primary.\n          <\/jats:p>\n          <jats:p>Experimental results using the TPC-C benchmark show that under Query Fresh, backup servers can replay log records faster than they are generated by the primary server, using one quarter of the available compute resources. With a 56Gbps network, Query Fresh can support up to 4--5 synchronous replicas, each of which receives and replays \u223c1.4GB of log records per second, with up to 4--6% overhead on the primary compared to a standalone server that achieves 620kTPS without replication.<\/jats:p>","DOI":"10.1145\/3186728.3164137","type":"journal-article","created":{"date-parts":[[2019,11,20]],"date-time":"2019-11-20T10:54:54Z","timestamp":1574247294000},"page":"406-419","source":"Crossref","is-referenced-by-count":23,"title":["Query fresh"],"prefix":"10.14778","volume":"11","author":[{"given":"Tianzheng","family":"Wang","sequence":"first","affiliation":[{"name":"University of Toronto"}],"role":[{"vocabulary":"crossref","role":"author"}]},{"given":"Ryan","family":"Johnson","sequence":"additional","affiliation":[{"name":"LogicBlox"}],"role":[{"vocabulary":"crossref","role":"author"}]},{"given":"Ippokratis","family":"Pandis","sequence":"additional","affiliation":[{"name":"Amazon Web Services"}],"role":[{"vocabulary":"crossref","role":"author"}]}],"member":"320","published-online":{"date-parts":[[2017,12]]},"reference":[{"key":"e_1_2_1_1_1","volume-title":"AgigaTech Non-Volatile RAM","year":"2017","unstructured":"AgigaTech. AgigaTech Non-Volatile RAM . 2017 . http:\/\/www.agigatech.com\/nvram.php. AgigaTech. AgigaTech Non-Volatile RAM. 2017. http:\/\/www.agigatech.com\/nvram.php."},{"key":"e_1_2_1_2_1","doi-asserted-by":"publisher","DOI":"10.14778\/3025111.3025116"},{"key":"e_1_2_1_3_1","doi-asserted-by":"publisher","DOI":"10.5555\/2228298.2228300"},{"key":"e_1_2_1_4_1","doi-asserted-by":"publisher","DOI":"10.1145\/2517349.2522732"},{"key":"e_1_2_1_5_1","doi-asserted-by":"publisher","DOI":"10.1145\/2723372.2750547"},{"key":"e_1_2_1_6_1","doi-asserted-by":"publisher","DOI":"10.1145\/2723372.2737788"},{"key":"e_1_2_1_7_1","volume-title":"CIDR","author":"Bernstein P. A.","year":"2011","unstructured":"P. A. Bernstein , C. W. Reid , and S. Das . Hyder - a transactional record manager for shared flash . CIDR , 2011 . P. A. Bernstein, C. W. Reid, and S. Das. Hyder - a transactional record manager for shared flash. CIDR, 2011."},{"key":"e_1_2_1_8_1","doi-asserted-by":"publisher","DOI":"10.14778\/3402707.3402732"},{"key":"e_1_2_1_9_1","doi-asserted-by":"publisher","DOI":"10.14778\/2904483.2904485"},{"key":"e_1_2_1_10_1","doi-asserted-by":"publisher","DOI":"10.1145\/2901318.2901349"},{"key":"e_1_2_1_11_1","doi-asserted-by":"publisher","DOI":"10.1109\/HOTI.2009.23"},{"key":"e_1_2_1_12_1","doi-asserted-by":"publisher","DOI":"10.1145\/1629575.1629589"},{"key":"e_1_2_1_13_1","doi-asserted-by":"publisher","DOI":"10.5555\/2387880.2387905"},{"key":"e_1_2_1_14_1","volume-title":"A revolutionary breakthrough in memory technology. Intel 3D XPoint launch keynote","author":"Crooke R.","year":"2015","unstructured":"R. Crooke and M. Durcan . A revolutionary breakthrough in memory technology. Intel 3D XPoint launch keynote , 2015 . R. Crooke and M. Durcan. A revolutionary breakthrough in memory technology. Intel 3D XPoint launch keynote, 2015."},{"key":"e_1_2_1_15_1","doi-asserted-by":"publisher","DOI":"10.14778\/2556549.2556575"},{"key":"e_1_2_1_16_1","doi-asserted-by":"publisher","DOI":"10.1145\/2463676.2463710"},{"key":"e_1_2_1_17_1","volume-title":"Storage Developer Conference","author":"Douglas C.","year":"2015","unstructured":"C. Douglas . RDMA with PMEM: Software mechanisms for enabling access to remote persistent memory . Storage Developer Conference , 2015 . http:\/\/www.snia.org\/sites\/default\/files\/SDC15_presentations\/persistant_mem\/ChetDouglas_RDMA_with_PM.pdf. C. Douglas. RDMA with PMEM: Software mechanisms for enabling access to remote persistent memory. Storage Developer Conference, 2015. http:\/\/www.snia.org\/sites\/default\/files\/SDC15_presentations\/persistant_mem\/ChetDouglas_RDMA_with_PM.pdf."},{"key":"e_1_2_1_18_1","doi-asserted-by":"publisher","DOI":"10.5555\/2616448.2616486"},{"key":"e_1_2_1_19_1","doi-asserted-by":"publisher","DOI":"10.1145\/2814710.2814716"},{"key":"e_1_2_1_20_1","doi-asserted-by":"publisher","DOI":"10.5555\/573304"},{"key":"e_1_2_1_21_1","unstructured":"IBM. High availability through log shipping. IBM DB2 9.7 for Linux UNIX and Windows documentation 2015.  IBM. High availability through log shipping. IBM DB2 9.7 for Linux UNIX and Windows documentation 2015."},{"key":"e_1_2_1_22_1","volume-title":"InfiniBand roadmap","author":"InfiniBand Trade Association","year":"2016","unstructured":"InfiniBand Trade Association . InfiniBand roadmap . 2016 . http:\/\/www.infinibandta.org\/content\/pages.php?pg=technology_overview. InfiniBand Trade Association. InfiniBand roadmap. 2016. http:\/\/www.infinibandta.org\/content\/pages.php?pg=technology_overview."},{"key":"e_1_2_1_23_1","volume-title":"Intel data direct I\/O technology (Intel DDIO): A primer","author":"Intel Corporation","year":"2012","unstructured":"Intel Corporation . Intel data direct I\/O technology (Intel DDIO): A primer . 2012 . Intel Corporation. Intel data direct I\/O technology (Intel DDIO): A primer. 2012."},{"key":"e_1_2_1_24_1","volume-title":"Intel 64 and IA-32 architectures software developer's manual","author":"Intel Corporation","year":"2015","unstructured":"Intel Corporation . Intel 64 and IA-32 architectures software developer's manual . 2015 . Intel Corporation. Intel 64 and IA-32 architectures software developer's manual. 2015."},{"key":"e_1_2_1_25_1","volume-title":"DDR3 SDRAM standard","author":"JEDEC.","year":"2012","unstructured":"JEDEC. DDR3 SDRAM standard . 2012 . http:\/\/www.jedec.org\/standards-documents\/docs\/jesd-79-3d. JEDEC. DDR3 SDRAM standard. 2012. http:\/\/www.jedec.org\/standards-documents\/docs\/jesd-79-3d."},{"key":"e_1_2_1_26_1","doi-asserted-by":"publisher","DOI":"10.14778\/1920841.1920928"},{"key":"e_1_2_1_27_1","doi-asserted-by":"publisher","DOI":"10.1145\/2740070.2626299"},{"key":"e_1_2_1_28_1","doi-asserted-by":"publisher","DOI":"10.5555\/3026877.3026892"},{"key":"e_1_2_1_29_1","doi-asserted-by":"publisher","DOI":"10.14778\/1454159.1454211"},{"key":"e_1_2_1_30_1","doi-asserted-by":"publisher","DOI":"10.1145\/3079856.3080236"},{"key":"e_1_2_1_31_1","doi-asserted-by":"publisher","DOI":"10.1145\/2806777.2806841"},{"key":"e_1_2_1_32_1","doi-asserted-by":"publisher","DOI":"10.1145\/2882903.2882905"},{"key":"e_1_2_1_33_1","doi-asserted-by":"publisher","DOI":"10.1145\/2723372.2746480"},{"key":"e_1_2_1_34_1","doi-asserted-by":"publisher","DOI":"10.1145\/279227.279229"},{"key":"e_1_2_1_35_1","doi-asserted-by":"publisher","DOI":"10.14778\/2536206.2536215"},{"key":"e_1_2_1_36_1","doi-asserted-by":"publisher","DOI":"10.1109\/ICDE.2013.6544834"},{"key":"e_1_2_1_37_1","doi-asserted-by":"publisher","DOI":"10.1145\/3064176.3064202"},{"key":"e_1_2_1_38_1","doi-asserted-by":"publisher","DOI":"10.1145\/3035918.3035959"},{"key":"e_1_2_1_39_1","doi-asserted-by":"publisher","DOI":"10.1109\/ICDE.2014.6816685"},{"key":"e_1_2_1_40_1","doi-asserted-by":"publisher","DOI":"10.1145\/2168836.2168855"},{"key":"e_1_2_1_41_1","volume-title":"RDMA aware networks programming user manual","author":"Technologies Mellanox","year":"2015","unstructured":"Mellanox Technologies . RDMA aware networks programming user manual . 2015 . Mellanox Technologies. RDMA aware networks programming user manual. 2015."},{"key":"e_1_2_1_42_1","first-page":"79","volume-title":"RDMA over converged ethernet (RoCE) - an efficient, low-cost, zero copy implementation","author":"Technologies Mellanox","year":"2017","unstructured":"Mellanox Technologies . RDMA over converged ethernet (RoCE) - an efficient, low-cost, zero copy implementation . 2017 . http:\/\/www.mellanox.com\/page\/products_dyn?product_family= 79 . Mellanox Technologies. RDMA over converged ethernet (RoCE) - an efficient, low-cost, zero copy implementation. 2017. http:\/\/www.mellanox.com\/page\/products_dyn?product_family=79."},{"key":"e_1_2_1_43_1","doi-asserted-by":"publisher","DOI":"10.5555\/3026959.3026967"},{"key":"e_1_2_1_44_1","doi-asserted-by":"publisher","DOI":"10.1007\/s00778-012-0294-6"},{"key":"e_1_2_1_45_1","doi-asserted-by":"publisher","DOI":"10.5555\/2535461.2535475"},{"key":"e_1_2_1_46_1","doi-asserted-by":"publisher","DOI":"10.1145\/128765.128770"},{"key":"e_1_2_1_47_1","volume-title":"Oracle Database Online Documentation","year":"2014","unstructured":"Oracle. TimesTen in-memory database replication guide . Oracle Database Online Documentation , 2014 . Oracle. TimesTen in-memory database replication guide. Oracle Database Online Documentation, 2014."},{"key":"e_1_2_1_48_1","unstructured":"Oracle. Chapter 17 Replication. MySQL 5.7 Reference Manual 2015.  Oracle. Chapter 17 Replication. MySQL 5.7 Reference Manual 2015."},{"key":"e_1_2_1_49_1","doi-asserted-by":"publisher","DOI":"10.1145\/2882903.2915251"},{"key":"e_1_2_1_50_1","volume-title":"CIDR","author":"Oukid I.","year":"2015","unstructured":"I. Oukid , W. Lehner , T. Kissinger , T. Willhalm , and P. Bumbulis . Instant recovery for main memory databases . CIDR , 2015 . I. Oukid, W. Lehner, T. Kissinger, T. Willhalm, and P. Bumbulis. Instant recovery for main memory databases. CIDR, 2015."},{"key":"e_1_2_1_51_1","doi-asserted-by":"publisher","DOI":"10.14778\/3151106.3151107"},{"key":"e_1_2_1_52_1","volume-title":"High availability with SQL Server","author":"Randal P. S.","year":"2008","unstructured":"P. S. Randal . High availability with SQL Server 2008 . Microsoft White Papers , 2009. https:\/\/technet.microsoft.com\/en-us\/library\/ee523927.aspx. P. S. Randal. High availability with SQL Server 2008. Microsoft White Papers, 2009. https:\/\/technet.microsoft.com\/en-us\/library\/ee523927.aspx."},{"key":"e_1_2_1_53_1","doi-asserted-by":"publisher","DOI":"10.1145\/2723872.2723885"},{"key":"e_1_2_1_54_1","doi-asserted-by":"publisher","DOI":"10.14778\/2856318.2856319"},{"key":"e_1_2_1_55_1","doi-asserted-by":"publisher","DOI":"10.14778\/2536222.2536226"},{"key":"e_1_2_1_56_1","volume-title":"12th Annual Open Fabrics Alliance Workshop, 2016","author":"Talpey T.","year":"2016","unstructured":"T. Talpey . RDMA extensions for remote persistent memory access . 12th Annual Open Fabrics Alliance Workshop, 2016 . https:\/\/www.openfabrics.org\/images\/eventpresos\/ 2016 presentations\/215RDMAforRemPerMem.pdf. T. Talpey. RDMA extensions for remote persistent memory access. 12th Annual Open Fabrics Alliance Workshop, 2016. https:\/\/www.openfabrics.org\/images\/eventpresos\/2016presentations\/215RDMAforRemPerMem.pdf."},{"key":"e_1_2_1_57_1","volume-title":"Load Balancing, and Replication. PostgreSQL 9.4.4 Documentation","author":"The PostgreSQL Global Development Group","year":"2015","unstructured":"The PostgreSQL Global Development Group . Chapter 25. High Availability , Load Balancing, and Replication. PostgreSQL 9.4.4 Documentation , 2015 . The PostgreSQL Global Development Group. Chapter 25. High Availability, Load Balancing, and Replication. PostgreSQL 9.4.4 Documentation, 2015."},{"key":"e_1_2_1_58_1","doi-asserted-by":"publisher","DOI":"10.14778\/1920841.1920855"},{"key":"e_1_2_1_59_1","doi-asserted-by":"publisher","DOI":"10.1145\/2213836.2213838"},{"key":"e_1_2_1_60_1","volume-title":"TPC benchmark C (OLTP) standard specification, revision 5.11","author":"TPC.","year":"2010","unstructured":"TPC. TPC benchmark C (OLTP) standard specification, revision 5.11 , 2010 . http:\/\/www.tpc.org\/tpcc. TPC. TPC benchmark C (OLTP) standard specification, revision 5.11, 2010. http:\/\/www.tpc.org\/tpcc."},{"key":"e_1_2_1_61_1","doi-asserted-by":"publisher","DOI":"10.1145\/2517349.2522713"},{"key":"e_1_2_1_62_1","doi-asserted-by":"publisher","DOI":"10.1145\/3035918.3056101"},{"key":"e_1_2_1_63_1","unstructured":"Viking Technology. DDR4 NVDIMM. 2017. http:\/\/www.vikingtechnology.com\/products\/nvdimm\/ddr4-nvdimm\/.  Viking Technology. DDR4 NVDIMM. 2017. http:\/\/www.vikingtechnology.com\/products\/nvdimm\/ddr4-nvdimm\/."},{"key":"e_1_2_1_64_1","doi-asserted-by":"publisher","DOI":"10.14778\/2732951.2732960"},{"key":"e_1_2_1_65_1","volume-title":"HPTS, 2015","author":"Wang T.","year":"2015","unstructured":"T. Wang , R. Johnson , and I. Pandis . Fresh replicas through append-only storage . HPTS, 2015 . http:\/\/www.hpts.ws\/papers\/ 2015 \/lightning\/append-only-log-ship.pdf. T. Wang, R. Johnson, and I. Pandis. Fresh replicas through append-only storage. HPTS, 2015. http:\/\/www.hpts.ws\/papers\/2015\/lightning\/append-only-log-ship.pdf."},{"key":"e_1_2_1_66_1","doi-asserted-by":"publisher","DOI":"10.14778\/3067421.3067427"},{"key":"e_1_2_1_67_1","doi-asserted-by":"publisher","DOI":"10.1145\/3035918.3064011"},{"key":"e_1_2_1_68_1","doi-asserted-by":"publisher","DOI":"10.1109\/ICDE.2013.6544908"},{"key":"e_1_2_1_69_1","doi-asserted-by":"publisher","DOI":"10.1145\/2882903.2915208"},{"key":"e_1_2_1_70_1","doi-asserted-by":"publisher","DOI":"10.14778\/3055330.3055335"},{"key":"e_1_2_1_71_1","doi-asserted-by":"publisher","DOI":"10.1145\/2694344.2694370"}],"container-title":["Proceedings of the VLDB Endowment"],"original-title":[],"language":"en","link":[{"URL":"https:\/\/dl.acm.org\/doi\/10.1145\/3186728.3164137","content-type":"unspecified","content-version":"vor","intended-application":"text-mining"},{"URL":"https:\/\/dl.acm.org\/doi\/pdf\/10.1145\/3186728.3164137","content-type":"unspecified","content-version":"vor","intended-application":"similarity-checking"}],"deposited":{"date-parts":[[2025,6,18]],"date-time":"2025-06-18T19:07:31Z","timestamp":1750273651000},"score":1,"resource":{"primary":{"URL":"https:\/\/dl.acm.org\/doi\/10.1145\/3186728.3164137"}},"subtitle":["log shipping on steroids"],"short-title":[],"issued":{"date-parts":[[2017,12]]},"references-count":71,"journal-issue":{"issue":"4","published-print":{"date-parts":[[2017,12]]}},"alternative-id":["10.1145\/3186728.3164137"],"URL":"https:\/\/doi.org\/10.1145\/3186728.3164137","relation":{},"ISSN":["2150-8097"],"issn-type":[{"value":"2150-8097","type":"print"}],"subject":[],"published":{"date-parts":[[2017,12]]}}}