Fred van den Driessche

b is for broadcasts

This is the second article in the Atlas A-Z series, brought to you by the letter B. B is for Broadcasts.

Broadcasts, along with on-demand locations, are one of the core pieces of metadata that Atlas holds about a show. At the time of writing, Atlas contains almost 30 million broadcasts across 10 million items from broadcast sources.

Broadcast detail a number of pieces of information:

  • Channel: on which the broadcast took place. Since channels are complex and change surprisingly often, this is stored internally as a reference to the channel which is resolved as necessary on output.

  • Interval: the start and end instances of the broadcast, stored and output as UTC date-times in full ISO-8601 format.

  • Id: the external source identifier for the broadcast.

  • Flags: describing if the broadcast is:

    • repeat
    • subtitled
    • signed
    • audio described
    • high definition
    • widescreen
    • surround
    • live
    • new series
    • new episode
    • premiere

On output broadcasts look something like:

Broadcasts are stored internally inside their items since there’s a one-to-many relationship between them, as shown below left. This relationship is inverted and denormalized to form schedules, shown below right.

schedule

items-and-broadcasts

That’s the important info about broadcasts in Atlas. If you have any questions or comments please get in touch below or on the mailing list. Next time: C is for Content.

blog comments powered by Disqus