Lecture Notes

The table below provides overviews of each lecture.

Lecture notes.
LEC #	TOPICS
1	Introduction
2	The Relational Model
3	Schema Normalization
4	Database Design
5	Indexing and Access Methods
6	Buffer Pool Design and Memory Management
7	Join Algorithms
8	Query Optimization
9	Introduction to Transaction Processing
10	Recovery
11	Optimistic Concurrency Control
12	Recovery (cont.)
13	Degrees of Locking
14	Distributed Databases - Guest Lecture
15	Distributed Transactions
16	Replication in Database Systems
17	Search Engines
18	Stream Processing
19	Adaptive Query Processing - Guest Lecture
20	Online Query Processing
21	Sensor Networks
22	XML and Semantic Web
23	XML