55 0

HTAP-friendly Version Management Architectures for MVCC Databases

Title
HTAP-friendly Version Management Architectures for MVCC Databases
Other Titles
다중 버전 병행 제어 데이터베이스의 하이브리드 트랜잭션/분석 처리를 위한 버전 관리 설계 구조
Author
김종빈
Alternative Author(s)
Jongbin Kim
Advisor(s)
정형수
Issue Date
2022. 8
Publisher
한양대학교
Degree
Doctor
Abstract
Multi-version concurrency control (MVCC) and design principles thereof are ingrained in MVCC databases for decades. It facilitates scalable transaction processing by providing point-in-time consistency, rescuing conflict operations that may otherwise be rejected in non-MVCC systems. Despite its favorable capability, contemporary MVCC systems are still vulnerable to the age-old problem: long-lived transactions. The presence of long-lived transactions impacts the stability of the multi-version nature, decreasing all aspects of performance metrics. Furthermore, the emergence of hybrid transactional/analytical processing (HTAP) aggravates the situation in that the complex analytic queries likely trigger the long-lived transactions while online transactions intensively expand the version space. This thesis presents a series of three version management architectures, vDriver, vWeaver, and DIVA. These architectures are designed by different approaches—from a practical remedy preserving the prevailing architecture to a comprehensive redesign respecting the separation of concerns principle—but share the same goal of breaking through the space-time tradeoff of conventional MVCC systems. To validate the proposed designs, we integrated each version management architecture into PostgreSQL and MySQL, well-known full-fledged MVCC database systems. The experimental evaluations demonstrate that the proposed designs generally improve all aspects of performance metrics, making MVCC databases HTAP-friendly.
URI
http://hanyang.dcollection.net/common/orgView/200000626392https://repository.hanyang.ac.kr/handle/20.500.11754/174220
Appears in Collections:
GRADUATE SCHOOL[S](대학원) > COMPUTER SCIENCE(컴퓨터·소프트웨어학과) > Theses (Ph.D.)
Files in This Item:
There are no files associated with this item.
Export
RIS (EndNote)
XLS (Excel)
XML


qrcode

Items in DSpace are protected by copyright, with all rights reserved, unless otherwise indicated.

BROWSE