Survey on Database Management Systems Supporting HTAP

被引：0
|
作者：
Wang S.-L. [1 ,2 ]
Jing Y.-N. [1 ,2 ]
He Z.-Y. [1 ,2 ]
Zhang K. [1 ,2 ]
Wang X.-Y. [1 ,2 ]
机构：
[1] Shanghai Key Laboratory of Data Science, Shanghai
[2] School of Computer Science, Fudan University, Shanghai
来源：
Ruan Jian Xue Bao/Journal of Software | 2024年 / 35卷 / 01期
关键词：
Database storage; Database system; Hybrid transactional/analytical processing (HTAP); Query processing; Storage model; Transactional processing;
D O I：
10.13328/j.cnki.jos.006916
中图分类号：
学科分类号：
摘要：
Database management systems are divided into transactional (OLTP) systems and analytical (OLAP) systems according to application scenarios. With the growing demand for real-time data analysis and the increasing popularity of mixed OLTP and OLAP tasks, the industry has begun to focus on database management systems that support hybrid transactional/analytical processing (HTAP). An HTAP database system not only needs to meet the requirements of high-performance transaction processing but also supports real-time analysis for data freshness. Therefore, it poses new challenges to the design and implementation of database systems. In recent years, some prototypes and products with diverse architectures and technologies have emerged in industry and academia. This study reviews the background and development status of HTAP databases and classifies current HTAP databases from the perspective of storage and computing. On this basis, this study summarizes the key technologies used in the storage and computing of HTAP systems from bottom to top. Under this framework, the design ideas, advantages and disadvantages, and applicable scenarios of various systems are introduced. In addition, according to the evaluation benchmarks and metrics of HTAP databases, this study also analyzes the relationship between the design of various HTAP databases and their performance as well as data freshness. Finally, this study combines cloud computing, artificial intelligence, and new hardware technologies to provide ideas for future research and development of HTAP databases. © 2024 Chinese Academy of Sciences. All rights reserved.
引用
收藏
页码：405 / 429
页数：24
相关论文
共 94 条
  • [1] Appuswamy R, Karpathiotakis M, Porobic D, Ailamaki A., The case for heterogeneous HTAP, Proc. of the 8th Biennial Conf. on Innovative Data Systems Research, pp. 1-11, (2017)
  • [2] El-Sappagh SHA, Hendawi AMA, El Bastawissy AH., A proposed model for data warehouse ETL processes, Journal of King Saud University-computer and Information Sciences, 23, 2, pp. 91-104, (2011)
  • [3] Edjlali R, Feinberg D, Rayner N, Pezzini M., How to enable digital business innovation via hybrid transaction/analytical processing, (2016)
  • [4] Pezzini M, Feinberg D, Rayner N, Edjlali R., Hybrid transaction/analytical processing will foster opportunities for dramatic business innovation, (2014)
  • [5] Feinberg D, Ronthal A., Hype Cycle for Data Management, 2019, (2019)
  • [6] Bouzeghoub M., A framework for analysis of data freshness, Proc. of the 2004 Int’l Workshop on Information Quality in Information Systems, pp. 59-67, (2004)
  • [7] Psaroudakis I, Wolf F, May N, Neumann T, Bohm A, Ailamaki A, Sattler KU., Scaling up mixed workloads: A battle of data freshness, flexibility, and scheduling, Proc. of the 6th TPC Technology Conf. on Performance Characterization and Benchmarking. Traditional to Big Data, pp. 97-112, (2015)
  • [8] Sirin U, Dwarkadas S, Ailamaki A., Performance characterization of HTAP workloads, Proc. of the 37th IEEE Int’l Conf. on Data Engineering (ICDE), pp. 1829-1834, (2021)
  • [9] MacLennan J, Tang ZH, Crivat B., Data Mining with Microsoft SQL Server 2008, pp. 40-43, (2011)
  • [10] Greenwald R, Stackowiak R, Stern J., Oracle Essentials: Oracle Database 12c, pp. 2-10, (2013)
12345678910