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.
|No class. Classes commence Week 2|
|Introduction class & module overview
Assignment A – Handout
|Alternative and NoSQL Databases
Assignment A – Lottery of research topics
|Query Optimization – Part 1|
|Query Optimization – Part 2
Assignment B – Handout
|Database Security / Distributed Databases|
|Bank Holiday – Review Week
Work on Completing Assignments A & B
|Visiting Speaker – Uli Bethke – Data Warehousing – On-premises & in the Cloud
Assignment A – Due Friday 8th November
|Assignment A – Student Presentations.
— IMPORTANT – Check dates and times for presentations – updated with correct dates, to correspond with weekly schedule given on this page.
|Assignment A – Student Presentations|
|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.
|No Class – Work on Assignment B
Assignment B – Due Friday 6th December
|Study & Revision
Assignment marking. I will endeavor to have assignments marked before Christmas.
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.