IS3S682 - Advanced Databases and Modelling 04 Feb 2019 - 31 Aug 2027 | Version 1
Associated Module Information
| Module Code: | IS3S682 | ||
|---|---|---|---|
| Module Title: | Advanced Databases and Modelling | ||
| Faculty: | Faculty of Computing, Engineering and Science | ||
| Faculty Group: | Information and Electronics | ||
| Faculty Sub Group: | informatics | ||
| Module Leader: | Robert Berry, Ian Fitzell | ||
| Module Team: | Joseph Griffiths | ||
| First Intended Intake: | SEP 2019 | Final Year of Intake: | |
| Date Closed: | |||
| Credit Value: | 20 | Credit Level: | 6 |
| Language: | English | ||
| Percentage of Module Taught in Welsh: | 0 | ||
| Equivalent Module: | |||
| HECOS codes: | 100754 - databases | ||
| HECOS Code Weighting: | 100 | ||
Document Version Information
| Version | 1 |
|---|---|
| Valid From | 04 Feb 2019 |
| Valid To | 31 Aug 2027 |
Module Aims
To understand advanced and developing data models and database systems, and so enable them to apply related concepts to advanced database systems applications.
Content Summary
Advanced database technologies, e.g. the data warehouse and data mart, distributed, graph, ‘big data’ and NoSQL.
Data mining. MOLAP/ROLAP. Dimensionality Modelling.
Multi-tier database architecture, web database, advanced XML.
Advanced retrieval techniques: data mining, drill-down, on-line analytical processing (OLAP), fragmentation.
Introduction to mobile database technology.
Advanced object-oriented analysis and design. Object-oriented data modelling.
Features of DBMS: transaction processing, ACID, concurrency, locking, security, integrity, access, backup and recovery.
Advanced transaction analysis.
DBMS management & administration.
Database performance: overview of storage and access methods, indexing, b-trees.
Learning and Teaching Methods
| Activity Type | Hours |
|---|---|
| Lecture | 10 |
| Practical classes and workshops | 10 |
| Supervised time in studio/workshop | 6 |
| Work based learning | 74 |
| Directed Study | 28 |
| Formative Assessment - Independent | 72 |
| Total Hours Selected | 200 |
Learning Outcomes
| # | Learning Outcome |
|---|---|
| LO1 | To critically evaluate the requirements and subsequently design an appropriate solution for a problem of defined scope using advanced design/modelling techniques in non-trivial situations. |
| LO2 | To produce an appropriate solution for a problem of defined scope using advanced design/modelling techniques in non-trivial situations. |
Module Requisites
| Code | Title | Requisite Type |
|---|---|---|
| MOD009107 | Advanced Databases and Modelling | pre-requisite |
Assessment Criteria
| Assessment Category | Assessment Type | Description | Duration | Word Count | Weight (%) | Best of? | Pass Mark |
|---|---|---|---|---|---|---|---|
| Synchronous Online Assessment (Exam) | Online Open Book Examination 1 | A test of knowledge and ability by questions not known to the candidate prior to the examination. | 120 | N/A | 40 | No | 40 |
| Portfolio | Portfolio 1 | Analysis, design and implementation project involving 2 milestones. | 0 | 3600 | 60 | No | 40 |
Assessment Matrix
| Assessment Type | Learning Outcomes | ||
|---|---|---|---|
| LO1 | LO2 | ||
| Online Open Book Examination 1 | ✔ | ✔ | |
| Portfolio 1 | ✔ | ✔ | |