The architecture of an active database management system
SIGMOD '89 Proceedings of the 1989 ACM SIGMOD international conference on Management of data
The Data Warehouse Toolkit: The Complete Guide to Dimensional Modeling
The Data Warehouse Toolkit: The Complete Guide to Dimensional Modeling
Active data warehouses: complementing OLAP with analysis rules
Data & Knowledge Engineering - Data warehousing
Realizing active data warehouses with off-the-shelf database technology
Software—Practice & Experience
Beyond data warehousing: what's next in business intelligence?
Proceedings of the 7th ACM international workshop on Data warehousing and OLAP
Proceedings of the 8th ACM international workshop on Data warehousing and OLAP
| Hi-index | 0.01 |
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 Excel™, SQL Server 2005™ and Windows Workflow Foundation™, providing end-users with the environment to design automated analyses.