|
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