作者投稿和查稿 主编审稿 专家审稿 编委审稿 远程编辑

计算机工程 ›› 2006, Vol. 32 ›› Issue (1): 71-73,253.

• 软件技术与数据库 • 上一篇    下一篇

ARIES 算法在PostgreSQL 中的实现

周文胜,叶晓俊   

  1. 清华大学软件学院信息系统与工程研究所,北京 100084
  • 出版日期:2006-01-05 发布日期:2006-01-05

Implementation of ARIES Algorithms in PostgreSQL

ZHOU Wensheng , YE Xiaojun   

  1. Institute of Information System and Engineering, School of Software, Tsinghua University, Beijing 100084
  • Online:2006-01-05 Published:2006-01-05

摘要: 通过现有的PostgreSQL 的恢复算法和ARIES 算法的比较,说明采用ARIES 算法来改进PostgreSQL 的必要性,并在分析现有的PostgreSQL 与恢复相关的几个实现策略上,介绍为采用ARIES 算法而设计的主要数据结构以及如何改进事务恢复管理器以便支持ARIES算法的事务基本操作和恢复管理的实现流程。这样比较显著地提高了PostgreSQL 的事务处理能力。

关键词: ARIES 算法;事务;日志;保存点;检查点

Abstract: This paper explains the necessity of adopting ARIES algorithms to improve the performance of PostgreSQL by way of comparing the latter's recovery algorithms with ARIES algorithms. Based on analyzing current implementation strategy about recovery of PostgreSQL, some main data structures are designed and improved on the transaction recovery so that ARIES algorithms are adopted. This leads to improving the capability of PostgreSQL transaction processing in evidence.

Key words: ARIES algorithms;Transaction;Log;Savepoint;Checkpoint