CS448: Introduction to Database Systems

Home | Syllabus | Schedule | Homework, Projects, & Handouts | Readings
_______________________________________________________________________________________________________________________

Lecture Schedule

The index of each slide corresponds with the associated chapter in the textbook.

Chapter 1 - Databases and Database Users (pdf )

Chapter 2 - Database System Concepts and Architecture (pdf )

Chapter 3 - Data Modeling Using the Entity Relationship (ER) Model (pdf )

Chapter 5 - The Relational Data Model Relational Database Constraints (pdf )

Chapter 6 - Basic SQL (pdf )

Chapter 7 - More SQL: Complex Queries, Triggers, Views, and Schema Modification (
pdf )

Chapter 8 - The Relational Algebra and Relational Calculus (
pdf)

Chapter 14 - Basics of Functional Dependencies and Normalization for Rational Databases (pdf)

Chapter 15 - Relational Database Design and Algorithms and Further Dependencies (pdf)

Chapter 16 - Disk Storage, Basic File Structures, Hashing, and Modern Storage Architectures (pdf)

Chapter 17 - Indexing Structures for Files and Physical DB Design (pdf)

Chapter 18 - Strategies for Query Processing (pdf)

Chapter 19 - Query Optimization (pdf)

Chapter 20 - Introduction to Transaction Processing Concepts and Theory (pdf)

Chapter 21 - Concurrency Control Techniques (pdf)

Chapter 22 - Database Recovery Techniques (pdf)

Chapter 23 - Distributed Database Concepts (pdf)

  • The Raid Distributed Database System, Bharat Bhargava and John Riedl, IEEE Trans on Software Engineering, 15(6), June 1989. [PDF]

Chapter 24 - NOSQL Databases and Big Data Storage Systems (pdf)

Chapter 25 - Big Data Technologies based on MapReduce and Hadoop (pdf)

Chapter 26 - Enhanced Data Models: Introduction to Active, Temporal, Spatial, Multimedia, and Deductive Databases (pdf)

Chapter 27 - Introduction to Information Retrieval and Web Search (pdf)

Chapter 28 - Data Mining Concepts (pdf)

Chapter 29 - Overview of Data Warehousing and OLAP (
pdf )


Other materials )

Chapter 4 - Enhanced Entity-Relationship (EER) Modeling (pdf

Chapter 9 - Relational Database Design by ER- and EER-to-Relational Mapping (pdf

Chapter 10 - Introduction to SQL Programming Techniques (pdf)

Chapter 11 - Web Database Programming Using PHP (pdf)

Chapter 12 - Object, Object-Relational, and XML: Concepts, Models, Languages, and Standards(pdf)