Abstract: Methods, algorithms, database structures, and reports for informing consumers of changes in times and channels at which episodes of a television (TV) series are aired on television each week. Based on prior TV listings, an expected time-channel (i.e., day-of-week, time, and channel) for airing a TV series is derived. Actual time-channels for a given week are compared with the expected time-channels to determine whether a deviation from the expected time-channel has occurred. If the deviation has occurred, then the deviation is classified, stored in a database, and transferred to a report that shows a list of such deviations for various TV series.

Abstract: Methods, algorithms, database structures, and reports for informing consumers of changes in times and channels at which episodes of a television (TV) series are aired on television each week. Based on prior TV listings, an expected time-channel (i.e., day-of-week, time, and channel) for airing a TV series is derived. Actual time-channels for a given week are compared with the expected time-channels to determine whether a deviation from the expected time-channel has occurred. If the deviation has occurred, then the deviation is classified, stored in a database, and transferred to a report that shows a list of such deviations for various TV series.

Abstract: A method and timezone database structure for generating, storing, and using information for performing timezone-related calculations, such as flexible and efficient conversion of dates and times from one timezone to another. The timezone database structure includes a first table and a second table. The first table relates timezones to timezone identifiers. The second table relates the timezone identifiers to local shift times and associated anchor shift times. The timezone database structure may be generated for a local timezone from knowledge of: the date and time of shift in local time, the amount and direction of the shift, the Standard Time offset between the local timezone and an anchor time, and an Advanced Time offset of the local timezone relative to Standard Time.