Questions about modelling an event fact table

View previous topic View next topic Go down

Questions about modelling an event fact table

Post  gforsmo on Sat Dec 01, 2012 11:09 am

Hello again!

I allows me to send another request in this forum. Accidents are often modeled as event-based fact-less tables. In connection with the accident, we injured people and there may be more injuries associated with the same incident. Beyond this, each person can also be injured body parts. In theory, we have 3 less fact tables but those tables've got a connection to each other. One could of course make a great table by accident but then aggrerere number of injuries per accident, number of injured body parts per accident but we must be able to report on injured people and injured body parts in different varieties. I want to get input from you expert contributors

regards

Geir

gforsmo

Posts : 3
Join date : 2012-12-01

View user profile

Back to top Go down

Re: Questions about modelling an event fact table

Post  John Simon on Sat Dec 01, 2012 8:23 pm

I've got some blog posts on this:
http://jsimonbi.wordpress.com/2011/01/16/data-modeling-conundrum/

https://jsimonbi.wordpress.com/2011/03/17/data-modeling-conundrum-follow-up/

I like Marco Russo's suggestion at the end of the second post.


John Simon

Posts : 186
Join date : 2009-05-29
Location : Melbourne, Australia

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

Back to top Go down

Re: Questions about modelling an event fact table

Post  gforsmo on Sat Dec 01, 2012 9:45 pm

Thanks for your respond on my question. I will study these articles with interests

gf

gforsmo

Posts : 3
Join date : 2012-12-01

View user profile

Back to top Go down

Re: Questions about modelling an event fact table

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