CE205-5-FY-KS:
Databases and Information Retrieval
2023/24
Computer Science and Electronic Engineering (School of)
Kaplan Singapore
Full Year
Undergraduate: Level 5
Current
Thursday 05 October 2023
Friday 28 June 2024
15
08 November 2023
Requisites for this module
(none)
(none)
(none)
(none)
(none)
BSC G400KJ Computer Science,
BSC G400KS Computer Science
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)
The aims of this module are to extend the principles of SQL database modelling and normalisation 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 different approaches.
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
Lectures, Labs and Classes
-
Kroenke, D.M. and Auer, D.J. (2015)
Database processing: fundamentals, design, and implementation. Fourteenth edition, Global edition. Upper Saddle River: Pearson. Available at:
https://ebookcentral.proquest.com/lib/universityofessex-ebooks/detail.action?docID=5185586.
-
Gudivada, V.N., Rao, D.L. and Gudivada, A.R. (2018) ‘Information Retrieval: Concepts, Models and Systems’, in C.R. Rao and V.N. Gudivada (eds)
Computational Analysis and Understanding of Natural Languages: Principles, Methods and Applications. Elsevier Science & Technology, pp. 331–401. Available at:
https://ebookcentral.proquest.com/lib/universityofessex-ebooks/detail.action?docID=5504733.
-
Manning, C.D., Raghavan, P. and Schütze, H. (2008)
Introduction to information retrieval. New York: Cambridge University Press. Available at:
https://search.ebscohost.com/login.aspx?direct=true&db=nlebk&AN=304660.
-
Dayley, B. (2015) ‘Implementing MongoDB in Python Applications’, in NoSQL with MongoDB in 24 Hours, Sams Teach Yourself. Indianapolis, US: Sams, pp. 311–330.
-
Connolly, T.M. and Begg, C.E. (2015)
Database systems: a practical approach to design, implementation and management. Sixth edition, global edition. Harlow: Pearson Education Limited. Available at:
https://ebookcentral.proquest.com/lib/universityofessex-ebooks/detail.action?pq-origsite=primo&docID=5174902.
The above list is indicative of the essential reading for the course.
The library makes provision for all reading list items, with digital provision where possible, and these resources are shared between students.
Further reading can be obtained from this module's
reading list.
Assessment items, weightings and deadlines
| Coursework / exam |
Description |
Deadline |
Coursework weighting |
Exam format definitions
- Remote, open book: Your exam will take place remotely via an online learning platform. You may refer to any physical or electronic materials during the exam.
- In-person, open book: Your exam will take place on campus under invigilation. You may refer to any physical materials such as paper study notes or a textbook during the exam. Electronic devices may not be used in the exam.
- In-person, open book (restricted): The exam will take place on campus under invigilation. You may refer only to specific physical materials such as a named textbook during the exam. Permitted materials will be specified by your department. Electronic devices may not be used in the exam.
- In-person, closed book: The exam will take place on campus under invigilation. You may not refer to any physical materials or electronic devices during the exam. There may be times when a paper dictionary,
for example, may be permitted in an otherwise closed book exam. Any exceptions will be specified by your department.
Your department will provide further guidance before your exams.
Overall assessment
Reassessment
Module supervisor and teaching staff
Dr Zulfiqar Ali, email: z.ali@essex.ac.uk.
School Office, email: csee-schooloffice (non-Essex users should add @essex.ac.uk to create full e-mail address), Telephone 01206 872770(non-Essex users should add @essex.ac.uk to create full e-mail address), Telephone 01206 872770
No
No
No
No external examiner information available for this module.
Available via Moodle
No lecture recording information available for this module.
Disclaimer: The University makes every effort to ensure that this information on its Module Directory is accurate and up-to-date. Exceptionally it can
be necessary to make changes, for example to programmes, modules, facilities or fees. Examples of such reasons might include a change of law or regulatory requirements,
industrial action, lack of demand, departure of key personnel, change in government policy, or withdrawal/reduction of funding. Changes to modules may for example consist
of variations to the content and method of delivery or assessment of modules and other services, to discontinue modules and other services and to merge or combine modules.
The University will endeavour to keep such changes to a minimum, and will also keep students informed appropriately by updating our programme specifications and module directory.
The full Procedures, Rules and Regulations of the University governing how it operates are set out in the Charter, Statutes and Ordinances and in the University Regulations, Policy and Procedures.