ERMIA: Fast Memory-Optimized Database System forHeterogeneous Workloads
Large main memories and massively parallel processors have triggered not only a resurgence of high-performance transaction processing systems optimized for large main-memory and massively parallel processors, but also an increasing demand for processing heterogeneous workloads that include read-mostly transactions. Many modern transaction processing systems adopt a lightweight optimistic concurrency control (OCC) scheme to leverage its low overhead in low contention workloads. However, we observe that the lightweight OCC is not suitable for heterogeneous workloads, causing significant starvation of read-mostly transactions and overall performance degradation. In this paper, we present ERMIA, a memory-optimized database system built from scratch to cater the need of handling heterogeneous workloads. ERMIA adopts snapshot isolation concurrency control to coordinate heterogeneous transactions and provides serializability when desired. Its physical layer supports the concurrency control schemes in a scalable way. Experimental results show that ERMIA delivers comparable or superior performance and near-linear scalability in a variety of workloads, compared to a recent lightweight OCC-based system. At the same time, ERMIA maintains high throughput on read-mostly transactions when the performance of the OCC-based system drops by orders of magnitude.
Code (1)
Similar Papers 제목 키워드 기반
Novel Cisplatin-Magnetoliposome Complex Shows Enhanced Antitumor Activity via Hyperthermia
There are several methods to improve cancer patient survival rates by inducing hyperthermia in tumor tissues, which involves raising their temperature above 41{\deg}C. These methods utilize different energy sources to de…
A simple EEG-based decision tool for neonatal therapeutic hypothermia in hypoxic-ischemic encephalopathy
Accurate identification of hypoxic-ischemic brain injury in the early neonatal period is essential for initiating therapeutic hypothermia (TH) within 6 hours of birth to optimize neurodevelopmental outcomes. We aimed to …
EEGElectroencephalogram (EEG)Metabolomic response of osteosarcoma cells to nanographene oxide-mediated hyperthermia
Nanographene oxide (nGO)-mediated hyperthermia has been increasingly investigated as a localised, minimally invasive anticancer therapeutic approach. Near InfraRed (NIR) light irradiation for inducing hyperthermia is par…
Fast Factorized Learning: Powered by In-Memory Database Systems
Learning models over factorized joins avoids redundant computations by identifying and pre-computing shared cofactors. Previous work has investigated the performance gain when computing cofactors on traditional disk-base…
PQTable: Non-exhaustive Fast Search for Product-quantized Codes using Hash Tables
In this paper, we propose a product quantization table (PQTable); a fast search method for product-quantized codes via hash-tables. An identifier of each database vector is associated with the slot of a hash table by usi…
CPUQuantization