Print

No-SQL versus relational databases

Code

IT-NSQ1

Version

1.1

Offered by

ICT Engineering

ECTS

5

Prerequisites

Database systems (DBS1) or similar

Main purpose

This course will provide students with knowledge of strengths and weaknesses of two fundamentally different approaches to database management systems.

Knowledge

The student should be able to

  • describe document-based and graph databases
  • explain updating and querying in different database paradigms
  • explain schemas and constraints in non-relational databases
  • compare relational and different non-relational approaches to database design.

Skills

The student should be able to apply
  • modelling techniques in document-based and graph databases
  • schemas and constraints to enforce designs in a no-SQL database
  • APIs and languages to maintain and query databases
  • administrative tools to set up data replication
  • administrative tools to set up sharding.

Competences

At the end of the course, the students should be able to
  • make an informed choice of database management system
  • design and create a data model in the chosen database system
  • set up a run-time environment to use for the data model.

Topics

  • Documents and collections
  • Document schemas
  • Querying in and updating documents
  • Storing data in graphs
  • Querying and updating data in graphs
  • Database operation: Replication and sharding

Teaching methods and study activities

Lessons alternate between theory and practical exercises. The course contains one or more compulsory assignments. If the assignments are not approved by the teacher, the student will be denied attending the exam and will thus have used one exam attempt.
 
Expected workload for students is estimated to 135 hours.

Resources

– Ian Robinson, Jim Webber & Emil Eifrem, Graph Databases, 2nd Edition, O’Reilly, ISBN 978-1-491-93200-1
– Internet resources

Evaluation

Examination

Oral examination based on a question from the course syllabus based on the course assignment. Approximately 20 minutes (including discussion of examinee’s performance) without preparation.

Internal exam

Grading criteria

The course is evaluated according to the 7-point grading scale based on the oral exam at the end of the course.
 

Additional information

Responsible

Ole I. Hougaard

Valid from

2/1/2021 12:00:00 AM

Course type

6. semester
7. semester
Elective for the specialization Data Engineering
Electives

Keywords

<div></div>