|
|
Proposal of SQL Database for a Drugstore Company
Zegzulka, Ivo ; Šťastníková, Adéla (referee) ; Kříž, Jiří (advisor)
This thesis deals with corporate database applications in SQL. The result should be applicable to business Iveta Šťastníková - production and distribution of toiletries, which is produced in dry goods. Primarily, should simplify operations such as stocking, invoicing, receipt and distribution of goods. First, we introduce the theoretical bases of work, and then move to the current state and the analysis itself. The result is a design solution that would meet the needs of the owner.
|
|
|
Database Version Management for Application Development in Eclipse
Palarczyk, Vít ; Šebek, Michal (referee) ; Burget, Radek (advisor)
This thesis deals with database version control for application development in Eclipse. In the theoretical part, it provides information about the Eclipse environment and its extension modules (plugins) that are an inseparable part of Eclipse. There is also a description of version control systems with a detailed focus on the Subversion system and a description of the JDBC application interface that is used for connecting the database in Java applications. The next part deals with the design of a tool for database version control, which is implemented as a plugin for Eclipse. In this section, there is a description of the implementation and a description of the installation and use of this tool. In the final part, there is a description of the performed tests and their results.
|
|
|
Comparison of Properties and Performance of Object Oriented Databases
Kozák, Daniel ; Burget, Radek (referee) ; Zelený, Jan (advisor)
In this thesis, the reader learns basic models, which are use for storing data in database sys- tems. Next I describe a way, how to store objects in Java Language and explain expressions like object-relational mapping, reflection and introspection. After that, I will introdice some of existing implementation, which are use for storing objects in Java. Next I will explain testing methodology and make benchmarks of various implementation. In the end I will analyze a results of these benchmarks.
|
|
|
NoSQL databases
Günzl, Richard ; Palovská, Helena (advisor) ; Strossa, Petr (referee)
This thesis deals with database systems referred to as NoSQL databases. In the second chapter, I explain basic terms and the theory of database systems. A short explanation is dedicated to database systems based on the relational data model and the SQL standardized query language. Chapter Three explains the concept and history of the NoSQL databases, and also presents database models, major features and the use of NoSQL databases in comparison with traditional database systems. In the fourth chapter I focus on the various representatives of NoSQL databases, in particular the ones that are most frequently used. In the next chapter, I have taken a practical look at a NoSQL database, specifically Apache Cassandra. I briefly describe the steps required to launch Apache Cassandra and its administration tools. In this practically-oriented chapter, I also show basic operations performed over a sample database using Cassandra CLI, its interactive command line interface. The purpose of this chapter is to make the reader familiar with the method of working with the Apache Cassandra database system and to point out some of its specific aspects. The primary objective of this thesis is to acquaint readers with the most important features and representatives of NoSQL databases and the potential for their practical use.
|
|
|
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.
|
|
| |
guest ::
