[Data-modeling] Olympics domain for review

Jeff Prucher jeff at metaweb.com
Wed Mar 26 19:06:18 UTC 2008


I think the denormalization is acceptable, because it permits the storing of
what would otherwise be partial information. E.g., say you have a list of
the Games at which each event in Tennis was contested, but you don't have
the list of medalists for every event/Olympics combo (such as the first
table in this WP article:
http://en.wikipedia.org/wiki/Tennis_at_the_Summer_Olympics). With the
denormalization, you could simply input the data you had. Otherwise, you'd
have to either omit the data, or create medalist entries with only the event
filled in, which would be a bit odd.

I'd vote "yea" for demonstration sports.

To answer one of your questions from the domain documentation, there have
been tennis mixed doubles events in the Olympics.

Jeff

> -----Original Message-----
> From: data-modeling-bounces at freebase.com 
> [mailto:data-modeling-bounces at freebase.com] On Behalf Of 
> Kirrily Robert
> Sent: Wednesday, March 26, 2008 11:26 AM
> To: data-modeling
> Subject: [Data-modeling] Olympics domain for review
> 
> So I have this user domain about the Olympics, at 
> http://www.freebase.com/view/user/skud/olympics and I'd love 
> some people to take a look at it.
> 
> The main thing that I'm undecided about is that the events 
> contested in a given Olympic Games and the medals awarded are 
> kind of redundant/denormalised.  That is, the same 
> information is appearing twice.  But if you make it so it 
> only appears once, under medals awarded, it would seem to 
> discourage people from entering in events for which the 
> medals are not yet awarded or are unknown.
> 
> The other thing I'm considering adding is demonstration events/sports.
> 
> Comments welcome.
> 
> K.
> 
> --
> Kirrily Robert
> Freebase Community Director
> kirrily at metaweb.com
> 
> _______________________________________________
> Data-modeling mailing list
> Data-modeling at freebase.com
> http://lists.freebase.com/mailman/listinfo/data-modeling
> 



More information about the Data-modeling mailing list