• Home
  • Search
  • Pick & Mix Isolation Levels: Mixed Serialization Graph Testing
  • Cite Icon1
  • https://doi.org/10.1007/978-3-031-29576-8_1Copy DOI Icon

Pick & Mix Isolation Levels: Mixed Serialization Graph Testing

  • Jan 1, 2023
  • Jack Waudby +2 more
Show More
  • Abstract
  • Literature Map
  • References
  • Citations
  • Similar Papers
Abstract

Concurrency control is an integral component in achieving high performance in many-core databases. Implementing serializable transaction processing efficiently is challenging. One approach, serialization graph testing (SGT) faithfully implements the conflict graph theorem by aborting only those transactions that would actually violate serializability (introduce a cycle), thus maintaining the required acyclic invariant. Alternative approaches, such as two-phase locking, disallow certain valid schedules to increase throughput, whereas SGT has the theoretically optimal property of accepting all and only conflict serializable schedules. Historically, SGT was deemed unviable in practice due to the high computational costs of maintaining an acyclic graph. Research has however overturned this historical view by utilising the increased computational power available due to modern hardware. Furthermore, a survey of 24 databases suggests that not all transactions demand conflict serializability but different transactions can perfectly settle for different, weaker isolation levels which typically require relatively lower overheads. Thus, in such a mixed environment, providing only the isolation level required of each transaction should, in theory, increase throughput and reduce aborts. The aim of this paper is to extend SGT for mixed environments subject to Adya’s mixing-correct theorem and demonstrate the resulting performance improvement. We augment the YCSB benchmark to generate transactions with different isolation requirements. For certain workloads, mixed serialization graph testing can achieve up to a 28% increase in throughput and a 19% decrease in aborts over SGT.

Similar Papers
  • Research Article
  • Citations18

Asynchronous operations in distributed concurrency control

  • May 01, 2003
  • IEEE Transactions on Knowledge and Data Engineering
  • P.K Reddy +1
  • Conference Article
  • Citations132

Architecting to achieve a billion requests per second throughput on a single key-value store server platform

  • Jun 13, 2015
  • Sheng Li +9
  • Research Article

Atomic transfer for distributed systems

  • Jul 06, 2018
  • Open Scholarship Institutional Repository (Washington University in St. Louis)
  • Kenneth J Goldman +1
  • Research Article
  • Citations17

Concurrency control for mixed transactions in real-time databases

  • Jul 01, 2002
  • IEEE Transactions on Computers
  • V.C.S Lee +2
  • Book Chapter
  • Citations3

Deadlock Prevention in Single-Server Multi-CS Distributed Systems Using Voting- and Priority-Based Strategies

  • Jan 01, 2018
  • Kamta Nath Mishra
  • Conference Article
  • Citations3

An optimistic concurrency control algorithm for mobile ad-hoc network databases

  • Jan 01, 2010
  • Zhaowen Xing +2
  • Research Article
  • Citations50

The Air Force Manufacturing Technology Laser Peening Initiative

  • Feb 01, 2002
  • Surface Engineering
  • D W See +3
  • Research Article
  • Citations63

Efficient optimistic concurrency control using loosely synchronized clocks

  • May 22, 1995
  • ACM SIGMOD Record
  • Atul Adya +3
  • Research Article
  • Citations39

Efficient concurrency control in multidimensional access methods

  • Jun 01, 1999
  • ACM SIGMOD Record
  • Kaushik Chakrabarti +1
  • Research Article
  • Citations36

Efficient validation of mobile transactions in wireless environments

  • Oct 09, 2003
  • The Journal of Systems & Software
  • Victor C.S Lee +2
  • Research Article
  • Citations7

Starvation-free secure multiversion concurrency control

  • Mar 01, 1998
  • Information Processing Letters
  • Heung-Taek Kim +1
  • PDF
  • Research Article
  • Citations27

Scifi-ATAC-seq: massive-scale single-cell chromatin accessibility sequencing using combinatorial fluidic indexing

  • Apr 08, 2024
  • Genome biology
  • Xuan Zhang +3
  • Research Article
  • Citations18

Adaptable concurrency control for atomic data types

  • Aug 01, 1992
  • ACM Transactions on Computer Systems
  • M S Atkins +1
  • Research Article
  • Citations15

System-on-package: a broad perspective from system design to technology development

  • Jul 18, 2003
  • Microelectronics Reliability
  • Li-Rong Zheng +1
  • Research Article
  • Citations9

A secure, scalable and versatile multi-layer client–server architecture for remote intelligent data processing

  • Nov 05, 2015
  • Journal of Reliable Intelligent Environments
  • Gabriele Piantadosi +3
Cactus Communications logo

Copyright 2026 Cactus Communications. All rights reserved.