interesting article about ACID in SQL

http://danweinreb.org/blog/acid-in-theory-and-practice

Also an interesting link to Postgres' implementation of true Serializable isolation.

http://wiki.postgresql.org/wiki/Serializable