SWEN 432: Advanced Database Design and Implementation 2019

Lecture Schedule

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

Week of the Term
Lecture Topic
Assignment

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

Week 2
11 March to 15 March
  • Partitioning and Replication,
  • Data Versioning,
  • Cassandra Data Modelling

Week 3
18 March to 22 March
  • Cassandra CQL Queries,
  • Cassandra Storage Engine

Assignment 1 out
Week 4
25 March to 29 March
  • Cassandra Consistency Levels,
  • Cassandra Tools and Files

Assignment 1 due
Week 5
01 April to 05 April
  • Cassandra Architecture,
  • Cassandra Repair Mechanisms,
  • MongoDB Data Model
Assignment 2 out

Week 6
08 April to 12 April
  • MongoDB Data Read,
  • MongoDB Write,
  • MongoDB Arrays
Assignment 2 due,
Assignment 3 out
Mid Trimester Break (15 April to 28 April)
Week 7
29 April to 03 May
  • MongoDB Aggregates,
  • MongoDB Architecture
Assignment 3 due
Week 8
06 May to 10 May
  • MongoDB Distributed Writes and Reads,
  • Introduction to Data Warehousing,
  • OLAP DB Structures
Assignment 4 out
Week 9
13 May to 17 May
  • Basic OLAP Queries,
  • OLAP Queries and SQL:1999,
  • Materialized Views


Week 10
20 May to 24 May
  • Dimension Hierarchies,
  • Aggregates,
  • Query Rewriting

Assignment 4 due

Week 11
27 May to 31 May
  • Query Rewriting,
  • Populating a Data Warehouse

Assignment 5 out

Week 12
03 June to 07 June
  • OLAP and DW Architectures,
  • Course Review

Assignment 5 due