Serializable snapshot isolation in postgreSQL

Proceedings of the VLDB Endowment

Volumn 5, Issue 12, 2012, Pages 1850-1861

  Ports, Dan R K ^a   Grittner, Kevin ^b  

^a MASSACHUSETTS INSTITUTE OF TECHNOLOGY   (United States)

^b Wisconsin Supreme Court ^*  (United States)

Author keywords

[No Author keywords available]

Indexed keywords

BENCHMARKING;

ISOLATION LEVEL; LOCK MANAGER; MEMORY USAGE; POSTGRESQL; READ-ONLY TRANSACTION; SNAPSHOT ISOLATION; TWO-PHASE LOCKING;

LOCKS (FASTENERS);

EID: 84869104832     PISSN: None     EISSN: 21508097     Source Type: Conference Proceeding    
DOI: 10.14778/2367502.2367523     Document Type: Article

References (21)

1. A. Adya. Weak Consistency: A Generalized Theory and Optimistic Implementations for Distributed Transactions. PhD thesis, MIT, 1999.
2. A. Adya, B. Liskov, and P. O'Neil. Generalized isolation level definitions. In ICDE, pages 67-80, 2000.
3. C. Amza, E. Cecchet, A. Chanda, S. Elnikety, A. Cox, R. Gil, J. Marguerite, K. Rajamani, and W. Zwaenepoel. Bottleneck characterization of dynamic web site benchmarks. TR02-388, Rice University, 2002.
4. ANSI. Database language - SQL. American National Standard for Information Systems X3.135-1992, 1992.
5. H. Berenson, P. Bernstein, J. Gray, J. Melton, E. O'Neil, and P. O'Neil. A critique of ANSI SQL isolation levels. In SIGMOD, pages 1-10, 1995.
6. M. J. Cahill. Serializable Isolation for Snapshot Databases. PhD thesis, University of Sydney, 2009.
7. M. J. Cahill, U. R̈ohm, and A. D. Fekete. Serializable isolation for snapshot databases. In SIGMOD, pages 729-738, 2008.
8. M. A. Casanova. The Concurrency Control Problem for Database Systems, volume 116 of LNCS. 1981.
9. K. P. Eswaran, J. N. Gray, R. A. Lorie, and I. L. Traiger. The notions of consistency and predicate locks in a database system. Communications of the ACM, 19(11):624-632, 1976.
10. A. Fekete, D. Liarokapis, E. O'Neil, P. O'Neil, and D. Shasha. Making snapshot isolation serializable. ACM Transactions on Database Systems, 30(2):492-528, 2005.
11. A. Fekete, E. O'Neil, and P. O'Neil. A read-only transaction anomaly under snapshot isolation. ACM SIGMOD Record, 33(3):12-14, 2004.
12. J. N. Gray, R. A. Lorie, G. R. Putzolu, and I. L. Traiger. Granularity of locks and degrees of consistency in a shared data base. In IFIP Working Conference on Modelling of Data Base Management Systems, pages 695-723, 1977.
13. J. M. Hellerstein, J. F. Naughton, and A. Pfeffer. Generalized search trees for database systems. In VLDB, pages 562-573, 1995.
14. S. Jorwekar, A. Fekete, K. Ramamritham, and S. Sudarshan. Automating the detection of snapshot isolation anomalies. In VLDB, pages 1263-1274, 2007.
15. H. T. Kung and J. T. Robinson. On optimistic methods for concurrency control. ACM Transactions on Database Systems, 6(2):213-226, 1981.
16. C. Mohan. ARIES/KVL: A key-value locking method for concurrency control of multiaction transactions operating on B-tree indexes. In VLDB, pages 392-405, 1990.
17. D. R. K. Ports, A. T. Clements, I. Zhang, S. Madden, and B. Liskov. Transactional consistency and automatic management in an application data cache. In OSDI, 2010.
18. S. Revilak, P. O'Neil, and E. O'Neil. Precisely serializable snapshot isolation (PSSI). In ICDE, pages 482-493, 2011.
19. M. Stonebraker. The design of the POSTGRES storage system. In VLDB, pages 289-300, 1987.
20. M. Stonebraker and L. A. Rowe. The design of POSTGRES. In SIGMOD, pages 340-355, 1986.
21. Transaction Processing Performance Council. TPC Benchmark C. http://www.tpc.org/tpcc/, 2010.