In order for a modern society to function properly it has to be able to efficiently process increasing amounts of data. To this end, numerous database models have been designed, the most popular of which is still the relational model. Many database systems have been developed in order to manage it. The aim of the diploma thesis is to select and evaluate some of the more popular open source database management systems and give an opinion on their suitability for storing and processing data in a given situation, which may, among other things, require its rapid responsiveness, security, spatial efficiency, etc. The selected systems are MySQL, MariaDB and due to the increasing popularity of portable devices also SQLite. Due to the increasing prevalence of non-relational data model, theoretical part will present extensions that enable the mentioned systems to process non-relationally organized data. In addition, through supported drives, various methods that allow database systems to handle large, high traffic databases will also be presented. Due to security being a topical issue the thesis will also contain an analysis of the available mechanisms used to ensure the security and anonymity of stored data. The data obtained and the findings of the theoretical work will be based mainly on existing documentation of data systems, existing legislation on data protection and other scientific literature. In the practical part of the thesis, speed tests of the selected systems will be performed on the basis of pre-prepared scenarios on a test database. Finally, a final conclusion will be given with the aim to give a better idea of the selected data systems and to help data managers in selecting the most appropriate system for a particular problem.
|
