Paper Info
Title
A rewrite/merge approach for supporting real-time data warehousing via lightweight data integration
Abstract
This paper proposes and experimentally assesses a rewrite/merge approach for supporting real-time data warehousing via lightweight data integration. Real-time data warehouses are becoming more and more relevant actually, due to emerging research challenges such as Big Data and Cloud Computing. Our contribution fulfills limitations of actual data warehousing architectures, which are no suitable to perform classical operations (e.g., loading, aggregation, indexing, OLAP query answering, and so forth) under real-time constraints. The proposed approach is based on intelligent manipulation of SQL statements of input queries, which are decomposed in suitable sub-queries (the rewrite phase) that are finally submitted as (final) input queries to an ad hoc component responsible for the cooperative query answering via a parallel query processing inspired method (the merge phase). This method induces in a novel data warehousing framework where the static phase is separated by the dynamic phase, in order to achieve the real-time processing features. We complete our analytical contributions by means of an extensive experimental campaign where we stress the performance of our proposed real-time data warehousing framework against a popular data warehouse benchmark, and in comparison with traditional architectures, which finally confirms the benefits deriving from our proposal.
Year
DOI
Venue
2020
10.1007/s11227-018-2707-9
The Journal of Supercomputing
Keywords
DocType
Volume
Real-time data warehousing, Data warehouse optimization, Data warehouse performance
Journal
76
Issue
ISSN
Citations 
5
1573-0484
0
PageRank 
References 
Authors
0.34
49
3
Name
Order
Citations
PageRank
Alfredo Cuzzocrea11751200.90
Nickerson Ferreira272.46
Pedro Furtado320455.67