|
|
RFID based attedance system design
Krejzek, Jakub ; Mašek, Petr (referee) ; Věchet, Stanislav (advisor)
This thesis describes the design of applications for attendance system. The first part describes today's modern applications and basic information about RFID technology. The second part deals with the design, of SQL database applications and own attendance system application. The last part describes the instructions and suggestions for possible improvements and expansion, which is described in the conclusion.
|
|
|
Industrial TwinCAT based diagnostics application
Zigo, Ľubomír ; Ondroušek, Vít (referee) ; Krejsa, Jiří (advisor)
This bachelor´s thesis describes designing of diagnostics application for press controlled by Beckhoff TwinCAT. Application monitors press regularly and informs staff in case of breakdown. Diagnostics application is created in high-level programming language Visual C++ in Microsoft Visual Studio environment. Application communicates with TwinCAT via .NET Framework library TwinCAT::Ads, which is part of TwinCAT. Breakdown texts are read from database via Microsoft OLE DB interface using SQL.
|
|
|
Applied analytics of Shared service centers
Budka, Marek ; Pour, Jan (advisor) ; Legát, Tomáš (referee)
This thesis focuses on the development and implementation of data analysis in an environment of shared service centers. The aim is the selection of analysis and its implementation from raw data to visualization of the results. The work is divided into two parts. The first part describes the shared services centers, their risks and benefits, and the process of data analysis, including a description and examples of visualization and data quality. The second part of the work describes the development of selected analysis. We chose the analysis of vendor master file. We perform anonymization of production raw data using IBM SPSS Modeler. We are completing this process in Microsoft SQL Server Management Studio, where we are continuing with the development of analysis logic and finally assembling dashboards in Tableau visualization program.
|
|
|
Comparison of in-memory database systems
Cabalka, Martin ; Chlapek, Dušan (advisor) ; Palovská, Helena (referee)
The aim of this thesis is to analyze basic technological principles of in-memory database systems, followed by a market research and selection of the products, which will be submitted to the qualitative comparison in a number of proposed criteria. Afterwards, there will be also explored the possibility of a performance measuring through the implementation of TPC-C benchmark, created at University of economics in Prague. In the introduction are outlined the circumstances and advantages, which support one of actual trends in database systems -- in-memory database systems. In the third chapter are described the most usual models of present database systems. This is followed by a next chapter, where are described technological principles of in-memory database systems. In chapter five are compared advantages and disadvantages of disc and in-memory systems and subsequently, the most common myths about in-memory databases are disproved. In a next part the in-memory database market is analyzed and criterions for choosing compared products are defined. Those products are subsequently compared, according to criterions defined in a chapter nine. In the last part is analyzed a possibility of a performance comparison of chosen products through the selected implementation of TPC-C benchmark. The most important outcome of this thesis is a complex analyze of in-memory database systems. Both from theoretical point of view, as well as from practical testing of chosen systems from proposed criterions.
|
|
|
Complex database solution design for Gemini ophtalmology clinic
Kadlec, Jakub ; Palovská, Helena (advisor) ; Sramka, Martin (referee)
The aim of this bachelor thesis is to provide a complex analysis and database solution design for Gemini ophtalmology clinic in Zlín, Czech Republic. The clinic handles a large amount of data on a daily basis being used by doctors, administrative workers, but as an essential background dataset by robotic surgical machines as well. Currently, the data is being transmitted via physical data files, which inevitably goes with a big probability of subjective errors and data redundancy. The analysis has been based on multiple interviews with Gemini's IT personnel and the models are result of throughout research of clinic's business and information processes. At the beginning of the thesis, there is a theoretical introduction to database analysis and design, followed by a complex database solution design, including features from object-relational database systems which can be helpful considering that the database will be connected to the robotic surgical machines. Their programmatic interface is written in C#, which is an object oriented language, and the thesis describes ways how object features in otherwise fully relational database can result in easier and more straightforward data manipulation. As a result, this bachelor thesis could serve as an inspiration in modernizing technology infrastructure design in a field which is very conservative and is adapting modern approach very slowly.
|
|
|
Data processing library using SQL queries
Sýkora, Jan ; Pecinovský, Rudolf (advisor) ; Oraný, Vladimír (referee)
Eighth version of programming language Java brought broad variety of changes, which strongly incline to declarative style of programming. In my thesis I have focused on using these changes in declarative ways of data processing on Java platform. I have decided on using Structured Query Language due to its declarativity Topic of my thesis was to create a library, which could interpret SQL queries. For interpretation, my library uses Streams and many other concepts which allow functional style of programming in Java. The most significant benefit of this library was giving alternative to programmers, who are looking for ways, how process data in application layer rather than on persistent layer.
|
|
|
Comparison of the best-known database systems
Fábera, Luboš ; Krejčová, Iva (advisor) ; Přibil, Jiří (referee)
The main aim of my thesis was to perform a high-level comparison of the selected database systems from the perspective of commonly perceived factors.The comparison has been made from the technological standpoint, the hardware requirements view, security and high availability. Factors like scalability, support for analytic tools and third party integration options as well as general usability have been included as well. The actual finance and budgeting piece generally defining the actual products are also part of the thesis. As the paper shows, it is not possible to generalize and select "the best" database system as those are defined by their properties specifically tailored for a defined set of use cases. The actual strengths and weakness of the products are however easy to pinpoint and are described. It remains clear that each implementation should included a detailed analytic part which directly maps the customer's requirements and is able to provide required information for the product selection in the later phases of the project.
|
|
| |
|
|
Evaluating of SLA in HP Quality Center
Doubrava, Jan ; Pour, Jan (advisor) ; Vacek, Martin (referee)
The objective of this thesis is to propose and describe the database, which enables to measure compliance of Service Level Agreement suppliers of software applications that work with HP Quality Center. The work describes specific solution used in project to implement a new core business system, describes requirements for functionality and use of result the solution. Briefly described is also HP Quality Center, the testing tool, from which are taken the input data and what possibility offers for monitoring the SLA. The proposed database allows calculation of the time which is actually spent by suppliers on solving the errors and comparison of calculated time with the defined SLA. It will also describe how to import data into the database and the basic reports, which are usable after implementation of the proposed solution.
|
|
|
Using the SAS System for Building Data Warehouses and Optimalization of ETL Processes
Pešička, Michal ; Novotný, Ota (advisor)
This diploma thesis deals with usability of the SAS system and its components for building and running data warehouse and complete solution of Business Intelligence. In the beginning it introduces the meaning and benefits of putting on Business Intelligence and its spot in an organization. It especially focuses on the running BI project in Kooperativa, a.s., insurance company. The main goal of this thesis is to aim on ETL processes of data warehouse, their specificity, characteristics and regular tasks solved across data layers, measuring their performance and feasibility of ETL optimalization. This optimalization can be considered from two different points of view – the first is a creation and maintenance of the ETL source code, the second is tuning for faster data processing. Log files, which are are the main source for performance monitoring, are processed by macroprogram specially tailored to this particular reason. Gained results are analyzed and on that basis I outline spots that need attention. The last part offers comparison of some alternatives to data transformation process typically solved by ETL tasks. Acquired results could be taken as hints used in designing and tweaking other akin ETL processes.
|
guest ::
