Diplomová práce se zaměřuje na propojení databáze Oracle s vývojovými platformami Java, .Net a Lotus Notes/Domino. Po vysvětlení základních principů a technik práce s databází následuje část, která si klade za cíl jednotlivé možnosti propojení porovnat a otestovat. Na všech 3 platformách existují vyspělé propojovací technologie pro práci s databází, mezi nejznámější patří ODBC, JDBC, ADO.NET a LC (Lotus Connectors). Jednotlivé možnosti propojení se na všech třech vývojových platformách značně liší. Společná zůstává jen základní funkcionalita pro práci s databází (sestavení připojení, řízení transakcí, volání SQL příkazů, přenášení základních datových typů a volání uložených procedur). Pro praktické ověření jednotlivých propojovacích produktů byla vyvinuta testovací/benchmark aplikace, která byla z jazyka Java naimplementována i do prostředí .NET (C#) a Lotus Notes/Domino (Lotus Script). Bylo naimplementováno a spuštěno 253 testů na 12 produktech od 8 výrobců. Podkladem pro zpracování diplomové práce a realizaci testů byla dokumentace k těmto systémům a další odborná literatura. Díky těmto testům bylo možné, v rámci možností, porovnání jednotlivých produktů i platforem. Systematické testování a práce s těmito produkty ukázaly, že jednotlivé produkty jsou velmi rozdílné v ceně, kvalitě, výkonu, ale i ve svých specifických funkcích.

<p>Abstract In high voltage substations there is an increasing demand for computerized equipment, and automation of operation and supervision. The future primary equipment will provide the possibility to collect more information and to provide better control for improved effectiveness. </p><p>Since ABB has got a large customer target, each product must be custom made to fulfil the customers (often from different countries) demands. Later these products will be configured by engineers who may not be familiar with the tools used at ABB. This is a very expensive and time consuming. To solve the problem, ABB was looking for a low cost, easy managed and more advanced replacement. </p><p>This report includes an investigation for a function block configuration tool based on Microsoft Visio. The tool is connected to a general database using ODBC for the latest ABB Substation Automation SW platform for protection in power transmission equipment. </p><p>The thesis report mainly contains a description of the functions and features that are requested. Then methods used to build the prototype is explained and at the end the result is presented. </p><p>At the same time the possibilities and problems that will arise from using ODBC based interface for control and monitoring of real-time systems were investigated.</p>

<p>This thesis paper introduces you about the process of how to build an inventory tracking system in a local Swedish company. The related project is to support the thesis paper, and is also for the company’ using. The software product of this project is an application that works for managing various types’ instruments in the company of SWECO-Vaxjo. It will play an important role in the further management work of the company.</p><p>In this thesis paper, the candidate techniques and theories for implementing this system are discussed. And in the end a good solution for this problem will be presented in the paper.</p>

This thesis paper introduces you about the process of how to build an inventory tracking system in a local Swedish company. The related project is to support the thesis paper, and is also for the company’ using. The software product of this project is an application that works for managing various types’ instruments in the company of SWECO-Vaxjo. It will play an important role in the further management work of the company. In this thesis paper, the candidate techniques and theories for implementing this system are discussed. And in the end a good solution for this problem will be presented in the paper.

Abstract In high voltage substations there is an increasing demand for computerized equipment, and automation of operation and supervision. The future primary equipment will provide the possibility to collect more information and to provide better control for improved effectiveness. Since ABB has got a large customer target, each product must be custom made to fulfil the customers (often from different countries) demands. Later these products will be configured by engineers who may not be familiar with the tools used at ABB. This is a very expensive and time consuming. To solve the problem, ABB was looking for a low cost, easy managed and more advanced replacement. This report includes an investigation for a function block configuration tool based on Microsoft Visio. The tool is connected to a general database using ODBC for the latest ABB Substation Automation SW platform for protection in power transmission equipment. The thesis report mainly contains a description of the functions and features that are requested. Then methods used to build the prototype is explained and at the end the result is presented. At the same time the possibilities and problems that will arise from using ODBC based interface for control and monitoring of real-time systems were investigated.

This thesis is focused on SAS Enterprise Intelligence Platform product and it's capabilities to integrate within a Business Intelligence solution. The aim of the thesis is to describe integration technolgies that the platform features, as well as to determine their application field and compare them, eventually add usage examples. The first part of the thesis explains the general concept and architecture of Business Intelligence, afterwards the reader gets familiar with the SAS Enterprise Intelligence Platform, it's stucture and components and it's Business Intelligence market position. The second part of the thesis contains description (how they work and what they are good for) of the integration technologies available in SAS Enterprise Intelligence Platform. Those technologies are mostly implementations of the most common industry standards (database APIs, COM/DCOM, CORBA, web services). The study also includes description of these standards supported by SAS. The thesis features also comparisions of the integration technologies, namely comparison of database API implementations and comparision of Integrated Object Model API with SAS BI Web Services.

The diploma thesis "Data Standard of the Health Information Systems" deals with the structure of data standard including XML language. Further the thesis is focusing on hospital information system CLINICOM with the inclusion of the access to data records from its database Caché company InterSystems. Description of the National registers of health is also included.The concept of web application is also one part of the thesis which enables to generate reports in the data standard of the Ministry of Healt of the Czech Republic for mandatory reporting by NHIS registers in the time interval from the Caché database. Found records from the database can be printed for archiving. The work also deals with security access to the HIS server and data communication between health organizations.