Introduction of the term Dimensional Modeling

Question

Give a brief introduction of the term Dimensional Modeling?

Answer 1

Dimensional modeling is one of the reasonable design methods employed in data warehousing. It is various from entity-relationship model. If useful to relational databases, and done appropriately, it is second or third normal form. It does not essentially include relational database. The valid level of modeling approach can be useful in physical form like flat files or database tables. It is one of the methods for the support of end-user queries in data warehousing. On different to database administration, it is tilting around understandability.