|
|
Designing a database and an application as a parametric web page for hotel owners
Menzel, Aleš ; Palovská, Helena (advisor) ; Chudán, David (referee)
This thesis consists of analysing database requirements, designing and creating a database for the needs of a reservation system and its corresponding parts. The purpose of this thesis is the practical implementation of the database and subsequently creating an application in the form of an administration interface, which is implemented in MySQL database platform and web technologies. Objective of the application is to provide complex system, which connects the parametric administration system with web pages in such a way, that the administrator of the application can manage the application from within the administration section. Requirements for this application and database are based on analysing the competitor's products and my own experience with creating a web application for a small pension. The goal is achieved by designing a flawless database and implementing the application. Furthermore the application proves and validates the database implementation by using test data. Main contribution of the thesis is completed application based on a high quality database model that is ready for deployment in practice. Structure of the thesis consists of two parts. First part describes theoretical basics that are important to know before designing a database and a short introduction to history of database models. The second part is dedicated to designing the database itself.
|
|
|
The selection of open-source database system for katalogue of parts
Čech, Miroslav ; Chlapek, Dušan (advisor) ; Palovská, Helena (referee)
The target of this thesis is choice of appropriate relation database management system for the specific application. Choice will be based on criteria formulated in this thesis. Thesis is divided to seven chapters beginning with Preamble, where will be specified the domain, targets and problems of contemporary state. In the second chapter the demands to the selected dbms (databse management system) and precise description of pre-selection and evaluation criteria will be set. This chapter is followed up with chapters Pre-selection and Measurement. There will be selected, which solutions will be measured, and will be descripted the methods. Next chapters will be Results and Selection, where the outputs of measurement will be presented and the selection will be done on basis of set criteria. Whole thesis will peak in Conclusion.
|
|
|
Database design for communication of a particular company with investors
Kaushik, Ondřej ; Palovská, Helena (advisor) ; Smýkal, Marek (referee)
The goal of this thesis is the analysis and design of a database for a particular company, which operates in the brokerage of investments. Company needs to cover its need for a structured storage of informations about investors. The main focus of this thesis is therefore accurate analysis of the current requirements of the company, identification of users and use cases of database applications. On these bases are created three models using the methodics "The principle of the three architectures (P3A)". The model reflects the anticipated use of the service applications and these are adapted to it. The resulting database is thus defined with the relevant restrictions and the entire database is ready to create for target DBMS (Microsoft SQL Sever 2008 R2) by using a SQL script. The functionality of the entire database is tested using test data.
|
|
|
Object-Relational Mapping with Framework Hibernate
Berger, Jan ; Pavlíčková, Jarmila (advisor) ; Palovská, Helena (referee)
The bachelor's thesis Object-Relational Mapping with Framework Hibernate is primarily concerned with the description of problems of data persistence of programs written in Java programming language in relational databases. The tool for implementing persistence is object-relational mapping. In the first part of the thesis a concept of object-relational mapping is defined and some problems of its implementing are described. Then an example application is introduced, on which framework Hibernate is demonstrated, followed by the description of structure and architecture of framework Hibernate. The second part of the thesis describes the philosophy and conditions for creating mapping metadata for the individual object structures, using XML and annotation notations. At the end of this part both notations are compared.
|
|
|
Comparison of relational database schema and XML structures
Vodňanský, Daniel ; Palovská, Helena (advisor) ; Řepa, Václav (referee)
The work deals with the relationship of the relational model and XML schema document and its technological and pragmatic aspects. It defines the theoretical field of data modeling at conceptual level and the two mentioned possible implementation models at the physical level. The aim is to answer the question when in the design and development of application or system it is appropriate to proceed with one of these models. Furthermore, this work also provides a general procedure for mapping conceptual schema into XML schema structures and solutions to problems that can come across during the mapping process. The problem is solved by analyzing two real issues - timetables of public transportation and the information system of a swimming school, formalized through a mechanism of predicate logic. Unlike most works on a similar topic this one varies in a pragmatic view on the problem - the concept of data, their origin, their target user and structuring.
|
|
|
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.
|
|
|
Analysis and proposal of marketing processes at the company AAA Auto
Gamazova, Ksenia ; Bruckner, Tomáš (advisor) ; Palovská, Helena (referee)
My thesis is focused on analysis and proposal of marketing processes in AAA AUTO company. Thesis starts with theoretical part, in which I describe various methods of development of information systems, provide examples of life cycle models and methods of modelling processes. In next part I provide theoretical introduction of marketing campaigns preparation. This part describes factors which influence a marketing campaigns success. Further follows practical part of this work, which begins with a brief description of AAA Auto company and its marketing department and goes on to processes analysis. The next chapter of practical part is devoted to proposal of the information system. In this chapter I describe requirements for information system and process models with the information system using.
|
|
|
Contributions of Cloud Computing in CRM Systems
Bobek, Pavel ; Bruckner, Tomáš (advisor) ; Palovská, Helena (referee)
This work deals with contributions of cloud computing to CRM. The main objective of this work is evaluation of cloud computing and its contributions to CRM systems and determining demands on cloud solution of CRM for trading company. The first chapter deals with CRM systems characteristics. The second chapter sums up qualities and opportunities of utilization of cloud computing. The third chapter describes demands on CRM systém with utilization of cloud computing for trading company that deals with mediation of financial products. The last, fourth chapter, sums up contributions of cloud computing in CRM systems.
|
|
|
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.
|
|
|
Oracle NoSQL database
Chlomek, Lukáš ; Palovská, Helena (advisor) ; Tomášková, Barbora (referee)
This thesis deals with the theme of NoSQL databases. The theoretical part describes, the reasons for the creation of this databases trend, their basic properties and the most widely used NoSQL data models. The practical part introduces readers with one representative of NoSQL key-value data model, Oracle NoSQL. Following is a sample of work with records of this database, using created test program. End of work includes a short practical demon-stration of manipulation with tables in the repository.
|
guest ::
