Thesis Details

Systém pro správu revizí záznamů databáze přepsaných matričních dat

Bachelor's Thesis Student: Gotzman Matěj Academic Year: 2021/2022 Supervisor: Kočí Radek, Ing., Ph.D.
English title
System for Managing Revisions of the Transcripted Registers Database

This work aims to create an extension of the existing system for managing master data (DEMoS) with the ability to manage record revisions. As part of the modifications, auxiliary tables, views and procedures were created in the database, which are used to store and manage the history of record changes. The created solution also contains a web interface showing the modifications made, including the time and the author of the change, as well as supporting the restoration of the record to one of the previous states. To facilitate the possible expansion of the database in the future, a script was created that automatically generates the MySQL code of implemented database controls for the specified original tables.


genealogy, registry book, transcription of registry records, DEMoS, revision control system, record state restoration, MySQL, Nette, PHP

Degree Programme
defended, grade B
16 June 2022
Kolář Dušan, doc. Dr. Ing. (DIFS FIT BUT), předseda
Chudý Peter, doc. Ing., Ph.D. MBA (DCGM FIT BUT), člen
Kekely Lukáš, Ing., Ph.D. (DCSY FIT BUT), člen
Lengál Ondřej, Ing., Ph.D. (DITS FIT BUT), člen
Rychlý Marek, RNDr., Ph.D. (DIFS FIT BUT), člen
GOTZMAN, Matěj. Systém pro správu revizí záznamů databáze přepsaných matričních dat. Brno, 2022. Bachelor's Thesis. Brno University of Technology, Faculty of Information Technology. 2022-06-16. Supervised by Kočí Radek. Available from:
    author = "Mat\v{e}j Gotzman",
    type = "Bachelor's thesis",
    title = "Syst\'{e}m pro spr\'{a}vu reviz\'{i} z\'{a}znam\r{u} datab\'{a}ze p\v{r}epsan\'{y}ch matri\v{c}n\'{i}ch dat",
    school = "Brno University of Technology, Faculty of Information Technology",
    year = 2022,
    location = "Brno, CZ",
    language = "czech",
    url = ""
Back to top