[Data-modeling] Mining TV shows productions

[Stefano Mazzocchi]

Alexander Marks wrote:
> "program_creator" connects to the person who conceived the show, while "tv_producer" connects to a producer (which can be a person or a company, presumably) via the "tv_producer_term" CVT. If you want to constrain the producer, you need to hop through the CVT, and I don't think creator is useful to your query at all.

D'oh! the CVT... that's what threw me off.

Thanks much, all clear now.

> 
> Al
> 
> ----- Original Message -----
> From: "Stefano Mazzocchi" <stefano at metaweb.com>
> To: data-modeling at freebase.com
> Sent: Tuesday, March 17, 2009 9:05:03 AM GMT -08:00 US/Canada Pacific
> Subject: [Data-modeling] Mining TV shows productions
> 
> I was exploring the TV-related data in freebase and found out that some 
> TV programs have 'program_creator' while others have 'tv_producer' and 
> some both. So I ran this query to understand the difference between the 
> two fields from the data they contained
> 
> [{
>    "type" : "/tv/tv_program",
>    "id" : null,
>    "name" : null,
>    "program_creator": [{
>      "id": null,
>      "*": null
>    }],
>    "tv_producer": [{
>      "id": null,
>      "*": null
>    }]
> }]
> 
> and made a puzzling discovery: program_creator contains people while 
> tv_producer contains a '/tv/tv_producer_term'.
> 
> As I'm trying to find sets of TV shows that were produced by the same 
> producer, but I find that the way the data is currently modeled makes it 
> pretty hard to do that.
> 
> Am I missing something?
> 
> TIA
> 


-- 
Stefano Mazzocchi                              Application Catalyst
Metaweb Technologies, Inc.                      stefano at metaweb.com
-------------------------------------------------------------------