Tentative Schedule |
|||||
No. |
Day |
Date |
Module |
Topics |
Reading_List |
1 | Mon | 6/21 | 1 |
Course introduction & objectives; Overview of database systems; |
1, 2 |
Relational model, Relational algebra, WinRDBI Asg 1+ |
5, 8 |
||||
2 | Wed | 6/23 | 1 |
SQL queries, MariaDB (XAMPP) |
6, 7, 18 |
Query execution (SQL -> Relational algebra) |
18 |
||||
3 | Fri | 6/25 | 1 |
Database design and normalization(top-down), Design (Bottom-up), |
3, 4, 9, 14 |
Index, view, trigger, and stored procedure; Quiz-1 (Module 1) |
17, 7, 10 | ||||
4 | Mon | 6/28 | 2 |
-Asg 1;Query processing, Relational algebra operator implementation, sort-merge join |
18 |
External sorting algorithm - Illustration; Asg 2+ | 18 | ||||
5 | Wed | 6/30 | 2,3 |
19 |
|
20 |
|||||
6 | Fri | 7/2 | 3 |
20 |
|
locks (binary, shared/exclusive, intention) Quiz-2 (Modules 2,3) |
20 | ||||
Mon | 7/5 |
Independence Day observed (University Closed) |
|||
7 | Wed | 7/7 | 4 | -Asg 2 Concurrency protocols: Two-phase locking, | 21 |
Deadlock prevention, and Time stamp ordering protocols | 21 | ||||
8 | Fri | 7/9 |
Mid-term exam (Modules 1,2,3,4) 5pm -7pm |
||
9 | Mon | 7/12 | 5 | Web queries | 11 |
Web Databases and PHP queries; Asg 3+ |
11 |
||||
10 | Wed | 7/14 | 6 |
XML, Document Type Definition, Generating XML documents from databases |
13 |
13 | |||||
11 | Fri | 7/16 | 7 | 13 | |
Data mining, generating association rules
|
28 |
||||
12 | Mon | 7/19 | 7 |
Classification, clustering, Apriori algorithm |
28 |
Frequent Pattern Tree algorithm; Asg 4+ |
28 |
||||
13 | Wed | 7/21 | 7 |
-Asg 3; GCP demo |
|
29 |
|||||
14 | Fri | 7/23 | 8 |
27 |
|
24 | |||||
15 | Mon | 7/26 | 8 |
MongoDB and Hive |
24 |
Hadoop, DFS, and Map Reduce
|
25 | ||||
16 | Wed | 7/28 | 8 |
-Asg 4; Spark |
|
Review | |||||
17 |
Fri | 7/30 |
Final exam (Modules 5,6,7,8) 5pm -7pm |
|
Asg x+ : The specification for Asg x will be made available
-Asg x : The completed Asg x must be submitted(uploaded) in Canvas