With Spectre and Meltdown out in the public, a rushed effort was made to patch these vulnerabilities by operating system vendors. However, with the mitigations against said vulnerabilities there will be some form of performance impact. This study aims to find out how much of an impact the software mitigations against Spectre and Meltdown have on database management systems during an online transaction processing workload. An experiment was carried out to evaluate two popular open-source database management systems and see how they were affected before and after the software mitigations against Spectre and Meltdown was applied. The study found that there is an average of 4-5% impact on the performance when the software mitigations is applied. The study also compared the two database management systems with each other and found that PostgreSQL can have a reduced performance of about 27% when both a hypervisor and the operating system is patched against Spectre and Meltdown. / När Spectre och Meltdown tillkännagavs gjordes en snabb insats för att korrigera dessa sårbarheter av operativsystemleverantörer. Men med mildringarna mot dessa sårbarheter kommer det att finnas någon form av prestationspåverkan. Denna studie syftar till att ta reda på hur mycket av en påverkan uppdateringarna mot Spectre och Meltdown har på databashanteringssystem under en online-transaktionsbehandlings arbetsbelastning. Ett experiment gjordes för att utvärdera två populära databashanteringssystem baserad på fri mjukvara och se hur de påverkades före och efter att uppdateringarna mot Spectre och Meltdown applicerats i en Linux maskin. Studien fann att det i genomsnitt är 4–5% påverkan på prestandan när uppdateringarna tillämpas. Studien jämförde också de två databashanteringssystemen med varandra och fann att PostgreSQL kan ha en reducerad prestanda på cirka 27% när både det virtuella maskinhanteringssystemet och operativsystemet är uppdaterad mot Spectre och Meltdown.

Denna kandidatuppsats berör databaser i javabaserade bildhanteringssystem där bilderna lagras och hämtas som binära objekt. I MySQL och en del andra databashanterare kallas detta format för Blob(Binary large object). För att bildhanteringssystemet skall fungera bra krävs det att man använder en snabb databas. Syftet har varit att av ett urval databaser utse den databas som är snabbast i avseende på svarstider för hämtning av bilder som lagras som binära objekt i databaser. Databaserna är de fyra välkända databashanterarna MySQL, MariaDB, PostGreSQL och MongoDB. Testerna har utförts med databaserna integrerade i Javabaserade klient-server moduler för att så mycket som möjligt spegla de villkor som förekommer i ett bildhanteringssystem. De testverktyg som har använts är JMeter som är en avancerad applikation för mätning av svarstider och PerfMon som övervakar åtgång av systemresurser. MongoDB var den snabbaste bilddatabasen men det finns många osäkerhetsfaktorer som måste beaktas vilket också beskrivs i denna kandidatuppsats. Trots att många åtgärder för att motverka osäkerhetsfaktorerna har gjorts, förblir mätosäkerheten stor. Mer åtgärder för att isolera databasernas del av svarstiderna i ett klient-server system måste göras. Förslag på åtgärder redogörs i denna kandidatuppsats. / This bachelor thesis concerns databases in Java-based imaging system where the images are stored and retrieved as binary objects. In MySQL and in some other database management systems this format is called Blob (Binary Large Object). For the imaging system to work well, it is necessary to use a fast database. The aim has been that out of a sample of databases designate the database that is the fastest in terms of response times for downloading images stored as binary objects in databases. The databases are the four well-known database management systems MySQL, MariaDB, PostgreSQL and MongoDB. The tests have been conducted with the databases integrated into Java-based client-server modules in order to as much as possible mirror the conditions prevailing in an imaging system. The test tool that has been used is JMeter which is an advanced application for measuring response times and PerfMon to monitor the consumption of system resources. MongoDB was the fastest image database, but there are many uncertainties that must be considered, which is also explained in this bachelor thesis. Although many measures to counter the uncertainties have been made, the measurement uncertainty remains big. Further measures to isolate the database part of the response times in a client-server system must be made. Proposed measures are described in this bachelor thesis.

This diploma thesis deals with the research of existing solutions of electronic information systems. The purpose of this survey is to inspire what is offered to users of these professional systems, or what users expect from these systems. Based on the acquired knowledge, the thesis also deals with the design of its own system, which can serve as another alternative to professional solutions of companies on the market, in the sense of the concept of solution of the given task. After the design of the system, the thesis deals chronologically with the selected "tools" used for the actual implementation of the assigned task Electronic Information Boards. Both hardware and software parts of the task, which form the majority of this thesis. At the end of the work are presented practical results.

The goal of this thesis is to create control software for stand-alone payment machines. The purpose of this software is minimize maintenance cost and usability as much as possible. Description of technologies and protocols used in implementation are in the text. Next, there is process of work beginning with analysis, continues with design, construction, testing and installation manual. Projekt status and product utilization at the end of project is in chapter about evaluation.

This thesis describes design and creation of application which collects and values telemetry data. Thesis consist of design and implementation which describes whole system, server settings as well as approach how to consume any given data. Corner stone of this application is based on given data from telemetry station (sensors) and projecting them on the map background. Application consist of user interface and logic how to project any given data into the map. Graphics interface is created using HTML, JavaScript and CSS programming languages. Logic itself is programmed by using backend language PHP including Laravel Framework in combination with MySQL database. Result of this thesis is working implementation covering administration user interface, working cooperation of MQTT server and APIs. There are also implemented all necessary parts for enablement of user interface with cooperation with map background layer. Implementation creates two possible ways how to install package necessary to run this app on Ubuntu system.

