dimensional modeling


Also found in: Dictionary, Thesaurus, Medical, Wikipedia.

dimensional modeling

A database model that focuses on decision support outcomes rather than the normal relationships between data sets as in an entity relationship (ER) model. ER models are "normalized" models that are designed to reduce redundancy and provide fast online transaction processing. An ER model of a company's data may result in hundreds of data tables, and complex queries become extremely cumbersome to formulate.

In contrast, dimensional models are many-to-many relationships that deal with the way business people think about their operation. The "fact table" is the highlight of a dimensional model and is visualized at the center of a star schema surrounded by dimension tables. See entity relationship model and normalization.
Copyright © 1981-2019 by The Computer Language Company Inc. All Rights reserved. THIS DEFINITION IS FOR PERSONAL USE ONLY. All other reproduction is strictly prohibited without permission from the publisher.
References in periodicals archive ?
RPD success is dependent on knowledge of a few principles, which include dimensional modeling and data modeling.
He also offers detailed descriptions of techniques for both dimensional analysis and dimensional modeling.