|
|
Comparison of distributed "NoSQL" databases with focus on performance and scalability
Vrbík, Tomáš ; Šlajchrt, Zbyněk (advisor) ; Pavlíček, Luboš (referee)
This paper focuses on NoSQL database systems. These systems currently serve rather as supplement than replacement of relational database systems. The aim of this paper is to compare 4 selected NoSQL database systems (MongoDB, Apache Cassandra, Apache HBase and Redis) with a main focus on performance and scalability. Performance comparison is done using simulated workload in a 4 nodes cluster environment. One relational SQL database is also benchmarked to provide comparison between classic and modern way of maintaining structured data. As the result of comparison I found out that none of these database systems can be labeled as "the best" as each of the compared systems is suitable for different production deployment.
|
|
|
Implementation of a test for comparison of database systems' performance
Matějka, Martin ; Chlapek, Dušan (advisor) ; Kaltoun, Jan (referee)
The aim of this thesis is to create a program, which will be able to perform a performance testing of relational database systems supporting query language SQL with an emphasis on open source systems. The test should simulate a real usage of tested database systems. In the introduction is shown the necessity of such program (which is supported by the analysis of existing theses and programs in the second chapter) and the fact, that it is convenient to base the test on the TPC-C as a standard for this type of testing in the proprietary sphere, so all the given requirements could be met. The third chapter gives insights into the history of transactional testing and what were the circumstances of the formation of Transaction Processing Performance Council, which authored the TPC-C specification. The main characteristics of TPC-C are decribed in the following chapter, while the fifth one addresses the implementation, i.e. the creation of the program, which can be used for testing of database systems. The sixth chapter deals with the usage of this program for the comparation of two well known open source database systems in their default configuration - MySQL and PostgreSQL. However, the goal of this testing is to find out whether the created program is fully functional, while the seventh chapter elaborates more on this. The most important outcome of this thesis is a program, which can be used for comparation of real-usage-like performance of (not only) open source relational database systems. This program is an open source, which increases its value since a user has a possibility to find out exactly what is tested and how it is done. Furthermore, it supports the future development of this program. Another outcome of the thesis is the comparation of two open source database systems.
|
|
|
Design and Implementation of an entertainment web portal
Lorenc, Ján ; Žamberský, Martin (advisor) ; Zimák, Radek (referee)
The work focuses on the design, development and implementation of a web entertainment portal. The main objective of this work is to create an application that will meet the required functionality using appropriate technologies. Defining the desired functionality as well as the selection of appropriate technology is part of corresponding chapters. As the selected and then used technology was chosen server-side programming language PHP in conjunction with the MySQL database system. The application is a web portal based on Zend framework application that is practical implementation of the MVC architecture. As the client-side programming language was chosen JavaScript, together with a freely available library jQuery that simplifies and streamlines work with the language. The thesis then describes the design data model, which forms the basis for future application. The following chapter describes the structure of each system and relations between them. The conclusion is devoted to consideration of whether the fulfillment of the objectives, benefits and work output.
|
|
| |
|
| |
|
| |
|
| |
|
| |
|
| |
|
| |
guest ::
