SWEN 432: Advanced Database Design and Implementation 2020

Lecture Schedule

Under construction! Details are not yet complete, even can be wrong.

This is an orientation schedule which will be adopted to needs during the term.

Week of the Term
Lecture Topic
Assignment

Week 1
02 March to 06 March
  • Course Overview,
  • Introduction to NoSQL Databases,
  • Trade-offs in NoSQL DBMSs

Week 2
09 March to 13 March
  • Partitioning and Replication,
  • Data Versioning,
  • Cassandra Data Modelling

Week 3
16 March to 20 March
  • Cassandra CQL Queries,
  • Cassandra Storage Engine

Assignment 1 out
Mid Trimester and Covid-19 Break (23 March to 28 April) Assignment 1 due

Week 4
28 April to 01 May
  • Cassandra Architecture,
  • Cassandra Tools and Files
Assignment 2 out
Week 5
04 May to 08 May
  • Cassandra Consistency Levels,
  • Cassandra Repair Mechanisms,
  • MongoDB Data Model

Week 6
11 May to 15 May
  • MongoDB Data Read,
  • MongoDB Write,
  • MongoDB Arrays
Assignment 2 due,
Assignment 3 out
Week 7
18 May to 22 May
  • MongoDB Aggregates,
  • MongoDB Architecture
Week 8

25 May to 29 May
  • MongoDB Distributed Writes and Reads,
  • Introduction to Data Warehousing,
  • OLAP DB Structures
Assignment 3 due
Assignment 4 out
Week 9
01 June to 05 June
  • Basic OLAP Queries,
  • OLAP Queries and SQL:1999,
  • Materialized Views

Week 10
08 June to 12 June
  • Dimension Hierarchies,
  • Aggregates,
  • Query Rewriting

Assignment 4 due
Assignment 5 out

Week 11
15 June to 19 June
  • Query Rewriting,
  • WINDOW Function,
  • Populating a Data Warehouse

Week 12
22 June to 26 June


Assignment 5 due