|
| |
|
|
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.
|
|
|
NNTP Server as a Windows Network Service
Loupanec, Josef ; Ráb, Jaroslav (referee) ; Očenášek, Pavel (advisor)
This work includes specification and analysis of requirements, design and implementation of the internet news server. The server controls newsgroups and associated news. It provides availability of the articles by NNTP protocol and HTTP protocol (by web interface). The server supports a user authentication and an optional proxy mode, when all NNTP requests are resent to another remote NNTP server. A mechanism that provides news-downloading from remote NNTP servers and performs distribution function is included too. The application is designed to run on MS Windows NT (and higher version) as a NT service. The server is configurable by a graphic user interface. The work also includes theoretical information needed for successful accomplishment of the above-mentioned requirements.
|
|
|
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.
|
|
|
Data collection from sensor units
Frkal, Pavel ; Verner, Lukáš (referee) ; Komosný, Dan (advisor)
This thesis deals with data collection from sensor units connected via 6LoWPAN standard (IEEE 802.15.4 standard), which uses simplified IPv6 protocol on the network layer. Featuring optimization makes this solution suitable for use in systems powered with chemical power supplies with a very low current consumption of both the sensor units and the control units. The thesis focuses on collecting data from sensor units that communicate on a star topology basis but it's also discussed possible usage of general topology, the end-station in such case works as active repeater and thus extend sensor network coverage without need of additional devices for wireless frames repeating or forwarding. It evaluates the realization of sensor networks created by both the actual data collection as well as specific technical parameters of used sensor boards. The practical part contains a specific application for gathering data from sensors present on the units and storing them in a relational database MySQL.
|
|
| |
|
|
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 ::
