Informační systém pro správu účtů databázových systémů

Abstract

The motive for the creation of this work was to eliminate the shortcomings of the existing system for the administration of database accounts of the Department of Informatics and its modernization. These issues included moving the system database from SQLite to Microsoft SQL Server, adjusting the appearance of the web interface, changing the event logging system, and migrating to .Net Core. A new data layer was created, using the EF Core framework based on the original database. Working with linked database systems is now consolidated into individual modules that load during runtime, allowing them to be changed without shutting down the system. The new web interface is inspired by the original, but is completely redesigned with MVC, Bootstrap, JQuery, and DataTables. The whole system is fully localized for Czech and English. Logging in is handled by checking login data using the LDAP school directory server.