Home // ICCGI 2014, The Ninth International Multi-Conference on Computing in the Global Information Technology // View article

WebETL Tool – A Prototype in Action

Authors:
Kornelije Rabuzin
Matija Novak

Keywords: ETL; data warehouse; web; ETL tool

Abstract:
Every grocery store has data about bills, bought items, etc., usually stored in a database (DB). There is often a need to analyze this data. This is not suitable to do on an operational DB, especially when data from two or more stores must be analyzed. Therefore, data from the operational DB is extract-ed, transformed, and loaded (ETL) into a data warehouse (DW). The ETL process is the most important part of build-ing a data warehouse. It is used to extract data from opera-tional data sources, transform the data (as needed) and to load the data into a data warehouse. Because the ETL pro-cess (as such) is very complex and time consuming, a proto-type of a web ETL tool was built and tested. The results have shown that it is possible to build a completely web-based ETL tool and that it is faster than manual ETL. Also, be-cause it is completely web based, multiple users can use the tool at the same time, with no installation is needed.

Pages: 67 to 71

Copyright: Copyright (c) IARIA, 2014

Publication date: June 22, 2014

Published in: conference

ISSN: 2308-4529

ISBN: 978-1-61208-346-9

Location: Seville, Spain

Dates: from June 22, 2014 to June 26, 2014