Thesis Details

Automatizované velkoobjemové zpracování testovacích výsledků

Bachelor's Thesis Student: Klem Richard Academic Year: 2020/2021 Supervisor: Hruška Tomáš, prof. Ing., CSc.
English title
Automatic Largescale Processing of Testing Results
Language
Czech
Abstract

This thesis deals with the issue of automated processing of large volumes of data in a relational database environment. The thesis focuses on the current situation in the Codasip company and solves the insufficiently fast implementation of materialized views updates. The result of the thesis is a draft to modify the current system. This draft successfully solves problems with slow data processing. The implemented solution then brought an average acceleration of the update of materialized views by 93 % and for some materialized views an acceleration of 99 %. This solution will help Codasip increase the efficiency of processor core development, as well as their other products. At the same time, this thesis can serve as a case study of optimizing slow database queries when processing large amounts of data.

Keywords

testing, automation, test results, report, MySQL, databases, database schema, SQL queries, pytest, data processing, optimization, partitioning, materialized view, visualization, Metabase

Department
Department of Information Systems FIT BUT
Degree Programme
Information Technology
Files
Status
defended, grade A
Date
15 June 2021
Reviewer
Šnobl Pavel, Ing.
Committee
Vojnar Tomáš, prof. Ing., Ph.D. (DITS FIT BUT), předseda
Kořenek Jan, doc. Ing., Ph.D. (DCSY FIT BUT), člen
Peringer Petr, Dr. Ing. (DITS FIT BUT), člen
Ryšavý Ondřej, doc. Ing., Ph.D. (DIFS FIT BUT), člen
Citation
KLEM, Richard. Automatizované velkoobjemové zpracování testovacích výsledků. Brno, 2021. Bachelor's Thesis. Brno University of Technology, Faculty of Information Technology. 2021-06-15. Supervised by Hruška Tomáš. Available from: https://www.fit.vut.cz/study/thesis/24133/
BibTeX 
@bachelorsthesis{FITBT24133,
    author = "Richard Klem",
    type = "Bachelor's thesis",
    title = "Automatizovan\'{e} velkoobjemov\'{e} zpracov\'{a}n\'{i} testovac\'{i}ch v\'{y}sledk\r{u}",
    school = "Brno University of Technology, Faculty of Information Technology",
    year = 2021,
    location = "Brno, CZ",
    language = "czech",
    url = "https://www.fit.vut.cz/study/thesis/24133/"
}

Theses

Back to top