[HTML][HTML] A prefetching indexing scheme for in-memory database systems

Q Zhang, H Song, K Zhou, J Wei, C Xiao - Future Generation Computer …, 2024 - Elsevier
In-memory databases (IMDBs) store all working data in the main memory, making memory
access the dominant factor in system performance. Moreover, for modern multi-version …

Revisiting Secondary Indexing in {LSM-based} Storage Systems with Persistent Memory

J Wang, Y Lu, Q Wang, Y Zhang, J Shu - 2023 USENIX Annual Technical …, 2023 - usenix.org
LSM-based storage systems are widely used for superior write performance on block
devices. However, they currently fail to efficiently support secondary indexing, since a …

Memory-optimized multi-version concurrency control for disk-based database systems

M Freitag, A Kemper, T Neumann - Proceedings of the VLDB Endowment, 2022 - dl.acm.org
Pure in-memory database systems offer outstanding performance but degrade heavily if the
working set does not fit into DRAM, which is problematic in view of declining main memory …

Diva: Making mvcc systems htap-friendly

J Kim, J Yu, J Ahn, S Kang, H Jung - Proceedings of the 2022 …, 2022 - dl.acm.org
Multiversion concurrency control (MVCC) and design principles thereof are ingrained in
modern database management systems, thus promoting remarkable progress in managing …

One-shot garbage collection for in-memory oltp through temporality-aware version storage

A Raza, P Chrysogelos, AC Anadiotis… - Proceedings of the ACM …, 2023 - dl.acm.org
Most modern in-memory online transaction processing (OLTP) engines rely on multi-version
concurrency control (MVCC) to provide data consistency guarantees in the presence of …

Perseid: A Secondary Indexing Mechanism for LSM-Based Storage Systems

J Wang, Y Lu, Q Wang, Y Zhang, J Shu - ACM Transactions on Storage, 2024 - dl.acm.org
LSM-based storage systems are widely used for superior write performance on block
devices. However, they currently fail to efficiently support secondary indexing, since a …

Eemarq: Efficient lock-free range queries with memory reclamation

G Sheffi, P Ramalhete, E Petrank - arXiv preprint arXiv:2210.17086, 2022 - arxiv.org
Multi-Version Concurrency Control (MVCC) is a common mechanism for achieving
linearizable range queries in database systems and concurrent data-structures. The core …

A survey on hybrid transactional and analytical processing

H Song, W Zhou, H Cui, X Peng, F Li - The VLDB Journal, 2024 - Springer
To provide applications with the ability to analyze fresh data and eliminate the time-
consuming ETL workflow, hybrid transactional and analytical (HTAP) systems have been …

Accelerating scan transaction with node locking

K Doki, T Hoshino, H Kawashima - 2023 IEEE 29th …, 2023 - ieeexplore.ieee.org
Transaction processing is widely used for many applications, such as credit card payments
or social data analysis. To deal with these applications, scalable concurrency control …

Deploying Computational Storage for HTAP DBMSs Takes More Than Just Computation Offloading

K Lee, I Jo, J Ahn, H Lee, H Lee, W Sul… - Proceedings of the VLDB …, 2023 - dl.acm.org
Hybrid transactional/analytical processing (HTAP) would overload database systems. To
alleviate performance interference between transactions and analytics, recent research …