What is Dimensional Modeling?
Dimensional modeling a discipline of logical data modeling which addresses the data modeling requirements of databases for end-user query and analysis applications. The dimensional modeling has been formalized and popularized by the leading luminary in the field of data warehousing, Ralph Kimball. The focus of dimensional models is end user understandability of data, handling of historical data in the changing business environment, high query performance and consistent query performance in an ad-hoc query environment.
