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.


5 comments:

Unknown said...

very nice information thanks for sharing it

www.tasflowrance.com

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

Unknown said...

Thanks for sharing.
Data Mining software service providers

digitmg_hyd said...

cool stuff you have and you keep overhaul every one of us
ai course in nashik

digitmg_hyd said...

Great post i must say and thanks for the information. Education is definitely a sticky subject. However, is still among the leading topics of our time. I appreciate your post and look forward to more.
ai course in nashik