Tentative Schedule
(Refresh/Reload for the latest version)

No.

Day

Date

Module

Topics

Reading_List
7th_Edition_Ch

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 - IllustrationAsg 2+ 18
5 Wed 6/30 2,3

Query optimization, Tuning queries

19

Transaction processing

20

6 Fri 7/2 3

Isolation Level, View serializability

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

XML queries

13
11 Fri 7/16  7

XML schema

13

Data mining, generating association rules
Quiz-3 (Modules 5,6)

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

Data warehouse schema: star, snow flake; OLTP and OLAP

29

14 Fri 7/23 8

Information retrieval and web search

27

 NOSQL Databases

24
15 Mon 7/26 8

 MongoDB and Hive

24

Hadoop, DFS, and Map Reduce
Quiz-4 (Modules 7,8)

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