Read-safe snapshots: An abort/wait-free serializable read method for read-only transactions on mixed OLTP/OLAP workloads
This paper proposes Read-Safe Snapshots (RSS), a concurrency control method that ensures reading the latest serializable version on multiversion concurrency control (MVCC) for read-only transactions without creating any serializability anomaly, thereby enhancing the transaction processing throughput...
Saved in:
| Published in: | Information systems (Oxford) Vol. 124; p. 102385 |
|---|---|
| Main Authors: | , , , , , |
| Format: | Journal Article |
| Language: | English |
| Published: |
Elsevier Ltd
01.09.2024
|
| Subjects: | |
| ISSN: | 0306-4379, 1873-6076 |
| Online Access: | Get full text |
| Tags: |
Add Tag
No Tags, Be the first to tag this record!
|
| Abstract | This paper proposes Read-Safe Snapshots (RSS), a concurrency control method that ensures reading the latest serializable version on multiversion concurrency control (MVCC) for read-only transactions without creating any serializability anomaly, thereby enhancing the transaction processing throughput under mixed workloads of online transactional processing (OLTP) and online analytical processing (OLAP). Ensuring serializability for data consistency between OLTP and OLAP is vital to prevent OLAP from obtaining nonserializable results. Existing serializability methods achieve this consistency by making OLTP or OLAP transactions aborts or waits, but these can lead to throughput degradation when implemented for large read sets in read-only OLAP transactions under mixed workloads of the recent real-time analysis applications. To deal with this problem, we present an RSS construction algorithm that does not affect the conventional OLTP performance and simultaneously avoids producing additional aborts and waits. Moreover, the RSS construction method can be easily applied to the read-only replica of a multinode system as well as a single-node system because no validation for serializability is required. Our experimental findings showed that RSS could prevent read-only OLAP transactions from creating anomaly cycles under a multinode environment of master-copy replication, which led to the achievement of serializability with the low overhead of about 15% compared to baseline OLTP/OLAP throughputs under snapshot isolation (SI). The OLTP throughput under our proposed method in a mixed OLTP/OLAP workload was about 45% better than SafeSnapshots, a serializable snapshot isolation (SSI) equipped with a read-only optimization method, and did not degrade the OLAP throughput. |
|---|---|
| AbstractList | This paper proposes Read-Safe Snapshots (RSS), a concurrency control method that ensures reading the latest serializable version on multiversion concurrency control (MVCC) for read-only transactions without creating any serializability anomaly, thereby enhancing the transaction processing throughput under mixed workloads of online transactional processing (OLTP) and online analytical processing (OLAP). Ensuring serializability for data consistency between OLTP and OLAP is vital to prevent OLAP from obtaining nonserializable results. Existing serializability methods achieve this consistency by making OLTP or OLAP transactions aborts or waits, but these can lead to throughput degradation when implemented for large read sets in read-only OLAP transactions under mixed workloads of the recent real-time analysis applications. To deal with this problem, we present an RSS construction algorithm that does not affect the conventional OLTP performance and simultaneously avoids producing additional aborts and waits. Moreover, the RSS construction method can be easily applied to the read-only replica of a multinode system as well as a single-node system because no validation for serializability is required. Our experimental findings showed that RSS could prevent read-only OLAP transactions from creating anomaly cycles under a multinode environment of master-copy replication, which led to the achievement of serializability with the low overhead of about 15% compared to baseline OLTP/OLAP throughputs under snapshot isolation (SI). The OLTP throughput under our proposed method in a mixed OLTP/OLAP workload was about 45% better than SafeSnapshots, a serializable snapshot isolation (SSI) equipped with a read-only optimization method, and did not degrade the OLAP throughput. |
| ArticleNumber | 102385 |
| Author | Arakawa, Suguru Yokota, Haruo Hikida, Satoshi Kurosawa, Ryoji Shioi, Takamitsu Kambayashi, Takashi |
| Author_xml | – sequence: 1 givenname: Takamitsu orcidid: 0000-0002-2081-6299 surname: Shioi fullname: Shioi, Takamitsu email: shioi.t.aa@m.titech.ac.jp organization: Tokyo Institute of Technology, Tokyo, Japan – sequence: 2 givenname: Takashi surname: Kambayashi fullname: Kambayashi, Takashi organization: Nautilus Technologies, Inc., Tokyo, Japan – sequence: 3 givenname: Suguru surname: Arakawa fullname: Arakawa, Suguru organization: Nautilus Technologies, Inc., Tokyo, Japan – sequence: 4 givenname: Ryoji surname: Kurosawa fullname: Kurosawa, Ryoji organization: Nautilus Technologies, Inc., Tokyo, Japan – sequence: 5 givenname: Satoshi surname: Hikida fullname: Hikida, Satoshi organization: Scalar, Inc., Tokyo, Japan – sequence: 6 givenname: Haruo surname: Yokota fullname: Yokota, Haruo organization: Josai University, Tokyo, Japan |
| BookMark | eNp1kE1rAjEURUOxULXdd5k_MJqZxDjjTqRfMKAUuw7P5AVjx0SSoWp_fcfabVePy-NcLmdAej54JOQxZ6Oc5XK8G7k0KlghuljwcnJD-nk55ZlkU9kjfcaZzASfVndkkNKOMVZMqqpPTu8IJktgkSYPh7QNbZrRuaewCbEdH8G1mY3YfTE6aNw3bBqksYPoHtttMNSG-Juz4JszbSP4BLp1wScaPN27Exq6rNer8bKer-gxxM8mgEn35NZCk_Dh7w7Jx_PTevGa1cuXt8W8zjTnvM2gkBthKqiERM4MZxahNHJiBdeWi1wWQmykNGCg4qyotK1KKZmeSlNOBBZ8SNi1V8eQUkSrDtHtIZ5VztTFnNopl9TFnLqa65DZFcFu15fDqJJ26DUaF1G3ygT3P_wDhh54aw |
| Cites_doi | 10.1109/RELDIS.2005.14 10.14778/3415478.3415535 10.1109/ICDE.2000.839388 10.1145/1071610.1071615 10.14778/1687627.1687707 10.14778/2367502.2367523 10.14778/2095686.2095689 10.14778/3402707.3402718 10.1109/ICDE.2011.5767897 10.14778/2732240.2732246 |
| ContentType | Journal Article |
| Copyright | 2024 The Author(s) |
| Copyright_xml | – notice: 2024 The Author(s) |
| DBID | 6I. AAFTH AAYXX CITATION |
| DOI | 10.1016/j.is.2024.102385 |
| DatabaseName | ScienceDirect Open Access Titles Elsevier:ScienceDirect:Open Access CrossRef |
| DatabaseTitle | CrossRef |
| DatabaseTitleList | |
| DeliveryMethod | fulltext_linktorsrc |
| Discipline | Engineering Computer Science |
| EISSN | 1873-6076 |
| ExternalDocumentID | 10_1016_j_is_2024_102385 S0306437924000437 |
| GroupedDBID | --K --M -~X .DC .~1 0R~ 13V 1B1 1~. 1~5 29I 4.4 457 4G. 5GY 5VS 63O 6I. 7-5 71M 77K 8P~ 9JN 9JO AAAKF AAAKG AACTN AAEDT AAEDW AAFTH AAIAV AAIKJ AAKOC AALRI AAOAW AAQFI AAQXK AARIN AAXUO AAYFN ABBOA ABFNM ABKBG ABMAC ABMVD ABTAH ABUCO ABXDB ACDAQ ACGFS ACHRH ACNNM ACNTT ACRLP ACZNC ADBBV ADEZE ADJOM ADMUD AEBSH AEKER AENEX AFFNX AFKWA AFTJW AGHFR AGUBO AGUMN AGYEJ AHHHB AHZHX AI. AIALX AIEXJ AIKHN AITUG AJOXV AKRWK ALEQD ALMA_UNASSIGNED_HOLDINGS AMFUW AMRAJ AOUOD APLSM ASPBG AVWKF AXJTR AZFZN BKOJK BLXMC BNSAS CS3 DU5 EBS EFJIC EJD EO8 EO9 EP2 EP3 F5P FDB FEDTE FGOYB FIRID FNPLU FYGXN G-Q G8K GBLVA GBOLZ HAMUX HF~ HLZ HVGLF HZ~ H~9 IHE J1W KOM LG9 M41 MO0 N9A O-L O9- OAUVE OZT P-8 P-9 P2P PC. PQQKQ Q38 R2- RIG RNS ROL RPZ SBC SDF SDG SDP SES SEW SPC SPCBC SSB SSD SSL SSV SSZ T5K TN5 UHS VH1 WUQ XSW ZCG ZY4 ~G- 77I 9DU AATTM AAXKI AAYWO AAYXX ABDPE ABJNI ABWVN ACLOT ACRPL ACVFH ADCNI ADNMO ADVLN AEIPS AEUPX AFJKZ AFPUW AGQPQ AIGII AIIUN AKBMS AKYEP ANKPU APXCP CITATION EFKBS EFLBG ~HD |
| ID | FETCH-LOGICAL-c333t-a26b4d9a946e30d30fea8d65f43cf3416244b66dada93029cf98660c76d854e23 |
| ISICitedReferencesCount | 0 |
| ISICitedReferencesURI | http://www.webofscience.com/api/gateway?GWVersion=2&SrcApp=Summon&SrcAuth=ProQuest&DestLinkType=CitingArticles&DestApp=WOS_CPL&KeyUT=001230268800001&url=https%3A%2F%2Fcvtisr.summon.serialssolutions.com%2F%23%21%2Fsearch%3Fho%3Df%26include.ft.matches%3Dt%26l%3Dnull%26q%3D |
| ISSN | 0306-4379 |
| IngestDate | Sat Nov 29 06:20:20 EST 2025 Tue Jun 18 08:52:27 EDT 2024 |
| IsDoiOpenAccess | true |
| IsOpenAccess | true |
| IsPeerReviewed | true |
| IsScholarly | true |
| Keywords | Serializability Multiversion concurrency control (MVCC) |
| Language | English |
| License | This is an open access article under the CC BY license. |
| LinkModel | OpenURL |
| MergedId | FETCHMERGED-LOGICAL-c333t-a26b4d9a946e30d30fea8d65f43cf3416244b66dada93029cf98660c76d854e23 |
| ORCID | 0000-0002-2081-6299 |
| OpenAccessLink | https://dx.doi.org/10.1016/j.is.2024.102385 |
| ParticipantIDs | crossref_primary_10_1016_j_is_2024_102385 elsevier_sciencedirect_doi_10_1016_j_is_2024_102385 |
| PublicationCentury | 2000 |
| PublicationDate | September 2024 2024-09-00 |
| PublicationDateYYYYMMDD | 2024-09-01 |
| PublicationDate_xml | – month: 09 year: 2024 text: September 2024 |
| PublicationDecade | 2020 |
| PublicationTitle | Information systems (Oxford) |
| PublicationYear | 2024 |
| Publisher | Elsevier Ltd |
| Publisher_xml | – name: Elsevier Ltd |
| References | Neumann, Mühlbauer, Kemper (b11) 2015 Cahill, Röhm, Fekete (b15) 2009 Berenson, Bernstein, Gray, Melton, O’Neil, O’Neil (b16) 1995 Lee, Muehle, May, Faerber, Sikka, Plattner, Krüger, Grund (b32) 2013 Tu, Zheng, Kohler, Liskov, Madden (b39) 2013 Baumbach, Becker, Denneler, Hechler, Hengstler, Knoll, Neumann, Schoellmann, Souissi, Zimmermann (b9) 2015 Jung, Han, Fekete, Röhm (b29) 2011; 4 S. Elnikety, F. Pedone, W. Zwaenepoel, Database replication using generalized snapshot isolation, in: 24th IEEE Symposium on Reliable Distributed Systems, SRDS’05, 2005, pp. 73–84 Schenkel, Weikum (b19) 2000 Mühe, Kemper, Neumann (b30) 2011 Weikum, Vossen (b12) 2001 Makreshanski, Giceva, Barthels, Alonso (b7) 2017 Schenkel, Weikum, Weißenberg, Wu (b20) 2000 Shanmugasundaram, Nithrakashyap, Sivasankaran, Ramamritham (b27) 1999 T.P.P. Council, Tpc benchmark c Kung, Robinson (b33) 1981 Fekete, Liarokapis, O’Neil, O’Neil, Shasha (b24) 2005; 30 M.A. Bornea, O. Hodson, S. Elnikety, A. Fekete, One-copy serializability with snapshot isolation under the hood, in: 2011 IEEE 27th International Conference on Data Engineering, ICDE, 2011, pp. 625–636 Diaconu, Freedman, Ismert, Larson, Mittal, Stonecipher, Verma, Zwilling (b37) 2013 Raza, Chrysogelos, Anadiotis, Ailamaki (b6) 2020 Unterbrunner, Giannikis, Alonso, Fauser, Kossmann (b1) 2009; 2 Paper (b3) 2015 Fekete, O’Neil, O’Neil (b17) 2004 Cole, Funke, Giakoumakis, Guy, Kemper, Krompass, Kuno, Nambiar, Neumann, Poess, Sattler, Seibold, Simon, Waas (b22) 2011 Difallah, Pavlo, Curino, Cudre-Mauroux (b23) 2013; 7 Cahill (b28) 2009 Plattner (b2) 2009 T.P.P. Council, Tpc benchmark h P.-r. Larson, Blanas, Diaconu, Freedman, Patel, Zwilling (b38) 2011; 5 . Agrawal, Bernstein, Gupta, Sengupta (b26) 1987 Ports, Grittner (b25) 2012; 5 Taft, Sharif, Matei, VanBenschoten, Lewis, Grieger, Niemi, Woods, Birzin, Poss, Bardea, Ranade, Darnell, Gruneir, Jaffray, Zhang, Mattis (b35) 2020 Skidanov, Papito, Prout (b8) 2016 Papadimitriou (b14) 1986 Huang, Liu, Cui, Fang, Ma, Xu, Shen, Tang, Zhou, Huang, Wei, Liu, Zhang, Li, Wu, Song, Sun, Yu, Zhao, Cameron, Pei, Tang (b34) 2020; 13 Yuri, Hector, Avi (b18) 1992 Bernstein, Hadzilacos, Goodman (b13) 1987 Kipf, Pandey, Böttcher, Braun, Neumann, Kemper (b4) 2019 A.C.D. documentation (b5) 2022 Kemper, Neumann (b10) 2011 A. Adya, B. Liskov, P. O’Neil, Generalized isolation level definitions, in: Proceedings of 16th International Conference on Data Engineering, ICDE, (Cat. No. 00CB37073), 2000, pp. 67–78 Weikum (10.1016/j.is.2024.102385_b12) 2001 Schenkel (10.1016/j.is.2024.102385_b20) 2000 Diaconu (10.1016/j.is.2024.102385_b37) 2013 P.-r. Larson (10.1016/j.is.2024.102385_b38) 2011; 5 Tu (10.1016/j.is.2024.102385_b39) 2013 Berenson (10.1016/j.is.2024.102385_b16) 1995 Shanmugasundaram (10.1016/j.is.2024.102385_b27) 1999 Raza (10.1016/j.is.2024.102385_b6) 2020 10.1016/j.is.2024.102385_b36 Unterbrunner (10.1016/j.is.2024.102385_b1) 2009; 2 Fekete (10.1016/j.is.2024.102385_b24) 2005; 30 A.C.D. documentation (10.1016/j.is.2024.102385_b5) 2022 Schenkel (10.1016/j.is.2024.102385_b19) 2000 Difallah (10.1016/j.is.2024.102385_b23) 2013; 7 Huang (10.1016/j.is.2024.102385_b34) 2020; 13 10.1016/j.is.2024.102385_b31 Mühe (10.1016/j.is.2024.102385_b30) 2011 Yuri (10.1016/j.is.2024.102385_b18) 1992 Cahill (10.1016/j.is.2024.102385_b15) 2009 Lee (10.1016/j.is.2024.102385_b32) 2013 Agrawal (10.1016/j.is.2024.102385_b26) 1987 Plattner (10.1016/j.is.2024.102385_b2) 2009 Kipf (10.1016/j.is.2024.102385_b4) 2019 10.1016/j.is.2024.102385_b41 Ports (10.1016/j.is.2024.102385_b25) 2012; 5 10.1016/j.is.2024.102385_b40 Neumann (10.1016/j.is.2024.102385_b11) 2015 Bernstein (10.1016/j.is.2024.102385_b13) 1987 Cole (10.1016/j.is.2024.102385_b22) 2011 Fekete (10.1016/j.is.2024.102385_b17) 2004 Cahill (10.1016/j.is.2024.102385_b28) 2009 Paper (10.1016/j.is.2024.102385_b3) 2015 Skidanov (10.1016/j.is.2024.102385_b8) 2016 10.1016/j.is.2024.102385_b21 Kemper (10.1016/j.is.2024.102385_b10) 2011 Taft (10.1016/j.is.2024.102385_b35) 2020 Makreshanski (10.1016/j.is.2024.102385_b7) 2017 Jung (10.1016/j.is.2024.102385_b29) 2011; 4 Kung (10.1016/j.is.2024.102385_b33) 1981 Papadimitriou (10.1016/j.is.2024.102385_b14) 1986 Baumbach (10.1016/j.is.2024.102385_b9) 2015 |
| References_xml | – year: 2022 ident: b5 article-title: Azure synapse link for azure cosmos db: Near real-time analytics use cases – start-page: 677 year: 2015 end-page: 689 ident: b11 article-title: Fast serializable multi-version concurrency control for main-memory database systems publication-title: Proceedings of the 2015 ACM SIGMOD International Conference on Management of Data – start-page: 90 year: 2000 end-page: 101 ident: b19 article-title: Integrating snapshot isolation into transactional federation publication-title: Proceedings of the 7th International Conference on Cooperative Information Systems – year: 1986 ident: b14 article-title: Theory of Database Concurrency Control – volume: 30 start-page: 492 year: 2005 end-page: 528 ident: b24 article-title: Making snapshot isolation serializable publication-title: ACM Trans. Database Syst. – start-page: 37 year: 2017 end-page: 50 ident: b7 article-title: Batchdb: Efficient isolated execution of hybrid OLTP＋OLAP workloads for interactive applications publication-title: Proceedings of the 2017 ACM International Conference on Management of Data – start-page: 1287 year: 2016 end-page: 1297 ident: b8 article-title: A column store engine for real-time streaming analytics publication-title: 2016 IEEE 32nd International Conference on Data Engineering – start-page: 45 year: 1987 end-page: 59 ident: b26 article-title: Distributed Optimistic Concurrency Control with Reduced Rollback, vol. 2 – year: 2015 ident: b9 article-title: Accelerating data transformation with IBM DB2 analytics accelerator for z/OS – start-page: 12 year: 2004 end-page: 14 ident: b17 article-title: A Read-Only Transaction Anomaly under Snapshot Isolation, vol. 33 – reference: T.P.P. Council, Tpc benchmark h, – year: 2009 ident: b28 article-title: Serializable Isolation for Snapshot Databases – year: 1987 ident: b13 article-title: Concurrency Control and Recovery in Database Systems – year: 2011 ident: b22 article-title: The mixed workload ch-benchmark publication-title: Proceedings of the Fourth International Workshop on Testing Database Systems – volume: 4 start-page: 783 year: 2011 end-page: 794 ident: b29 article-title: Serializable snapshot isolation for replicated databases in high-update scenarios publication-title: VLDB Endow. – start-page: 18 year: 2013 end-page: 32 ident: b39 article-title: Speedy transactions in multicore in-memory databases publication-title: Proceedings of the Twenty-Fourth ACM Symposium on Operating Systems Principles – year: 2001 ident: b12 article-title: Transactional Information Systems: Theory, Algorithms, and the Practice of Concurrency Control and Recovery – volume: 13 start-page: 3072 year: 2020 end-page: 3084 ident: b34 article-title: Tidb: A raft-based htap database publication-title: VLDB Endow. – start-page: 1 year: 2009 end-page: 2 ident: b2 article-title: A common database approach for OLTP and OLAP using an in-memory column database publication-title: Proceedings of the 2009 ACM SIGMOD International Conference on Management of Data – start-page: 28 year: 2013 end-page: 33 ident: b32 article-title: High-Performance Transaction Processing in SAP HANA, vol. 36 – volume: 5 start-page: 1850 year: 2012 end-page: 1861 ident: b25 article-title: Serializable snapshot isolation in postgresql publication-title: VLDB Endow. – volume: 7 start-page: 277 year: 2013 end-page: 288 ident: b23 article-title: Oltp-bench: An extensible testbed for benchmarking relational databases publication-title: VLDB Endow. – start-page: 1493 year: 2020 end-page: 1509 ident: b35 article-title: Cockroachdb publication-title: Proceedings of the 2020 ACM SIGMOD International Conference on Management of Data – reference: T.P.P. Council, Tpc benchmark c, – start-page: 195 year: 2011 end-page: 206 ident: b10 article-title: Hyper: A hybrid OLTP OLAP main memory database system based on virtual memory snapshots publication-title: 2011 IEEE 27th International Conference on Data Engineering – start-page: 213 year: 1981 end-page: 226 ident: b33 article-title: On Optimistic Methods for Concurrency Control, vol. 6 – reference: S. Elnikety, F. Pedone, W. Zwaenepoel, Database replication using generalized snapshot isolation, in: 24th IEEE Symposium on Reliable Distributed Systems, SRDS’05, 2005, pp. 73–84, – reference: A. Adya, B. Liskov, P. O’Neil, Generalized isolation level definitions, in: Proceedings of 16th International Conference on Data Engineering, ICDE, (Cat. No. 00CB37073), 2000, pp. 67–78, – reference: . – start-page: 1243 year: 2013 end-page: 1254 ident: b37 article-title: Hekaton: Sql server’s memory-optimized oltp engine publication-title: Proceedings of the 2013 ACM SIGMOD International Conference on Management of Data – year: 2009 ident: b15 article-title: Serializable Isolation for Snapshot Databases, vol. 34 – start-page: 1 year: 1995 end-page: 10 ident: b16 article-title: A Critique of Ansi Sql Isolation Levels, vol. 24 – volume: 2 start-page: 706 year: 2009 end-page: 717 ident: b1 article-title: Predictable performance for unpredictable workloads publication-title: VLDB Endow. – year: 2015 ident: b3 article-title: Oracle goldengate 12 c: Real-time access to real-time information – start-page: 85 year: 1999 end-page: 96 ident: b27 article-title: Efficient Concurrency Control for Broadcast Environments, vol. 28 – reference: M.A. Bornea, O. Hodson, S. Elnikety, A. Fekete, One-copy serializability with snapshot isolation under the hood, in: 2011 IEEE 27th International Conference on Data Engineering, ICDE, 2011, pp. 625–636, – start-page: 17 year: 2011 end-page: 26 ident: b30 article-title: How to efficiently snapshot transactional data: Hardware or software controlled? publication-title: Proceedings of the Seventh International Workshop on Data Management on New Hardware – volume: 5 start-page: 298 year: 2011 end-page: 309 ident: b38 article-title: High-performance concurrency control mechanisms for main-memory databases publication-title: VLDB Endow. – start-page: 1 year: 2000 end-page: 25 ident: b20 article-title: Federated transaction management with snapshot isolation publication-title: Transactions and Database Dynamics – start-page: 2043 year: 2020 end-page: 2054 ident: b6 article-title: Adaptive HTAP through elastic resource scheduling publication-title: Proceedings of the 2020 ACM SIGMOD International Conference on Management of Data – start-page: 181 year: 1992 end-page: 239 ident: b18 article-title: Overview of Multidatabase Transaction Management, vol. 1 – year: 2019 ident: b4 article-title: Scalable Analytics on Fast Data, vol. 44 – start-page: 1243 year: 2013 ident: 10.1016/j.is.2024.102385_b37 article-title: Hekaton: Sql server’s memory-optimized oltp engine – start-page: 18 year: 2013 ident: 10.1016/j.is.2024.102385_b39 article-title: Speedy transactions in multicore in-memory databases – year: 2015 ident: 10.1016/j.is.2024.102385_b9 – start-page: 1 year: 1995 ident: 10.1016/j.is.2024.102385_b16 – ident: 10.1016/j.is.2024.102385_b31 doi: 10.1109/RELDIS.2005.14 – start-page: 1493 year: 2020 ident: 10.1016/j.is.2024.102385_b35 article-title: Cockroachdb – volume: 13 start-page: 3072 year: 2020 ident: 10.1016/j.is.2024.102385_b34 article-title: Tidb: A raft-based htap database publication-title: VLDB Endow. doi: 10.14778/3415478.3415535 – start-page: 28 year: 2013 ident: 10.1016/j.is.2024.102385_b32 – start-page: 85 year: 1999 ident: 10.1016/j.is.2024.102385_b27 – year: 2001 ident: 10.1016/j.is.2024.102385_b12 – start-page: 45 year: 1987 ident: 10.1016/j.is.2024.102385_b26 – start-page: 1287 year: 2016 ident: 10.1016/j.is.2024.102385_b8 article-title: A column store engine for real-time streaming analytics – ident: 10.1016/j.is.2024.102385_b21 doi: 10.1109/ICDE.2000.839388 – start-page: 12 year: 2004 ident: 10.1016/j.is.2024.102385_b17 – volume: 30 start-page: 492 issue: 2 year: 2005 ident: 10.1016/j.is.2024.102385_b24 article-title: Making snapshot isolation serializable publication-title: ACM Trans. Database Syst. doi: 10.1145/1071610.1071615 – ident: 10.1016/j.is.2024.102385_b40 – year: 1986 ident: 10.1016/j.is.2024.102385_b14 – year: 2009 ident: 10.1016/j.is.2024.102385_b15 – year: 2009 ident: 10.1016/j.is.2024.102385_b28 – start-page: 213 year: 1981 ident: 10.1016/j.is.2024.102385_b33 – start-page: 37 year: 2017 ident: 10.1016/j.is.2024.102385_b7 article-title: Batchdb: Efficient isolated execution of hybrid OLTP＋OLAP workloads for interactive applications – volume: 2 start-page: 706 year: 2009 ident: 10.1016/j.is.2024.102385_b1 article-title: Predictable performance for unpredictable workloads publication-title: VLDB Endow. doi: 10.14778/1687627.1687707 – volume: 5 start-page: 1850 year: 2012 ident: 10.1016/j.is.2024.102385_b25 article-title: Serializable snapshot isolation in postgresql publication-title: VLDB Endow. doi: 10.14778/2367502.2367523 – start-page: 17 year: 2011 ident: 10.1016/j.is.2024.102385_b30 article-title: How to efficiently snapshot transactional data: Hardware or software controlled? – year: 2019 ident: 10.1016/j.is.2024.102385_b4 – start-page: 677 year: 2015 ident: 10.1016/j.is.2024.102385_b11 article-title: Fast serializable multi-version concurrency control for main-memory database systems – volume: 5 start-page: 298 year: 2011 ident: 10.1016/j.is.2024.102385_b38 article-title: High-performance concurrency control mechanisms for main-memory databases publication-title: VLDB Endow. doi: 10.14778/2095686.2095689 – year: 2011 ident: 10.1016/j.is.2024.102385_b22 article-title: The mixed workload ch-benchmark – year: 1987 ident: 10.1016/j.is.2024.102385_b13 – year: 2022 ident: 10.1016/j.is.2024.102385_b5 – volume: 4 start-page: 783 year: 2011 ident: 10.1016/j.is.2024.102385_b29 article-title: Serializable snapshot isolation for replicated databases in high-update scenarios publication-title: VLDB Endow. doi: 10.14778/3402707.3402718 – start-page: 90 year: 2000 ident: 10.1016/j.is.2024.102385_b19 article-title: Integrating snapshot isolation into transactional federation – year: 2015 ident: 10.1016/j.is.2024.102385_b3 – ident: 10.1016/j.is.2024.102385_b36 doi: 10.1109/ICDE.2011.5767897 – start-page: 195 year: 2011 ident: 10.1016/j.is.2024.102385_b10 article-title: Hyper: A hybrid OLTP OLAP main memory database system based on virtual memory snapshots – start-page: 2043 year: 2020 ident: 10.1016/j.is.2024.102385_b6 article-title: Adaptive HTAP through elastic resource scheduling – start-page: 181 year: 1992 ident: 10.1016/j.is.2024.102385_b18 – volume: 7 start-page: 277 year: 2013 ident: 10.1016/j.is.2024.102385_b23 article-title: Oltp-bench: An extensible testbed for benchmarking relational databases publication-title: VLDB Endow. doi: 10.14778/2732240.2732246 – ident: 10.1016/j.is.2024.102385_b41 – start-page: 1 year: 2000 ident: 10.1016/j.is.2024.102385_b20 article-title: Federated transaction management with snapshot isolation – start-page: 1 year: 2009 ident: 10.1016/j.is.2024.102385_b2 article-title: A common database approach for OLTP and OLAP using an in-memory column database |
| SSID | ssj0002599 |
| Score | 2.3954442 |
| Snippet | This paper proposes Read-Safe Snapshots (RSS), a concurrency control method that ensures reading the latest serializable version on multiversion concurrency... |
| SourceID | crossref elsevier |
| SourceType | Index Database Publisher |
| StartPage | 102385 |
| SubjectTerms | Multiversion concurrency control (MVCC) Serializability |
| Title | Read-safe snapshots: An abort/wait-free serializable read method for read-only transactions on mixed OLTP/OLAP workloads |
| URI | https://dx.doi.org/10.1016/j.is.2024.102385 |
| Volume | 124 |
| WOSCitedRecordID | wos001230268800001&url=https%3A%2F%2Fcvtisr.summon.serialssolutions.com%2F%23%21%2Fsearch%3Fho%3Df%26include.ft.matches%3Dt%26l%3Dnull%26q%3D |
| hasFullText | 1 |
| inHoldings | 1 |
| isFullTextHit | |
| isPrint | |
| journalDatabaseRights | – providerCode: PRVESC databaseName: Elsevier SD Freedom Collection Journals 2021 customDbUrl: eissn: 1873-6076 dateEnd: 99991231 omitProxy: false ssIdentifier: ssj0002599 issn: 0306-4379 databaseCode: AIEXJ dateStart: 19950301 isFulltext: true titleUrlDefault: https://www.sciencedirect.com providerName: Elsevier |
| link | http://cvtisr.summon.serialssolutions.com/2.0.0/link/0/eLvHCXMwtV1Lb9QwELaWLQc48Cggyks-cEHINBsnTsxthVoBqtoVXaTeokmctFl2k9UmbXd_EP-TsZ1kw0sCJC5RnnaU-WRPxt_MR8hL8BRPBHiM8zRhnoSAxWqUMMhcqdA_Dxzfik0Ex8fh2ZmcDAZf21yYq3lQFOF6LZf_1dR4Do2tU2f_wtxdo3gC99HouEWz4_aPDK9p8ayCLH1dFbCsLsq6aqJ_2t445h5eQ16zbJXiHeaFNLFrruVTQDWK0oZ8qI9ZWcw3WkeiFRU3qwuLfI1-6snRdIKtnRyNJ0ZxZl6CzRpund0m1ckgzFaMNiFem6PYC0GcXuSlIRVM4Qss8tpqsZhpABYxbLTeU3sZd7cYxeNrsNyi88vV9ildorO58mlTzvJ-aMP1Ou5WE29rc262BCeT5-UIpqso2hnMDtthwJlwrJJMN67b5Oyf5ggbrphha290p6Z4hZUN-qHy9qnuSvekeba6BtQNsuMGvgyHZGf84eDsYzfl4z-ktMtV9tWa9XBLJPy-n1_7Pz2fZnqP3Gl-RujYgug-GaTFLrnbCn3QZtzfJbd7VSsfkHWHMNoh7C0dF9Tga79DF-2ji2o0UYsuivanHbpoH120LKhBF9Xo2tfYoh22HpLPhwfTd-9ZI-DBEs55zcAVsackSE-k3FHcyVIIlfAzjycZuk8CfctYCAUKJHdcmWQyFMJJAqFC30td_ogMi7JIHxMagp_4DoTpKAb04EdyxN3ACTIVBh7EsbdHXrWfNVraOi1RS2CcRXkVaRNE1gR7hLffPWr8TOs_RgiR3z715J-eekpubZH9jAzr1WX6nNxMruq8Wr1ocPQNpD2iRw |
| linkProvider | Elsevier |
| openUrl | ctx_ver=Z39.88-2004&ctx_enc=info%3Aofi%2Fenc%3AUTF-8&rfr_id=info%3Asid%2Fsummon.serialssolutions.com&rft_val_fmt=info%3Aofi%2Ffmt%3Akev%3Amtx%3Ajournal&rft.genre=article&rft.atitle=Read-safe+snapshots%3A+An+abort%2Fwait-free+serializable+read+method+for+read-only+transactions+on+mixed+OLTP%2FOLAP+workloads&rft.jtitle=Information+systems+%28Oxford%29&rft.au=Shioi%2C+Takamitsu&rft.au=Kambayashi%2C+Takashi&rft.au=Arakawa%2C+Suguru&rft.au=Kurosawa%2C+Ryoji&rft.date=2024-09-01&rft.pub=Elsevier+Ltd&rft.issn=0306-4379&rft.eissn=1873-6076&rft.volume=124&rft_id=info:doi/10.1016%2Fj.is.2024.102385&rft.externalDocID=S0306437924000437 |
| thumbnail_l | http://covers-cdn.summon.serialssolutions.com/index.aspx?isbn=/lc.gif&issn=0306-4379&client=summon |
| thumbnail_m | http://covers-cdn.summon.serialssolutions.com/index.aspx?isbn=/mc.gif&issn=0306-4379&client=summon |
| thumbnail_s | http://covers-cdn.summon.serialssolutions.com/index.aspx?isbn=/sc.gif&issn=0306-4379&client=summon |