| | SLO | ENG | Cookies and privacy

Bigger font | Smaller font

Show document Help

Title:ANALIZA IN PRIMERJAVA ORODIJ ZA INTEGRACIJO PODATKOV
Authors:ID Hrnčič, Tomaž (Author)
ID Hölbl, Marko (Mentor) More about this mentor... New window
ID Sevčnikar, Andrej (Comentor)
Files:.pdf VS_Hrncic_Tomaz_2013.pdf (2,07 MB)
MD5: EC2DB590BD22BA4266A0CF11663046F9
 
Language:Slovenian
Work type:Bachelor thesis/paper
Typology:2.11 - Undergraduate Thesis
Organization:FERI - Faculty of Electrical Engineering and Computer Science
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, analiza, primerjava orodij
Place of publishing:Maribor
Publisher:[T. Hrnčič]
Year of publishing:2013
PID:20.500.12556/DKUM-42328 New window
UDC:004.6(043.2)
COBISS.SI-ID:17469718 New window
NUK URN:URN:SI:UM:DK:8PD1XNEF
Publication date in DKUM:19.09.2013
Views:3534
Downloads:278
Metadata:XML DC-XML DC-RDF
Categories:KTFMB - FERI
:
Copy citation
  
Average score:(0 votes)
Your score:Voting is allowed only for logged in users.
Share:Bookmark and Share



Hover the mouse pointer over a document title to show the abstract or click on the title to get all document metadata.

Secondary language

Language:English
Title:ANALYSIS AND COMPARISON OF ETL TOOLS
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.
Keywords:ETL, data warehouse, integration, analysis, tool comparison


Comments

Leave comment

You must log in to leave a comment.

Comments (0)
0 - 0 / 0
 
There are no comments!

Back
Logos of partners University of Maribor University of Ljubljana University of Primorska University of Nova Gorica