Modelling and implementing a database system capable of performing data mining on the stored data, in order to discover useful patterns.
Closed book examination
A weighted aggregate mark of 50% is required to pass the module.
A database system is the core part in information systems and most modern applications in general and it is a vital component of a system that can determine its performance and security. When developing information systems, great emphasis should be put into the way that the database is designed, implemented, configured and administered. Furthermore, state-of-the art add-on and plug-in database components can enrich the system with data mining and information retrieval capabilities.
The main aim of this module has two purposes. The first is to develop the necessary skills and familiarity to use state-of-the-art technologies to design, implement and manage a database system, and the second is to use data mining and information retrieval tools to discover data patterns and retrieve information from the database.
By the end of the module the students should be able to:
design and implement a database system based on given requirements
administer and secure a database system
understand data mining techniques and be able to choose the appropriate one to analyse data and retrieve useful patterns
use information retrieval techniques to store and retrieve multimedia data
work in a group to model and develop a comprehensive database system based on specified requirements
Introduction to database systems:
Popular databases: Oracle, MySQL, Microsoft SQL Server
Relational models and data structure
Design verification (normalisation) and revision (optimisation)
Working with primitive data types
Working with data objects
Connection pooling, scalability, security
Understand how, when, and where to use data mining techniques
Discovering data patterns in raw data
Storing unstructured and multimedia data
Retrieving multimedia data
Methods of Teaching/Learning
The module will consist of approximately 20 hours of lectures and 10 hours of lab sessions.
Recommended books are:
Rob, P., Coronel, C. and Crockett, K., Database Systems: Design, Implementation & Management - International Edition, Thomson Learning, 2008, ISBN: 1844807320
MacLennan J., Tang Z. H. and Crivat, B., Data Mining with Microsoft SQL Server 2008, John Wiley & Sons, 2008, ISBN: 0470277742
The University of Surrey, Guildford, Surrey, GU2 7XH | Tel: +44 (0)1483 300800 | Fax: +44 (0)1483 300803 | Contact