dimensional modeling

Also found in: Wikipedia

0.01 sec.

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.

Want to thank TFD for its existence? Tell a friend about us, add a link to this page, add the site to iGoogle, or visit the webmaster's page for free fun content.

?Page tools

Printer friendly
Cite / link

Feedback

Mentioned in	?		References in periodicals archive	?		Encyclopedia browser	?		Full browser	?
No references found			50 Dimensional modeling has become an approach for data warehouse design. The Data Warehouse Toolkit, Second Edition: The Complete Guide to ... by Software World With a dimensional modeling approach, many of the traditional normalization techniques are not utilized. Salvaging Information Engineering Techniques In A Data Warehouse ... by Politano, Anthony L. / Computer Technology Review Part II Dimensional Modeling and Data Warehouse Design. Research and Markets: Pentaho Solutions: Business Intelligence and ... by Business Wire			DIMATE Dimbleby Dimbokro Dimbovita Dîmbovita Dimcho Debelianov dime dime novels dimedone Dimension dimension declaration statement dimension line dimension lumber dimension ratio dimension shingles dimension stock dimension stone dimension stone tile dimension stuff dimension table dimension theory dimension work Dimensional Analysis dimensional constant dimensional formula dimensional modeling dimensional regularization dimensional stability dimensionally stable dimensioning dimensionless group Dimensionless groups dimensionless number Dimensionless Quantities Dimensions dimer dimercaprol dimeric water dimerization dimerous dimetan dimethachlon dimethicone Dimethoate dimethrin dimethyl dimethyl carbate dimethyl diaminophenazine chloride dimethyl ether dimethyl ketone dimethyl phthalate			Dimensional Change Card Sort dimensional constant Dimensional Control Systems, Inc. Dimensional Controller Nodes dimensional data dimensional data dimensional data dimensional data Dimensional Data Warehouse Dimensional Drawing Dimensional Fact dimensional formula Dimensional Fund Advisors Inc. Dimensional Fund Advisors Ltd. Dimensional Fx Dimensional Hammer Otaku Society Dimensional Health Care Associates, Inc Dimensional Insight Users Conference Dimensional Installation Drawings Dimensional lumber Dimensional lumber Dimensional lumber Dimensional Measurement Interface Specification Dimensional Measurement Interface Standard Dimensional Measurement, Inc Dimensional Metals Inc. Dimensional Metrology Laboratory Dimensional Metrology Standards Consortium dimensional model dimensional modeling Dimensional Paper Model Dimensional regularization dimensional stability dimensional stability dimensional stability dimensional stability dimensional stability Dimensional Vector Packing Problem Dimensional weight Dimensional wood Dimensional wood Dimensional wood Dimensional Yale-Brown Obsessive-Compulsive Scale dimensionality dimensionality dimensionality dimensionality dimensionally dimensionally dimensionally dimensionally dimensionally stable Dimensionally Stable Anode Dimensionally-Modeled Relational Dimensionalysis dimensioned dimensioned dimensioned dimensioned Dimensionful

Encyclopedia

Free Tools:	For surfers: Free toolbar & extensions \| Word of the Day \| Help For webmasters: Free content \| Linking \| Lookup box \| Double-click lookup

Disclaimer
All content on this website, including dictionary, thesaurus, literature, geography, and other reference data is for informational purposes only. This information should not be considered complete, up to date, and is not intended to be used in place of a visit, consultation, or advice of a legal, medical, or any other professional.