Search programme

​Use the search function to search amongst programmes at Chalmers. The study programme and the study programme syllabus relating to your studies are generally from the academic year you began your studies.

Syllabus for

Academic year
DAT475 - Advanced databases  
Avancerade databaser
 
Syllabus adopted 2021-02-17 by Head of Programme (or corresponding)
Owner: MPDSC
7,5 Credits
Grading: TH - Pass with distinction (5), Pass with credit (4), Pass (3), Fail
Education cycle: Second-cycle
Major subject: Computer Science and Engineering, Software Engineering
Department: 37 - COMPUTER SCIENCE AND ENGINEERING


Teaching language: English
Application code: 87122
Open for exchange students: Yes
Block schedule: D
Status, available places (updated regularly): Yes

Module   Credit distribution   Examination dates
Sp1 Sp2 Sp3 Sp4 Summer course No Sp
0121 Written and oral assignments 3,0c Grading: UG   3,0c    
0221 Examination 4,5c Grading: TH   4,5c    

In programs

MPALG COMPUTER SCIENCE - ALGORITHMS, LANGUAGES AND LOGIC, MSC PROGR, Year 1 (elective)
MPDSC DATA SCIENCE AND AI, MSC PROGR, Year 1 (compulsory elective)

Examiner:

Graham Kemp

  Go to Course Homepage


Course specific prerequisites

To be eligible to the course, the student should have a Bachelor's degree in any subject, or have successfully completed 90 credits of studies in computer science, software engineering, or equivalent.
Specifically, at least 15 credits of successfully completed courses in programming or equivalent are required. The student also needs to have attended a course in databases of at least 7.5 credits (e.g. TDA357 Databases or DAT335 Data management).

Aim

Database management systems have been around for over fifty years. While relational database systems have been the dominant database technology, other kinds of non-relational systems have been in and out of fashion throughout that time, and today many applications are better supported by a variety of non-relational systems that have emerged in recent years. These include NoSQL systems, including graph databases, and systems based on Semantic Web standards. This course provides an overview of today’s database management system landscape and highlights major trends. The course also includes concepts related to the implementation of database management systems since it is necessary to understand these concepts in order to appreciate the advantages and disadvantages of different database management systems. The purpose of this course is to provide a deeper understanding of databases, building on knowledge from an earlier introductory database course.

Learning outcomes (after completion of the course the student should be able to)

Knowledge and understanding
  • describe concepts relating to the implementation of database management systems
  • compare and contrast features of relational and non-relational database management systems
Skills and abilities
  • construct Web ontology language statements corresponding to an Entity-Relationship diagram 
  • construct RDF (Resource Description Framework) triples that contain data for a given domain
  • implement a graph database for a given domain
  • retrieve data using declarative query languages for graph databases
Judgement ability and approach
  • discuss advantages and disadvantages of different database design decisions
  • discuss advantages and disadvantages of alternative query plans
  • discuss suitability of different database management systems for various tasks

Content

Course contents:
  • database management system architecture and implementation
  • concurrency and recovery
  • indexes
  • query processing and optimization
  • Semantic Web; RDF; RDF Schema; SPARQL
  • ontologies
  • NoSQL systems; aggregation-orientation; CAP theorem
  • querying graph databases
  • database applications

Organisation

The course consists of weekly lectures and exercise sessions, as well as supervised lab sessions.

Literature

Course literature to be announced the latest 8 weeks prior to the start of the course.

Examination including compulsory elements

Written individual exam given in an examination hall and programming assignments. The programming assignments are normally carried out in pairs.

The course examiner may assess individual students in other ways than what is stated above if there are special reasons for doing so, for example if a student has a decision from Chalmers on educational support due to disability.


Page manager Published: Mon 28 Nov 2016.