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
- Entity Relationship Modelling
- Normalisation
- Modelling in a Realistic Scenario
Principles of Information Retrieval
- Term Weighting Models
- Word Frequency, Stemming and Stoplists
- Inverted Indexing, TF*IDF and OKAPI
- Implementation of Phrase and Wildcard Searches
- Performance Evaluation in a Practical Task
Introduction to NoSQL Databases
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