|
|
Comparison of Open Source relational database systems
Kováč, Ondřej ; Chlapek, Dušan (advisor) ; Palovská, Helena (referee)
This thesis deals with the subject of Open Source relational database systems. Its goal is to provide an overview about these systems, analyze their position on market and compare them according to predefined comparative criteria, which are focused on specific general features and administration of database systems. The first part of the thesis provides necessary theoretical knowledge about database systems describes currently most widely used types of these systems and explains the term Open Source software. Next one is aimed on how are these systems used in companies information systems and how are they positioned on database market. Third part presents four most widespread Open Source relational database systems, states their development in time from their creation till nowadays and what licenses are they provided under. Following is a part dedicated to specification of comparative criteria, which is followed by the comparison of database systems in these criteria, always using one of three evaluation methods. In the last part of thesis the final review of gained knowledge and the results of the comparison are presented in summarized graphs. The thesis could be used as a unified information source for computer specialists in different job positions - IT Managers, database administrators or systems integrators - while choosing suitable Open Source relation database system for engineered or redesigned information system of a company.
|
|
|
Model for monitoring the value of enterprise Informatics: system / deterministic chaotic model
Filippi, Tomáš ; Bruckner, Tomáš (advisor) ; Palovská, Helena (referee)
This study deals with the value of ICT services. Enterprise Informatics is a widespread line of business and it is part of every company. There are not only software and hardware resources in enterprise informatics, but also people belong into and work with informatics every day. Currently, there are new trends how to manage enterprise informatics. Based on the same principles as for the business. A prerequisite for effective management is accurate overview of the costs and benefits. For this purpose there is a group of metrics which ensure measuring the amount of inputs, outputs and quality of services. The value of ICT services should be positive. Benefits should be greater than costs. The aim of this work is to create a model for monitoring the value of enterprise Informatics. Model simulate the dynamics of enterprise informatics and describe all important parameters in terms of value. Model should also find out if there are some external or internal factors, which could bring on some random element complicating the process of effective management.
|
|
|
Possibilities of using Caché database system
Brož, Ondřej ; Palovská, Helena (advisor) ; Vedral, Pavel (referee)
Structure of this work is divided into a few main chapters. The biggest part is focused on a creation relational and object schema of a specific example and their realization in Caché database. The next goals are theoretically describe database, object model, its characteristics as well and comparison the object principles in Caché and Oracle database. After a few words whose describe the most important facts in a history of databases the reader can learn something about the Caché database. Mainly its architecture which is the greatest advantage against the competition. Next charter quickly show how to successfully install and access the database. In charter 4 the basic database tools are mentioned such as development environment Caché Studio, command line Caché Terminal and web interface for administration called Caché System Management Portal. The fifth and sixth chapter covers the main goal of this work. In fifth chapter the object model (relational model only in part), its basic principles (defined in ODMG standards) and object characteristics are described. The sixth chapter show the creation process of the object schema "step by step" together with possible ways how to insert data and select them. Final codes for structure and data are placed at the end of work . In last chapter I am trying to compare object characteristics in Caché and Oracle database(version 10gR2). The contribution of this work is in explanation of object principles with the "step by step" processes of creating and realization object schema shown on a concrete example (the official documentation doesn't obtain them).
|
|
|
Database model design for informational, community and e-learning portal focused on driving license applicants
Demuth, Jan ; Palovská, Helena (advisor) ; Klas, Jan (referee)
This work is concerned with the process of designing and documentation of a web portal covering informational, community and e-learning application functionality focused on the field of driving schools and driving license applicants training and education. The emphasis lies on the phase of optimal database model design independent of the final technological solution of the developed application and documentation of relations and purpose of all entities in the system influenced by the process of design and further development of the physical database.
|
|
|
The design of database for the company Foram spol. s r.o.
Gottwald, Karel ; Palovská, Helena (advisor) ; Klas, Jan (referee)
The work deals with the definition of terms, mention of history and theory of design databases. The main objective was to propose a solution for the company Foram spol. s r.o. on the basis of theoretical knowledge in order to be usable in practice. The logic was to capture the reality of the best capturing given situation. It was necessary to communicate with the company and analyze their requirements. They defined the basis for drawing up a conceptual and physical model. Diagrams were created in PowerDesigner version 12.0. Finally, the functionality of the proposal was verified on the test data.
|
|
| |
|
|
Design database for a joiner workshop
Jun, Miroslav ; Palovská, Helena (advisor) ; Klas, Jan (referee)
This bachelor thesis deal with analysis, design and implementation of a database for an aplication, which can use a joinerworkshop. The inspiration for this database I took in the company Setim s.r.o. The main function of this aplication is tracing products in the process of production. Thanks to this aplication is possible to find for each product workers, who are responsible for its manufacturing. The main goal of this thesis is creating a flexible design of database and its implementation in database system Oracle 10g Express Edition. The right function of this database is tested by the examplary SQL comands.
|
|
|
Framework for teaching Database Management Systems on VŠE Praha
Turčín, Pavel ; Chlapek, Dušan (advisor) ; Palovská, Helena (referee)
This thesis focuses on design and subsequent realization of e-learning support for the database management systems course. The first step is definition of the e-learning itself as well as other related concepts. Following part analyzes current status of teaching and evaluating students' knowledge and other possible ways to do so without changing the basic course frame defined by the given syllabus. A list of requirements on the software framework is made on basis of this analysis. These requirements are technical (demanded functionality) and economical (costs of installation and maintenance). The most suitable e-learning system is chosen according to these requirements. The chosen system unfortunately does not fulfill all specified requirements and software witch does, is not available. In this case the following step is design and realization of such software. At first are all requirements specified in detail. The software solution is designed as three independently usable applications: Exercise client, Test client and Administrator. Software is implemented in C# programming language. Whole process of implementation is divided into three increments witch corresponds with projected applications. Every increment adds new functionality to existing solution and the output of every increment is fully usable component.
|
|
|
Backup and recovery of Oracle Database using Recovery Manager
Hubáček, Filip ; Macák, Petr (advisor) ; Palovská, Helena (referee)
The bachelor's thesis discusses the implementation of backup and recovery of Oracle database using Recovery Manager. There are described individual backup types available in Oracle database environment and recovery types. Author introduces the benefits of using Recovery Manager, as the main backup tool in comparison to other methods of performing backup / restore.The reader is acquaint with the results of tests of the possible backup types. The tested features are speed of backup operation, the availability of the database during the backup, the compression ratio and the speed of restore operation. Base on the comparison of these results is set the backup and recovery strategy for the database of two model companies.
|
|
|
Preparation of test demo database and tuning of SQL commands
Valoušek, Filip ; Palovská, Helena (advisor) ; Chlapek, Dušan (referee)
This bachelor work deals with projecting and implementation of the demo test database, which is used for training work with relational databases. A set of educational queries submissions which enable practising query language SQL (Structured Query Language) is one part of the work. There is a well-arranged table of correct output from data test for all of queries allowing to check correct query setting. In the theoretical part there is a short mention about the principles of databases projecting and data modelling, especially about the "Three schema approaches".
|
guest ::
