华东师范大学学报(自然科学版)

• 计算机科学 • 上一篇    下一篇

内存数据库事务提交的关键技术与挑战

胡 爽,  周  欢, 钱卫宁   

  1. 华东师范大学 数据科学与工程研究院, 上海 200062
  • 收稿日期:2016-07-01 出版日期:2016-09-25 发布日期:2016-11-29
  • 通讯作者: 钱卫宁, 男, 教授, 博士生导师, 研究方向为可扩展事务处理和海量数据管理与分析. E-mail: wnqian@sei.ecnu.edu.cn.
  • 基金资助:

    国家自然科学基金重点项目(61332006); 国家863计划项目(2015AA015307)

Key techniques and challenges of transaction commit in main-memory database systems

HU Shuang, ZHOU Huan, QIAN Wei-ning   

  1. Institute for Data Science and Engineering, East China Normal University, Shanghai 200062, China
  • Received:2016-07-01 Online:2016-09-25 Published:2016-11-29

摘要:

ARIES作为传统事务提交机制从20世纪90年代问世以来, 一直是主流商业或开源数据库系统普遍采用的方法. 随着应用的高通量化, 基于传统硬件设备实现的事务提交机制成为了系统性能提升的首要瓶颈. 然而大内存、多核等高性能硬件技术的发展又为事务提交机制的优化提供了新的契机. 本文详细分析并总结了传统事务提交机制中存在的问题, 然后归纳并讨论了现有基于新型硬件的事务提交技术的应用现状与优缺点, 最后探讨了事务提交优化的未来发展与挑战.

关键词: 内存数据库; , 事务提交; , 日志处理技术

Abstract:

Since its debut in the 1990s, ARIES, as the traditional transaction commit, has been widely adopted by the mainstream commercial or open source database systems. With the performance of applications increasingly improved, transaction commit based on the traditional hardwares has become the first bottleneck for performance of systems. However, the developments of high-performance hardwares, such as memory and multiple CPU cores, offer a new opportunity for the optimization of transaction commit. In this paper, we analyze and summarize the existing bottlenecks of traditional transaction commit in detail. Furthermore, key techniques of transaction commit based on new hardwares are discussed and concluded, including their application status, advantages and disadvantages. Finally, challenges and future developments for optimization of transaction commit are discussed.

Key words: main-memory database systems, transaction commit, techniques of log processing