No-SQL versus relational databases

Code

IT-NSQ1

Version

2.0

Offered by

ICT Engineering

ECTS

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 updating and querying in GraphQL
• 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
• setting up No-SQL databases in the cloud

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 cloud 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.

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

Exam prerequisites:

None

Type of exam:
Individual oral exam, 20 minutes without preparation.

Exam is based upon two course assignments handed in before deadline, and it is covering mandatory course work and theory covered in the course.

Internal assessment

Tools allowed:
N/A

Re-exam:
Same as the ordinary exam

Grading criteria

Grading based on the Danish 7-point scale.

Additional information

Responsible

Ole Ildsgaard Hougaard (oih)

Valid from

01-02-2024 00:00:00