Author Archive

Prevalent Data Warehouse Development Approaches

There are two prevalent approaches to the development of Datawarehouse Architectures: A. Data Warehouse (DWH) bus architecture (introduced by Ralph Kimball) B. Corporate Information Factory CIF (introduced by Bill Inmon) In this article we analyse and compare these two approaches.

Read the rest of this entry »

Components of a Data Warehouse Architecture – Part 2, The Kimball Presentation Area

In the present and following article we shall describe the presentation area of the data warehouse. The term presentation is used to denote the fact that this is the area, where data are presented to its Customers (the business analysts). There is no globally acceptable standard on the development of the data warehouse presentation area.

Read the rest of this entry »

Components of a Data Warehouse Architecture – Part 4, Kimball vs Inmon

In parts 2 & 3 of this article series, we described the data warehouse architecture according to the Kimball and the Inmon approach. In the present article we shall describe the main differences between the two approaches and their common points.

Read the rest of this entry »

Components of a Data Warehouse Architecture – Part 1, ETL and the Staging Area

Decision support systems are usually based on the development of Data Warehouse infrastructures. A data warehouse architecture has two major areas: the staging area and the presentation area. In this article we present the staging area.

Read the rest of this entry »

Components of a Data Warehouse Architecture – Part 3, The Inmon Approach

In the present article we shall describe the presentation area of the data warehouse, according to the Inmon approach. The Inmon approach (marketed as Corporate Information Factory) involves the holistic view of the Enterprise and its informational needs.

Read the rest of this entry »