Please use this identifier to cite or link to this item: http://hdl.handle.net/1822/43853

TitleAn architecture for data warehousing in big data environments
Author(s)Bruno Martinho
Santos, Maribel Yasmina
KeywordsBig Data
Data Warehouse
NoSQL
Hadoop
Hive
Impala
Issue dateDec-2016
PublisherSpringer Verlag
JournalLecture Notes in Business Information Processing
CitationMartinho, Bruno, and Maribel Yasmina Santos, “An Architecture for Data Warehousing in Big Data Environments”, Proceedings of the 10th. International Conference on Research and Practical Issues of Enterprise Information Systems (Confenis’2016), IFIP International Federation for Information Processing, LNBIP 268, pp. 237–250, 2016, Springer-Verlag, 13-14 December 2016, Viena, Aústria, 2016. (DOI: 10.1007/978-3-319-49944-4_18).
Abstract(s)Recent advances in Information Technologies facilitate the increasing capacity to collect and store data, being the Big Data term often mentioned. In this context, many challenges need to be addressed, being Data Warehousing one of them. In this sense, the main purpose of this work is to propose an architecture for Data Warehousing in Big Data, taking as input a data source stored in a traditional Data Warehouse, which is transformed into a Data Warehouse in Hive. Before proposing and implementing the architecture, a benchmark was conducted to verify the processing times of Hive and Impala, understanding how these technologies could be integrated in an architecture where Hive plays the role of a Data Warehouse and Impala is the driving force for the analysis and visualization of data. After the proposal of the architecture, it was implemented using tools like the Hadoop ecosystem, Talend and Tableau, and validated using a data set with more than 100 million records, obtaining satisfactory results in terms of processing times.
TypeconferencePaper
URIhttp://hdl.handle.net/1822/43853
ISBN9783319499437
DOI10.1007/978-3-319-49944-4_18
ISSN1865-1348
Peer-Reviewedyes
AccessrestrictedAccess
Appears in Collections:CAlg - Artigos em livros de atas/Papers in proceedings

Files in This Item:
File Description SizeFormat 
ArchitectureBigDataWarehousing_Final.pdf992,14 kBAdobe PDFView/Open    Request a copy!

Partilhe no FacebookPartilhe no TwitterPartilhe no DeliciousPartilhe no LinkedInPartilhe no DiggAdicionar ao Google BookmarksPartilhe no MySpacePartilhe no Orkut
Exporte no formato BibTex mendeley Exporte no formato Endnote Adicione ao seu Currículo DeGóis