Module Description

This module extends the principles of SQL database modelling laid down in the first year. It introduces the concept of NoSQL databases and compares the strengths and weaknesses of all three approaches (SQL, IR and NoSQL paradigms)

Learning Outcoumes

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


This module is 70% Exam and 30% Coursework