Databases are used extensively for websites and a large amount of websites are built upon Wordpress. Wordpress uses MySQL compatible databases and for many larger websites itcan be imperative to have the best possible performance. Recently, NewSQL databases have been appearing that combine the features of NoSQL databases with SQL compatibility and ACID compliance that is usually not found in NoSQL databases. Due to their recency, thereis a knowledge gap in the literature regarding NewSQL databases. Therefore, this work compares the performance of the NewSQL database TiDB against the SQL database MariaDB in a performance benchmark. The benchmark includes three testing approaches with an aim of testing multiple performance aspects. These include load testing, complex queries and performance in a realistic environment. Results from this thesis show that TiDB achieves better average response time for complex queries and in load testing where the databases and load is large but gets worse results for simple queries and small datasets. MariaDB performs better when used with a web server andwith tests that involve write-operations.

This independent work includes refactoring a website application. In simpler sense, it means modernizing existing code by increasing its quality and making it more understandable; to exchange old knowledge of methods and concepts into something that is more relevant to its time. This refactoring has also meant to transform the UI into something that is more appealing, and more userfriendly. The website that has gone through the refactoring is Nordyr (”https://nordyr.com/”). Nordyr is a Nordic Film & Series Database that shares information about Nordic films and tv-series, and everyone involved. They also offer social tools such as user profiles and various tools to simplify the exploration and interaction between Nordic movies and consumers. This was made possible by using vanilla PHP, JavaScript/jQuery, and the MariaDB database for information storage and management. The implementation of the refactoring meant retaining PHP for the backend, but applying the Laravel framework, and likewise for JavaScript, but applying ReactJS (a powerful JavaScript library). Nordyr retains MariaDB for its information storage and management, however, its SQL queries have been adapted to Laravel’s query-builder and Eloquent ORM, which means that the majority of SQL queries have been rewritten and the majority of data tables are now represented by models. The restructuring of Nordyr has shown that the website now has the ability to scale better, and the development environment will also be more pleasant for those involved. / Det här självständiga arbetet har innefattat att omstrukturera en hemsida. Det innebär i enklare mening att modernisera kod och öka dess kvalité; att byta ut äldre kunskaper om metoder och koncept till något som anses vara av mer relevans för sin tid. Refaktoreringen har också inneburit att dess UI gjorts om till att bli mer tilltalande och användarvänlig. Hemsidan som gått igenom refaktoreringen är Nordyr (”https://nordyr.com/”). Nordyr är en Nordisk Film- & Serie-databas som delar information om nordiska filmer och tv-serier och alla inblandade. De erbjuder även sociala verktyg som användarprofiler och diverse verktyg för att förenkla upptäckandet och interaktionen mellan nordiska titlar och konsumenter. Detta gjordes möjligt med hjälp av vanilj PHP, JavaScript/jQuery, och databasen MariaDB för informationslagring och hantering. Genomförandet av refaktoreringen innebar att behålla PHP för backend men tillämpa ramverket Laravel, och likaså för frontend, JavaScript stod kvar men ReactJS (”JavaScript bibliotek”) tillämpades. Nordyr behåller MariaDB, men dess förfrågningar i SQL har anpassats till Laravels query-builder och Eloquent ORM, vilket innebar att majoriteten av SQL frågor skrivits om och majoriteten av tabeller representeras nu av modeller (”Models”). Omstruktureringen av Nordyr har visat på att hemsidan nu har förmågan att skala bättre, och utvecklingsmiljön kommer även bli mer behaglig för de inblandade.

This thesis is based on measuring how Relational Database Management Systems utilizing data-at-rest encryption with varying AES key lengths impact the performance in terms of transaction throughput of operations through the process of a controlled experiment. By measuring the effect through a series of load tests followed by statistical analysis, the impact of adopting a specific data-at-rest encryption algorithm could be displayed. The results gathered from this experiment were measured regarding the average transactional throughput of SQL operations. An OLTP workload in the benchmarking tool HammerDB was used to generate a transactional workload. This, in turn, was used to perform load tests on SQL databases encrypted with different AES-key lengths. The data gathered from these tests then underwent statistical analysis to either keep or reject the stated hypotheses. The statistical analysis performed on the different versions of the AES-algorithm showed no significant difference in terms of transaction throughput concerning the results gathered from the load tests on MariaDB. However, statistically, significant differences are proven to exist when running the same tests on MySQL. These results answered our research question, "Is there a significant difference in transaction throughput between the AES-128, AES-192, and AES-256 algorithms used to encrypt data-at-rest in MySQL and MariaDB?". The conclusion is that the statistical evidence suggests a significant difference in transactional throughput between AES algorithms in MySQL but not in MariaDB. This conclusion led us to investigate further transactional database performance between MySQL and MariaDB, where a specific type of transaction is measured to determine if there was a difference in performance between the databases themselves using the same encryption algorithm. The statistical evidence confirmed that MariaDB vastly outperformed MySQL in transactional throughput.

No description available.

The aim of this thesis is the analysis, design and implementation of a data bridge between the information system of the company Sledovanitv.cz, s.r.o. and the economic system. The first part describes the objectives of the project. The theoretical part provides the necessary foundation for the implementation and, in addition to the theoretical background of information systems as a whole it presents and describes the technologies used for the execution of the implementation. The needs and requirements for future expansion are determined based on the analysis of the current situation. The practical part introduces a proposed solution, the method and procedure of implementation. In the final part, the author gives an assessment of the practical and economic benefits of the project.