Logical Dimensional Model
2 posters
Page 1 of 1
Logical Dimensional Model
Is there such a thing as a logical dimensional model? If you agree, how is it different than your physical dimensional model?
BoxesAndLines- Posts : 1212
Join date : 2009-02-03
Location : USA
Re: Logical Dimensional Model
There are always logical and physical models, for all the normal reasons... physical table and column names may be different to fit some internal standard, definition of index structures and other physical manifestations of the data base. But beyond that, I personally don't see the need to present either in a different form.
I have seen cases where the logical model represents dimensional roles as separate entities (sometimes even manifested as views), but this seems to be a lot of extra work without doing much to improve the overall understanding of the model.
I have seen cases where the logical model represents dimensional roles as separate entities (sometimes even manifested as views), but this seems to be a lot of extra work without doing much to improve the overall understanding of the model.
Similar topics
» Logical Data Model - Clients
» Tool to capture physical metadata, logical business model and relationship between the two?
» 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 ?
» Tool to capture physical metadata, logical business model and relationship between the two?
» 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 ?
Page 1 of 1
Permissions in this forum:
You cannot reply to topics in this forum