Re: Works and instances

On Mon, Jan 7, 2013 at 11:39 AM, Laura Dawson <ljndawson@gmail.com> wrote:
> When I was at Muze (now Rovi), which aggregates data about books, music,
> movies, and video games, we used the example of "The Godfather", which is
> a book, a soundtrack, several movies, and a video game. We wanted to
> define the concept/story of "The Godfather" uniquely, and branch out by
> type of product from that.

That's an interesting example.  One way to model it would be like this:

Book http://www.freebase.com/view/m/0c8zk
  linked to 26 editions, the movie, and the sequels
Movie http://www.freebase.com/view/en/the_godfather
  linked to 48 releases, the soundtrack, the sequels, and the video games
Video game http://www.freebase.com/view/en/the_godfather_the_game
  linked to 9 different game platform releases
Soundtrack http://www.freebase.com/view/m/01jrzr6
  linked to releases on LP & CD (http://www.freebase.com/view/m/0310kvs)
Movie sequel http://www.freebase.com/view/en/the_godfather_part_ii
Movie sequel http://www.freebase.com/view/en/the_godfather_part_iii
Book sequel http://www.freebase.com/view/en/the_sicilian
Movie adaptation of the book sequel http://www.freebase.com/view/m/0280rsv
Subject of The Sicilian http://www.freebase.com/view/en/salvatore_giuliano
Opera Salvatore Giuliano http://www.freebase.com/view/m/04j6s8q
Book about the opera
http://www.freebase.com/view/en/nascita_di_unopera_salvatore_giuliano
the sole edition of that book http://www.freebase.com/view/m/0pd67pk
linked to its OpenLibrary entry
http://openlibrary.org/books/OL19739222M/Nascita_di_un'opera_Salvatore_Giuliano

All the pages are linked to Wikipedia, Netflix, OpenLibrary,
MusicBrainz, LCNAF, VIAF, etc as appropriate.

There are obviously lots of ways to model this, but I think the
important thing is to work with real world data in the schema and get
experience with what works and what needs to be modified.  I helped
this example a bit by adding a UPC code to the CD release and creating
the final book edition entry, but everything else was there already
fully populated in an existing schema, so it's not an impossible task.

Another view of this data can be had by just typing "The Godfather"
into Google.  It's apparently decided that's the movie, but it also
suggests the related search "The Godfather novel."

Tom

Received on Monday, 7 January 2013 18:46:41 UTC