|
|
Oracle Database Management System and Administration
Zapletal, Jakub ; Rydzi, Daniel (advisor) ; Studnička, Lumír (referee)
This bachelor thesis deals with the structure and administration of Oracle database. It tries to simply and clearly explain the proceses and architecture of which the database consists. Its aim is to explain the principle on which Oracle is based, and not only to describe how to install and administrate the database. Information has been gathered from my own experience and from the Oracle materials.
|
|
|
Access to data sources in Zend Framework.
Zikmund, Štěpán ; Pavlíček, Luboš (advisor) ; Hradecký, Radim (referee)
The purpose of this bachelor thesis is to give a description of architecture of access to data sources in Zend Framework and its creation based on design patterns described by Martin Fowler. The first part introduces the creation of fundamental components of architecture for access to data sources; there are four possibilities offered by Martin Fowler: Table Data Gateway, Row Data Gateway, Active Record and Data Mapper. The first part also describes the implementation in Zend Framework and selection of patterns Table Data Gateway and Row Data Gateway. The posibility of their cooperation with domain objects is also discussed. The second part is about extending the architecture's structure and behavior of its objects. Pattern Query Object and its likeness with class Zend_Db_Select follows. There is also presented Lazy load pattern and the posibility of its implemetation with Zend Framework and domain objects. Lastly, the implementation of Identity Map pattern is described.
|
|
|
Comparison of MySQL data storage environments
Vopička, Adam ; Chlapek, Dušan (advisor) ; Pavlíček, Luboš (referee)
The purpose of this bachelor's thesis is the description of data storing possibilities offered by the MySQL database management system. The first of four chapters describes the DBMS itself in general. The second chapter describes each data storing option, implemented by so-called storage engines. The engines are described both in general and according to determined criteria. The third chapter is dedicated to the questions of DBMS benchmarking, benchmarking tools and practical benchmarking. The last part describes the choice of storage engines for specific application types. The thesis should serve as a lead when considering MySQL as the DBMS for a specific application, as much of a guide when choosing the right data storage option.
|
|
| |
|
|
Analysis and development of IS/ICT solution for project Sanace dluhů in the Czech republic
Kaltoun, Jan ; Chlapek, Dušan (advisor) ; Komínek, Stanislav (referee)
This paper describes the analysis and development of IS/ICT for the project Sanace dluhů in the Czech republic which is being realised by The Association for Probation and Mediation in Justice in cooperation with Czech Probation and Mediation Service and Swiss association VEBO. The goal of this project was to design and realize the IS/ICT support for project Sanace dluhů. In order to meet this goal many activities had to be performed such as designing the architecture of the information system, programming the IASW and the creation of documentation and training of future users. The first part of this paper describes the process of choosing the methodology and continues with more detailed description of the chosen methodology and with the description of how the methodology was adapted to fit the project. In this part there are also mentioned the agile techniques and models used during the analysis. In the next chapter the author describes and documents the analysis of clients' requests and the present state. Following chapters describe among other topics the design of the final solution, selected topics dealing with the application development and with the process of delivery of the developed solution to end-users. This part of the paper also discusses the future possibilities of extending the application. Author's contribution lies in performing the activities specified by the chosen methodology and in presentation of their outputs. In the process of creation of this paper the author understood the project Sanace dluhů, thoroughly analysed the requests for its IS/ICT support, reacted on the changes in requests and created a product based on these requests that fulfills clients' vision. Author then put the product into operation considering both hardware and software and trained its users.
|
|
|
Database System shoice based on requirements of the IS/ICT project
Petřík, Tomáš ; Chlapek, Dušan (advisor) ; Chocholatý, Drahomír (referee)
Aim of this work is to make a methodic to support a decision which database system is the most suitable for the IS/ICT project. At first, some database systems are being described and it's being shown, how to compare their performance. Then there is a chapter about database migration and finally the chapter describing particular factors of making a decision which database system is the best option. Those factors are summarized at the end of a chapter. This work is based on resources literature and my experience during my studies and practice. I tried to describe a process which was, in my own opinion, the best eventuality to solve a problem to make a choice which database system is the most suitable.
|
|
|
Use of LINQ technology
Fexa, Marek ; Buchalcevová, Alena (advisor) ; Jelínek, Pavel (referee)
This work is focused at new Microsoft technology for querying data LINQ (Language intergrated query). It is built as complex technology, it allows working with various data sources. For example it contains collections of objects, created for temporary storing data in memory, but also data in robust database systems. In first part of this work I describe how data was queried before LINQ was on scene and what reasons made LINQ originate. Then I analyze new features in C# that were prerequisites for creating language integrated query as part of base libraries. Next part focuses at query operators, their interfaces and provides examples of use. Then I describe LINQ technology in complex, I create and describe in detail process of execution of LINQ query. Next chapter describes querying ADO.NET Datasets. Practical examples are created for both typed and untyped Datasets. In following chapter I analyze LINQ to SQL functionality. There is described method of implementation, mainly translation LINQ query to SQL language, integrated object rational mapping tool, change tracking in mapped objects including concurrency problems. At the end of the chapter I sketch the future in data access in ADO.NET entities. In last but one chapter is created complex application of use LINQ technology. Application is built as thin client that uses LINQ as for reading and manipulating data from relational database. In the application is LINQ also used common work with component that presents data. At the end part of this work is LINQ technology summarized. Contribution and pitfalls of LINQ technology are also described.
|
|
|
Approaches to consolidating data base and source code base of the Techno.cz webserver
Stankay, Michal ; Gála, Libor (advisor) ; Kafka, Daniel (referee)
In this diploma thesis, I conduct a research into approaches to consolidating data base and source code base of the Techno.cz webserver, which is the subject of the consolidation. By consolidation I mean bringing the server into the state where documentation is produced according to given requirements, data base is changed in order to improve data structure and consistency and source code base is reorganised in order to unify source code upon one platform, improve file system organization and remove problematic characteristics of the source code in general. The goals of this thesis are to create and describe general process of consolidation, sequence and contents of its steps; to describe contents of consolidation in given areas: documentation, data base and source code base; to describe actual steps made to achieve the final state of the server. My approach to accomplishing these goals is the study of relevant literature and usage of my practical experience in the field of web development. My contribution to the topic is the creation of the general consolidation process that has a potential to be reused by similar projects. Another contribution may be the description of handling the risks and problems that emerged during the consolidation process. This topic may find itself as a valuable source of knowledge for fellow developers facing similar issues. The thesis is divided into eight chapters. After the introduction chapter 2 follows. Chapter 2 describes parameters of the Techno.cz webserver. Chapter 3 discusses software engineering methodologies in order to create suitable consolidation process. Chapter 4, 5, 6 discuss particular fields of consolidation: documentation, data base and source code. In chapter 7 I am trying to assess suitability of created processes and approaches for usage in future development. In the conclusion I summarize the thesis according to required structure.
|
|
|
Data Security Audit
Vepřek, Petr ; Benešová, Vlasta (advisor) ; Novotný, Petr (referee)
Cílem práce je zpracovat vybrané okruhy související s ochranou a zabezpečením datové základny podniku a navrhnout metodiku pro provádění auditu systému bezpečnosti datové základny. Práce ozřejmuje význam a přínosy aktivní ochrany datové základny podniku, charakterizuje proces provádění analýzy rizik, diskutuje problematiku zálohování, archivace a obnovy datové základny a specifikuje nástroje a systémy eliminace ztrát, poškození a zneužití informací. V poslední kapitole je navrhnuta metodika zpracování auditu ochrany a zabezpečení datové základny a stručně popsána její aplikace v praxi.
|
|
|
The proposal of the optimal type of e-communication for the division of microscopes and industrial endoscopes of the Olympus company
Dobiášová, Olga ; Postler, Milan (advisor) ; Lukeš, Ivo (referee)
The graduatin thesis is devoted to implementation of the new model of e-communication for the division of microscopes and industrial endoscopes of the Olympus company. The first part includes theoretical essentials for the elaboration. The terms concerning marketing and commerial communications are explained in it, such as the differences between the purchasing process of the consumer and the companies, the topic of brand management is also mentioned and situation analysis and in the end general rules of comercial communications and e-marketing ale discussed.The aplication part describes the history of the Olympus company, its situation analysis and SWOT analysis of the division of microscopes,the procedure of creating the clients database, development of forms of the commercial notes sent and also the results of the first and second e-mailing realized. As the conclusion the recommendations to the future are indicated.
|
guest ::
