Module Database Search



MODULE DESCRIPTOR
Module Title
Advanced Databases
Reference CMM702 Version 2
Created October 2017 SCQF Level SCQF 11
Approved May 2016 SCQF Points 15
Amended November 2017 ECTS Points 7.5

Aims of Module
To provide systematic understanding of up-to-date issues, techniques and technologies for developing robust, usable and scalable database management systems for big data.

Learning Outcomes for Module
On completion of this module, students are expected to be able to:
1 Critically appraise relational database principles and practices in the context of transferability to complex large-scale data stores.
2 Develop robust and scalable systems that integrate web technologies for databases and database connectivity.
3 Critically appraise relational and schema-less database offerings (e.g. NoSQL) for a significant technical problem.
4 Design and implement a solution to a significant industry-focused problem providing insights and conclusions about challenges, opportunities and risks for big data management.

Indicative Module Content
Database analysis and design: Entity-Relationship modelling, Object-Oriented and Object-Relational databases. Data management: data storage, standards and exchange. Data administration methods. File systems for Massively parallel processing, hashing and key-value pair representations; Databases and the internet; modelling and design of data intensive web sites; web interfaces for DB systems; the XML language.

Module Delivery
Key concepts are introduced and illustrated through lectures and directed reading. The understanding of the students is tested and further enhanced through interactive tutorials. In the laboratories the student will progress through a sequence of practical exercises to develop sufficient knowledge of database applications.

Indicative Student Workload Full Time Part Time
Contact Hours N/A 48
Non-Contact Hours N/A 102
Placement/Work-Based Learning Experience [Notional] Hours N/A N/A
TOTAL N/A 150
Actual Placement hours for professional, statutory or regulatory body    

ASSESSMENT PLAN
If a major/minor model is used and box is ticked, % weightings below are indicative only.
Component 1
Type: Coursework Weighting: 100% Outcomes Assessed: 1, 2, 3, 4
Description: Coursework assignment consisting of a relational DB development exercise (50%) and a schema-less DB development exercise (50%).

MODULE PERFORMANCE DESCRIPTOR
Explanatory Text
The student must have a grade D on C1 to pass the module.
Module Grade Minimum Requirements to achieve Module Grade:
A Student needs to achieve an A in C1.
B Student needs to achieve a B in C1.
C Student needs to achieve a C in C1.
D Student needs to achieve a D in C1.
E Student needs to achieve an E in C1.
F Student needs to achieve an F in C1.
NS Non-submission of work by published deadline or non-attendance for examination

Module Requirements
Prerequisites for Module None except for course entry requirements.
Corequisites for module None.
Precluded Modules None.

INDICATIVE BIBLIOGRAPHY
1 CONNOLLY, T. AND BEGG, C., 2015. Database Systems: A Practical Approach to Design, Implementation and Management. Pearsons.
2 DIETRICH, S.W. AND URBAN, S.D., 2005. An Advanced Course in Database Systems: Beyond Relational Databases. Pearson Prentice Hall.
3 GORDON, K., 2013. Principles of Data Management: Facilitating Information Sharing (2nd Edition). BCS
4 RUSSELL, J., 2014. Getting Started with Impala: Interactive SQL for Apache Hadoop. O’Reilly
5 CAPRIOLO, E., WAMPLER, D., RUTHERGLEN, J., 2012. Programming HIVE. O’Reilly
6 GUPTA, S., 2012. Oracle Advanced PL/SQL Developer Professional Guide. Packt

Robert Gordon University, Garthdee House, Aberdeen, AB10 7QB, Scotland, UK: a Scottish charity, registration No. SC013781