The aim of the subject element is to train the student to be able to select and apply various database types appropriately in relation to various fields of application. The student must also be able to analyse and develop in relation to large databases, including redesign and optimisation.

The student must have knowledge of:
•Various database types and the underlying models
•A specific database system’s storage organisation and query execution
•A specific database system’s optimisation possibilities – including advantages and disadvantages
•Database-specific security problems and their solutions
•Concepts and issues in relation to data warehousing, including big data
•The particular issues raised by having many simultaneous transactions, including in connection with distributed databases
•Relational algebra (including its relationship to execution plans)

The student can:
•Transform logical data models into physical models in various database types
•Implement database optimisation
•Use parts of the administration tool to assist in the optimisation and tuning of existing databases, including the incorporation of a specific DBMS’ execution plans
•Use a specific database system’s tools for handling simultaneous transactions
•Use the programming and other facilities provided by a modern DBMS
•Use an object-relational mapping tool

The student can:
•Analyse the application domain in order to select a database type
•Divide responsibility for tasks between the application and DBMS during system development, to ensure the best possible implementation.