Advanced Database Systems
INFC20, Informatics, 7.5 ECTS credits
The course is offered on the fifth term of the Bachelor's programme in Design of Information Systems, to exchange students and as a freestanding course.
Course description
The course presupposes a basic knowledge of conceptual modelling for data base systems and implementation using relational DBMS and SQL. The course aims to a more profound understanding of database theories, models, and methods and an ability to use these in different situations.
Course content:
- Database systems concepts and architecture
- Concepts used in UML, EER, and XML.
- Transformation of conceptual models to a relation. Properties of normalisation up to 4NF.
- Views, implementation of integrity constraints.
- Centralised, decentralised and distributed databases.
- Transaction handling. Concurrency and recovery. Query optimization. Advanced and embedded SQL. Triggers and stored procedures.
- The problem of using different architectures in client and server side applications.
- Techniques for efficient storing, accessing, securing, and recovering of data.
- Implementation of advanced structures in relational, hybrid, and object oriented data bases.
- Techniques for distributed data bases.
Teaching methods and examination: Lectures, lessons, laboratory work. Written test and assignments.