Modeling an attribute that belongs in more than one dimension

View previous topic View next topic Go down

Modeling an attribute that belongs in more than one dimension

Post  gbaren on Wed Feb 19, 2014 12:48 pm

The fact table is transactions at a kiosk. The identification of the machine is qualified by the store where it is located. It is not identified uniquely without the store. The store is also part of the Location and owner dimensions.

What's the best way to model something like this?

Thanks in advance!

gbaren

Posts : 15
Join date : 2014-01-30
Location : 02

View user profile http://equalsql.wordpress.com

Back to top Go down

Re: Modeling an attribute that belongs in more than one dimension

Post  ngalemmo on Wed Feb 19, 2014 1:27 pm

Include store as part of the natural key. You may also include store as an attribute of the dimension. The fact would carry store, kiosk, location & owner as dimensions.
avatar
ngalemmo

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

View user profile http://aginity.com

Back to top Go down

Re: Modeling an attribute that belongs in more than one dimension

Post  gbaren on Wed Feb 19, 2014 1:53 pm

Thank you for the quick response!

There's an added complication, the device dimension is an SCD as the kiosk is configured to be different things and the configuration is relevant to the transaction. So, a natural key is, I guess, not applicable.

This is my first modeling project, so please forgive any unrefined assumptions and other stupidity. Add to that that "they" won't let me use actual scenarios and I'm forced to paint analogies while asking for help.



gbaren

Posts : 15
Join date : 2014-01-30
Location : 02

View user profile http://equalsql.wordpress.com

Back to top Go down

Re: Modeling an attribute that belongs in more than one dimension

Post  ngalemmo on Wed Feb 19, 2014 2:10 pm

There is ALWAYS a natural key. Assuming the configuration is dynamic, you should implement a separate configuration dimension and use the kiosk dimension to identify the particular machine.

The configuration dimensions would be Type 1 and referenced from the fact identifying the configuration in place at the time of the transaction.
avatar
ngalemmo

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

View user profile http://aginity.com

Back to top Go down

Re: Modeling an attribute that belongs in more than one dimension

Post  gbaren on Wed Feb 19, 2014 2:13 pm

I'm beginning to see the picture. Thank you!

gbaren

Posts : 15
Join date : 2014-01-30
Location : 02

View user profile http://equalsql.wordpress.com

Back to top Go down

Re: Modeling an attribute that belongs in more than one dimension

Post  Sponsored content


Sponsored content


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