Advanced Database Systems
Textbook
Part 1
Concurrency Control
Chapter 17, Textbook
Other References
Books
- P. A. Bernstein, V. Hadzilakos, and N. Goodman, Concurrency Control and Recovery in Database Systems,
Addison Wesley, 1987, ISBN 0-201-10715-5, online in PDF.
- Jim Gray, Andreas Reuter, Transaction Processing: Concepts and Techniques Morgan Kaufmann 1993, ISBN 1-55860-190-2
Contents
Seminal Papers
- Kapali P. Eswaran, Jim Gray, Raymond A. Lorie, Irving L. Traiger, The Notions of Consistency and Predicate Locks in a Database
System. CACM 19(11): 624-633(1976)
- H. T. Kung, John T. Robinson, On Optimistic Methods for Concurrency Control. TODS 6(2): 213-226(1981)
- C. T. Davies Jr., Data Processing Spheres of Control, IBM Systems Journal, 17(2):179-199(1978)
Crash Recovery
Chapter 18, Textbook
Other References
Overview Papers
- Theo Harder, Andreas Reuter, Principles of Transaction-Oriented Database Recovery ,
Computing Surveys 15(4): 287-317(1983)
- Michael J. Franklin,
Concurrency Control and Recovery,
The Handbook of Computer Science and Engineering, A. Tucker, ed., CRC Press, Boca Raton, 1997.
Seminal Papers
- (ARIES) C. Mohan, Donald J. Haderle, Bruce G. Lindsay, Hamid Pirahesh, Peter Schwarz,
ARIES: A Transaction Recovery Method Supporting Fine-Granularity Locking and
Partial Rollbacks Using Write-Ahead Logging,. TODS 17(1): 94-162(1992)
- (System R) Jim Gray, Paul R. McJones, Mike W. Blasgen, Bruce G. Lindsay, Raymond A. Lorie,
Thomas G. Price, Gianfranco R. Putzolu, Irving L. Traiger,
The Recovery Manager of the System R Database Manager
Computing Surveys 13(2): 223-243(1981)
Query Optimization
Chapter 13, Textbook
Other References
Distributed Database Systems
Chapter 19: 19.5 -- 19.13, Textbook
Other References
Object Database Systems
Chapter 21
Other References
Part 2
Heterogeneous Databases
Web and Databases
Chapter 16.3 , M. Tamer Ozsu and Patrick Valduriez,
Principles of Distributed Database Systems
Prentice Hall, 1999, ISBN 0-13-659707-6
Other References
Overview Papers
- D. Florescu, A. Levy and A. Mendelson,
Database Techniques for the World-Wide Web:A Survey ,
Sigmod Record, 27 (3), September 1998
- IEEE Data Engineering Bulettin, 21(2), June 1998
Special Issue on Databases and
the World Wide Web , in particular, S. Malaika,
Resistance is Futile: The Web will assimilate your Database
Mobility in Database Systems