CS4411/9538 Lecture Notes

  1. Set 1: Introduction, in powerpoint
    Readings:  Fundamentals of Object-Oriented Databases, by Stanley B. Zdonik and David Maier, in Readings in Object-oriented Database Systems, Morgan Kaufmann, 1990.
  2. Set 2: Architecture, ppt   

Readings:  Chapter 4 of the Ozsu and Valduriez text.

  1. Set 3: Distributed Database Design. ppt
    Readings: Chapter 5 of the Ozsu and Valduriez text.
  2. Set 4, Data Modeling Issues ppt
    Chapter 2 of the ODMG standard book, edited by Cattell. ODMG example    last page of ODMG
  3. Set 5, OO Database Query Languages ppt
    Readings:   ODBMS web page full of resources: link

Chapter 9 in the Garcia-Molina, Ullman, Widom book.
Chapter 4 in the ODMG book.
Chapter 11 in Elmasri and Navathe (the text for CS3319, 6th edition) if you still have it.

Appendix 2: Second set of notes on O2 in pdf
Readings: the O2 manuals

  1. Set 6: Intro to XML, XPath and XQuery ppt, last 2 pages
    Readings: Article by Don Chamberlin, from IBM Systems Journal, 2002 (in pdf).
  2. Tutorial notes on XQuery, for Assignment 2 in pdf
  3. Set 7: Algebraic Query Optimization ppt
  4. Set 8: Storage, Indexing and Execution Strategies, Part 1 ppt
  5. Set 8, Part 2: Costs ppt
  6. Set 8, Part 3: XML implementation issues ppt

Some papers to read: survey paper, MonetDB paper, another MonetDB paper

also the whole Dec. 2008 issue of the IEEE Data Engineering Bulletin

two papers talking about DB2’s implementation of XML System RX, Cost-based optimization in DB2 XML

paper describing a stand-alone implementation, Sedna

 

  1. Set 9, Part 1: Transactions and Concurrency Control ppt

Additional reading on B-tree locking: Graefe’s survey paper

explanation of degrees of isolation in the book by Oneil and Oneil.

DB2 manual pages on degrees of isolation and phantoms

  1. Set 9, Part 2: Transactions and Concurrency Control Continued ppt
  2. Set 10, Recovery ppt

Additional reading: in the O’Neil & O’Neil book

  1. Set 11, Database Security ppt