Shapes of things to come
Post categories: Design,ÌýTechnology
| 11:57 UK time, Monday, 21 April 2008
Possibly not a post of interest to many but we thought we'd share our /programmes schema with you. It's just going through a major rewrite, the results of which should be live on the site soon-ish. In the meantime we hope you think it's as pretty as we do.
It's probably best to note that whilst /programmes and iPlayer take their data from a common pot (PIPs) this is not the schema of either PIPs or iPlayer but has been reshaped slightly for our publishing platform.
If this is of interest you might also like to compare and contrast with the .
Updates
-
01-06-2008 uploaded schema 1.38
Comment number 1.
At 22nd Apr 2008, Frankie Roberto wrote:I still don't get the logic behind having both Episodes and Series/Brands in the same table. Surely they're completely different beasts?
Complain about this comment (Comment number 1)
Comment number 2.
At 22nd Apr 2008, Jonathan Tweed wrote:Whilst they initially look like three separate things, brands, series and episodes are all editorial grouping constructs that have pretty much the same metadata.
This is also the approach taken by TV-Anytime, where what we call brands, series and episodes are represented by GroupInformation elements of type show, series and programConcept.
Complain about this comment (Comment number 2)
Comment number 3.
At 23rd Apr 2008, fantasticlife wrote:It's kind of an editorial / audience vs production distinction. In the editorial world episodes are items and series / brands are groups of items. But PIPs models down to versions - it's versions that are broadcast, versions that appear in iplayer etc. Episodes group versions, series + brands group episodes. So episodes, series and brands are all just groups.
Complain about this comment (Comment number 3)
Comment number 4.
At 23rd Apr 2008, Jonathan Tweed wrote:I'd argue that the versions in PIPs are also editorial, but you do have to careful how they are exposed in audience facing UIs.
We have to flatten production versions to create the audience facing ones (signed, shortened, etc).
Complain about this comment (Comment number 4)