Kimball Forum
Would you like to react to this message? Create an account in a few clicks or log in to continue.

Fact modeling for DVD Rental Shop

3 posters

Go down

Fact modeling for DVD Rental Shop Empty Fact modeling for DVD Rental Shop

Post  DreamingFighter Wed Jul 10, 2013 12:45 am

I everyone, I'm having an issue with modeling fact table that need advice here

Currently I'm building reporting system for a DVD rental shop. When the customer rent a DVD, the system would create a record in database, and when he return it, the system would update return time on that record.

I'm going to create 2 fact table, 1 for rent action, 1 for return action. What do you think about this approach? Will it work? Please give me advice on this issue.

Thank you.
DreamingFighter
DreamingFighter

Posts : 6
Join date : 2012-10-22

Back to top Go down

Fact modeling for DVD Rental Shop Empty Re: Fact modeling for DVD Rental Shop

Post  BoxesAndLines Wed Jul 10, 2013 9:09 am

You do need two fact tables, just not the two you described. You need a transacation fact to hold all of the customer transactions, rent, return, buy, etc. And you need an accumulating snapshot fact table to track rentals from start to end.
BoxesAndLines
BoxesAndLines

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

Back to top Go down

Fact modeling for DVD Rental Shop Empty Re: Fact modeling for DVD Rental Shop

Post  ngalemmo Wed Jul 10, 2013 2:37 pm

And do it quick... DVD rental shops won't be around much longer.
ngalemmo
ngalemmo

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

http://aginity.com

Back to top Go down

Fact modeling for DVD Rental Shop Empty Re: Fact modeling for DVD Rental Shop

Post  BoxesAndLines Wed Jul 10, 2013 6:38 pm

LOL, no kidding. I figured it was homework.
BoxesAndLines
BoxesAndLines

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

Back to top Go down

Fact modeling for DVD Rental Shop Empty Re: Fact modeling for DVD Rental Shop

Post  DreamingFighter Thu Jul 11, 2013 2:34 am

Not in my country, we don't have hulu or xbox or whatever

I would just do as you said, it's simple request with simple reporting forms anyway.

DreamingFighter
DreamingFighter

Posts : 6
Join date : 2012-10-22

Back to top Go down

Fact modeling for DVD Rental Shop Empty Re: Fact modeling for DVD Rental Shop

Post  Sponsored content


Sponsored content


Back to top Go down

Back to top

- Similar topics

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