|
|
Methods of access to PostgreSQL databases in .NET Framework
Henzl, Václav ; Kouřil, Jiří (referee) ; Lattenberg, Ivo (advisor)
The results of this work are two major projects - NpgObjects and PagedDataGridView. NpgObjects is a simple ORM framework to enable the mapping database tables to objects in the common language runtime. It contains a specially designed generator which generates classes in C# from information obtained from the database. These classes are mapping on the database tables one to one. NpgObjects allows all the basic database operations - SELECT, INSERT, UPDATE and DELETE. PagedDataGridView is a component for displaying tabular data. In cooperation with NpgObjects can paginate database data and manage the flow of data into application. It provides a comfortable user interface, which can easily navigate between different pages of data.
|
|
|
Comparison of data management solutions in MySQL and MongoDB while using Doctrine 2 in Symfony 2 framework
Firla, Dominik ; Palovská, Helena (advisor) ; Mittner, Jan (referee)
This thesis focuses on comparing a relational database system with a document database on both theoretical and practical levels. In theoretical part of this thesis principles of relational and document databases are explained. Closer attention is given to MySQL and MongoDB databases. In practical part a solution to data management is realized for a model situation. Both systems are compared in terms of implementation and performance. Knowledge gained is summarized in conclusion of this thesis and should help a reader when choosing the right database system not only for a web application implementing PHP framework Symfony. Practical part of the thesis also includes an author-made project containing implementation of both databases in the model situation.
|
|
|
guide for development of database application
Keder, Michal ; Buchalcevová, Alena (advisor) ; Pecinovský, Rudolf (referee)
This thesis is focused on the development of application for work with database. In this thesis is described the process of designing a database, that use SQL script file for setting the database data with description of various technologies used it process of creating this application and description of created application. The aim of this thesis is to describe a database design along with the created database.
|
|
|
Use of Doctrine 2 in Zend Framework
Řehout, Michal ; Mittner, Jan (advisor) ; Pavlíček, Luboš (referee)
The subject of this document is to analyze and evaluate the features of Zend_Db and Doc-trine 2 -- two different implementations of object-relational mapping. The objectives will be achieved through objective performance testing in the sample appli-cation and subjective evaluation of difficulty to work with and contribution of each indi-vidual solution. The document is divided into four main parts. The first part will focus on the theory of object-relational mapping -- design patterns Table Data Gateway (Zend_Db_Table) and Data Mapper (Doctrine 2). In the second part we will summarize and evaluate the options of integrating Doctrine 2 with Zend Framework, this section freely continues in part four with a practical example of simple application. In the third part we will evaluate the analysis of the compared solutions.
|
|
|
Database abstraction layers for PHP
Ježek, David ; Palovská, Helena (advisor) ; Burkoň, Lukáš (referee)
The goal and benefit of the bachelor's thesis is explanation what the database abstraction layers are and what advantages and disadvantages they bring, and comparison of most commonly used database abstraction layers for PHP. For greater clarity, the text is supplemented with examples of source code. The thesis can be a basis for deciding whether to use a database abstraction layer in a project, eventually which one to choose. It may also be a guide for programmers who want to start working with database abstraction layers.
|
|
|
Practical usage of Entity Data Framework
Náprstek, Michal ; Pavlíčková, Jarmila (advisor) ; Burkoň, Lukáš (referee)
Object oriented programming together with relational databases is common technology used for SW products development. Both of these, however, have different understanding of the data concept. This poses a challenge to the developers in a way of securing data consistency of application data representation versus storage data representation. Due to this concern, there are tools for object-relational mapping, which are supposed to make developers' work more convenient. The topic of this thesis is one of these tools, the Entity framework by Microsoft company. And the goal being to present the specific concepts of object-relational mapping, which Entity framework employs, as well as to put these in practical use with a demo application utilizing Entity framework.
|
|
|
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.
|
|
|
Comparison of ORM frameworks for PHP
Procházka, Ivan ; Pavlíčková, Jarmila (advisor) ; Schrotter, Michal (referee)
This study deals with a comparison of object relational mapping frameworks for PHP program language. On theoretical review, it describes the possibilities of mapping and available design patterns for mapping are presented. Basic principles of object oriented programming and relational databases are surveyed. For a comparison of tools, a model case of a library is suggested and implemented in chosen tools. Based on specified criteria, a comparison of selected frameworks is given. The main goal is to evaluate features of chosen frameworks, demonstrate their usage on the model case of a library and summarize the possibilities of object relational mapping on PHP platform.
|
|
|
Object relational mapping frameworks
Patrný, Vojtěch ; Pavlíčková, Jarmila (advisor) ; Hrnko, Petr (referee)
This paper is about Java object relational frameworks and related processes. The goal of this work consists of showing design patterns for ORM, introducing Java ORM standards along with the main implementations, finding criteria for comparison of ORM frameworks and showing working ORM example in a case study. This paper has the following structure: The first part of this paper discusses main ORM design patters, approaches to ORM and performance related features of Java ORM frameworks. Next part describes available Java ORM standards and implementations and introduces case study attached to this part as appendix. The last part of this paper presents ORM frameworks comparison criteria and compares main implementations of the JPA standard.
|
|
|
Vybrané problémy řízení operačního rizika v bankách
Uličná, Ivana ; Revenda, Zbyněk (advisor) ; Jindrová, Miroslava (referee)
Práce se zaměřuje na problematiku operačního rizika v bankách v souvislosti s aplikací kapitálového konceptu Basel II v ČR. Přináší charakteristiku základních prvků kvalitního systému řízení operačního rizika (konceptu, fází a nástrojů ORM, kontrolního systému, komunikačního systému) a pojednává o přístupech pro výpočet kapitálového požadavku k operačnímu riziku podle Basel II (BIA, TSA, ASA a AMA).
|
guest ::
