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

ProblemWorkSolution
Multiple and heterogeneous data sourcesMesiti et al. [5]Stream processing
 Naeem et al. [6] 
 Zhang et al. [7] 
 Waas et al. [20] 
Performance degradation and backup dataVassiliadis and Simitsis [12]Log CDC*
 Jain et al. [8]Trigger CDC
 Shi, JinGang, et al. [28]Timestamp CDC
Master data overheadNaeem 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]