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.