Thesis Details
Systém pro správu revizí záznamů databáze přepsaných matričních dat
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
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
@bachelorsthesis{FITBT24211, 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 = "https://www.fit.vut.cz/study/thesis/24211/" }