Implementing automated analyses in an active data warehouse environment using workflow technology

M. Zwick, C. Lettner, C. Hawel. Implementing automated analyses in an active data warehouse environment using workflow technology. volume 4473, pages 341-354, 2007.

Autoren
  • Michael Zwick
  • Christian Lettner
  • Christian Hawel
Editoren
  • D. Draheim
  • G. Weber
BuchTrends in Enterprise Application Architecture
TypIn Sammelband
VerlagSpringer
SerieLecture Notes in Computer Science
Band4473
ISBN978-3-540-75911-9
Jahr2007
Seiten341-354
Abstract A major goal of active data warehouses is to automatically perform analysis tasks. However, this goal is only insufficiently implemented in current active data warehousing architectures. For end-users, it is not possible to design and modify such automated analysis tasks, as the needed tools are not seamlessly integrated into common business intelligence environments. As analysis tasks can be modeled as workflows in a natural way, we propose to use workflow technology to close this gap. Furthermore, workflow engines provide a graphical user interface that can be extended to allow end-users to assemble and manage complex analysis tasks. A prototype that builds up the foundation for this new active data warehousing architecture is implemented using Microsoft ExcelTM, SQL Server 2005TM and Windows Workflow FoundationTM, providing end-users with the environment to design automated analyses.