Dimensional Modeling for Data Warehouse

Many surveys indicate that a significant percentage of DWs fail to meet business objectives or are outright failures. In this paper, the authors are describing about multidimensional data model for the DWs, which will help in surround facts with as much relevant context dimensions. Multidimensionality is just a design technique that separates the information into facts and dimensions. It gives rise to schema with star shape, Consists of a fact table with a single table for each dimension. Snowflake Schema is a variation of star schema, in which the dimensional tables from a star schema are organized into a hierarchy by normalizing them.

Provided by: GGS Indraprastha University Topic: Big Data Date Added: Mar 2010 Format: PDF

Download Now

Find By Topic