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.



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