IS3S662 - Advanced Databases and Modelling 01 Jul 2022 - 31 Aug 2028 | Version 5
Associated Module Information
| Module Code: | IS3S662 | ||
|---|---|---|---|
| Module Title: | Advanced Databases and Modelling | ||
| Faculty: | Faculty of Computing, Engineering and Science | ||
| Faculty Group: | Computing and Mathematics | ||
| Faculty Sub Group: | Informatics | ||
| Module Leader: | Robert Berry | ||
| Module Team: | Joseph Griffiths, Adam Jones | ||
| First Intended Intake: | 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: | 100753 - systems analysis and design | 100754 - databases | 100755 - data management |
| HECOS Code Weighting: | 20 | 50 | 30 |
Document Version Information
| Version | 5 |
|---|---|
| Valid From | 01 Jul 2022 |
| Valid To | 31 Aug 2028 |
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 | 24 |
| Tutorial | 24 |
| Independent Study | 80 |
| Directed Study | 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
N/A
Assessment Criteria
| Assessment Category | Assessment Type | Description | Duration | Word Count | Weight (%) | Best of? | Pass Mark |
|---|---|---|---|---|---|---|---|
| Asynchronous Assessment | Portfolio 1 | Analyse the requirements and design of solutions for real-world problems. | 0 | N/A | 60 | No | 40 |
| Synchronous Onsite Assessment (Exam) | Onsite Closed Book Examination 1 | An examination that draws on knowledge and material from the module | 120 | N/A | 40 | No | 40 |
Assessment Matrix
| Assessment Type | Learning Outcomes | ||
|---|---|---|---|
| LO1 | LO2 | ||
| Portfolio 1 | ✔ | ✔ | |
| Onsite Closed Book Examination 1 | ✔ | ✔ | |