Journal of East China Normal University(Natural Sc

Previous Articles     Next Articles

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


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