Logical Dimensional Model

View previous topic View next topic Go down

Logical Dimensional Model

Post  BoxesAndLines on Mon Mar 08, 2010 10:00 am

Is there such a thing as a logical dimensional model? If you agree, how is it different than your physical dimensional model?
avatar
BoxesAndLines

Posts : 1212
Join date : 2009-02-03
Location : USA

View user profile

Back to top Go down

Re: Logical Dimensional Model

Post  ngalemmo on Tue Mar 09, 2010 12:24 pm

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.
avatar
ngalemmo

Posts : 3000
Join date : 2009-05-15
Location : Los Angeles

View user profile http://aginity.com

Back to top Go down

View previous topic View next topic Back to top

- Similar topics

 
Permissions in this forum:
You cannot reply to topics in this forum