Active data warehousing: a new breed of decision support

Summary form only given. Active data warehousing is rapidly changing the landscape for deployment of decision support solutions. The trend toward actionable business intelligence demands that capabilities for tactical and event-driven decision-making be supported in addition to traditional uses of the data warehouse for strategic decision-making. The resulting challenges to deliver extreme service levels in the areas of performance, availability, and data freshness require new methods for data warehouse construction. In this paper, the architectural requirements for an active data warehouse are described in detail. The evolutionary steps from first generation data warehouse implementations to active data warehouse deployment are provided as a means for incrementally delivering business value in the path toward advanced decision support capability. The service level requirements and technical building blocks for an active data warehouse deployment are described using specific examples. We explore the design tradeoffs and implementation techniques for active data warehouse deployment. Particular attention is paid to architectural topologies for successful implementation and the role of frameworks for enterprise application integration (EAI). Implementation of scalable solutions with capability for near real-time data acquisition and mixed workload management with aggressive service levels are discussed with real customer scenarios as mini case study examples.