![]() |
15-415 - Database Applications | ![]() |
Week |
Session |
Date |
Topic |
Teaching Method |
Reading |
Projects |
Prob. Solving Assignments |
1 |
1 |
11 Jan |
Administrivia and Introduction |
Lecture |
Syllabus, R&G C1 |
|
|
|
2 |
13 Jan |
The Entity-Relationship Model |
Lecture |
R&G C2 |
|
Start PS1 |
|
3 |
15 Jan |
Case study on Entity Relationship Diagram |
Recitation |
Notes from TA |
|
|
2 |
4 |
18 Jan |
The Relational Model |
Lecture |
R&G C3 |
|
|
|
5 |
20 Jan |
Relational Algebra |
Lecture |
R&G C4.2 |
|
|
|
6 |
22 Jan |
Case study on Relational Algebra |
Recitation |
Notes from TA |
|
End PS1 |
3 |
7 |
25 Jan |
Relational Calculus |
Lecture |
R&G C4.3 |
|
Start PS2 |
|
8 |
27 Jan |
The SQL Query Language (Part I) |
Lecture |
R&G C5 |
|
|
|
9 |
29 Jan |
Hands-on PostgreSQL + Overview of P1 |
Recitation |
Notes from TA |
Start P1 |
|
4 |
10 |
01 Feb |
The SQL Query Language (Part II) |
Lecture |
R&G C5 |
|
|
|
11 |
03 Feb |
Storing Data –
Disks, Buffers, |
Lecture |
R&G C9 |
|
|
|
12 |
05 Feb |
More hands-on PostgreSQL |
Recitation |
Notes from TA |
|
End PS2 |
5 |
13 |
08 Feb |
File Organizations and Indexing |
Lecture |
R&G C8 |
|
|
|
14 |
10 Feb |
Qatar National Sports Day; No Class |
|
|
|
|
|
15 |
12 Feb |
Database Connectivity in Java (JDBC) |
Recitation |
Notes from TA |
End P1 |
|
6 |
16 |
15 Feb |
Tree-Based Indexing Schemes |
Lecture |
R&G C10 |
Start P2 |
|
|
17 |
17 Feb |
Hash-Based Indexing Schemes |
Lecture |
R&G C11 |
|
Start PS3 |
|
18 |
19 Feb |
Overview of P2 with a focus on JSPs |
Recitation |
Notes from TA |
|
|
7 |
19 |
22 Feb |
Review for midterm |
Lecture |
Notes from the Instructor |
|
|
|
|
24 Feb |
Midterm |
Exam 1 |
|
|
|
|
20 |
26 Feb |
More on P2 |
Recitation |
Notes from TA |
|
|
8 |
|
01 – 05 Mar |
Spring Break; No Classes |
|
|
|
End PS3 on 01 Mar |
9 |
21 |
08 Mar |
A Brief Primer on Query Evaluation and External Sorting |
Lecture |
R&G C12 & C13 |
|
Start PS4 |
|
22 |
10 Mar |
Relational Operators (Part I) |
Lecture |
R&G C12 & C14 |
End P2 |
|
|
23 |
12 Mar |
Case study on Query Plans and Cost Estimation + Overview of P3 |
Recitation |
Notes from TA |
Start P3 |
|
10 |
24 |
15 Mar |
Relational Operators (Part II) |
Lecture |
R&G C12 & C14 |
|
|
|
25 |
17 Mar |
Query Optimization |
Lecture |
R&G C15 |
|
|
|
26 |
19 Mar |
Overview of P3 |
Recitation |
Notes from TA |
|
|
11 |
27 |
22 Mar |
Parallel and Distributed DBMSs |
Lecture |
R&G C22 |
|
End PS4 |
|
28 |
24 Mar |
Big Data and Hadoop |
Lecture |
Notes from the Instructor |
|
|
|
29 |
26 Mar |
Simple ISAM in C |
Recitation |
Notes from TA |
End P3 |
|
12 |
30 |
29 Mar |
No-SQL Databases: The Google’s BigTable |
Lecture |
Notes from the Instructor |
|
|
|
31 |
31 Mar |
New-SQL |
Lecture |
Notes from the Instructor |
Start P4 |
|
|
32 |
02 Apr |
Overview of P4 + Hands-on MapReduce |
Recitation |
Notes from TA |
|
Start PS5 |
13 |
33 |
05 Apr |
Concurrency Control (Part I) |
Lecture |
R&G C17 |
|
|
|
34 |
07 Apr |
Concurrency Control (Part II) |
Lecture |
R&G C17 |
|
|
|
35 |
09 Apr |
More on P4 + HBase |
Recitation |
Notes from TA |
|
|
14 |
36 |
12 Apr |
Logging and Recovery (Part I) |
Lecture |
R&G C18 |
|
|
|
37 |
14 Apr |
Logging and Recovery (Part II) |
Lecture |
R&G C18 |
|
|
|
38 |
16 Apr |
More on P4 |
Recitation |
Notes from TA |
|
End PS5 |
15 |
39 |
19 Apr |
TBD |
Lecture |
|
|
|
|
40 |
21 Apr |
TBD |
Lecture |
|
|
|
|
41 |
23 Apr |
Review for final |
Recitation |
Notes from the Instructor |
End P4 |
|
16 |
|
26 Apr |
Final |
Exam 2 |
|
|
|