A read-only transaction anomaly under snapshot isolation

SIGMOD Record

Volumn 33, Issue 3, 2004, Pages 12-14

  Fekete, Alan ^a   O'Neil, Elizabeth ^a   O'Neil, Patrick ^a  

^a NONE

Author keywords

[No Author keywords available]

Indexed keywords

ALGORITHMS; BENCHMARKING; COMPUTER PROGRAMMING LANGUAGES; CONCURRENCY CONTROL; DATA TRANSFER;

READ-ONLY TRANSACTION ANOMALY; SNAPSHOT ISOLATION (SI);

DATABASE SYSTEMS;

EID: 5444270649     PISSN: 01635808     EISSN: None     Source Type: Journal    
DOI: 10.1145/1031570.1031573     Document Type: Article

References (8)

1. [BBGMOO95] H. Berenson, P. Bernstein, J. Gray, J. Melton, E. O'Neil, and P. O'Neil. A Critique of ANSI SQL Isolation Levels. Proc. of the ACM SIGMOD International Conference on Management of Data, 1995. Pages 1-10.
2. [BHG87] P. A. Bernstein, V. Hadzilacos, and N. Goodman. Concurrency Control and Recovery in Database Systems. Addison Wesley, 1987. (This text is now out of print but can be downloaded from http://research.microsoft.com/pubs/ ccontrol/default.htm)
3. [BLL00] A. Bernstein, P. Lewis and S. Lu. Semantic Conditions for Correctness at Different Isolation Levels. In Proceedings of IEEE International Conference on Data Engineering, 2000. Pages 57-66.
4. [F99] A. Fekete. Serializability and Snapshot Isolation. Proceedings of the Australian Database Conference, Auckland, New Zealand, January 1999. Pages 201-210.
5. [GR93] J. N. Gray and A. Reuter. Transaction Processing: Concepts and Techniques. Morgan Kaufmann Publishers Inc., 1993.
6. [JAC95] K. Jacobs, with contributors: R. Bamford, G. Doherty, K. Haas, M. Holt, F. Putzolu, B. Quigley. Concurrency Control: Transaction Isolation and Serializability in SQL92 and Oracle7. Oracle White Paper, Part No. A33745, July, 1995.
7. [PAPA86] C. Papadimitriou. The Theory of Database Concurrency Control. Computer Science Press, 1986.
8. [TPC-C] TPC-C Benchmark Specification, available at http://www.tpc.org/