Sustav za automatiziranu administraciju relacijske baze podataka

master's thesis

• Title (english): System for automatized administration of relational databases
• Author: Josip Nimac
• Mentor: Ivica Botički (mentor)
• Committee member: Ivica Botički (predsjednik povjerenstva)
• Committee member: Marina Bagić Babac (član povjerenstva)
• Committee member: Boris Vrdoljak (član povjerenstva)
• Granter: University of Zagreb; Faculty of Electrical Engineering and Computing; Zagreb
• Defense date and country: 2021-07-14, Croatia
• Scientific / art field, discipline and subdiscipline: TECHNICAL SCIENCES; Computing

Abstract

Tema ovog diplomskog rada je razvoj sustava za pomoć pri administraciji relacijskih baza podataka. Sustav nudi grafičko web-sučelje u kojem administratori mogu upravljati podacima iz baza podataka bez korištenja upitnog jezika SQL. Funkcionalnosti uključuju čitanje, stvaranje, uređivanje i brisanje podataka. Svaka promjena podataka se bilježi te se cijela povijest promjena može na jedinstven način rekonstruirati. Dodatno sustav podržava rad s proizvoljno mnogo administratorskih uloga, od kojih svaka ima svoj skup dozvoljenih akcija. Poslužiteljski dio aplikacije razvijen je u okruženju Node, dok je za klijentski dio korištena biblioteka React. Metamodel produkcijske baze čuva se u SQLite bazi podataka koja se pakira izravno u programsko rješenje.

Abstract (english)

This thesis deals with the development of a system for the administration of data in relational databases. The system offers a web based graphical user interface for administrators for managing data in a database without the knowledge of SQL. Functionalities include the standard create, read, update and delete operations. Each change of data is logged, which allows for full reconstruction of the change history. Additionally, the system supports multiple administrative roles, with their own set of allowed actions. The server side was developed using the Node environment, while the client application was built with the help of React library. Metamodel of the production database is stored in the SQLite database engine, which is packet directly in the project solution.

• Keywords: metamodeliranje; relacijske baze podataka; administracija; web aplikacija; Node; React
• Keywords (english): metamodeling; relational databases; administration; web application; Node; React
• Language: croatian
• URN:NBN: urn:nbn:hr:168:400722
• Study programme: Title: Computing; Study programme type: university; Study level: graduate; Academic / professional title: magistar/magistra inženjer/inženjerka računarstva (magistar/magistra inženjer/inženjerka računarstva)
• Type of resource: Text
• File origin: Born digital
• Access conditions: Closed access
• Created on: 2023-01-13 13:19:54