Business Intelligence And Data Warehousing Software Directory

Active Data Warehousing

Details: The article outlines Active Data Warehousing which is an opposite approach to the traditional population of the data warehouse using off-line ETL processes. The concept of active data warehousing is a trend where data warehouses are updated as frequently as possible, to accommodate the high demands of business users for fresh data.

The authors of this article propose a sample and theoretical Active DW framework, which implements queue theory for the ETL process of the refreshment process. The article illustrates different architectural choices for the Active Data Warehouse along with the potential issues that may arise. The article has the following chapters:
  • Introduction to Active Data Warehousing
  • Queue theory for ETL process
  • Framework, system architecture and issues raised
  • Two sets of experiments
  • Conclusions and future of active data warehousing
  • Address:
    Categories: ETL ARTICLES