[Data-modeling] TV sub-episodes

[Jeff Prucher]

There was a request to create a model for sub-sections of a TV show. The particular use case was for Monty Python's Flying Circus sketches, but the pattern is pretty  common. To make a long story short:

http://www.sandbox-freebase.com/view/user/typelibrarian/default_domain/views/tv_segments

The model is basically a new type (TV Episode Segment), with several of the properties from TV Episode duplicated onto it: Writer, Director, Performer. I could add Personal Appearances, Crew, Producer, etc., if anyone ever had a need for them.

This would potentially result in a denormalization of sorts, since the list of people involved in a show comprising multiple segments should be the union of the list of people for each segment. I think we can live with this, but it might look a bit odd to some people.

I'm also not convinced that "segment" is the right term, since news programs (for example) can be organized into things called segments that are different than what I'm trying to model.

Commments?

Jeff

PS: original discussion: 
http://www.freebase.com/view/guid/9202a8c04000641f800000000abbdd61
JIRA: https://bugs.freebase.com/browse/DA-620