Sep 26, 2009

Dimensional Modeling


Dimensional Modeling refers to the technique used to design logical models for database which can support OLAP and Data Warehousing operations. It differs from the relational modeling or ER modeling in the sense that it can be used for data warehouse as well as relational databases.

Dimensional modeling is based on two concepts called facts and dimensions. Facts are usually numeric values or something that can be measured or aggregated. For example: monthly sales amount. Dimensions are groups of hierarchies and attributes that are used to define facts. For example product and its color. In a dimensional model a group of facts forms a fact table while a group of dimensions form a dimension table.


3 comments:

Tas said...

very nice information thanks for sharing it

www.tasflowrance.com

benslin kard said...

Data warehousing is used to view day-to-day operations, but its primary function is often strategic planning based on long-term data overviews.

Iweb said...

hey nice source for me,thanks for sharing this of the data mining.This information very helpful for me.thanks

business directory data mining