Show simple record

dc.contributor.authorKatragadda, Ranjith
dc.contributor.authorTirumala, Sreenivas Sremath
dc.contributor.authorNandigam, David
dc.date.accessioned2016-05-11T20:44:09Z
dc.date.available2016-05-11T20:44:09Z
dc.date.issued2015-01
dc.identifier.urihttps://hdl.handle.net/10652/3366
dc.description.abstractRelational databases are bound to follow various database integrity rules and constraints that makes the reporting a time consuming process. Data Warehousing has evolved out of the desperate need for easy access to structured storage of quality data that can be used for effective decision making. Data are turned into knowledge and knowledge into plans which are instrumental in profitable business decision making. To serve this purpose, data need to be extracted from various sources, transformed and loaded into the data warehouse which constitute the process of ETL (Extract, Transform and Load). ETL process can be accomplished using various tools both open source and proprietary. In this paper, we provide an empirical study of two ETL tools, an open source Talend Studio and Microsoft SSIS. In spite of the dominance among a vast majority of computer software solutions, open source technologies, as the comparative analysis that this study has undertaken, concludes that open sources tools are yet to evolve in order to be sustainableen_NZ
dc.language.isoenen_NZ
dc.publisherInstitute of Electrical and Electronics Engineers (IEEE)en_NZ
dc.subjectExtract, Transform and Load (ETL)en_NZ
dc.subjectTalend Studio (Software)en_NZ
dc.subjectMicrosoftSQL Server Integration Services (SSIS)en_NZ
dc.subjectdata warehousesen_NZ
dc.subjectopen source ETLen_NZ
dc.titleETL tools for data warehousing : an empirical study of open source Talend Studio versus Microsoft SSISen_NZ
dc.typeConference Contribution - Paper in Published Proceedingsen_NZ
dc.rights.holderInstitute of Electrical and Electronics Engineers (IEEE)en_NZ
dc.subject.marsden080109 Pattern Recognition and Data Miningen_NZ
dc.identifier.bibliographicCitationKatragadda, R., Tirumala, S.S., & Nandigam, D. (2015). ETL tools for Data Warehousing: An empirical study of Open Source Talend Studio versus Microsoft SSIS. IEEE (Ed.), CWISCE'2015 International Conference on Web Information System and Computing Education, The 2nd World Congress on Computer Applications and Information Systems (WCCAIS'2015)en_NZ
unitec.institutionUnitec Institute of Technologyen_NZ
unitec.conference.title2nd World Congress on Computer Applications and Information Systems (WCCAIS'2015)en_NZ
unitec.conference.orgInstitute of Electrical and Electronics Engineers (IEEE)en_NZ
unitec.conference.locationYasmine Hammamet, Tunisiaen_NZ
unitec.conference.sdate2015-01-17
unitec.conference.edate2015-01-19
unitec.peerreviewedyesen_NZ
unitec.identifier.roms57964en_NZ


Files in this item

Thumbnail

This item appears in

Show simple record