| |
GeekInterview.com > Interview Questions > Data Warehousing > Basics
| Print | |
Question: What is Dimensional Modelling
|
| July 07, 2005 20:35:50 |
#4 |
| Kenny |
Member Since: Visitor Total Comments: N/A |
RE: What is Dimensional Modelling
|
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 |
| |
Back To Question | |
