This paper describes our experience implementing PostgreSQL’s new serializable isolation level. It is based on the recently-developed Serializable Snapshot Isolation (SSI) technique. This is the first implementation of SSI in a production database release as well as the first in a database that did not previously have a lock-based serializable isolation level. We reflect on our experience and describe how we overcame some of the resulting challenges, including the implementation of a new lock ...

DB - A Critique of ANSI SQL Isolation Levels.pdf ANSI SQL-92 [MS, ANSI] defines Isolation Levels in terms of phenomena: Dirty Reads, Non-Re-peatable Reads, and Phantoms. This document shows that these phenomena and the ANSI SQL definitions fail to characterize several popular isolation levels, including the standard locking implementations of the levels. Investigating the ambiguities of the phenomena leads to clearer definitions.

ARIES - A Transaction Recovery Method Supporting Fine-Granularity Locking and Partial Rollbacks Using Write-Ahead Logging.pdf Algorithm for Recouery and Isolation Exploiting Semantics), which supports partial rollbacks of transactions, finegranularity (e.g., record) locking and recovery using write-ahead logging (WAL). We introduce the paradigm of repeating history to redo all missing updates before performing the rollbacks of the loser transactions during restart after a system failure.

【Java面试】请你简单说一下Mysql的事务隔离级别.doc

面试官：什么是MySQL 事务与 MVCC 原理？.doc

详解Mysql事务隔离级别与锁机制.doc

事务的隔离级别与MVCC.doc

okcnw内容提要：本文将讲述数据库的四个重要概念：事物、游标、存储过程以及触发器。主要内容包括事务的概念及函数、游标的概念及语句、存储过程概述及其函数、触发器概述及其函数。关键字：事物、游标、存储过程、触发器引言：在关系数据库系统中，事务指的是组成为独立单元的一个或多个SQL操作的可恢复的序列。对数据库的任何一次读或写都是在某次事务内完成的。游标类似一个指针，指向某一个特定的行，根据游标的当前位置，获取和修改数据库表中的当前行。存储过程是保存起来的可以接受和返回用户提供的参数的SQL语句的集合。触发器是一种特殊的存储过程，

项目代码编程规范（设计类和方法、变量、for语句格式 、while语句、 switch语句 、封装事务）.doc

第十一章并发控制，题型则是考察事务调度。这部分比较简单，占分比例和关系代数差不多，但更简单，算是性价比很高的一章。重点掌握调度正确性的判断方法和两段锁协议；第七章数据库设计，这部分考察画E-R图和其到关系模型的转换，占分也较重，画图和转换并不难，算是很简单的一章。但如果学校给出的题目太长，画图的过程可能会绕进去，这时候可以先尝试写表，再通过表逆推E-R图进行求解。