|
Top-k querying over a relational databases: analysis and problems
Čech, Martin ; Pokorný, Jaroslav (advisor) ; Eckhardt, Alan (referee)
Due to increasing capacity of storage devices and speed of computer networks during last years, it is still more required to sort and search data effectively. Query result containing thousands of rows is usually useless and unreadable. In that situation, users may prefer to define constraints and sorting priorities in the query, and see only several top rows from the result. This thesis deals with top-k queries problems, extension of relational algebra by new operators and their implementation in database system. It focuses on optimization of operations join and sort. The thesis includes implementation and comparison of some algorithms in standalone .NET library NRank.
|
|
Database design for connecting SAP as a data source for a Web application
MARHOUN, Lukáš
The thesis deals with connecting SAP ERP system via local database system MS SQL Server using the tools SAP BI, data synchronization between systems and advanced usage of T-SQL language for preparing data for web applications and reports written in PHP. The thesis contains a brief overview of the SAP system and the possibility of connecting to the SAP system. The general principles of described solution can be used in conjunction with other systems and programming languages.
|
|
Design of an Information System Part
Liška, Michal ; Pivovar,, Jiří (referee) ; Neuwirth, Bernard (advisor)
The bachelor thesis focuses on solving the issue regarding enhancing the administration workflow effectiveness at the local election of the representatives. It goes the way of designing a part of the information system – the election application, created in the environment of the MS ACCESS 2013. The thesis is based on the database and information system theories and their use in a production environment. I have used the law normatives of the Czech republic for the organization and election processing based on the specific type of the local authority.
|
|
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.
|
| |
| |
| |
|
Design of System for Maintanance of Fires
Mešková, Lucia ; Podhorský, Peter (referee) ; Klusák, Aleš (advisor)
The aim of this thesis is to design a system for the purposes of registry of fires of the Fire and rescue department of the Slovak Republic. System should serve to members of the department for administration of records about all fires within the Žilina Region and it should work through the web interface. Emphasis will be placed on using frameworks with the aim to simplify the process of development of the system.
|
|
Photogrammetric data storage
Malásek, Jan ; Petyovský, Petr (referee) ; Babinec, Tomáš (advisor)
The Bachelor´s thesis gives us a view of computer vision development and its applications in a real world. It exists many typical tasks of computer vision. This thesis is focused on the scene description of picture information. It describes the most widely used types of relational databases, their advantages and disadvantages. The most important part of the work is a realization of application for photogrammetric data service. It is programmed in C# using Microsoft Visual Studio 2010. The application is based on a relational database system Microsoft SQL Server Compact Edition 3.5.
|
|
IS for School Registration in Africa
Mikulka, David ; Ráb, Jaroslav (referee) ; Kašpárek, Tomáš (advisor)
This document contains description of a design and implementation of an information system for school registration for project Adopce na dálku®. The information system audits the information about children whom school fees are paid form the project mentioned above. The information personal, about child's family, higienic condition, about sponsor and mainly the information about school, which are ranged especially to audit the information about school fees payment, are stored. Access to this application is hierarchic in compliance with rights of an individual users autentificated by password. The system allows to create new child's records and its editing, it can generate lists for printing in accordance with various criteria, too. The system is created for effective and synoptical management of information presented above.
|