Print

No-SQL versus relational databases

Code

IT-NSQ1

Version

2.0

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


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 ho​urs.

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​​​

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 submitted in Itslearning prior to the exam. 
For the oral exam, the student draws one of the topics from the curriculum, which will be discussed based on the course assignments, but the student may be asked about the full syllabus of the course. 
The assessment is based solely on the student's oral performance.
Internal assessment.

Tools allowed: 
All

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

2/1/2024 12:00 AM

Course type

6. semester<br/>7. semester<br/>Elective for the specialization Data Engineering<br/>Electives<br/>Web 6 og 7<br/>

Keywords