|
What is Dimensional Modeling?Dimensional modeling is often used in Data warehousing. In simpler words it is a rational or consistent design technique used to build a data warehouse. DM uses facts and dimensions of a warehouse for its design. A snow and star flake schema represent data modeling.What is Dimensional Modeling?Dimensional modeling is one of the logical design techniques used in data warehousing. It is different from entity-relationship model. If applied to relational databases, and done properly, it is 2nd or 3rd normal form. It does not necessarily involve relational database. The logical level of modeling approach can be applied in physical form like database tables or flat files. It is one of the techniques for the support of end-user queries in data warehousing. On contrary to database administration, it is oriented around understandability.
|
