|
|
Comparison of the possibilities of object-oriented and relational databases
Šolar, Tomáš ; Palovská, Helena (advisor) ; Pavlíčková, Jarmila (referee)
This thesis presents the theoretical description of relational and object-oriented databases, including the underlying basic concepts. The paper briefly describes the specific database systems according to various categories. Work tries to look at all the facts in general terms therefore does part of it explain other database principles. On the example of a small library the paper displays the strengths and weaknesses of both principles. Later the paper describes more thoroughly the Caché database system, which can be addressed by both principles. The difference between object and relational approach is then shown in this environment. The goal is therefore to provide side information about the various principles, define the differences in categories and then show the problems on a practical example. Further clarify the specific database system and try to demonstrate the previously defined categories in this environment. One's own contribution to the treated subject can be found in different approaches of the specific models, the comparison of the two approaches on particular examples, the examination of the selected database system and conducting a comparison of the principles in the Caché environment.
|
|
|
Impact of partitioning on the performance of Oracle database
Řeháček, Tomáš ; Macák, Petr (advisor) ; Palovská, Helena (referee)
The main aim of this bachelor thesis is to provide information about how to use partitioning in an Oracle database and to determine its effect on change in performance during database load. Description of this additional functionality and proposal appropriate testing environment in which it is possible to make measurements were necessary in order to achieve the main goal. The contribution is in the recommendations that can be drawn on the basis of the values obtained during tests performed. The thesis examines general options of partitioning, benefits and costs that are associated with its use, application partitioning methods and management capabilities. Tests are conducted on a large number of scenarios in the practical part. Conclusions, recommendation and suitable conditions for use of partitioning are based on tests.
|
|
|
Examination and measuring of Oracle database system b-tree index inefficiency
Klepetko, Vítězslav ; Macák, Petr (advisor) ; Palovská, Helena (referee)
This thesis describes the Oracle database b-tree index and compares it to the concept of a b-tree as a graph theory structure. It analyses main factors causing inefficiency in b-tree index which emerge during DML queries execution. It shows to what extent the inefficiency manifests and describes ways of dealing with it. For the purpose of index mechanism analysis a method called block dumping is used. The level of inefficiency is determined by measuring queries duartion in a database created for that purpose. Inner fragmentation of index database block, segment fragmentation and high value of clustering factor are identified as main inefficiency-causing factors.
|
|
|
Object-relational mapping in PHP
Vrchota, Michal ; Pavlíček, Luboš (advisor) ; Palovská, Helena (referee)
Objective of this document is to provide a view for mapping an object model into relational database. This work is divided into two main sections. The first one describes theory of object-relational mapping and used design patterns targeting on patterns for object model representation and inheritance. The second part is devoted to description of object relational mapping in PHP language and focuses on usage of libraries Zend_Db and Doctrine. It is illustrated the basic work with those libraries and reasons for deployment in real application are explained as well. The contribution of this work is a brief explanation of object-relational mapping problematic and its implementation in PHP applications using ORM libraries.
|
|
|
Database design: Community discussion board
Klepetko, Radim ; Palovská, Helena (advisor) ; Klas, Jan (referee)
The goal of this thesis is designing a database for discussion board application, which will be able to provide classic discussion board functionality and web 2.0 features in addition. The emphasis lies on a precise description of the application requirements, which are used afterwards to design an optimal database model independent from technological implementations (chosen database system). In the end of my thesis the database design is tested using MySQL database system.
|
|
|
The design of database for hotels and guest houses
Vojtek, Michal ; Palovská, Helena (advisor) ; Strossa, Petr (referee)
This bachelor's thesis presents an analysis, design and implementation of a database solution for hotels and guest houses. The main objective of the thesis is to design an efficient database solution covering the functionality of booking, online access, invoicing and complaints systems. It is a comprehensive database solution providing information support both in normal operation and for management work. The secondary objectives can be defined as methods of using the database and the identification of the database user. The thesis has been prepared based on my own experience. The first part of the thesis introduces the systems using the database; this does not refer to any specific applications but only to generally defined systems for which the thesis outlines a potential use for the database. The second part deals with the possibilities offered by the database for specific persons who come in contact with this database. The third part describes a conceptual data model, explaining all its entities and relationships and clarifying the use of integrity constraints. The fourth part introduces another integrity constraint and analyses a database adjustment for RDBMS Oracle Database Express Edition 10g, in which the functionality of the database was tested. The last part proposes security measures and defines access authorizations for tables, introduces created views limiting the volume of data visible for users, and stored procedures serving to automate certain activities.
|
|
|
Database design for a website about runners
Šimůnek, Dominik ; Palovská, Helena (advisor) ; Strossa, Petr (referee)
The aim of this bachelor thesis is to design a concept of a database for the website on the competitors in athletics. This includes a creation of the web application which allows the website visitors to edit, add, change or delete information mostly about the atheletes. This thesis emphasises the exact determination of the requirements concerning web functionality. The most convenient database model is created according to these requirements and afterwards implemented on the database system MySQL. Database design is a major part of this work. Second part of the thesis is dedicated to the creation of the web application while using the PHP language. The functionality of the database application and model is consequently verified by the existing data created for the pursposes of this thesis, or eventually imported from other data sources available in order to assure larger sample of the data regarding the athletes. The web application will be available on the internet for any visitor.
|
|
|
Design of the database for forwarding agency
Kolařík, Vít ; Palovská, Helena (advisor) ; Strossa, Petr (referee)
The goal of this bachelor thesis was to create a design of a database for aplication of a transport company, that would be able to file orders and to control own trucks. I was progressing from creating an analysis and conceptual and physical model of the database to testing the database by simple commands in Oracle 10g Express Edition. Beside the design, I was also concerned in access of the users into the database. The presumed benefit should be the fact, that the customer would have the possibility to trace the order. An employee should be more effective in planning of the transports and a manager will have data at disposal concerning the orders and the trucks. He should be able to analyse the data because it will be in one place.
|
|
|
Database design for ISP
Mareček, Aleš ; Palovská, Helena (advisor) ; Palovský, Radomír (referee)
This bachelor thesis deals with analysis, design and implementation of database application, which could benefit an organization providing internet access. The whole text is built on several years of personal experience of the author in providing an Internet connection. Main goal of this thesis is to create a flexible database design and test it successfully in a database system, Oracle 10g Express Edition. The main function of the database is to cover the following three business processes: customer records, asset management and providing an overview of individual employees. Database functionality is verified by the implementation and filling the database with test data.
|
|
| |
guest ::
