|
Operations and maintenance methodology of BI systems
Matiášek, Tomáš ; Pour, Jan (advisor) ; Zajíc, Ján (referee)
This diploma thesis is focused on operation and maintenance of BI systems based on Microsoft's SQL Server 2008 R2 platform. This work covers regular activities related to BI system management that means monitoring, performance tuning, maintenance, administration, backup and recovery tasks. System management is based mainly on SQL Server's native management tools along with Microsoft's applications System Center: Essentials and System Center: Data Protection Manager. The main goal of this work is to create BI system operations and maintenance methodology in cooperation with Clever Decision which is specialized in BI area. Partial goals are to design a way of monitoring components of BI system, including to outline backup and recovery posibilities, maintenance and performance tuning of the SQL Server platform. Each chapter contains methods, best practices, summary tables and appropriate tools which help DBA to achieve the specified goals. The main contribution of this work is operations and maintenance methodology created according to Clever Decision's needs. Among the other contributions of this thesis also belongs the definition of using tools for monitoring and maintenance and their relations to the SQL Server's components. The work also contains simple backup and performance tuning methodology for SQL Server. At least, this diploma thesis represents comprehensive material which is strictly focused on OLAP databases operation and maintenance.
|
| |
|
Nativní indexování rozsáhlých XML databází
Bartoš, Tomáš ; Pokorný, Jaroslav (referee) ; Skopal, Tomáš (advisor)
In the present work we study the indexing methods for large XML databases and their time efficiency when evaluating path queries. There are several ways of indexing XML data but we focus on indexing root- to-leaf paths and grouping them according to the common criteria, path labels. We study the existing methods and combine them in order to create the iXUPT, a novel native indexing concept using path templates, which leverages advantages of current approaches. We provide two variations of our solution depending on the way of handling ancestor-descendant relationships. The first one uses the proposed numbering scheme, while the second one relies on the Rho-Index structure. Furthermore, we prove the feasibility of our concept by the implemented prototype and by evaluating sample regular path expressions represented by XPath queries. We compare the variations between each other and also with other solutions.
|
|
SMV-2013-20: A module to measure optical frequency spectrum in the range of wavelengths 1300 – 1600 nm
Mikel, Břetislav
We realized a development of the module to measure optical frequency spectrum in the near field infra-red range of optical spectrum. A development of the module was started with research and preparing of the set-up of the measurement of optical frequency spectrum by tuned optical filter instead of optical spectrometer. Optical filter works like the optical selective element. It is possible to measure wavelength after calibration of the filter from the known driving signal. The method was checked and optimized to using by company NWG. We optimized especially range of the measured optical frequency spectrum, resolution and speed of the measurement.
|
|
Logistics assurance of production of wheel frames
DVOŘÁK, Jan
The main goal of my diploma was global analysis of the flow of material in production of wheel frames for train in company ČKD Kutná Hora a. s., foundry České Budějovice. I mainly aimed at mapping steps that are part of production of frames. The next part of my diploma work was to find the best solvent for flow of material in manufactured. For good result was used method of sighting, time recording and discussion with workers. I found the best posibility result. I resommended transporter of TRANSPORTA CHRUDIM company. I is one of real solvent. During the working on my diploma work I resulted from my own finding obtained by the consultations with executives and by the analyse of the documents which I had available.
|
|
Optimization of marketing communication of SKF CZ, a.s.
Zastoupilová, Cecílie ; Vávra, Oldřich (advisor) ; Hloušek, Miloslav (referee)
The content of this thesis is based on the marketing communication in B2B in engineering company SKF CZ, a.s. on the Czech market. First the theory regarding B2B marketing, evaluation of marketing communication, situation analysis and marketing research is introduced. It is followed by situation analysis of the company SKF CZ, a.s. using the 5C method, the description of marketing communication and evaluation of its effectivity based on primary and secondary data. The conclusion consists of appropriate allocation of investments in marketing budget on marketing communication tools and setting appropriate measures for creating the marketing dashboard, which will continuously monitor and evaluate the efficiency of SKF CZ marketing communication.
|
|
Concepts of Quality Management and their application in Tourism
Sysel, Jiří ; Indrová, Jarmila (advisor) ; Jakubíková, Dagmar (referee) ; Pražská, Lenka (referee) ; Konečná, Marie (referee)
This thesis deals with quality management concepts and their applications in the field of tourism services. The first part defines the basic concepts of quality issues and deals with the approach to its management development. It includes specifics of quality management in the Czech Republic and relationship of quality and competitiveness at the national and corporate levels. The next part is devoted to presentation of the main methods and concepts of quality management, from the simplest historic instruments over the methodologies of planning, optimization, evaluation, analysis and prevention of risks to the indication of the main international standards and models for complex their achievement and control. It is always commented on their suitability and possible links to tourism services, which are listed and defined in the thesis in the context of the main theoretical approaches to quality and its management in the field of services. The analytical part is devoted to analysis of approaches to quality in tourism and specifics of the national service quality systems in developed European countries (Spain, Switzerland and Germany). Their evaluation and comparison with the state of quality management in tourism in the Czech Republic is executed. Subsequently the merits of implementing a quality management system according to ISO 9001 in the hotel business is analyzed and evaluated. Data from the project TLT Benchmark of consulting company KPMG Czech Republic for the period 2009-2011 and data of selected tourism organizations are used. The final part of the paper presents a model solution to the National quality system of tourism services in the Czech Republic. This is based on comparisons and analyzes and presents its main components, namely the national quality standard, brand quality, and institutional security systems. The proposed model is the author's own solution based on theoretical knowledge and long experience in the field of tourism and quality management.
|
|
Global optimization of multiple variables functions
Vláčil, Stanislav ; Janda, Marcel (referee) ; Kloc, Petr (advisor)
Master’s thesis deals with numerical finding the global minimum. A theoretical part of project presents a problem of global optimization, her basic division and shows basic examples the specific problems of global optimization. Further, the reader is familiar with the basics of some numerical methods and with description of their strengths and weaknesses. A practical part shows concrete algorithm of global optimization, its use on data of specified function. Data refer to the issue of radiative heat transfer.
|
|
Antimicrobial peptides and their application into foods
Janhuba, Filip ; Petrik, Siniša (referee) ; Márová, Ivana (advisor)
The presented thesis is focused on a study of antimicrobial peptides and their potential applications into foods. Two types of antimicrobial peptides were studied in detail - bacteriocin nisin and antimicrobial enzyme lysozyme. In theoretical part an overview of antimicrobial peptides used in food industry was introduced. The experimental part of this work was focused on optimization of methods for the determination of antimicrobial peptides concentration. Commonly used spectrophotometric methods for quantitative analysis of total proteins as well as high performance liquid chromatography were tested. To determine the molecular weight and purity a modified SDS-PAGE with the addition of urea and tricine buffer was performed. Further, encapsulation of nisin into liposome was tested. Encapsulated particles were prepared by three different procedures: by ultrasonication, ethanol injection and TLE. Particles stability, distribution and size were studied by dynamic light scattering. Stability of encapsulated peptides in model conditions and model foods was studied too. Finally, antibacterial properties of the selected peptides using test system Bacillus subtilis were studied. Nisin already showed antimicrobial effect at low concentrations - about 1 µg/ml. The inhibitory effect of nisin was more evident in liquid cultures.
|
|
2-D simulations of electromigration processes
Kolivoška, Viliam ; Koval, Dušan (referee) ; Gaš, Bohuslav (advisor)
6 Abstract In the presented thesis we introduce a computational model that can be used for 2-D and 3-D computer simulations of experiments in electrophoresis. The simulations are carried out by the aid of the finite element method (FEM). In particular, commercially available program Comsol Multiphysics 3.3 is employed. A general shape of continuity equation is chosen to express the mass, electric charge, momentum and energy conservation law. Diffusion, migration and convection terms are taken into account when formulating the mass conservation law. Both external (driving voltage) and internal (diffusion currents) terms are considered in the electric charge conservation law. Both constant voltage mode and constant current mode can be handled. A solvent is regarded as an incompressible Newtonian fluid. Both pressure-driven and electroosmotic flows can be taken into consideration. The heat convection as well as the heat diffusion is governed by the energy conservation law. Both strong and weak electrolytes (of any attainable valency) may be regarded as system constituents. Furthermore, the model can handle the ionic strength correction if desired. A task may be assigned either in Cartesian or cylindrical coordinates. The presented model was employed to solve four particular tasks. The first one inspects the...
|
guest ::
