Skip to main content

Table 1 Near real-time ETL problems and solutions

From: DOD-ETL: distributed on-demand ETL for near real-time business intelligence

Problem

Work

Solution

Multiple and heterogeneous data sources

Mesiti et al. [5]

Stream processing

 

Naeem et al. [6]

 
 

Zhang et al. [7]

 
 

Waas et al. [20]

 

Performance degradation and backup data

Vassiliadis and Simitsis [12]

Log CDC*

 

Jain et al. [8]

Trigger CDC

 

Shi, JinGang, et al. [28]

Timestamp CDC

Master data overhead

Naeem et al. [6]

Master data repository

 

Polyzotis, Neoklis, et al. [24]

Join optimizations

 

Bornea, Mihaela A., et al. [26]

 
 

Naeem, M. Asif, et al. [27]

 
 

Zhang et al. [7]