Module Description
The aims of this module are to extend the principles of SQL database modelling laid down in the first year, to describe the field of Information Retrieval, to introduce the concept of NoSQL databases and hence to compare the strengths and weaknesses of all three approaches to information access.
Learning Outcomes
After completing this module, students will be expected to be able to:
1. Understand SQL database modelling and normalisation;
2. Appreciate the principles of Information Retrieval;
3. Apply and evaluate IR in a practical context;
4. Discuss differences between models such as SQL, IR and NoSQL.
Outline Syllabus
SQL Database Design
Principles
- Modelling in a Realistic Scenario
- Relational Model and Normalisation
- SQL Database Design Using Normalisation
- Operational/transactional Systems and Business Intelligence Systems
- Concepts and Design of Data Warehouses
Principles of Information Retrieval
- Document Processing and Indexing
- Term-document Matrix and Bag-of-Words Model
- Term Weighting and Information Retrieval (IR) Models
- Performance Evaluation in a Practical Task and Relevance Judgments
NoSQL Databases
- Introduction of NoSQL Databases and Working with MongoDB
- Comparison of SQL, IR, and NoSQL paradigms
Learning & Teaching Methods
Lectures, Laboratories and Classes
Assessment
This module is 70% Exam and 30% Coursework
- Module Supervisor: Zulfiqar Ali