Analiza in primerjava orodij za integracijo podatkov

diplomsko delo

Tomaž Hrnčič (Author), Marko Hölbl (Mentor), Andrej Sevčnikar (Co-mentor)

Abstract

Diplomska naloga je namenjena predstavitvi, analizi in primerjavi treh izbranih orodij za integracijo podatkov: Pentaho Data Integration, Oracle Data Integrator in Microsoft SQL Server Integration Services. Prav tako je predstavljen splošen problem integracije, ter način, ki je potreben za njegovo razrešitev. Razložen je pojem ETL in naloge njegovih korakov v procesu integracije. Diploma na kratko opiše tudi vlogo ter arhitekturo podatkovnih skladišč, ki se uporabljajo ob izvajanju omenjenih postopkov. Na praktičnem primeru je izvedena analiza virov podatkov, na osnovi katere je zgrajen model podatkovnega skladišča, ter podrobno opisan in izveden postopek integracije podatkov za vsa omenjena orodja. Za dosego zanesljive primerjave orodij, so vsi procesi ETL izvajani pod enakimi pogoji in tehnologijami podatkovnih baz. Na koncu so prikazani rezultati primerjav po izbranih merilih na podlagi analiz in izkušenj, ter predstavljene splošne ugotovitve.

Keywords

ETL;podatkovno skladišče;integracija;primerjava orodij;diplomske naloge;

Data

Language:	Slovenian
Year of publishing:	2013
Typology:	2.11 - Undergraduate Thesis
Organization:	UM FERI - Faculty of Electrical Engineering and Computer Science
Publisher:	[T. Hrnčič]
UDC:	004.6(043.2)
COBISS:	17469718
Views:	1644
Downloads:	191
Average score:	0 (0 votes)
Metadata:

Other data

Secondary language:	English
Secondary title:	ANALYSIS AND COMPARISON OF ETL TOOLS
Secondary abstract:	The thesis aims to present, analyse and compare three distinct data integration tools: Pentaho Data Integration, Oracle Data Integrator and SQL Server Integration Services. It explains the general problem of integration and the manner in which it should be resolved. It also explains the concept of ETL, describes its steps in the process of integration and briefly explains the role and architecture of data warehouses, which are used in the implementation of these procedures. A data source analysis and a data warehouse model are described and build based on a practical example, after which the data integration procedures are executed and explained in deatail for each mentioned product. In order to achieve a reliable comparison, all ETL processes are executed under the same conditions and database technologies. In the end, results are compared and presented based on chosen criteria, analysis and observations.
Secondary keywords:	ETL;data warehouse;integration;analysis;tool comparison;
URN:	URN:SI:UM:
Type (COBISS):	Bachelor thesis/paper
Thesis comment:	Univ. v Mariboru, Fak. za elektrotehniko, računalništvo in informatiko
Pages:	IX, 54 f.
ID:	8727227