CE205-_-__ : Databases and Information Retrieval

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

Assessment


This module is 70% Exam and 30% Coursework