Metode osiguranja kvalitete procesa integracije u projektima upravljanja poslovnim informacijama

master's thesis

• Title (english): Integration Process Quality Assurance Methods in Business Intelligence Project
• Author: Melita Fertalj
• Mentor: Željka Car (mentor)
• Committee member: Željka Car (predsjednik povjerenstva)
• Committee member: Branko Mikac (član povjerenstva)
• Committee member: Marin Vuković (član povjerenstva)
• Granter: University of Zagreb; Faculty of Electrical Engineering and Computing; Zagreb
• Defense date and country: 2016-07-07, Croatia
• Scientific / art field, discipline and subdiscipline: TECHNICAL SCIENCES; Computing
• Scientific / art field, discipline and subdiscipline: TECHNICAL SCIENCES; Electrical Engineering

Abstract

U ovom radu je opisan integracijski proces koji je implementiran za učitavanje, preoblikovanje i punjenje podataka, modelirano skladište podataka, definirane metrike za evaluaciju podataka te razvijeno programsko rješenje za automatizaciju testiranja.
Integracijski proces (ETL) je implementiran korištenjem alata za ekstrahiranje, transformaciju i punjenje podataka Talend Open Studio for Data Integration. Transakcijska baza podataka i skladište podataka su izgrađeni pomoću alata PostgreSQL. Administracijski alat za upravljanje bazom podataka je pgAdmin. Na Oracle bazi podataka implementirane su različite PL/SQL procedure za provođenje testova nad podacima.
Korisnici trebaju poznavati osnove pisanja SQL upita za korištenje pohranjenih procedura.

Abstract (english)

This thesis describes the integration process, which is implemented to extract, transform and load data, designed data warehouse, defined metrics for data evaluation and a software solution for the test automation.
The integration process (ETL) is implemented using tools to extract, transform and load data, i.e. Talend Open Studio for Data Integration. The transactional database and data warehouse are built using the PostgreSQL database. Administration tool used for database management is pgAdmin. Various PL/SQL procedures for conducting data tests are implemented using Oracle database.
Users need to know the basics of writing SQL queries to use automated testing.

• Keywords: ETL; metrike; PL/SQL
• Keywords (english): ETL; metrics; PL/SQL
• Language: croatian
• URN:NBN: urn:nbn:hr:168:443966
• Study programme: Title: Information and Communication Technology; Study programme type: university; Study level: graduate; Academic / professional title: magistar/magistra inženjer/inženjerka informacijske i komunikacijske tehnologije (magistar/magistra inženjer/inženjerka informacijske i komunikacijske tehnologije)
• Type of resource: Text
• File origin: Born digital
• Access conditions: Closed access
• Created on: 2018-02-06 08:43:24