RocolSys: an Automatic Row-Column Data Storage System for HTAP

Shuangshuang Cui,Hongzhi Wang,Hao Wu,Dong Wang,Jinxuan Li,Jingbiao Ren,Chenguang Li,Wei Zhao
DOI: https://doi.org/10.1007/978-981-97-7244-5_27
2024-01-01
Abstract:Hybrid Transactional and Analytical Processing (HTAP) brings great challenges to data storage systems. However, traditional approaches have struggled to dynamically adapt storage structures to data and complex workloads. Fortunately, machine learning can provide new methods to guide decisions on data storage structure selection. Motivated by this, we develop RocolSys, an automatic hybrid data storage system for HTAP that can predict workloads and select storage structure automatically based on machine learning. RocolSys predicts workloads accurately and selects storage structures efficiently. It also provides the user-friendly interface that allows users to connect to their own databases. We demonstrate the efficiency of RocolSys on public benchmarks.
What problem does this paper attempt to address?