Lecture Slides
We will be using the
slides
from the book website with minor modifications.
I Foundations
Chapter 1: Introduction
Chapter 2: ER Model and Conceptual Design
Chapter 3: The Relational Model and SQL DDL
Chapter 4:
Relational Algebra
and
Relational Calculus
Chapter 5: SQL
III Systems
Chapter 8: Overview of Storage and Indexing
Chapter 9: Data Storage
Chapter 10: Tree Indexes
Chapter 11: Hash Indexes
IV Systems
Chapter 12: Overview of Query Evaluation
Chapter 13: External Sorting
Chapter 14: Evaluation of Relational Operators:
First part (joins)
and
second part (other operators)
Chapter 15: A Typical Relational Optimizer
V Systems
Chapter 16: Overview of Transaction Management
Chapter 17: Concurrency Control
Chapter 18: Recovery
VI Applications
Chapter 19: Schema Refinement, Functional Dependencies, Normalization
Chapter 20: Physical Database Design, Database Tuning
Chapter 21: Security and Authorization
VII Advanced Topics
Chapter 23:
Data Warehousing and Decision Support
.
Views
.
Chapter 26: Data Mining
Chapter 27: Information Retrieval and XML Data Management. Slides come in five parts:
Introduction to Semistructured Data and XML
XQuery