15.10 - Transaction Processing References - Teradata Database

Teradata Database SQL Request and Transaction Processing

prodname
Teradata Database
vrm_release
15.10
category
Programming Reference
User Guide
featnum
B035-1142-151K

Atul Adya, Barbara Liskov, and Patrick O’Neil, “Generalized Isolation Level Definitions,” Proceedings of 16th International Conference on Data Engineering, pp. 67-78, 2000.

Hal Berenson, Phil Bernstein, Jim Gray, Jim Melton, Elizabeth O’Neil, and Patrick O’Neil, “A Critique of ANSI SQL Isolation Levels,” Proceedings of ACM SIGMOD 1995, 1-10, 1995.
Also available as a free PDF file of Microsoft Research Technical Report MSR‑TR‑95‑51 from the following URLs: http://arxiv.org/abs/cs/0701157 and http://research.microsoft.com/apps/pubs/default.aspx?id=69541.

Philip A. Bernstein and Nathan Goodman, “Concurrency Control in Distributed Database Systems,” ACM Computing Surveys, 12(2):185-221, 1981.

Philip A. Bernstein and Nathan Goodman, “The Failure and Recovery Problem for Replicated Databases,” Proceedings of 2nd ACM Symposium on Principles of Distributed Computing, pp. 114-122, 1983.

Philip Bernstein and Eric Newcomer, Principles of Transaction Processing. San Francisco: Morgan Kaufmann Publishers, 1997.

Philip A. Bernstein, Vassos Hadzilacos, and Nathan Goodman, Concurrency Control and Recovery in Database Systems. Reading, MA: Addison-Wesley Publishing Company, 1987.

Lawrence A. Bjork, “Recovery Scenario for a DB/DC System,” Proceedings 1973 ACM National Conference, pp. 142-146, 1973.

Mike Blasgen, Jim Gray, Mike Mitoma, and Tom Price, “The Convoy Phenomenon,” ACM Operating Systems Review, 13(2):20-28, 1979.

Michael J. Cahill, Uwe Röhm, and Alan D. Fekete, “Serializable Isolation for Snapshot Databases,” ACM Transactions on Database Systems, 34(4):Article 20, 2009.

C.J. Date, An Introduction to Database Systems (8th ed.). Boston, MA: Addison‑Wesley, 2004.

C.J. Date with Hugh Darwen, A Guide to the SQL Standard (4th ed.). Boston, MA: Addison‑Wesley, 1997.

Charles T. Davies, Jr., “Recovery Semantics for a DB/DC System,” Proceedings 1973 ACM National Conference, pp. 135-141, 1973.

K.P. Eswaran, J.N. Gray, R.A. Lorie, and I.L. Traeger, “On the Notions of Consistency and Predicate Locks in a Database System,” IBM Research Report RJ 1487, IBM Research Laboratories, San Jose, California, December, 1974.

K.P. Eswaran, J.N. Gray, R.A. Lorie, and I.L. Traeger, “The Notions of Consistency and Predicate Locks in a Database System,” Communications of the ACM, 19(11):624-633, 1976.

Alan Fekete, “Allocating Isolation Levels to Transactions,” Proceedings of PODS 2005, 206-215, 2005.

Alan Fekete, Elizabeth O’Neil, and Patrick O’Neil, “A Read‑Only Transaction Anomaly Under Snapshot Isolation,” ACM SIGMOD Record, 33(3):12-14, 2004.

Alan Fekete, Dimitrios Liarokapis, Elizabeth O’Neil, Patrick O’Neil, and Dennis Shasha, “Making Snapshot Isolation Serializable,” ACM Transactions on Database Systems, 30(2):492‑528, 2005.

Peter Franaszek and John T. Robinson, “Limitations of Concurrency in Transaction Processing,” ACM Transactions on Database Systems, 10(1):1-28, 1985.

Burton Grad (ed.), “History of Database Management Systems,” IEEE Annals of the History of Computing, 31(4), 2009.

Goetz Graefe, “A Survey of B‑Tree Locking Techniques,” ACM Transactions on Database Systems, 35(3), Article 16, 2010.

Jim Gray, “A Transaction Model,” in: Source Lecture Notes In Computer Science, Vol. 85: Proceedings of the 7th Colloquium on Automata, Languages and Programming. Berlin: Springer-Verlag, 1980.

Jim Gray and Andreas Reuter, Transaction Processing: Concepts and Techniques. San Francisco: Morgan Kaufmann Publishers, 1993.

J.N. Gray, R.A. Lorie, and G.R. Putzolu, “Granularity of Locks and Degrees of Consistency in a Shared Data Base,” IBM Research Report RJ 1654, IBM Research Laboratories, San Jose, California, September, 1975.

J.N. Gray, R.A. Lorie, G.R. Putzolu, and I.L. Traeger, “Granularity of Locks and Degrees of Consistency in a Shared Data Base.” In: G.M. Nijssen (ed.) IFIP Working Conference on Modeling of Data Base Management Systems. Amsterdam, North-Holland, 1976 pp. 365-394.

Jim Gray, Pat Helland, Patrick O’Neil, and Dennis Shasha, “The Dangers of Replication and a Solution,” Proceedings of ACM SIGMOD 1996, pp. 173-182, 1996.

