Validating the model
2 posters
Page 1 of 1
Validating the model
Hi,
Is there a quicker way to validate the data model?
Is there a quicker way to validate the data model?
dbadwh- Posts : 31
Join date : 2011-09-30
Re: Validating the model
How are you validating it now?
BoxesAndLines- Posts : 1212
Join date : 2009-02-03
Location : USA
Re: Re: Validating the model
Manually checking each dimension, facts and relationships. Cross verifying with Functionality and so on.
But just want to know any other validation mechanism where we can validate it quickly. And I need it currently.
But just want to know any other validation mechanism where we can validate it quickly. And I need it currently.
dbadwh- Posts : 31
Join date : 2011-09-30
Re: Validating the model
Given an existing database target, you can "complete compare" a model against the database tables and view the differences. If it is a new model, the model should be validated against a source to target specification. You can also build into the modeling tool rules to ensure the correct data types and lengths are chosen as well as indexes, constraint names, table names, and column names. Unfortunately, there's no way to validate that what is modeled is actually "correct" in that in meets its intended purpose without someone looking at it.
BoxesAndLines- Posts : 1212
Join date : 2009-02-03
Location : USA
Re: Validating the model
Actually I want to validate the logical model, which is little bit big enough. It is very tedious to find how each tables are linked and whether the linked correctly, satisfying the cardinality and granularity. If there is a quicker method or process to ensure the correctness at least to some level, it would be great. Since, we can be little bit confidence .
dbadwh- Posts : 31
Join date : 2011-09-30
Similar topics
» credit card model
» Rule based algorithm to convert an ER model to a dimensional model
» Complexities of Relational Model and Simplicities of Dimensional Model
» Why we use Dimensional Model over De-normalized relational Model ?
» Meta-model of Kimball dimensional model
» Rule based algorithm to convert an ER model to a dimensional model
» Complexities of Relational Model and Simplicities of Dimensional Model
» Why we use Dimensional Model over De-normalized relational Model ?
» Meta-model of Kimball dimensional model
Page 1 of 1
Permissions in this forum:
You cannot reply to topics in this forum