[Data-modeling] Mining TV shows productions

Stefano Mazzocchi stefano at metaweb.com
Tue Mar 17 16:05:03 UTC 2009


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



More information about the Data-modeling mailing list