[Data-modeling] Mining TV shows productions

[Alexander Marks]

"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.

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
-------------------------------------------------------------------

_______________________________________________
Data-modeling mailing list
Data-modeling at freebase.com
http://lists.freebase.com/mailman/listinfo/data-modeling