Posted in February 8, 2010 ¬ 8:22 amh.Kostis Panayotakis
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 »
Posted in February 8, 2010 ¬ 8:20 amh.Kostis Panayotakis
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 »
Posted in February 8, 2010 ¬ 8:19 amh.Kostis Panayotakis
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 »
Posted in February 8, 2010 ¬ 8:15 amh.Kostis Panayotakis
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 »
Posted in February 8, 2010 ¬ 8:15 amh.Kostis Panayotakis
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 »