|
| |
|
|
Comparison of Databases Systems for the Registers Digitalization
Rešovský, Martin ; Rozman, Jaroslav (referee) ; Kočí, Radek (advisor)
This paper presents comparative analysis of relational and object-based database systems over firmly specified data set gathered by registers digitalization of wedding and death records. Data were processed by chosen representants of theirs categories Db4o and PostgreSQL. Data model was created and described for both databases. Evaluation was made on the base of comparison of theoretical foundations, implementation and results of performance tests of the databases on test dataset equivalent to original sample. By carried out research, we found out, that relational model has stronger theoretical foundations, much better support and administration, and is more efficient. On the other hand, object-based approach models database much more naturally and preced construction complications. Main result is, that relational database model appears to be more efficient and preferable, and therefore, with gained knowledge, we can state, that it has better preconditions for effective processing of death and wedding historic records.
|
|
|
Database Performance Tuning
Paulíček, Martin ; Ruttkay, Ladislav (referee) ; Chmelař, Petr (advisor)
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.
|
|
|
Insurance agents personal database system
Bumbala, Ondřej ; Tröster, František (referee) ; Weirich, Pavel (advisor)
Thesis deals with design of database and administrative system used by insurance salesmen to administer contracts and analyse financial situation. Thesis contains analyse of possible solutions and choice of the most efficient one. Thesis describes abilities of working in symfony PHP framework and own plan of work on application.
|
|
|
A Tool for Database Content Analysis for Testing Purposes
Kropáč, František ; Šimková, Hana (referee) ; Smrčka, Aleš (advisor)
Acceptance testing of applications before the production includes testing of scenarios resembling situations of real usage of the application. Creating the test data is complicated matter since the data are specified by restrictions concerning the domain of the tested application and the specifications of the structural restrictions and the relations between these data. This thesis focuses on the issues of detecting the data constraints in an already created relational database. The outcome of the thesis is a tool which automatically controls and mediates the detection of the data constraints in a relational database. The detection result is a weight rating of the data restrictions, which represents both the data type and the relation between tables, columns in relational database. These restrictions can be used to generate a random testing data which would represent inputs for seemingly realistic scenarios of the usage of the application.
|
|
|
Comparison of Relation and Document Database Systems
Pakes, Marek ; Rozman, Jaroslav (referee) ; Kočí, Radek (advisor)
The purpose of this thesis is to compare relational and document-oriented database systems for use in genealogy field. PostgreSQL and MongoDB database systems were used in pursuance of the comparison. The systems are compared according to vital records of marriage and death certificates. Testing data set is generated and filled in the databases by an own implementation of a Node.js script.
|
|
|
A File System Implementing Storage for Gentoo Portage Based on a Relational Database
Štulpa, Adam ; Mlích, Jozef (referee) ; Rychlý, Marek (advisor)
The thesis deals with implementation of a program which can, through the use of FUSE library, make data accessible in the relational database like the classical Gentoo Portage storage. First, the reader of the thesis becomes familiar with FUSE library itself. After that, the new data model is built based on the analysis of the Portage structure. The new model emphasizes especially dependencies of packages. The key implementation issues are also described in the next part. Finally, the thesis assesses outcomes achieved including comparison with standard Portage implementation and classical file system. The other possibilities of the project development are considered as well.
|
|
|
Design of a Football Association System for Administration Purposes
Vařacha, Jan ; Vyskočil,, Marek (referee) ; Luhan, Jan (advisor)
This master’s thesis aims to design a suitable system based on a relational database for the purposes of administrative activities of the District Football Association. The created relational database should be managed primarily by the association secretary, to a lesser extent by members of association specialist committees. The database should be able to contain all the information and records which have been dealing with the paper form so far (match fixtures, awarding fines, clubs’ fees, players’ punishments, etc.). Routine administrative work, such as reading, inserting, deleting and updating the data will be carried out through the web interface and should not place any special demands on the level of users computer skills.
|
|
|
Application Database Layer Generator
Kuboš, Jaroslav ; Rychlý, Marek (referee) ; Burget, Radek (advisor)
This diploma thesis deals with the design and implementation of a framework for the database persistence layer development. This framework is easy to use while keeping the code elegance. It supports object oriented programming features such as inheritance and collections. Other features include versioning of objects and lazy loading. The object metadata are obtained through reflection provided by the .NET framework. The framework is not using any literal for identification (classes, attributes) even in object queries. Most of checks are done by compiler.
|
|
| |
guest ::
