681 Data Management Technologies
Content
Course topics:
External data management:
- Databases and data warehouses
- Database design:
- conceptual, logical and physical design
- advanced normalization,
- performance optimizaton
- Data warehouse design:
- design methodologies,
- data quality assurance,
- data analysis
- Non-relational database design (NoSQL)
- Non-relational data modeling
Internal data management:
- Assuring availability and consistency of stored data:
- concurrent data access,
- data archival and recovery
- distributed and parallel databases
- Query evaluation and optimization:
- query execution planning,
- estimating the costs of basic operations,
- alternative plan considerations
- Management of semi-structured and unstructured data types:
- Modern non-relational database systems
- spatial and temporal data,
- other semi-structured data (audio, video, images, sequences, JSON, XML)
Tutorial topics:
- Recognize typical data management problems and approaches for solving them
- Get to know various tools for database design and utilization, and use them in practical problems.
- Using the products of aforementioned tools for a practical database implementation (in terms of a substantial project)
Through the tutorial students get familiar with various data management tools and use them – in course of their projects – as a part of a practical problem solution. The final part of the project is a public presentation of the assigned problem, its solution and results.
Objectives and competences
The main course objective is to present principles and approaches to data management from two points of view: external, focusing on proper database/data warehouse design and data preparation, and internal, focusing on intrinsic key database technologies.
General competences:
- ability of critical thinking
- developing skills in critical, analytical and synthetic thinking
- the ability to define, understand and solve creative professional challenges in
- computer and information science
- compliance with security, functional, economic and environmental principles
- the ability to apply acquired knowledge in independent work for solving technical and scientific problems in computer and information science; the ability to upgrade acquired knowledge
Subject specific competences:
- the ability to understand and apply computer and information science knowledge to other technical and relevant fields (economics, organisational science, etc)
- practical knowledge and skills of computer hardware, software and information technology necessary for successful professional work in computer and information science
- the ability to independently perform both less demanding and complex engineering and organisational tasks in certain narrow areas and independently solve specific well-defined tasks in computer and information science