Modules

Core Module Information
Module title: Advanced Database Systems
SCQF level: 09:
SCQF credit value: 20.00
ECTS credit value: 10
Module code: SET09107
Module leader: Taoxin Peng
School School of Computing, Engineering and the Built Environment
Subject area group: Computer Science
Prerequisites

Requisites: AND Pre-requisite: A database systems course using SQL and A software development course covering object-oriented techniques AND AND Pre-requisite: [Module SET07110] Foundations of Software Design and Development AND Pre-requisite: [Module SET08120] Database Systems
Description of module content:

This module aims to provide you with core advanced database techniques, focusing on techniques beyond traditional relational database systems. This module comprises two parts: Object-Relational Modelling and other advanced topics. In the part of Object-Relational Modelling, you will learn how to model data by the use of techniques from Object Oriented methods/techniques, integrated with Relational modelling techniques. To help you to understand and master the fundamentals of Object-Relational Modelling, you will be provided with opportunities to practice modelling, designing, implementing Object-Relational databases by the use of industry standard platforms, such as Oracle Express and SQL Developer.In the second part, other advanced topics will be introduced, such as Data Warehouses, Big Data and NoSQL. Contents covered by these topics are: Data Warehouses – Why are data warehouses needed? Difference between data warehouses and traditional databases, data modelling techniques, implementation issuesBig Data – What is big data? Differences between big data and other databases, an introduction to big data analytics.NoSQL - What is NoSQL? RDBMS issues, NoSQL issues, Types of NoSQL
Learning Outcomes for module:

Upon completion of this module you will be able to

LO1: Critically analyse and evaluate modelling and development methods/techniques in Object-Relational Databases.

LO2: Design and implement a non-relational data model.

LO3: Critically compare, analyse and evaluate methods/technologies in developing data warehouses.

LO4: Critically compare, analyse and evaluate different technologies in big data analytics.

LO5: Critically review a selection of emerging database technologies.
Full Details of Teaching and Assessment
2024/5, Trimester 1, Blended,
VIEW FULL DETAILS
Occurrence: 001
Primary mode of delivery: Blended
Location of delivery: MERCHISTON
Partner:
Member of staff responsible for delivering module: Taoxin Peng
Module Organiser:


Student Activity (Notional Equivalent Study Hours (NESH))
Mode of activityLearning & Teaching ActivityNESH (Study Hours)NESH Description
Face To Face Centrally Time Tabled Examination 2 You will take an online centrally time tabled exam to show your mastery of the knowledge and skills taught on topics of Dat Warehousing, Big Data and NoSQL.
Online Guided independent study 158 Self-learning materials, including Oracle online documentations, Book chapters, Notes/Tutorials/Blogs, videos, and Research articles, will be released on the Moodle page. The lecture slides and notebooks will also be released one week earlier before the lecture day.
Face To Face Lecture 20 The lectures present fundamentals, especially main features of Object-Relational modelling approaches. They also cover a comprehensive set of the state-of-art knowledge and skills on advanced topics, such as Dat Warehousing, Big Data and NoSQL.
Face To Face Practical classes and workshops 20 The practicals cover hands-on exercises in data modelling and implementation, using Oracle Express and SQL Developer. Feedback will be given on your practical exercises during these sessions.
Total Study Hours200
Expected Total Study Hours for Module200


Assessment
Type of Assessment Weighting % LOs covered Week due Length in Hours/Words Description
Practical Skills Assessment 60 1~2~5 Week 10 HOURS= 40 hours Component 1 is a practical coursework (LOs 1, 2, 5), which assesses fundamentals and practical skills of object-relational databases.
Centrally Time Tabled Examination 40 3~4~5 Exam Period HOURS= 2 hours Component 2 is a central timetabled exam (LOs 3, 4, 5), which assesses fundamentals and theories of emerging database technologies, such as data warehouses, big data, and NoSQL.
Component 1 subtotal: 60
Component 2 subtotal: 40
Module subtotal: 100

Indicative References and Reading List - URL:
SET09107 Advanced Database Systems
 

Related information