Academic literature on the topic 'Databázový systém Oracle'

This thesis examines ways of comparing performance of Oracle databases. The need to compare performance is given by making changes in database systems, for example changes in databases structures or database management systems. One of the goals of this thesis includes a description of options and ways of comparing performance of Oracle databases which does not involve any additional licensing costs. Because there is a need to evaluate obtained performance indicators, part of this thesis deals with the design and implementation tool, which allows analysis of data and their evaluation through defined reports. Functionality of the tool is verified and demonstrated on data obtained from real databases. The main contribution of this thesis is the implementation of the tool, which significantly facilitate evaluating performance impact of changes which should be made in the production database.

Práce se zabývá problematikou objektově-relačních databázových systémů. Cílem je analýza současné situace na poli databázových platforem ze sféry tradičních robustních i open source produktů, která by vedla k posouzení předpokladů uplatnění otevřených databázových platforem v oblastech dosud charakteristických především pro tradiční distributory. Na počátku práce nejprve přibližuji čtenáři otázky související s distribucí softwaru (proprietární vs. open source) a základní pojmy v oboru databázových systémů. Po tomto výchozím uvedení stanovuji kriteria pro následnou komparaci vybraných databázových platforem, která předurčují další postup v rozhodující části věnované komparační analýze. K dovršení celého rozboru práci uzavírám nastíněním přítomných možností využití tradičních robustních a především pak open source databázových systémů. Komparační analýza je vystavena na základě předem definovaných kritérií do pěti oddílů zohledňujících základní charakteristiky, technologické a funkční vlastnosti, bezpečnost, dostupnost i podporu produktů a nevěnuje se rozboru z hlediska výkonu a optimalizace. Za účelem srovnání byly vybrány čtyři přední databázové systémy ? Oracle, DB2, Teradata a PostgreSQL. V návaznosti na důkladnou analýzu, která vedla ke zmapování aktuální situace na databázovém trhu, jsou v závěru práce vytknuty hlavní faktory kolidující širšímu uplatnění open source platforem.

This master´s thesis deals with data integration that is used for data transfer within various database systems in both directions - data migration and replication. We become familiar with the technologies of distributed databases. In detail the system of health care providers is described and particular tables involved into its data integration are explored. For the project execution the proposal for integration of this system is created and whereupon following implementation is described.

System for data mining Fit-Miner is now dependant on only one specific DBMS. This master’s thesis  deals with analysis of implementation that works with database, modules and functions for data mining. Next it shows the set of changes which will allow FIT-Miner to work with another DBMS. And finally, a description of the implementation of these changes.

Thesis deal with tuning of database Oracle, which is used by digital archive SAFE. In the concrete deal with setting parameters of database. It is divided to three parts. In first part it characterizes factors that influence performance of database. In second part it describes possibilities of tuning and setting Oracle database. In third part it is first introduced digital archive SAFE, after that it is chosen suitable testing tool for workload generation and described test scenarios and last are performed tests and compared results at different database database settings. Goal of thesis is description and trial tuning of Oracle database, which is used by digital archive SAFE. Other goal is test of files inserting into digital archive at different settings (saving to the database, on file system). These goals are achieved by testing tool workload generation and compare response time at different settings. Contribution of this thesis is above all trial of tuning Oracle database, which is used by digital archive SAFE. Document can be used like handbook for implementatory of tested implementation of digital archive SAFE.

With the increase of demands for the speed and availability of the information technologies, the process of optimization gains more and more importance. Concerning search engine optimization, optimization of operating systems or application optimization (source code), the goal is to gain faster, smaller and more maintainable solution. In my thesis I deal with optimization of database systems, which includes low level of database tuning - physical organization of data and indices, database management system tuning and query optimization. I focused on optimization of Microsoft SQL Servers 2005 in enterprise environment.

The master's thesis focuses on the creation of the automatic error cleansing software which clears the errors generated by the ordering system. Based on the error analysis (e.g. their causes and possibilities of their correction) the software enables the automatic error correction without the necessity of any manual action resulting in minimal delay of customers’ orders.