Database Tuning Coursework

This repository contains coursework developed as part of the Database Tuning course at the University of Salzburg (2025).

The exercises focus on practical database performance analysis, query optimization, transaction behavior, benchmarking, and tuning techniques.

Team

• Josef Litoš – B.Sc. Student
• Noga Aviran – B.Sc. Student

---

Topics Covered

• Query optimization and execution-time comparison
• Indexing strategies
• Transaction handling and concurrency behavior
• Database configuration and performance tuning
• SQL experimentation and benchmarking
• Python-based setup and test utilities

---

Structure

The repository is organized by course exercise:

• HW1 – introductory database setup and analysis
• HW2 – data generation and database setup
• HW3 – query modification and performance comparison
• HW4 – measurement and testing
• HW5 – database tuning exercises
• HW6 – transaction and concurrency experiments

---

Technologies

• SQL
• Python
• Shell scripting
• Relational databases