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.


7 comments:

Unknown said...

very nice information thanks for sharing it

www.tasflowrance.com

Unknown 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

Unknown said...

Thanks for sharing.
Data Mining software service providers

Afsal said...

Good contentData Mining software services India

digitmgmsa said...

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

digitmgmsa 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