Yé Y, Wahser U: "Using the Concept of Info-Cubes to Facilitate Data Analysis in Demographic Surveillance Systems"
Previous Slide Index of Presentations Next Slide
Table of Contents

Slide 6: Peeping into DWH Architecture

If we peek into data processing in big companies, we will find operational databases, which store business data in relational models. Business transactions are tracked online on these OLTP systems.

Regularly (e.g. weekly, daily) core data from the corporate OLTP systems are extracted from the OLTP systems and merged into a data warehouse (DWH). These data are stored in a multidimensional database, which is the basis for OLAP. The structures, which contain the data are called info cubes (synonyms: hyper cube, data cube ...).

The content of an info cube is determined mainly by the analysis topic, the needed level of detail, the user groups, who have to access the cube, the intervalls in which the cubes need to be updated and other factors.

Subsets of the data warehouse are being distributed into data marts, which contain departmental information.

Previous Slide Show Current Slide Next Slide
Table of Contents
This page was build by Uwe Wahser (uwe@wahser.de)
Last Revision: July 2001