URL study guide
https://tue.osiris-student.nl/onderwijscatalogus/extern/cursus?cursuscode=2IMD10&collegejaar=2025&taal=enDescription
Selected topics from the area of database system properties and their realization. The implementation design of a database system has to take performance and dependability requirements into account. In this course the different ways are studied in which database systems try to meet these requirements. In particular, attention will be paid to access and storage structures, query and transaction processing, concurrency control and recovery. These aspects will be studied for both central and distributed relational database systems. Some topics will be covered in the lectures, others in an assignment. Specific topics will be announced online.Knowledge of (modern) C++ programming language is necessary for the course project.
Objectives
At the end of this course, students should be able to:1. Analyze the core components and processing stages within a database query pipeline, including parsing, optimization and execution.
2. Apply principles of cost-based query optimization, including the use of statistics for cardinality estimation and the evaluation of different physical operator algorithms and access paths.
3. Evaluate the performance trade-offs of fundamental data structures and algorithms used in database internals, including indexing and large-scale sorting/joining.
4. Design and Compare different data storage and representation strategies considering their impact on query performance and memory footprint.
5. Apply theoretical concepts to implement and empirically assess the performance of database system components.
6. Explain advanced query processing concepts, such as techniques for handling complex query features or optimizing execution in distributed environments.