The purpose of this master's thesis is to design and create system for company dealing with telephoning, which will simplify and automate the work of their employees as much as possible. System will meet the requirements on modern information system of telemarketing company and will be connected to telephone private branch exchange, from which it will be getting information about all phone calls including their voice records. The work is focused on usage of modern quality technologies and their integration into one system. First part of this work will closely describe requirements on this system and resulting creation of design. In the second part there will be presented used technologies and implementation of particular sections including configuration and connection with telephone private branch exchange. There will be also description of performance measurement process and resulting optimalization of critical sections in which high performance is required.

The diploma thesis deals with automated measurement of humidity and CO2 concentration inside buildings. Results of this measurement form the input parameters for the effective management of technologies reducing the energy performance of buildings. In the introduction, the issue of indoor air quality of buildings and indicators characterizing this quality are approached. The technical part of the thesis consists of making a measuring device which contains two prototype sensors provided by Teco Inc. with online access to measured data. The measurement of relative humidity, CO2 concentration and temperature in the interior of the building with the made device is compared with commercially available devices for measuring selected parameters. For unambiguous interpretation of online data, the virtual machine with an online database is configured for the created measuring device. The possibilities of using the prepared measuring device to achieve a reduction in the energy performance of buildings are discussed in the final part.

The aim of this thesis is to propose a way to implement the missing XML functionality for the database system PostgreSQL. The second chapter discusses the theoretical paradigm with an XML-related technologies like Xpath or XQuery. The third chapter discusses the ISO SQL standards and describes the current level of implementation of native XML databases, versus traditional relational databases. The last part focuses on different approaches and it proposes a solution to implement the XML API to PostgreSQL, which validates XML documents against XSD, DTD and RelaxNG schemes. Next point is focused on XML indexing techniques and proposal of new index based on GiST.

This thesis describes the problems of storage and management of biological data, particularly of Haloalkane Dehalogenase enzymes. Furthermore, the thesis aims at project HADES (HAloalkane DEhalogenase databaSe) initiated by protein engineering group of Loschmidt Laboratories, Masaryk University in Brno. This is a project whose main goal is simply to store, preserve and display a wide variety of proteins data. The result of this work is a flexible database system allowing easy extensibility and maintainability, which is built on technologies Apache, PostgreSQL and PHP using the Zend Framework.

This thesis focuses on a implemenation of a a temporal data support within traditional relational environment of PostgreSQL system. I pick up on Radek Jelínek's thesis and an extension developed by him. I've analyzed the extension from functional, practical and performance perspectives. Based on my results, I've designed and implemented changes to the original extension. The work also contains implementation details as well as performance comparison results between the new and the original extensions.

The goal of the master ́s thesis is to study index methods, spatial data type objects in PostgreSQL database systems and to create SP-GiST index by quadtree in the PostGIS. The PostGIS is spatial database, which extends of PostgreSQL. PostGIS adds support for geographic and spatial objects. It is a big benefit. PostGIS has its own data types, methods and GiST index too, but there is SP-GiST index missing, therefore master's thesis was created.

Over a few years back, REST APIs were considered standard web APIs, which nowhave a strong competitor. REST APIs provide some excellent features like stateless serversand structured access to resources. However, over time, it doesn’t offer flexibility withthe access of data and client changing requirements. In 2015 GraphQL was introduced byFacebook, which overcomes the problems with the REST and provides more flexibility andefficiency to the client requirements. For example, remove the over and under fetching.To change the existing APIs into GraphQL APIs require considerable time and effort.Therefore, some server implementation tools are developed to reduce the developmentcost and time. A few of these tools generate GraphQL schema and server implementationsautomatically over a legacy database.This master thesis studies tools that automatically generate GraphQL server implementationover legacy databases and evaluate such generated GraphQL server’s performance.First, we find some GraphQL server implementation tools such as Hasura andPostGraphile and then compare the server’s performance using benchmark methodology.Secondly, we run an experiment on a computer system and use the performance metricsfor assessment. The results of our experiment concluded that PostGraphile has higherthroughput and low query execution time as compared to Hasura. In most of the querytemplates from the benchmark, PostGraphile outperforms Hasura.

This masters thesis is dedicated to theme of multimodal databases, especially multimedia databases. The first part contains overview of today's most used data models. Next part summarizes information about content-based search in multimedia content and indexing this type of data. Final part is dedicated to implementation system for storing and managing of multimedia content based on Helix streaming system a PostgreSQL database system.

This thesis deals with the issue of preparation of final exams at the Faculty of Information Technology of Brno University of Technology. It describes the process of design and implementation of a web application that allows teachers to create and manage room schemes and terms of individual exams. An important part of the application is also the automatic placement of students in the rooms and the generation of individual exam assignments for printing based on the given template and the method of placement. The application provides students with a clear view of individual exam terms and details about them. The work will result in a functional and usable web application written in Java using the Spring and Angular frameworks.

The objective of this thesis was to study problems of an insufficient database processing performance and possibilities how to improve the performance with database configuration file optimizations, more powerful hardware and parallel processing. The master thesis contains a description of relational databases, storage media and different forms of parallelism with its use in database systems. There is a description of the developed software for testing database performance. The program was used for testing several database configuration files, various hardware, different database systems (PostgreSQL, Oracle) and advantages of parallel method "partitioning". Test reports and evaluation results are described at the end of the thesis.