Course code

IFI6106.DT

old course code

IFI6106

Course title in Estonian

Andmebaasid

Course title in English

Databases

ECTS credits

4.0

Assessment form

Examination

lecturer of 2023/2024 Spring semester

Not opened for teaching. Click the study programme link below to see the nominal division schedule.

lecturer of 2024/2025 Autumn semester

Not opened for teaching. Click the study programme link below to see the nominal division schedule.

Course aims

Give an opportunity to learn how to select appropriate relational and other modern databases for the task at hand, keep them operational, optimize and scale them to match the demand.

Brief description of the course

Requirements for modern databases: fault tolerance, scaling, global access, high availability

Database classifications:
* SQL - traditional relational databases
* "No-SQL" - key-value store, columnar store, document store, graph db
* "New-SQL" - new generation relation databases meant to use distributed [cloud] environments

Management of relational databases, problems related to growth of the data, optimizations, replication, geo-replication, multi-tenancy, sharding, backup and recovery plans

Cloud databases (Azure, Amazone, Google), solutions for databases with global reach

Data consistency levels: ACID, CAP, BASE

Learning outcomes in the course

Upon completing the course the student:
- has ability to choose appropriate database for the task, keep it optimally operational when data volume and availability demands increase.

Teacher

Priidu Paomets

Prerequisite course 1

Design and Development of Databases (IFI6013.DT)

Study programmes containing that course

Computer Science (IFIFB/24.DT)
Computer Science (IFIFB/23.DT)
Computer Science (IFIFB/22.DT)
Computer Science (IFIFB/21.DT)
Computer Science (IFIFB/20.DT)
Computer Science (IFIFB/19.DT)
Computer Science (IFIFB/18.DT)
Computer Science (IFIFB/17.DT)
Computer Science (IFIFB/16.DT)
Computer Science (IFIFB/15.DT)
Computer Science (IFIFB/14.DT)