dimensional modeling

(redirected from dimensional model)

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.
References in periodicals archive ?
Currently, the three dimensional model doesn't have the accurate texture or the feel of a real finger but has advanced fingerprint sensing and matching technology.
The VDS uses Knowledge Based Reconstruction to automatically compare the points to a database and generate a three dimensional model.
Whether personality disorders are discrete conditions or dimensions of the functioning of general personality is the main question addressed by these 26 papers and commentary, with the general objective being to incorporate a dimensional model of personality disorder with the next edition of the DSM.
Data warehouse developments, to include dimensional model design, warehouse and OLAP cube development, reporting and associated governance procedures.
As the data is interpreted a three dimensional model will be generated for each mineral body detected.
The data will be interpreted and a three dimensional model generated for each mineral body detected.
The available SQL Server 2005 toolkits cover topics such as the Unified Dimensional Model (UDM), migration tips, data visualization, and reporting and analytics.
This third updated edition provides an in-depth library of dimensional modeling techniques, is updated with new insights and best practices, and provides models for designing dimensional models for those new to the concept of data warehousing as well as those who already work with such systems.
Guidelines for designing dimensional models are illustrated using real-world data warehouse case studies drawn from a variety of business areas.
0 beta of the Pliable Display Technology (PDT) Software Development Kit and the PDT 3d SDK beta featuring platform support for Mac OS X and "PDT 3d", a new application of PDT that extends "detail-in-context" viewing functionality to three dimensional models.
We isolated the building blocks that dictate insect growth-enzymes and receptors, then built three- dimensional models of them.