Testování závislosti fyzického návrhu databáze na hardware

Abstract

Bachelor thesis focuses on database testing, more specifically on TPC-H database testing. The individual tasks of this thesis develop an application that generates miscellaneous physical database designs by using SQL command indexes in order to identify differences in command‘s execution. All of these designs are executed in the same way on various hardware configurations. The goal is to measure the time of the command execution and evaluate if it is beneficial to use specific set of indexes on one machine whereas it might not be beneficial on other machine.