Database - Data Warehousing - Discussion

There's a lot of stir in the market place these days with a term called: Operational Business Intelligence, over the years there's been a lot of interest and usage of the term: Active Data Warehousing, which according to Bill Inmon is really: "real-time data warehousing" or "operational data warehousing. ".

An active data warehouse (ADW) is a traditional data warehouse extended to provide operational intelligence based on historical data combined with today's up-to-date data. The ADW supports mixed workloads from an enterprise data warehouse that serves as a single source of truth for decision making with predictable service levels for query response times, near real-time data freshness, and mission critical data availability.

Data warehouse is an exclusive storage of data obtained from different sources, it includes all the above like data mart to store subset of data and real time updates.

Data warehouse architecture, which is based on multi-agent systems, not only improves the active and real-time performance of the data warehouse.

At least one data mart. Data that can extracted from numerous internal and external sources. Near real-time updates.

An active data warehouse should contain at-least one data mart belonging to a subject area. Also the data for the warehouse can be extracted from numerous internal and external sources. The data warehouse always gets near real-time updates i.e. the data is being updated constantly as and when it happens.