Overview

 

Announcements

 

Syllabus

 

Lectures

 

Projects

 

Exams

 

Papers

 

E-mails

 

 

Lecture Notes

  • Overview
  • Set Theory Fundamentals
  • Relational Model and Algebra
  • SQL
  • Storage Organization
  • RAID
  • Buffer Management
  • File Structures
  • Introduction to Indexing
  • Tree-based Indexing
  • Hash-based Index
  • Introduction to Query Processing
  • Query Evaluation Techniques I (Sorting, Selections, Projections)
  • Query Evaluation Techniques II (Join Processing)
  • Query Optimization
  • Introduction to Transaction Processing I
  • Introduction to Transaction Processing II
  • Concurrency Control
  • Crash Recovery

 

 

Practice Exercises

 

Supplementary Readings

 

 

 

© University of Puerto Rico-Mayaguez. All rights reserved.


 

manuelr@acm.org