Lectures

Lectures are held on Tuesday nights from 6:00 - 8:00 pm Eastern. Students can participate live online via web conference, or watch a recorded video on demand.

• To access the live lecture meetings, go to the course’s site on Canvas and click on the Zoom link in the left-hand navigation bar. This will take you to a tool called Gather. Under Course Events, find the event labeled Class and click its Join button.

• The lectures will be recorded and made available within 24 hours. Use the Class Recordings link on Canvas to access them.

Full coursepack

Optional suggested readings

0. Introduction; ER diagrams and the relational model

   notes
   videos 1-4 from an optional collection of videos

1. Relational algebra and SQL

   notes
   videos 5-14 from an optional collection of videos
   solutions to practice problems, solutions to extra-practice problems

2. Storage and indexing

   notes
   solutions to hash-table examples

3. Implementing a logical-to-physical mapping

   notes

4. Transactions and schedules

   notes,
   solutions to practice problems

5. Concurrency control

   notes,
   timestamp summary,
   solutions to practice problem on deadlock-detection,
   solutions to practice problems on timestamps

6. Semistructured data and XML databases

   notes,
   solutions to XPath practice problem

7. Distributed databases and replication

   notes

8. Processing distributed data using MapReduce

   notes

9. NoSQL

   notes,
   solutions to practice queries

10. Recovery and logging

    notes,
    solutions to practice problems

11. Performance tuning; wrap-up and conclusions

    notes

12. Review

Last updated on November 20, 2024.