BrightSpace : This module is now available on BrightSpace. Each student needs to self-enrol in the module. Search for ‘Advanced Databases DATA9810: 2019-20‘, and for my name. The module description will have my name.

Students are reminded that notes provided on this site are intended to form summary material only and are not intended to be a substitute for attending lectures or further reading on the subject.

My slides are not Lecture Notes

Students should download the notes to your own device. The notes are a living artifact and will evolve from semester to semester. It cannot be guaranteed that the notes will be available after the end of a semester.

Important: You will need to perform additional reading and research (outside of class time) on each topic. A number of lab exercises will be given and it is expected that these will be completed. You may need to complete additional research to complete these.

*** Module Introduction & Admin – Notes

Week of/begin
 Lecture Topic
16th Sept
No class. Classes commence Week 2
23rd Sept
Introduction class & module overview

Review of Database & Database Management, and their role in Enterprises

Assignment A – Handout

30th Sept
Alternative and NoSQL Databases

Assignment A – Lottery of research topics

7th Oct
Query Optimization – Part 1
14th Oct
Query Optimization – Part 2

Assignment B – Handout

21st Oct
Database Security / Distributed Databases
28th Oct
Bank Holiday – Review Week

Work on Completing Assignments A & B

4th Nov
Visiting Speaker – Uli Bethke – Data Warehousing – On-premises & in the Cloud

Assignment A – Due Friday 8th November

11th Nov
Assignment A – Student Presentations.

— IMPORTANT – Check dates and times for presentations – updated with correct dates, to correspond with weekly schedule given on this page.

Part-time Student Schedule
Full-time Student Schedule

18th Nov
Assignment A – Student Presentations
25th Nov
Assignment A – Student Presentations

In-class group discussion based on topics covered in presentations.

We will examine the different topics, discuss theory very reality, marketing vs hype, etc. and place where the different topics fit within enterprises of today and the future.

2nd Dec
No Class – Work on Assignment B

Assignment B – Due Friday 6th December

9th Dec
Study & Revision

Assignment marking. I will endeavor to have assignments marked before Christmas.
Due to the short turn around time, this may not be possible, and results will be available in early January.Assignment feedback sessions. Monday 6th January 12:00-14:00

Would you interested in writing your own Database. Here is sample code for creating a basic database engine using Go Lang. And here is the blog post to step you through the code.