Jim Gray, Paul McJones, Mike Blasgen, Bruce Lindsay, Raymond Lorie, Tom Price, Franco Putzolu, and Irving Traiger, “The Recovery Manager of a Data Management System,” IBM Research Report RJ 2623, IBM Research Laboratories, San Jose, California, June, 1979.

Jim Gray, Paul McJones, Mike Blasgen, Bruce Lindsay, Raymond Lorie, Tom Price, Franco Putzolu, and Irving Traiger, "The Recovery Manager of the System R Database Manager," ACM Computing Surveys, 13(2):223-242, 1981.

Theo Haerder, “Observations on Optimistic Concurrency Control Schemes,” Information Systems, 9(2):111-120, 1984.

Theo Haerder and Andreas Reuter, "Principles of Transaction-Oriented Database Recovery," ACM Computing Surveys, 15(4):287-317, 1983.

Maurice P. Herlihy and Jeannette M. Wing, “Linearizability: A Correctness Condition for Concurrent Objects,” ACM Transactions on Programming Languages and Systems, 12(3):463-492, 1990.

Paul R. Johnson and Robert H. Thomas, “The Maintenance of Duplicate Databases,” Network Working Group RFC # 677, 1975. Available at http://www.faqs.org/rfcs/rfc677.html.

R.M. Karp and R.E. Miller, “Properties of a Model for Parallel Computations: Determinacy, Termination, Queueing,” SIAM Journal on Applied Mathematics, 14(6):1390-1411, 1966.

H.T. Kung and C.H. Papadimitriou, “An Optimality Theory of Concurrency Control for Databases,” Proceedings of ACM SIGMOD 1979, pp. 116-126, 1979.

H.T. Kung and John T. Robinson, “On Optimistic Methods for Concurrency Control,” ACM Transactions on Database Systems, 6(2):213-226, 1981.

Butler W. Lampson and Howard E. Sturgis, “Crash Recovery in a Distributed Data Storage System,” Technical Report, Xerox Palo Alto Research Center, Palo Alto, California, 1976.

Yi Lin, Bettina Kemme, Ricardo Jiménez-Peris, Marta Patiño-Martínez, and José Enrique Armendáriz-Iñigo, “Snapshot Isolation and Integrity Constraints in Replicated Databases,” ACM Transactions on Database Systems, 34(2)11:1-11:49, 2009.

Jim Melton (ed.), International Standard ISO/IEC 9075-2 (5th ed.), Part 2: Foundation
(SQL/Foundation)
. Geneva, Switzerland: ISO/IEC/ANSI, 2003.

C. Mohan, “Less Optimism About Optimistic Concurrency Control,” Proceedings of 2nd International Workshop on Research Issues on Data Engineering 1992, 199-204, 1992.

C. Mohan and Frank Levine, “ARIES/IM: An Efficient and High Concurrency Index Management Method Using Write-Ahead Logging,” IBM Research Report RJ6846, IBM Almaden Research Center, San Jose, California, June, 1989.

C. Mohan and Frank Levine, “ARIES/IM: An Efficient and High Concurrency Index Management Method Using Write-Ahead Logging,” Proceedings of SIGMOD 1992, 371-380, 1992.

C. Mohan, Don Haderle, Bruce Lindsay, Hamid Pirahesh, and Peter Schwarz, “ARIES: A Transaction Recovery Method Supporting Fine-Granularity Locking and Partial Rollbacks Using Write-Ahead Logging,” ACM Transactions on Database Systems, 17(1):94-162, 1992.

Patrick O’Neil, Course Notes for CS735, Database Internals. Department of Computer Science, University of Massachusetts, Boston, 2004.

Patrick O’Neil and Elizabeth O’Neil, Project Summary for Isolation Testing. NSF Project Proposal, University of Massachusetts, Boston, 15pp., 1999.

Christos H. Papadimitriou, The Theory of Database Concurrency Control. Rockville, MD: Computer Science Press, 1986.

K. Rothermel and C. Mohan, “ARIES/NT: A Recovery Method Based on Write-Ahead Logging for Nested Transactions,” Proceedings of 15th International Conference on Very Large Data Bases, pp. 337-346, 1989.

Yasushi Saito and Marc Shapiro, “Optimistic Replication,” ACM Computing Surveys, 37(1):42-81, 2005.

Y.C. Tay, Locking Performance in Centralized Databases. Boston, MA: Academic Press, Inc., 1987.

Y.C. Tay, Nathan Goodman, and Rajan Suri, “Locking Performance in Centralized Databases,” ACM Transactions on Database Systems, 10(4):415-462, 1985.

Alexander Thomasian, “Concurrency Control: Methods, Performance, and Analysis,” ACM Computing Surveys, 30(1):70-119, 1998.

Irving L. Traiger, James N. Gray, Cesare A. Galtieri, and Bruce G. Lindsay, “Transactions and Consistency in Distributed Database Systems,” IBM Research Report RJ 2555, IBM Research Laboratories, San Jose, California, June, 1979.

Jeffrey D. Ullman, Principles of Database Systems (2nd ed.). Rockville, Maryland: Computer Science Press, 1982.

Gerhard Weikum and Gottfried Vossen, Transactional Information Systems: Theory, Algorithms, and the Practice of Concurrency Control and Recovery. San Francisco: Morgan Kaufmann Publishers, 2001.