DBScholar

Back to papers

ERMIA: Fast Memory-Optimized Database System for Heterogeneous Workloads

Summary: ERMIA is a memory-optimized DB system built from scratch to support heterogeneous workloads. It uses snapshot isolation for coordination and can provide serializability, delivering scalable performance and preserving high read-mostly throughput where OCC-based systems falter. (summarized by gpt-5-nano on Feb 09 2026)

Paper ID
5158
Venue
SIGMOD
Year
2016
Pagerank
0.00015263509
Overall Rank
655 | 95.51%
DOI
10.1145/2882903.2882905

Incoming Non-self Citations Over Time

Authors

BibTeX Citation

@inproceedings{kim_sigmod16,
        title = {{ERMIA: Fast Memory-Optimized Database System for Heterogeneous Workloads}},
        author = {Kim, Kangnyeon and Wang, Tianzheng and Johnson, Ryan and Pandis, Ippokratis},
        series = {{SIGMOD} '16},
        booktitle = {Proceedings of the {ACM} {SIGMOD} International Conference on Management of Data},
        publisher = {Association for Computing Machinery},
        doi = {10.1145/2882903.2882905},
        url = {https://dl.acm.org/doi/10.1145/2882903.2882905},
        year = {2016}
}

Incoming Citations (Sorted by Pagerank)

Showing 50 of 63 citing papers.

Rank Citing Paper Year Venue Pagerank
614 Faster: A Concurrent Key-Value Store with In-Place Updates 2018 SIGMOD 0.00015720975
760 Cicada: Dependably Fast Multi-Core In-Memory Transactions 2017 SIGMOD 0.0001425909
903 An Empirical Evaluation of In-Memory Multi-Version Concurrency Control 2017 VLDB 0.0001332486
1,063 High Performance Transactions via Early Write Visibility 2017 VLDB 0.00012343623
1,141 Mostly-Optimistic Concurrency Control for Highly Contended Dynamic Workloads on a Thousand Cores 2017 VLDB 0.0001200422
1,334 Improving Optimistic Concurrency Control Through Transaction Batching and Operation Reordering 2019 VLDB 0.00011123567
1,390 Building a Bw-Tree Takes More Than Just Buzz Words 2018 SIGMOD 0.00010942775
1,700 Aria: A Fast and Practical Deterministic OLTP Database 2020 VLDB 9.9726588e-05
2,998 Handling Highly Contended OLTP Workloads Using Fast Dynamic Partitioning 2020 SIGMOD 7.8727047e-05
3,013 Opportunities for Optimism in Contended Main-Memory Multicore Transactions 2020 VLDB 7.8518631e-05
3,088 Query Fresh: Log Shipping on Steroids 2018 VLDB 7.7694381e-05
3,644 CoroBase: Coroutine-Oriented Main-Memory Database Engine 2021 VLDB 7.2306862e-05
3,661 Sundial: Harmonizing Concurrency Control and Caching in a Distributed OLTP Database Management System 2018 VLDB 7.2167755e-05
3,967 STAR: Scaling Transactions through Asymmetric Replication 2019 VLDB 6.984665e-05
3,975 Scalable Replay-Based Replication For Fast Databases 2017 VLDB 6.9802959e-05
4,110 Spitfire: A Three-Tier Buffer Manager for Volatile and Non-Volatile Memory 2021 SIGMOD 6.8948348e-05
4,296 Latch-free Synchronization in Database Systems: Silver Bullet or Fool's Gold? 2017 CIDR 6.7773228e-05
4,440 The Art of Latency Hiding in Modern Database Engines 2024 VLDB 6.7049797e-05
4,603 The Art of Balance: A RateupDB Experience of Building a CPU/GPU Hybrid Database Product 2021 VLDB 6.6105578e-05
4,626 In-Network Support for Transaction Triaging 2021 VLDB 6.5985783e-05
4,675 Accelerating Analytical Processing in MVCC using Fine-Granular High-Frequency Virtual Snapshotting 2018 SIGMOD 6.5727393e-05
4,763 Rethinking Logging, Checkpoints, and Recovery for High-Performance Storage Engines 2020 SIGMOD 6.519206e-05
4,869 Epoch-based Commit and Replication in Distributed OLTP Databases 2021 VLDB 6.4709867e-05
5,024 Fast Failure Recovery for Main-Memory DBMSs on Multicores 2017 SIGMOD 6.3977285e-05
5,447 FILM: a Fully Learned Index for Larger-than-Memory Databases 2023 VLDB 6.2149491e-05
5,805 Diva: Making MVCC Systems HTAP-Friendly 2022 SIGMOD 6.0822211e-05
5,825 Long-lived Transactions Made Less Harmful 2020 SIGMOD 6.0747201e-05
6,027 Rethink the Scan in MVCC Databases 2021 SIGMOD 6.0022194e-05
6,058 Plor: General Transactions with Predictable, Low Tail Latency 2022 SIGMOD 5.9920075e-05
6,099 Transaction Repair for Multi-Version Concurrency Control 2017 SIGMOD 5.9776969e-05
6,291 Adaptive Optimistic Concurrency Control for Heterogeneous Workloads 2019 VLDB 5.9252026e-05
6,402 C5: Cloned Concurrency Control that Always Keeps Up 2023 VLDB 5.8859793e-05
6,476 When Private Blockchain Meets Deterministic Database 2023 SIGMOD 5.8686486e-05
6,724 Skeena: Efficient and Consistent Cross-Engine Transactions 2022 SIGMOD 5.7924267e-05
6,742 Bf-Tree: A Modern Read-Write-Optimized Concurrent Larger-Than-Memory Range Index 2024 VLDB 5.7862414e-05
6,776 X-SSD: A Storage System with Native Support for Database Logging and Replication 2022 SIGMOD 5.777467e-05
6,782 Everything is a Transaction: Unifying Logical Concurrency Control and Physical Data Structure Maintenance in Database Management Systems 2021 CIDR 5.7762362e-05
6,792 Border-Collie: A Wait-free, Read-optimal Algorithm for Database Logging on Multicore Hardware 2019 SIGMOD 5.7721543e-05
7,159 Transaction Scheduling: From Conflicts to Runtime Conflicts 2023 SIGMOD 5.6857508e-05
7,184 Memory-Optimized Multi-Version Concurrency Control for Disk-Based Database Systems 2022 VLDB 5.6785094e-05
7,717 Asynchronous Prefix Recoverability for Fast Distributed Stores 2021 SIGMOD 5.5605526e-05
7,765 An Analysis of Concurrency Control Protocols for In-Memory Databases with CCBench 2020 VLDB 5.5499187e-05
7,975 Lotus: Scalable Multi-Partition Transactions on Single-Threaded Partitioned Databases 2022 VLDB 5.515614e-05
7,988 Scalable and Robust Snapshot Isolation for High-Performance Storage Engines 2023 VLDB 5.5113542e-05
8,099 Index Checkpoints for Instant Recovery in In-Memory Database Systems 2022 VLDB 5.4873906e-05
8,167 DecLog: Decentralized Logging in Non-Volatile Memory for Time Series Database Systems 2024 VLDB 5.4745703e-05
8,474 OptiQL: Robust Optimistic Locking for Memory-Optimized Indexes 2023 SIGMOD 5.4172941e-05
8,576 A Study of Database Performance Sensitivity to Experiment Settings 2022 VLDB 5.4095894e-05
8,832 Online Schema Evolution is (Almost) Free for Snapshot Databases 2023 VLDB 5.36029e-05
8,840 Low-Latency Transaction Scheduling via Userspace Interrupts: Why Wait or Yield When You Can Preempt? 2025 SIGMOD 5.3589906e-05
Previous Page 1 / 2 Next

Outgoing Citations (Sorted by Pagerank)

Showing 29 of 29 cited papers.

Citations counted here include only citations to other VLDB/SIGMOD/CIDR/PODS papers in this database.

Rank Cited Paper Year Venue Pagerank
19 A Critique of ANSI SQL Isolation Levels 1995 SIGMOD 0.00058720861
38 Hekaton: SQL Server’s Memory-Optimized OLTP Engine 2013 SIGMOD 0.00047648573
83 H-Store: A High-Performance, Distributed Main Memory Transaction Processing System 2008 VLDB 0.00036185259
126 Schism: a Workload-Driven Approach to Database Replication and Partitioning 2010 VLDB 0.00030779127
157 OLTP Through the Looking Glass, and What We Found There 2008 SIGMOD 0.0002863588
172 High-Performance Concurrency Control Mechanisms for Main-Memory Databases 2012 VLDB 0.00027281663
245 Serializable Isolation for Snapshot Databases 2008 SIGMOD 0.00023458287
256 Data-Oriented Transaction Execution 2010 VLDB 0.00023172982
260 Models for Studying Concurrency Control Performance: Alternatives and Implications 1985 SIGMOD 0.00023103999
379 Hyder - A Transactional Record Manager for Shared Flash 2011 CIDR 0.00019611067
428 HYRISE—A Main Memory Hybrid Storage Engine 2011 VLDB 0.00018633493
473 Staring into the Abyss: An Evaluation of Concurrency Control with One Thousand Cores 2015 VLDB 0.00017900942
537 FOEDUS: OLTP Engine for a Thousand Cores and NVRAM 2015 SIGMOD 0.00016931517
575 Efficient Transaction Processing in SAP HANA Database – The End of a Column Store Myth 2012 SIGMOD 0.00016257033
603 Scalable Logging through Emerging Non-Volatile Memory 2014 VLDB 0.00015853456
720 Anti-Caching: A New Approach to Database Management System Architecture 2013 VLDB 0.00014632914
733 Serializable Snapshot Isolation in PostgreSQL 2012 VLDB 0.00014533437
755 Rethinking serializable multiversion concurrency control 2015 VLDB 0.00014326008
766 The Case for Determinism in Database Systems 2010 VLDB 0.0001420984
773 Low Overhead Concurrency Control for Partitioned Main Memory Databases 2010 SIGMOD 0.00014131021
1,014 Aether: A Scalable Approach to Logging 2010 VLDB 0.00012650747
1,089 High Performance Transactions in Deuteronomy 2015 CIDR 0.00012242396
1,315 Fast Updates on Read-Optimized Databases Using Multi-Core CPUs 2012 VLDB 0.00011181796
1,358 PLP: Page Latch-free Shared-everything OLTP 2011 VLDB 0.0001104203
1,501 Key Range Locking Strategies for Improved Concurrency 1993 VLDB 0.00010559899
1,831 On Predictive Modeling for Optimizing Transaction Execution in Parallel OLTP Systems 2012 VLDB 9.6635729e-05
1,961 Scalable Atomic Visibility with RAMP Transactions 2014 SIGMOD 9.4000927e-05
3,808 Making Updates Disk-I/O Friendly Using SSDs 2013 VLDB 7.1083217e-05
5,497 JECB: a Join-Extension, Code-Based Approach to OLTP Data Partitioning 2014 SIGMOD 6.1973614e-05
Previous Page 1 / 1 Next

Semantically Similar Papers