|
||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
|
Class Notes and Reading Guide
|
Class Logistics & Introduction to Database Systems | Chapter 1 from the textbook |
Set #1 4 slides per page |
|
Design of Query Languages | Chapter 2.0-2.3, 6.0-6.5, 8.1-8.2.2, 8.5 & 10.1 from the textbook |
Set #1 4 slides per page |
|
(Optional) |
|
[1pm-1:50pm]: Zoom Link (pass: DBrec22) [2pm-2:50pm]: Zoom Link (pass: DBrec22) |
PostgreSQL & DataGrip Setup Interfaces Quick Guide |
Design of Query Languages | Chapter 2.0-2.3, 6.0-6.5, 8.1-8.2.2, 8.5 & 10.1 from the textbook |
Set #2 4 slides per page |
|
SQL Transactions & Specifying C of ACID (Integrity Constraints) | Chapter 7 from the textbook |
Set #1 4 slides per page |
|
Theory of Recovery | Chapters 1.1-1.2, 2.1 & 2.4 from BHG book from extra material |
Set #1 4 slides per page |
|
Theory of Recovery | Chapters 1.1-1.2, 2.1 & 2.4 from BHG book from extra material |
Set #2 4 slides per page |
|
Theory of Serializability | Chapters 1.3, 2.1-2.3 & 2.5-2.6 from BHG book from extra material |
Set #1 4 slides per page |
|
Theory of Serializability | Chapters 1.3, 2.1-2.3 & 2.5-2.6from BHG book from extra material |
Set #2 4 slides per page |
|
Theory of Serializability | Chapters 1.3-1.4, 2.1-2.3 & 2.5-2.6 from BHG book from extra material |
Set #3 4 slides per page |
|
Data Storage | Chapter 13 from textbook |
Set #1 4 slides per page |
|
Data Storage | Chapter 13 from textbook |
Set #2 4 slides per page |
|
Data Storage | Chapter 13 from textbook & UC Caching from extra material |
Set #3 4 slides per page |
|
Data Storage | Chapter 13 from textbook & SSDs, QMD, and TraQIOS from extra material |
Set #4 4 slides per page |
|
File Organization | Chapter 13 from textbook |
Set #1 4 slides per page |
|
File Organization | Chapter 13 from textbook |
Set #2 4 slides per page |
|
Access Methods & Index Structures | Chapter 14 from textbook |
Set #1 4 slides per page |
|
Access Methods & Index Structures | Chapter 14 from textbook |
Set #2 4 slides per page |
|
Access Methods & Index Structures | Chapter 14 from textbook |
Set #3 4 slides per page |
|
Query Processing (Relational Algebra review) | Chapter 5.1-5.2 from textbook |
Set #1 4 slides per page |
|
Query Processing | Chapters 15 & 16 from textbook |
Set #2
4 slides per page |
|
Query Processing | Chapters 15 & 16 from textbook |
Set #3
4 slides per page |
|
Query Processing | Chapters 15 & 16 from textbook |
Set #4
4 slides per page |
|
Recovery Tecnhiques | Chapter 17 & 19.1 from textbook |
Set #1
4 slides per page |
|
Recovery Techniques | Chapter 17 & 19.1 from textbook |
Set #2
4 slides per page |
|
Locking Techniques | Chapter 18 & 19.2 from textbook |
Set #1
4 slides per page |
|
Locking Techniques | Chapters 18 & 19.2 from textbook |
Set #2
4 slides per page |
|
Timestamp Ordering Techniques | Chapter 18 & 19.2 from textbook |
Set #1
4 slides per page |
|
Optimistic CC Techniques | Chapter 18 & 19.2 from textbook |
Set #1
4 slides per page |
|
Multi-Version CC Techniques | Chapter 18 & 19.2 from textbook |
Set #1
4 slides per page |
|
Distributed DBMSs | Chapter 20.2-20.6 from textbook |
Set #1
4 slides per page |
|
Distributed DBMSs | Chapter 20.2-20.6 from textbook |
Set #2,
Set #3
4 slides per page |
Panos K. Chrysanthis © 2022 | Last updated on April 26, 2022 at 19:18:54 EST |