Nirav

• May 14th, 2005

 

In Dimensional Modeling, Data is stored in two kinds of tables: Fact Tables and Dimension tables.  
Fact Table contains fact data e.g. sales, revenue, profit etc..... 
Dimension table contains dimensional data such as Product Id, product name, product description etc.....

Meenal

• Jul 14th, 2005

 

Dimensional Modelling is a design concept used by many data warehouse desginers to build thier datawarehouse. In this design model all the data is stored in two types of tables - Facts table and Dimension table. Fact table contains the facts/measurements of the business and the dimension table contains the context of measuremnets ie, the dimensions on which the facts are calculated.

Kenny

• Jul 18th, 2005

 

Why is Data Modeling Important? 
 
Data modeling is probably the most labor intensive and time consuming part of the development process. Why bother especially if you are pressed for time? A common response by practitioners who write on the subject is that you should no more build a database without a model than you should build a house without blueprints.  
 
The goal of the data model is to make sure that the all data objects required by the database are completely and accurately represented. Because the data model uses easily understood notations and natural language , it can be reviewed and verified as correct by the end-users.  
 
The data model is also detailed enough to be used by the database developers to use as a "blueprint" for building the physical database. The information contained in the data model will be used to define the relational tables, primary and foreign keys, stored procedures, and triggers. A poorly designed database will require more time in the long-term. Without careful planning you may create a database that omits data required to create critical reports, produces results that are incorrect or inconsistent, and is unable to accommodate changes in the user's requirements.

Kenny

• Jul 18th, 2005

 

Steps In Building the Data Model  
 
While ER model lists and defines the constructs required to build a data model, there is no standard process for doing so. Some methodologies, such as IDEFIX, specify a bottom-up development process were the model is built in stages. Typically, the entities and relationships are modeled first, followed by key attributes, and then the model is finished by adding non-key attributes. Other experts argue that in practice, using a phased approach is impractical because it requires too many meetings with the end-users. The sequence used for this document are:  
 
Identification of data objects and relationships  
 
Drafting the initial ER diagram with entities and relationships  
Refining the ER diagram  
 
Add key attributes to the diagram  
 
Adding non-key attributes  
 
Diagramming Generalization Hierarchies  
 
Validating the model through normalization  
 
Adding business and integrity rules to the Model

Rahul Katakam

• Aug 19th, 2005

 

Dimensional Modeling is a logical design technique that seeks to present the data in a standard, intuitive framework that allows for high-performance access. It is inherently dimensional, and it adheres to a discipline that uses the relational model with some important restrictions. Every dimensional model is composed of one table with a multipart key, called the fact table, and a set of smaller tables called dimension tables. Each dimension table has a single-part primary key that corresponds exactly to one of the components of the multipart key in the fact table. Dimensional Modeling

AS VENKATESH

• Aug 31st, 2005

 

It's a process or technique of designing a database model.

saravanan

• Dec 2nd, 2005

 

a centralized table is called as fact table which is connected to multiple dimension table is called as dimensional modelling or star schema

Sithu

• Dec 23rd, 2005

 

Systematic arrangement of Fact/Dimension tables are called as Schema, the designing a schema in data warehouse / data mart is known as Dimension modeling

 

Cheers

Sithu

sithusithu

 Profile Answers by sithusithu 

• Jan 10th, 2006

 

 

Systematic arrangement of Fact/Dimension tables are called as Schema, the designing a schema in data warehouse / data mart is known as Dimension modeling

 

Cheers

Sithu

ravi kumar guturi

• Mar 9th, 2006

 

Dimensional Modeling , It is a modeling technic used in OLAP system,

Here one fact table and sarounded by diffrent dimensions,

ANIL

• Jun 28th, 2006

 

HI, Dimensional modeling is a design discipline that straddles the formal relational model and the engineering realties of text and number data. Comapred to E/R modeling , it's less rigorous but more practical because it accommodates database complexity and improves performance.

chandrarekha

• May 7th, 2007

 

Dimension modeling is an approach or methodology used to design the star schema data base
dimensional modeling consists of 3 phases
conceptual modeling
logical modeling
physical modeling

Sridhar Tirukovela

• Jun 26th, 2007

 

Analyzing the transactional data based on the master data by using fact tables and dimension tables.

jgd.ramesh

• Aug 15th, 2007

 

It is logical design techniques and visual techinques it can be contain aggregate table, dimension table, fact table

rk_dwh

 Profile Answers by rk_dwh 

• May 27th, 2008

 

Dimensional modelling consist of 3 stages
1.conceptual Requirements
here business architect should be clear with facts and levels (data for Dimension table)
2.Logical requirements
here he has to design dimension table with levels, and c=fact table with facts and compisite keys and make relation between dimension and fact table
3. Physical modelling
Implementing Logical struture in to database physically using modelling tools like erwin model

plz rectify if any wrong

blsashok

 Profile Answers by blsashok 

• Aug 2nd, 2010

 

For build any DB, It needs to be designed first. So Dimentional modeling is used to design the dataware house DB. It can be done by two ways. Star schema, snowflake schema.
We generally follow the denormalisation method for the dimentional modeling.
It is used to design dataware house database.

kevin0209

 Profile Answers by kevin0209 

• Aug 30th, 2010

 

Dimension modelling is a logical design technique that seeks to present the data in a standard framework that allows users for high performance accesss.

rajnsuccess

 Profile Answers by rajnsuccess 

• Jan 10th, 2011

 

Dimensional Modelling is a design concept used by many data warehouse desginers to build thier datawarehouse. In this design model all the data is stored in two types of tables - Facts table and Dimension table. Fact table contains the facts/measurements of the business and the dimension table contains the context of measuremnets ie, the dimensions on which the facts are calculated.