Advanced Databases
Description
This module provides an in-depth treatment of the theory and practice relating to advanced database applications in areas such as Enterprise Data Management, and in the management and storage of non-relational data. It expands the knowledge acquired through programmes taken at Level seven or earlier such as Database Management or equivalent.
Learning Outcomes
Distinguish between Operational Databases, used for Online Transaction Processing, and Data Warehouses, used for Online Analytical Processing.
Demonstrate an understanding of a Data Warehouse design method and its application.
Discuss how Data Mining and other advanced data analysis tools are used to give corporate decision makers access to all of an organisation's data, both historical and current.
Recognise the benefits and the considerable difficulties associated with Distributed DBMSs and have high awareness of the protocols associated with distributed transaction management, concurrency control, and recovery.
Understand the limitations of the relational model with regard to advanced database applications such as CAD, multi-media, and OIS, and recognise how database technology, based on the Object model, may be used to overcome these limitations.
Demonstrate a critical appreciation of the various approaches by which the WEB and database technology are currently being integrated, and the appropriateness of the WEB as a database application platform.