CA2442634C - Distribution of real-time entertainment scheduling data - Google Patents
Distribution of real-time entertainment scheduling data Download PDFInfo
- Publication number
- CA2442634C CA2442634C CA2442634A CA2442634A CA2442634C CA 2442634 C CA2442634 C CA 2442634C CA 2442634 A CA2442634 A CA 2442634A CA 2442634 A CA2442634 A CA 2442634A CA 2442634 C CA2442634 C CA 2442634C
- Authority
- CA
- Canada
- Prior art keywords
- database
- real
- user
- dataset
- entertainment
- Prior art date
- Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
- Expired - Lifetime
Links
- 238000009826 distribution Methods 0.000 title claims description 5
- 238000004891 communication Methods 0.000 claims abstract description 36
- 238000000034 method Methods 0.000 claims abstract description 25
- 238000012546 transfer Methods 0.000 claims abstract description 4
- 238000012986 modification Methods 0.000 claims description 12
- 230000004048 modification Effects 0.000 claims description 12
- 238000000605 extraction Methods 0.000 claims description 5
- 238000012937 correction Methods 0.000 claims description 4
- 230000001419 dependent effect Effects 0.000 description 7
- 238000004590 computer program Methods 0.000 description 4
- 238000013519 translation Methods 0.000 description 4
- 238000012545 processing Methods 0.000 description 3
- 238000003860 storage Methods 0.000 description 3
- 230000005540 biological transmission Effects 0.000 description 2
- 230000003203 everyday effect Effects 0.000 description 2
- 230000003287 optical effect Effects 0.000 description 2
- 230000036962 time dependent Effects 0.000 description 2
- 230000001960 triggered effect Effects 0.000 description 2
- 238000012935 Averaging Methods 0.000 description 1
- 208000032041 Hearing impaired Diseases 0.000 description 1
- 230000008901 benefit Effects 0.000 description 1
- 230000008859 change Effects 0.000 description 1
- 230000008878 coupling Effects 0.000 description 1
- 238000010168 coupling process Methods 0.000 description 1
- 238000005859 coupling reaction Methods 0.000 description 1
- 230000000694 effects Effects 0.000 description 1
- 238000005516 engineering process Methods 0.000 description 1
- 239000000284 extract Substances 0.000 description 1
- 230000006870 function Effects 0.000 description 1
- 238000004519 manufacturing process Methods 0.000 description 1
- 230000007246 mechanism Effects 0.000 description 1
- 230000008569 process Effects 0.000 description 1
- 230000010076 replication Effects 0.000 description 1
- 230000001568 sexual effect Effects 0.000 description 1
Classifications
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/27—Replication, distribution or synchronisation of data between databases or within a distributed database system; Distributed database system architectures therefor
Abstract
A method, system, and software for distributing entertainment scheduling data (e.g., television scheduling data, movie scheduling data, etc.) to end users. Entertainment scheduling data updates are entered into an editorial database and then used to rapidly update a real-time database. A subset of entertainment scheduling data from the real-time database may be transmitted from the real-time database to an end-user database of an end user. The subset may be transmitted across a communication interface (e.g., the Internet) from the real-time database to the end-user database. An intermediate destination (e.g., a File Transfer Protocol server) between the real-time database and the communication interface may be used for temporary parking of the subset.
Description
DISTRIBUTION OF REAL-TIME ENTERTAINMENT SCHEDULING DATA
Background of the Invention 1. Technical Field The present invention relates to a method, system, and a software for distributing data, including a method, system, and software for distributing entertainment scheduling date.
Background of the Invention 1. Technical Field The present invention relates to a method, system, and a software for distributing data, including a method, system, and software for distributing entertainment scheduling date.
2. Related Art Current methods for distributing television scheduling data to end users lack optimal timelines. Thus, there is a need for a method, system, and a software for distributing television scheduling data to end users with improved timelines.
Summary of the Invention In an embodiment, the present invention relates to a method for distributing entertainment scheduling content in real-time from an editorial database to a real-time database, and then to a destination server, an then to an end-user database via a communication link, the distribution to the end-user database being based upon a plurality of end-user selection criteria, the method comprising the following steps:
entering the entertainment scheduling content into the editorial database, wherein the editorial database is recorded in a first computer-readable medium and wherein the entertainment scheduling content comprises new entertainment scheduling data not previously stored in the editorial database and correction entertainment scheduling data intended to replace existing data in the editorial database;
extracting the entertainment scheduling content from the editorial database wherein extraction of the content from the editorial database is based on factors other than a target environment context of any end users;
updating the real-time database with the extracted entertainment scheduling content by pushing via real-time software the entertainment scheduling content from the editorial database to the real-time database, wherein the real-time database is recorded in a second computer-readable medium;
adapting a portion of the entertainment scheduling content stored in the real-time database into an end-user specific dataset by applying a plurality of end-user selection criteria to the entertainment scheduling content stored in the real-time database;
pushing the end-user specific dataset to the destination server, wherein the destination server stores the dataset in a third computer-readable medium;
pulling the dataset from the destination server to the end-user database wherein the dataset is pulled to the end-user database via pull software running on the end user database, wherein the end-user database is recorded in a fourth computer-readable medium, the end-user database corresponds to the end-user selection criteria, and the dataset is adapted to be transmitted to the end-user database via the communication link between the destination server and the end-user database; and updating the end-user database with the dataset without logical modification of the dataset.
In another embodiment, the present invention provides a system for distributing data, comprising a real-time database:
wherein the real-time database is recorded in a first computer-readable medium;
wherein the real-time database includes entertainment scheduling data that comprises a dataset;
wherein the dataset includes entertainment scheduling content for updating an end-user database of an end user;
wherein the end-user database is recorded in a second computer-readable medium;
and wherein receipt of said dataset by said end-user database updates the end-user database by means other than logical modification of the dataset.
In another embodiment, the present invention provides a system for distributing data, said system comprising an end user having an end-user database that is adapted to receive a dataset which is stored in a real-time database:
wherein the real-time database is recorded in a first computer-readable medium;
wherein the end-user database is recorded in a second computer-readable medium;
wherein the real-time database includes entertainment scheduling data that comprises the dataset;
wherein the dataset includes entertainment content; and wherein receipt of the dataset updates the end-user database with the dataset by means other than logical modification of the dataset.
In another embodiment, the present invention provides a computer program product, comprising a computer usable medium having a computer readable program code embodied therein, wherein the computer readable program code comprises an algorithm adapted to effectuate an updating of a real-time database that comprises entertainment scheduling data:
wherein the real-time database is recorded in a first computer-readable medium;
wherein said updating of the real-time database updates the entertainment scheduling data with entertainment scheduling content that is extracted from an editorial database through an editing of the editorial database;
wherein the editorial database is recorded in a second computer-readable medium;
wherein the algorithm is adapted to effectuate a completion of the updating of the real-time database in a time interval LT following completion of the editing of the editorial;
Summary of the Invention In an embodiment, the present invention relates to a method for distributing entertainment scheduling content in real-time from an editorial database to a real-time database, and then to a destination server, an then to an end-user database via a communication link, the distribution to the end-user database being based upon a plurality of end-user selection criteria, the method comprising the following steps:
entering the entertainment scheduling content into the editorial database, wherein the editorial database is recorded in a first computer-readable medium and wherein the entertainment scheduling content comprises new entertainment scheduling data not previously stored in the editorial database and correction entertainment scheduling data intended to replace existing data in the editorial database;
extracting the entertainment scheduling content from the editorial database wherein extraction of the content from the editorial database is based on factors other than a target environment context of any end users;
updating the real-time database with the extracted entertainment scheduling content by pushing via real-time software the entertainment scheduling content from the editorial database to the real-time database, wherein the real-time database is recorded in a second computer-readable medium;
adapting a portion of the entertainment scheduling content stored in the real-time database into an end-user specific dataset by applying a plurality of end-user selection criteria to the entertainment scheduling content stored in the real-time database;
pushing the end-user specific dataset to the destination server, wherein the destination server stores the dataset in a third computer-readable medium;
pulling the dataset from the destination server to the end-user database wherein the dataset is pulled to the end-user database via pull software running on the end user database, wherein the end-user database is recorded in a fourth computer-readable medium, the end-user database corresponds to the end-user selection criteria, and the dataset is adapted to be transmitted to the end-user database via the communication link between the destination server and the end-user database; and updating the end-user database with the dataset without logical modification of the dataset.
In another embodiment, the present invention provides a system for distributing data, comprising a real-time database:
wherein the real-time database is recorded in a first computer-readable medium;
wherein the real-time database includes entertainment scheduling data that comprises a dataset;
wherein the dataset includes entertainment scheduling content for updating an end-user database of an end user;
wherein the end-user database is recorded in a second computer-readable medium;
and wherein receipt of said dataset by said end-user database updates the end-user database by means other than logical modification of the dataset.
In another embodiment, the present invention provides a system for distributing data, said system comprising an end user having an end-user database that is adapted to receive a dataset which is stored in a real-time database:
wherein the real-time database is recorded in a first computer-readable medium;
wherein the end-user database is recorded in a second computer-readable medium;
wherein the real-time database includes entertainment scheduling data that comprises the dataset;
wherein the dataset includes entertainment content; and wherein receipt of the dataset updates the end-user database with the dataset by means other than logical modification of the dataset.
In another embodiment, the present invention provides a computer program product, comprising a computer usable medium having a computer readable program code embodied therein, wherein the computer readable program code comprises an algorithm adapted to effectuate an updating of a real-time database that comprises entertainment scheduling data:
wherein the real-time database is recorded in a first computer-readable medium;
wherein said updating of the real-time database updates the entertainment scheduling data with entertainment scheduling content that is extracted from an editorial database through an editing of the editorial database;
wherein the editorial database is recorded in a second computer-readable medium;
wherein the algorithm is adapted to effectuate a completion of the updating of the real-time database in a time interval LT following completion of the editing of the editorial;
wherein the entertainment scheduling data in the real-time database is adapted to have portions thereof become available to a plurality of end users; and wherein extraction of the entertainment scheduling content from the editorial database is based on one or more factors other than a target environment context of the end user.
In another embodiment, the present invention provides a computer program product, comprising a computer usable medium having a computer readable program code embodied therein, wherein the computer readable program code comprises an algorithm adapted to effectuate pushing a dataset from a real-time database to a computer-readable medium of a destination:
wherein the real-time database is recorded in a first computer-readable medium;
wherein the real-time database includes entertainment scheduling data that comprises the dataset, wherein the dataset comprises entertainment scheduling content;
wherein the dataset at the destination is adapted to be transmitted to an end-user database of an end user via a communication link between the destination and the end-user database;
wherein the end-user database is recorded in a second computer-readable medium;
and wherein receipt of the dataset by the end-user database updates the end-user database with the dataset by means other than logical modification of the dataset.
In another embodiment, the present invention provides a computer program product, comprising a computer usable medium having a computer readable program code embodied therein, wherein the computer readable program code comprises an algorithm adapted to effectuate pushing a dataset from a real-time database to an end-user database of an end user:
In another embodiment, the present invention provides a computer program product, comprising a computer usable medium having a computer readable program code embodied therein, wherein the computer readable program code comprises an algorithm adapted to effectuate pushing a dataset from a real-time database to a computer-readable medium of a destination:
wherein the real-time database is recorded in a first computer-readable medium;
wherein the real-time database includes entertainment scheduling data that comprises the dataset, wherein the dataset comprises entertainment scheduling content;
wherein the dataset at the destination is adapted to be transmitted to an end-user database of an end user via a communication link between the destination and the end-user database;
wherein the end-user database is recorded in a second computer-readable medium;
and wherein receipt of the dataset by the end-user database updates the end-user database with the dataset by means other than logical modification of the dataset.
In another embodiment, the present invention provides a computer program product, comprising a computer usable medium having a computer readable program code embodied therein, wherein the computer readable program code comprises an algorithm adapted to effectuate pushing a dataset from a real-time database to an end-user database of an end user:
wherein the real-time database is recorded in a first computer-readable medium;
wherein the end-user database is recorded in a second computer-readable medium;
wherein the real-time database includes entertainment scheduling data that comprises the dataset, wherein the dataset comprises entertainment scheduling content;
wherein the dataset at the real-time database is adapted to be transmitted to the end-user database via a communication link between the real-time database and the end-user database; and wherein receipt of dataset by the end-user database updates the end-user database with the dataset by means other than logical modification of the dataset.
The method and system of the present invention beneficially provides a method, system, and software for distributing entertainment scheduling data (e.g., television scheduling data, movie-theatre scheduling data, etc.) to end users with improved timeliness.
Brief Description of the Drawings FIG. 1 depicts a system for distributing entertainment scheduling data to end users from a real-time database and through use of a File Transfer Protocol (FTP) server, in accordance with embodiments of the present invention.
FIG. 2 depicts the system of FIG. I without the FTP server, in accordance with embodiments of the present invention.
FIG. 3 depicts a computer system for distributing entertainment scheduling data to end users from a real-time database, in accordance with embodiments of the present invention.
FIGS. 4A, 4B, and 4C show the fields of a television (TV) schedule record of a database table, in accordance with embodiments of the present invention.
wherein the end-user database is recorded in a second computer-readable medium;
wherein the real-time database includes entertainment scheduling data that comprises the dataset, wherein the dataset comprises entertainment scheduling content;
wherein the dataset at the real-time database is adapted to be transmitted to the end-user database via a communication link between the real-time database and the end-user database; and wherein receipt of dataset by the end-user database updates the end-user database with the dataset by means other than logical modification of the dataset.
The method and system of the present invention beneficially provides a method, system, and software for distributing entertainment scheduling data (e.g., television scheduling data, movie-theatre scheduling data, etc.) to end users with improved timeliness.
Brief Description of the Drawings FIG. 1 depicts a system for distributing entertainment scheduling data to end users from a real-time database and through use of a File Transfer Protocol (FTP) server, in accordance with embodiments of the present invention.
FIG. 2 depicts the system of FIG. I without the FTP server, in accordance with embodiments of the present invention.
FIG. 3 depicts a computer system for distributing entertainment scheduling data to end users from a real-time database, in accordance with embodiments of the present invention.
FIGS. 4A, 4B, and 4C show the fields of a television (TV) schedule record of a database table, in accordance with embodiments of the present invention.
FIG. 5 shows the fields of a TV station record of a database table, in accordance with embodiments of the present invention.
FIGS. 6A, 6B, 6C, 6D, and 6E show the fields of a TV program of a database table, in accordance with embodiments of the present invention.
FIG. 7 shows the fields of a TV translation record of a database table, in accordance with embodiments of the present invention.
Detailed Description of the Invention FIG. 1 depicts a system 10 for distributing entertainment scheduling data, in accordance with embodiments of the present invention. The system 10 comprises an editorial database 14, a real-time database 20, a File Transfer Protocol (FTP) server 22, a communication interface 30, end user 40 and 50, real-time software 16, push software 24, and push software 26.
The editorial database 14 and the real-time database 20 (as well as end-user databases 42 and 52, discussed infra) are each embedded or recorded in a computer-usable or computer-readable medium. Similarly, the real-time software 16, push software 24, and push software 26 each comprise computer readable program code and are each embedded or recorded in a computer-usable or computer-readable medium. For the present invention, a computer-usable or computer-readable medium comprises, inter alia, a computer storage or memory device (e.g., hard disk, floppy disk, magnetic tape, optical storage such as a compact disc (CD) or a digital video disc (DVD), dynamic random access memory (DRAM), a read-only memory (ROM), etc.).
The editorial database 14 comprises, inter alia, entertainment scheduling data such as, inter alia, television (TV) scheduling data, movie-theatre scheduling data, sports events scheduling data, musical performance scheduling data, live theater scheduling data, etc. Movie-theatre scheduling data is defined herein as pertaining to movies at movie theaters. The scheduling data relates to any data directly or indirectly associated with the scheduling of the entertainment events and the events that are scheduled. For example, TV
scheduling data may include the type of data typically associated with an electronic program guide (EPG) such as data relating to dates and times that TV programs are scheduled to be aired and associated TV channel lineups, program description identifiers (e.g., to identify movies, shows, episodes, sports events, etc.), availability of closed captioning (e.g., to assist hearing-impaired viewers), program ratings (e.g., indications of adult situations, sexual content, violent situations, strong language, strong dialogue, fantasy violence, etc.), program presentation technology (e.g., 3-D
format, high definition TV, Dolby/Dolby digital, etc.), foreign language indication, actors/actresses, programming credits of a show or movie, name of company responsible for distribution of a movie, the year a feature film was released, indication that a film was made specifically for television, etc. The preceding examples of TV scheduling data is a small fraction of TV
scheduling data generally. The scope of the present invention includes any TV
scheduling data, and any entertainment scheduling data associated with any other entertainment category such as movie-theatre scheduling data, sports events scheduling data, musical performance scheduling data, live theatre scheduling data, etc. The scope of the present invention also includes scheduling data unrelated to entertainment such as, inter alia, scheduling for travel (by air, train, ship, etc.), scheduling of activities in the workplace, scheduling of events for a campaign relating to a election, etc.
The editorial database 14 is edited to receive input 12 periodically or at random times;
generally, whenever such input 12 is made available to the editorial database 14 over a communication path 1. The communication path 1 may represent, inter alia, an entry path of the input 12 into the editorial database 14 after having been manually entered by a user. Thus, the editing may be manual, automated, or both. As an example of automated editing, the input 12 may be entered, as received from a source, through an updating algorithm wherein manual effort is not required. The input 12 and editing thereof updates the editorial database 14. Each such input 12 received by the editorial database 14 is a group of entertainment scheduling data, and successive groups are received periodically or at random times. The input 12 may include new entertainment scheduling data not currently in the editorial database 14, correction data intended to replace existing entertainment scheduling data in the editorial database 14, and replications of already existing entertainment scheduling data in the editorial database 14.
The real-time software 16 operates on the editorial database 14 to extract (i.e., copy but not remove) updates 18 from the editorial database 14 to the real-time database 20, so that the real-time software 16 effectively "pushes" the updates 18 to the real-time database 20. The direction of the arrowhead shown on the communication path 3 between the real-time software 16 and the editorial database 14 denotes that the real-time software 16 is "pushing" the updates 18 from the editorial database 14 to the real-time database 20 over a communication path 2. The updates 18 are data changes of the input data 12, namely new entertainment scheduling data not currently in the editorial database 14 and correction entertainment scheduling data intended to replace existing data in the editorial database 14. The updates 18 may be partitioned into groups, resulting in the updates 18 being transmitted to the real-time database 20 as groups of entertainment scheduling updates.
Portions of the updates 18 may be subsequently transmitted to the end users 40 and 50, or to any other end users. However, extraction of the entertainment scheduling content from the editorial database 14 is not based on a target environment context of any of said end users (or "targets") but instead is end-user independent. This aspect of the present invention is one of the features that distinguishes the present invention from United States Patent 5,666,645 (Thomas et al., issued Sept. 9, 1997), wherein in Thomas "feed extraction process 710 connects to the main database 90 and extracts the appropriate content information based on the target environment context" (emphasis added) (see Thomas, col. 11, lines 47-49). For the present invention, the "target environment context" of an individual end user identifies the entertainment scheduling data that is intended to be transmitted to the individual end user.
The real-time database 20 may comprise, inter alia, tables in any database environment such as a relational database that could be accessed by Structured Query Language (SQL). The real-time database 20 includes entertainment scheduling data that comprises the entertainment scheduling content of the updates 18. As an illustration under the assumption that the entertainment scheduling data comprises TV scheduling data, the real-time database 20 may comprise relational database tables, each having a plurality of records in accordance with the record layouts (in terms of fields) shown infra in FIG. 4A, 4B, 4C, FIG. 5, FIG. 6A, FIG. 6B, FIG. 6C, FIG. 6D, FIG. 6E, and FIG. 7, in accordance with embodiments of the present invention. Hereinafter, FIG. 4 shall denote FIGS. 4A, 4B, and 4C collectively, and FIG. 4 shows the fields of a schedule record of a database table. FIG. 5 shows the fields of a TV station record of a database table. Hereinafter, FIG. 6 shall denote FIGS. 6A, 6B, 6C, 6D, and 6E collectively, and FIG. 6 shows the fields of a program record of a database table. FIG. 7 shows the fields of a TV translation record of a database table. In FIG. 4, the schedule record identifies the TV
content of a unique channel-time slot (i.e., unique combination of date, time, and TV channel).
The primary key that makes each such schedule record unique is the combination of date, time, and station (i.e., channel), which are respectively represented in fields 3, 4, and 1. The station identifier of field 1 of the schedule record is a foreign key associated with the station record of FIG. 5. The TV program identifier of field 2 of the schedule record is a foreign key associated with the program record of FIG. 6. In FIG. 5, the station record identifies the characteristics (e.g., location) of a unique TV station. The primary key that makes each such station record unique is the unique station identifier in field 1, which also serves as a foreign key in the schedule record of FIG. 4 as stated supra. In FIG. 6, the program record identifies the characteristics (program name, actor, language, etc.) of a unique TV program.
The primary key that makes each such program record unique is the unique program identifier in field 1, which also serves as a foreign key in the schedule record of FIG. 4 as stated supra.
In FIG. 7, the translation record provides an English translation of a foreign word or phrase.
As stated supra, the updates 18 are extracted from the editorial database 14 and then transmitted to the real-time database 20 and are used to update the real-time database 20. Said updating of the real-time database 20 may occur within a time interval AT
following completion of the editing of the editorial database 14 such that AT does not exceed about 240 minutes. The present invention is also capable of achieving better timings such that AT
does not exceed a value below 240 minutes such as, inter alia, any of the following values below 240 minutes:
about 180 minutes, 120 minutes 60 minutes, 30 minutes, 15 minutes, 10, minutes, 5 minutes, 3 minutes, and 2 minutes. Projecting into the future, the scope of the present invention also includes AT not exceeding about 1 minute. Thus any of the preceding values of AT may pertain to an update from the editorial database 14 to the real-time database 20.
The preceding values of AT are directed an to individual, discrete updating.
However for a plurality of such updatings, a parameter ATAVE may be defined as a statistical average of AT
over said plurality of such updatings of the real-time database 20. ATAVE may be computed by any recognized statistical averaging process and may represent an arithmetic average, a weighted average, etc. For N values of AT of AT,, AT2, ..., ATN, the arithmetic average of AT is computed as (AT, + AT2 + ... + ATN)/N. For the same N values of AT, the weighted average of AT is computed as (W,AT, + W2AT2 + ... + WNATN) / (WI + W2 + ... + WN), wherein the weights W,, W2, .,.., WN may be based on any desired weighting criteria. The present invention is capable of achieving timings such that ATAVE does not exceed about any of the following values: 10 minutes, 5 minutes, 2 minutes, and 1 minute. Thus any of the preceding values of ATAVE may pertain to a plurality of updates from the editorial database 14 to the real-time database 20.
With the preceding low values of AT and [XTAVE, the real-time database 20 may have the characteristic of being updated quasi-continuously in real time, which accounts for the term "real-time" in the phrase "real-time database." Nonetheless, the real-time database 20 may not be so limited by AT and ATAVE in some embodiments of the present invention.
When low values of AT and ATAVE are applicable, the real-time software 16 uses various techniques to achieve the low values of AT and ATAVE which may include, inter alia, multi-thread processing. The real-time software 16 uses any technique of multi-thread processing known to a person of ordinary skill in the art such as, inter alia, multi-thread processing techniques that take advantage of parallel processors, multiple registers, etc. to facilitate simultaneous updating of multiple portions of the real-time database 20. As a result, the updating of the real-time database 20 with the entertainment scheduling content comprises multi-threaded updating of the real-time database 20 with the entertainment scheduling content.
The end user 40 is a computer system that comprises the end-user database 42, and the end user 50 is a computer system that comprises the end-user database 52.
Although FIG. 1 depicts only the end users 40 and 50, the system 10 generally includes M such end-user database such that M>_ 1; i.e., M is any positive integer. Another term for expressing "end user" is "target." The M end-users may be within a local area network (LAN), wide area network (WAN), or any other network such that the N end-users are coupled to the real-time database 20 through the communication interface 30 as shown. Hence, the communication interface 30 may comprise, inter alia, the Internet. Generally, the communication interface 30 comprises any communication interface known to one of ordinary skill in the art for coupling N end-users to the real-time database 20. The following discussion focuses on the end user 40 as also representing any other end user such as the end user 50 or one of the M end users.
Likewise, the preceding discussion that related to the end user 40 also pertained to any other end user such as the end user 50 or one of the M end users.
The end-user database 42 of the end user 40 includes entertainment scheduling data that is obtained from the real-time database 20 via the communication interface 30 between the real-time database 20 and the end user 40. The entertainment scheduling content that is transmitted from the real-time database 20 to the end-user database 42 of the end user 40 is end-user dependent and thus comprises a subset of the updates 18 that results from application of end-user selection criteria; i.e., each individual end user receives entertainment scheduling content that is individualized for said individual end user. For example if the entertainment scheduling data comprises TV scheduling data, then one end user may have arranged to receive updates relating to particular TV channels but not to other TV channels, while another end user may have arranged to receive updates relating to particular type of TV programs (e.g., sports programs) but not to other types of TV programs.
The entertainment scheduling content that is transmitted from the real-time database 20 to the end user 40 may be derived from the updates 18 and is configured within the real-time database 20 as one or more datasets 21. A dataset is a collection of data. An example of a dataset is a "linear dataset" which is a linear array of data. Examples of a linear dataset include:
a record of a file, a row of a table, a column of a table, etc. To illustrate, the entertainment scheduling content that is transmitted from the real-time database 20 to the end user 40 may take the form of a file that comprises linear datasets, namely records. Another example of a dataset is a set of eXtensible Markup Language (XML) data.
A dataset is considered to have been logically modified if the dataset changes in content or in the ordering of content. As a first example, modifying a dataset by adding or deleting fields results in a logical modification of the dataset. As a second example, if the text "heet" in a dataset is changed to "heat", then the dataset has been logically modified. As a third example, if the number "1000.00" in a dataset is changed to "1.OE+03", then the dataset has been logically modified. As a fourth example, if a dataset has three fields sequentially ordered as field 1, field 2 and field 3, then a reordering of the fields into the sequence of field 2, field 1, and field 3 represents a logical modification of the dataset. However, a change in form of representation of a dataset (e.g., row of a table to record of a file or vice versa) is not a modification of the dataset.
A feature that is within the scope of the present invention is transmitting the dataset from the real-time database 20 to the end user 40, and then updating the end-user database 42 of the end user 40 without logical modification of the dataset. This feature speeds and simplifies the updating of the end-user database 42.
In FIG. 1, the FTP server 22 may function as a "destination" that interfaces between the real-time database 20 and the communication interface 30. For example, the dataset 21 (which includes entertainment scheduling content of the updates 18) that is transmitted from the real-time database 20 to the end user 40 may be first pushed by pushing software 24 to a computer-readable medium of the FTP server 22 where the dataset 21 may be recorded and "parked" and denoted, while within the FTP server 22, as dataset 23 until subsequently transmitted from the FTP server 22 to the end user 40 via the communication interface 30. The direction of the arrowhead shown on the communication path 5 between the push software 24 and the real-time database 20 denotes that the push software 24 is pushing the dataset 21 from the real-time database 20 to a computer-readable medium of the FTP server 22 over a communication path 4.
The parked dataset 23 on the FTP server 22 is individualized for the end user 40, and other datasets on the FTP server 22 are individualized for other end users. The subsequent transmission from the FTP server 22 to the end user 40 may be effectuated by "pulling" or "pushing" the dataset 23 that is parked on a computer-readable medium of the FTP server 22.
The end user 40 may "pull" the parked dataset 23 across the communication interface 30 and into the end user 40 (and into the end-user database 42) through use of the pull software 44 that is comprised by the user 40. Thus in FIG. 1, the direction of the arrowhead shown on the communication path 7 between the pull software 44 and the end-user database 42 denotes that the pull software 44 is pulling the dataset 23 from a computer-readable medium of the FTP
server 22 to the end user 40 across the communication interface 30.
Alternatively, the parked dataset 23 may be pushed across the communication interface 30 and into the end user 40 (and into the end-user database 42) through use of the push software 26 that is coupled to the FTP
server 22. The direction of the arrowhead shown on the communication path 6 between the push software 26 and the FTP server 22 denotes that the push software 26 is pushing the dataset 23 from a computer-readable medium of the FTP server 22 to the end user 40 across the communication interface 30. Thus, "pulling" the dataset 23 into an end user from a source comprises using software that exists within the end user to trigger copying the dataset from the source and transmitting the copied dataset to the end user. "Pushing" a dataset into an end user from a source comprises using software external to the end user to trigger copying the dataset from the source and transmitting the copied dataset to the end user.
Pushing the dataset 21 (that is ultimately intended to be transmitted to the end user 40 as the dataset 23) from the real-time database 20 to a computer-readable medium of the FTP server 22 may be triggered to occur upon satisfaction of a condition. The condition may be individualized for individual end users. The condition may be time dependent.
For example, one end user may have arranged for the dataset 21 to be pushed to a computer-readable medium of the FTP server 22 at 8:00AM every day, while another end user may have arranged for the dataset 21 to be pushed to a computer-readable medium of the FTP server 22 at 12:00AM every Sunday. The condition may be event dependent. For example for TV scheduling updates, an end user may have arranged for the dataset 21 to be pushed to a computer-readable medium of the FTP server 22 whenever the updates 18 include the appearance of a new TV
program. The condition may be content dependent. For example for TV scheduling updates, an end user may have arranged for the dataset to be pushed to a computer-readable medium of the FTP server 22 whenever the updates 18 include strong language or adult situations. The condition may be primary key dependent. For example, the condition may comprise a requirement that a primary key of the dataset 21 matches a key in a list of keys, wherein the primary key makes the dataset unique within the real-time database. To illustrate for FIG. 4-7, the list of primary keys may include the station identifier primary key of the station record (see FIG. 5) and the program identifier primary key of the program record (see FIG. 6), so that if the dataset is a station record or a program record then the dataset will be pushed from the real-time database 20 to a computer-readable medium of the FTP server 22. The condition may include a requirement that the updates 18 include a specified data item that is being changed to a preselected value (e.g., the data item is: availability of closed captioning; and the preseleted value in the updates 18 is: YES, meaning that closed captioning is available). The condition may be expressed in any form such as a logical expression involving logical operators (e.g., AND, OR, NOT, etc.) and having any degree of logical complexity.
Although the FTP server 22 has been described herein as a destination that interfaces between the real-time database 20 and the communication interface 30, for the temporary parking of a dataset to be transmitted from the real-time database 20 to the end user 40, any other device or mechanism known to a person of ordinary skill in the art could be used instead of the FTP
server 22 to provide the functionality of the FTP server 22.
FIG. 2 depicts a system 11, which is equivalent to the system 10 of FIG. I
without the FTP server 22, in accordance with embodiments of the present invention. Aside from aspects of the system 11 as described infra, the features of the system 11 of FIG. 2 are the same as the corresponding features of the system 10 of FIG. 1 that have been described supra.
In FIG. 2, the real-time database 20 has been updated with the updates 18 extracted from the editorial database 14, as in FIG. 1. Subsequent transmission of the dataset 21 comprising a portion of said updates 18 from the real-time database 20 to the end user 40 may be effectuated by pulling or pushing the dataset 21 into the end-user database 42 of the end user 40. The end user 40 may pull the dataset 21 from the real-time database 20 across the communication interface 30 and into the end-user database 42 of the end user 40 through use of the pull software 44 that is comprised by the user 40. Thus in FIG. 2, the direction of the arrowhead shown on the communication path 7 between the pull software 44 and the end-user database 42 denotes that the pull software 44 is pulling the dataset 21 from the real-time database 20 to the end-user database 42 via across the communication interface 30. Alternatively, the dataset 21 may be pushed from the real-time database 20 across the communication interface 30 and into the end-user database 42 of end user 40 through use of the push software 25 that is coupled to the real-time database 20. Thus, the direction of the arrowhead shown on the communication path 8 between the push software 25 and the real-time database 20 denotes that the push software 25 is pushing the dataset 21 from the real-time database 20 to the end-user database 42 via across the communication interface 30. If the dataset is transmitted into the end-user database 42 immediately or shortly after the real-time database is updated (as described supra), then the end-user database 42 may be viewed as being updated in real time.
Transmitting, via pulling or pushing as described supra, the dataset from the real-time database 20 to the end-user database 42 of the end user 40 may be triggered to occur upon satisfaction of a condition. The condition may be individualized for individual end users. The condition may be time dependent. For example, one end user may have arranged for the dataset 21 to be transmitted to the end-user database 42 at 8:00AM every day, while another end user may have arranged for the dataset to be transmitted to the end-user database 42 at 12:00AM
every Sunday. The condition may be event dependent. For example for TV
scheduling updates, an end user may have arranged for the dataset to be transmitted to the end-user database 42 whenever the updates 18 include the appearance of a new TV program. The condition may be content dependent. For example for TV scheduling updates, an end user may have arranged for the dataset to be transmitted to the end-user database 42 whenever the updates 18 include strong language or adult situations. The condition may be primary key dependent. For example, the condition may comprise a requirement that a primary key of the dataset matches a key in a list of keys, wherein the primary key makes the dataset unique within the real-time database. To illustrate for FIGS. 4-7, the list of primary keys may include the station identifier primary key of the station record (see FIG. 5) and the program identifier primary key of the program record (see FIG. 6), so that if the dataset is a station record or a program record then the dataset will be transmitted from the real-time database 20 to the end-user database 42. The condition may include a requirement that the updates 18 include a specified data item that is being changed to a preselected value (e.g., the data item is: availability of closed captioning;
and the value in the updates 18 is: YES, meaning that closed captioning is available). The condition may be expressed in any form such as a logical expression involving logical operators (e.g., AND, OR, NOT, etc.) and having any degree of logical complexity.
FIG. 3 illustrates a computer system 90 for distributing entertainment scheduling data to end users from the real-time database 22 of FIGS. 1 and 2, in accordance with embodiments of the present invention. The computer system 90 comprises a processor 91, an input device 92 coupled to the processor 91, an output device 93 coupled to the processor 91, and memory devices 94 and 95 each coupled to the processor 91. The input device 92 may be, inter alia, a keyboard, a mouse, etc. The output device 93 may be, inter alia, a printer, a plotter, a computer screen, a magnetic tape, a removable hard disk, a floppy disk, a magnetic tape, an optical storage such as a compact disc (CD) or a digital video disc (DVD), a dynamic random access memory (DRAM), a read-only memory (ROM), etc. The memory device 95 includes a computer code 97.
The computer code 97 includes algorithms associated with any or all of the software of FIGS. 1 and 2 described supra, namely the real-time software 16 (see FIG. 1), the push software 24 (see FIG. 1), the push software 26 (see FIG. 1), the pull software 44 (see FIG. 1), the pull software 54 (see FIG. 1), and the push software 25 (see FIG. 2). The processor 91 executes the computer code 97. The memory device 94 includes input data 96. The input data 96 includes input required by the computer code 97. The output device 93 displays output from the computer code 97. Either or both memory devices 94 and 95 (or one or more additional memory devices not shown in FIG. 9) may be used as a computer usable medium (or a computer readable medium or a program storage device) having a computer readable program code embodied therein and/or having other data stored therein, wherein the computer readable program code comprises the computer code 97. Generally, a computer program product (or, alternatively, an article of manufacture) of the computer system 90 may comprise said computer usable medium (or said program storage device).
While FIG. 3 shows the computer system 90 as a particular configuration of hardware and software, any configuration of hardware and software, as would be known to a person of ordinary skill in the art, may be utilized for the purposes stated supra in conjunction with the particular computer system 90 of FIG. 9. For example, the memory devices 94 and 95 may be portions of a single memory device rather than separate memory devices.
The computer system 90 of FIG. 3 represents any of several different computer systems of the present invention. As a first example, the computer system 90 of FIG. 3 may include some or all of the editorial database 14, the real-time database 20, real-time software 16, push software 24, push software 26, push software 25, and FTP server 22, wherein any or all of the preceding software and databases may be stored in one or both of the memory devices 94 and 95 of FIG. 3.
As a second example, the computer system 90 of FIG. 3 may pertain to an end user such as the end user 40 of FIG. 1 and 2, and thus store the end-user database 42 and pull software 40 in one or both of the memory devices 94 and 95.
While particular embodiments of the present invention have been described herein for purposes of illustration, many modifications and changes will become apparent to those skilled in the art. Accordingly, the appended claims are intended to encompass all such modifications and changes as fall within the true spirit and scope of this invention.
FIGS. 6A, 6B, 6C, 6D, and 6E show the fields of a TV program of a database table, in accordance with embodiments of the present invention.
FIG. 7 shows the fields of a TV translation record of a database table, in accordance with embodiments of the present invention.
Detailed Description of the Invention FIG. 1 depicts a system 10 for distributing entertainment scheduling data, in accordance with embodiments of the present invention. The system 10 comprises an editorial database 14, a real-time database 20, a File Transfer Protocol (FTP) server 22, a communication interface 30, end user 40 and 50, real-time software 16, push software 24, and push software 26.
The editorial database 14 and the real-time database 20 (as well as end-user databases 42 and 52, discussed infra) are each embedded or recorded in a computer-usable or computer-readable medium. Similarly, the real-time software 16, push software 24, and push software 26 each comprise computer readable program code and are each embedded or recorded in a computer-usable or computer-readable medium. For the present invention, a computer-usable or computer-readable medium comprises, inter alia, a computer storage or memory device (e.g., hard disk, floppy disk, magnetic tape, optical storage such as a compact disc (CD) or a digital video disc (DVD), dynamic random access memory (DRAM), a read-only memory (ROM), etc.).
The editorial database 14 comprises, inter alia, entertainment scheduling data such as, inter alia, television (TV) scheduling data, movie-theatre scheduling data, sports events scheduling data, musical performance scheduling data, live theater scheduling data, etc. Movie-theatre scheduling data is defined herein as pertaining to movies at movie theaters. The scheduling data relates to any data directly or indirectly associated with the scheduling of the entertainment events and the events that are scheduled. For example, TV
scheduling data may include the type of data typically associated with an electronic program guide (EPG) such as data relating to dates and times that TV programs are scheduled to be aired and associated TV channel lineups, program description identifiers (e.g., to identify movies, shows, episodes, sports events, etc.), availability of closed captioning (e.g., to assist hearing-impaired viewers), program ratings (e.g., indications of adult situations, sexual content, violent situations, strong language, strong dialogue, fantasy violence, etc.), program presentation technology (e.g., 3-D
format, high definition TV, Dolby/Dolby digital, etc.), foreign language indication, actors/actresses, programming credits of a show or movie, name of company responsible for distribution of a movie, the year a feature film was released, indication that a film was made specifically for television, etc. The preceding examples of TV scheduling data is a small fraction of TV
scheduling data generally. The scope of the present invention includes any TV
scheduling data, and any entertainment scheduling data associated with any other entertainment category such as movie-theatre scheduling data, sports events scheduling data, musical performance scheduling data, live theatre scheduling data, etc. The scope of the present invention also includes scheduling data unrelated to entertainment such as, inter alia, scheduling for travel (by air, train, ship, etc.), scheduling of activities in the workplace, scheduling of events for a campaign relating to a election, etc.
The editorial database 14 is edited to receive input 12 periodically or at random times;
generally, whenever such input 12 is made available to the editorial database 14 over a communication path 1. The communication path 1 may represent, inter alia, an entry path of the input 12 into the editorial database 14 after having been manually entered by a user. Thus, the editing may be manual, automated, or both. As an example of automated editing, the input 12 may be entered, as received from a source, through an updating algorithm wherein manual effort is not required. The input 12 and editing thereof updates the editorial database 14. Each such input 12 received by the editorial database 14 is a group of entertainment scheduling data, and successive groups are received periodically or at random times. The input 12 may include new entertainment scheduling data not currently in the editorial database 14, correction data intended to replace existing entertainment scheduling data in the editorial database 14, and replications of already existing entertainment scheduling data in the editorial database 14.
The real-time software 16 operates on the editorial database 14 to extract (i.e., copy but not remove) updates 18 from the editorial database 14 to the real-time database 20, so that the real-time software 16 effectively "pushes" the updates 18 to the real-time database 20. The direction of the arrowhead shown on the communication path 3 between the real-time software 16 and the editorial database 14 denotes that the real-time software 16 is "pushing" the updates 18 from the editorial database 14 to the real-time database 20 over a communication path 2. The updates 18 are data changes of the input data 12, namely new entertainment scheduling data not currently in the editorial database 14 and correction entertainment scheduling data intended to replace existing data in the editorial database 14. The updates 18 may be partitioned into groups, resulting in the updates 18 being transmitted to the real-time database 20 as groups of entertainment scheduling updates.
Portions of the updates 18 may be subsequently transmitted to the end users 40 and 50, or to any other end users. However, extraction of the entertainment scheduling content from the editorial database 14 is not based on a target environment context of any of said end users (or "targets") but instead is end-user independent. This aspect of the present invention is one of the features that distinguishes the present invention from United States Patent 5,666,645 (Thomas et al., issued Sept. 9, 1997), wherein in Thomas "feed extraction process 710 connects to the main database 90 and extracts the appropriate content information based on the target environment context" (emphasis added) (see Thomas, col. 11, lines 47-49). For the present invention, the "target environment context" of an individual end user identifies the entertainment scheduling data that is intended to be transmitted to the individual end user.
The real-time database 20 may comprise, inter alia, tables in any database environment such as a relational database that could be accessed by Structured Query Language (SQL). The real-time database 20 includes entertainment scheduling data that comprises the entertainment scheduling content of the updates 18. As an illustration under the assumption that the entertainment scheduling data comprises TV scheduling data, the real-time database 20 may comprise relational database tables, each having a plurality of records in accordance with the record layouts (in terms of fields) shown infra in FIG. 4A, 4B, 4C, FIG. 5, FIG. 6A, FIG. 6B, FIG. 6C, FIG. 6D, FIG. 6E, and FIG. 7, in accordance with embodiments of the present invention. Hereinafter, FIG. 4 shall denote FIGS. 4A, 4B, and 4C collectively, and FIG. 4 shows the fields of a schedule record of a database table. FIG. 5 shows the fields of a TV station record of a database table. Hereinafter, FIG. 6 shall denote FIGS. 6A, 6B, 6C, 6D, and 6E collectively, and FIG. 6 shows the fields of a program record of a database table. FIG. 7 shows the fields of a TV translation record of a database table. In FIG. 4, the schedule record identifies the TV
content of a unique channel-time slot (i.e., unique combination of date, time, and TV channel).
The primary key that makes each such schedule record unique is the combination of date, time, and station (i.e., channel), which are respectively represented in fields 3, 4, and 1. The station identifier of field 1 of the schedule record is a foreign key associated with the station record of FIG. 5. The TV program identifier of field 2 of the schedule record is a foreign key associated with the program record of FIG. 6. In FIG. 5, the station record identifies the characteristics (e.g., location) of a unique TV station. The primary key that makes each such station record unique is the unique station identifier in field 1, which also serves as a foreign key in the schedule record of FIG. 4 as stated supra. In FIG. 6, the program record identifies the characteristics (program name, actor, language, etc.) of a unique TV program.
The primary key that makes each such program record unique is the unique program identifier in field 1, which also serves as a foreign key in the schedule record of FIG. 4 as stated supra.
In FIG. 7, the translation record provides an English translation of a foreign word or phrase.
As stated supra, the updates 18 are extracted from the editorial database 14 and then transmitted to the real-time database 20 and are used to update the real-time database 20. Said updating of the real-time database 20 may occur within a time interval AT
following completion of the editing of the editorial database 14 such that AT does not exceed about 240 minutes. The present invention is also capable of achieving better timings such that AT
does not exceed a value below 240 minutes such as, inter alia, any of the following values below 240 minutes:
about 180 minutes, 120 minutes 60 minutes, 30 minutes, 15 minutes, 10, minutes, 5 minutes, 3 minutes, and 2 minutes. Projecting into the future, the scope of the present invention also includes AT not exceeding about 1 minute. Thus any of the preceding values of AT may pertain to an update from the editorial database 14 to the real-time database 20.
The preceding values of AT are directed an to individual, discrete updating.
However for a plurality of such updatings, a parameter ATAVE may be defined as a statistical average of AT
over said plurality of such updatings of the real-time database 20. ATAVE may be computed by any recognized statistical averaging process and may represent an arithmetic average, a weighted average, etc. For N values of AT of AT,, AT2, ..., ATN, the arithmetic average of AT is computed as (AT, + AT2 + ... + ATN)/N. For the same N values of AT, the weighted average of AT is computed as (W,AT, + W2AT2 + ... + WNATN) / (WI + W2 + ... + WN), wherein the weights W,, W2, .,.., WN may be based on any desired weighting criteria. The present invention is capable of achieving timings such that ATAVE does not exceed about any of the following values: 10 minutes, 5 minutes, 2 minutes, and 1 minute. Thus any of the preceding values of ATAVE may pertain to a plurality of updates from the editorial database 14 to the real-time database 20.
With the preceding low values of AT and [XTAVE, the real-time database 20 may have the characteristic of being updated quasi-continuously in real time, which accounts for the term "real-time" in the phrase "real-time database." Nonetheless, the real-time database 20 may not be so limited by AT and ATAVE in some embodiments of the present invention.
When low values of AT and ATAVE are applicable, the real-time software 16 uses various techniques to achieve the low values of AT and ATAVE which may include, inter alia, multi-thread processing. The real-time software 16 uses any technique of multi-thread processing known to a person of ordinary skill in the art such as, inter alia, multi-thread processing techniques that take advantage of parallel processors, multiple registers, etc. to facilitate simultaneous updating of multiple portions of the real-time database 20. As a result, the updating of the real-time database 20 with the entertainment scheduling content comprises multi-threaded updating of the real-time database 20 with the entertainment scheduling content.
The end user 40 is a computer system that comprises the end-user database 42, and the end user 50 is a computer system that comprises the end-user database 52.
Although FIG. 1 depicts only the end users 40 and 50, the system 10 generally includes M such end-user database such that M>_ 1; i.e., M is any positive integer. Another term for expressing "end user" is "target." The M end-users may be within a local area network (LAN), wide area network (WAN), or any other network such that the N end-users are coupled to the real-time database 20 through the communication interface 30 as shown. Hence, the communication interface 30 may comprise, inter alia, the Internet. Generally, the communication interface 30 comprises any communication interface known to one of ordinary skill in the art for coupling N end-users to the real-time database 20. The following discussion focuses on the end user 40 as also representing any other end user such as the end user 50 or one of the M end users.
Likewise, the preceding discussion that related to the end user 40 also pertained to any other end user such as the end user 50 or one of the M end users.
The end-user database 42 of the end user 40 includes entertainment scheduling data that is obtained from the real-time database 20 via the communication interface 30 between the real-time database 20 and the end user 40. The entertainment scheduling content that is transmitted from the real-time database 20 to the end-user database 42 of the end user 40 is end-user dependent and thus comprises a subset of the updates 18 that results from application of end-user selection criteria; i.e., each individual end user receives entertainment scheduling content that is individualized for said individual end user. For example if the entertainment scheduling data comprises TV scheduling data, then one end user may have arranged to receive updates relating to particular TV channels but not to other TV channels, while another end user may have arranged to receive updates relating to particular type of TV programs (e.g., sports programs) but not to other types of TV programs.
The entertainment scheduling content that is transmitted from the real-time database 20 to the end user 40 may be derived from the updates 18 and is configured within the real-time database 20 as one or more datasets 21. A dataset is a collection of data. An example of a dataset is a "linear dataset" which is a linear array of data. Examples of a linear dataset include:
a record of a file, a row of a table, a column of a table, etc. To illustrate, the entertainment scheduling content that is transmitted from the real-time database 20 to the end user 40 may take the form of a file that comprises linear datasets, namely records. Another example of a dataset is a set of eXtensible Markup Language (XML) data.
A dataset is considered to have been logically modified if the dataset changes in content or in the ordering of content. As a first example, modifying a dataset by adding or deleting fields results in a logical modification of the dataset. As a second example, if the text "heet" in a dataset is changed to "heat", then the dataset has been logically modified. As a third example, if the number "1000.00" in a dataset is changed to "1.OE+03", then the dataset has been logically modified. As a fourth example, if a dataset has three fields sequentially ordered as field 1, field 2 and field 3, then a reordering of the fields into the sequence of field 2, field 1, and field 3 represents a logical modification of the dataset. However, a change in form of representation of a dataset (e.g., row of a table to record of a file or vice versa) is not a modification of the dataset.
A feature that is within the scope of the present invention is transmitting the dataset from the real-time database 20 to the end user 40, and then updating the end-user database 42 of the end user 40 without logical modification of the dataset. This feature speeds and simplifies the updating of the end-user database 42.
In FIG. 1, the FTP server 22 may function as a "destination" that interfaces between the real-time database 20 and the communication interface 30. For example, the dataset 21 (which includes entertainment scheduling content of the updates 18) that is transmitted from the real-time database 20 to the end user 40 may be first pushed by pushing software 24 to a computer-readable medium of the FTP server 22 where the dataset 21 may be recorded and "parked" and denoted, while within the FTP server 22, as dataset 23 until subsequently transmitted from the FTP server 22 to the end user 40 via the communication interface 30. The direction of the arrowhead shown on the communication path 5 between the push software 24 and the real-time database 20 denotes that the push software 24 is pushing the dataset 21 from the real-time database 20 to a computer-readable medium of the FTP server 22 over a communication path 4.
The parked dataset 23 on the FTP server 22 is individualized for the end user 40, and other datasets on the FTP server 22 are individualized for other end users. The subsequent transmission from the FTP server 22 to the end user 40 may be effectuated by "pulling" or "pushing" the dataset 23 that is parked on a computer-readable medium of the FTP server 22.
The end user 40 may "pull" the parked dataset 23 across the communication interface 30 and into the end user 40 (and into the end-user database 42) through use of the pull software 44 that is comprised by the user 40. Thus in FIG. 1, the direction of the arrowhead shown on the communication path 7 between the pull software 44 and the end-user database 42 denotes that the pull software 44 is pulling the dataset 23 from a computer-readable medium of the FTP
server 22 to the end user 40 across the communication interface 30.
Alternatively, the parked dataset 23 may be pushed across the communication interface 30 and into the end user 40 (and into the end-user database 42) through use of the push software 26 that is coupled to the FTP
server 22. The direction of the arrowhead shown on the communication path 6 between the push software 26 and the FTP server 22 denotes that the push software 26 is pushing the dataset 23 from a computer-readable medium of the FTP server 22 to the end user 40 across the communication interface 30. Thus, "pulling" the dataset 23 into an end user from a source comprises using software that exists within the end user to trigger copying the dataset from the source and transmitting the copied dataset to the end user. "Pushing" a dataset into an end user from a source comprises using software external to the end user to trigger copying the dataset from the source and transmitting the copied dataset to the end user.
Pushing the dataset 21 (that is ultimately intended to be transmitted to the end user 40 as the dataset 23) from the real-time database 20 to a computer-readable medium of the FTP server 22 may be triggered to occur upon satisfaction of a condition. The condition may be individualized for individual end users. The condition may be time dependent.
For example, one end user may have arranged for the dataset 21 to be pushed to a computer-readable medium of the FTP server 22 at 8:00AM every day, while another end user may have arranged for the dataset 21 to be pushed to a computer-readable medium of the FTP server 22 at 12:00AM every Sunday. The condition may be event dependent. For example for TV scheduling updates, an end user may have arranged for the dataset 21 to be pushed to a computer-readable medium of the FTP server 22 whenever the updates 18 include the appearance of a new TV
program. The condition may be content dependent. For example for TV scheduling updates, an end user may have arranged for the dataset to be pushed to a computer-readable medium of the FTP server 22 whenever the updates 18 include strong language or adult situations. The condition may be primary key dependent. For example, the condition may comprise a requirement that a primary key of the dataset 21 matches a key in a list of keys, wherein the primary key makes the dataset unique within the real-time database. To illustrate for FIG. 4-7, the list of primary keys may include the station identifier primary key of the station record (see FIG. 5) and the program identifier primary key of the program record (see FIG. 6), so that if the dataset is a station record or a program record then the dataset will be pushed from the real-time database 20 to a computer-readable medium of the FTP server 22. The condition may include a requirement that the updates 18 include a specified data item that is being changed to a preselected value (e.g., the data item is: availability of closed captioning; and the preseleted value in the updates 18 is: YES, meaning that closed captioning is available). The condition may be expressed in any form such as a logical expression involving logical operators (e.g., AND, OR, NOT, etc.) and having any degree of logical complexity.
Although the FTP server 22 has been described herein as a destination that interfaces between the real-time database 20 and the communication interface 30, for the temporary parking of a dataset to be transmitted from the real-time database 20 to the end user 40, any other device or mechanism known to a person of ordinary skill in the art could be used instead of the FTP
server 22 to provide the functionality of the FTP server 22.
FIG. 2 depicts a system 11, which is equivalent to the system 10 of FIG. I
without the FTP server 22, in accordance with embodiments of the present invention. Aside from aspects of the system 11 as described infra, the features of the system 11 of FIG. 2 are the same as the corresponding features of the system 10 of FIG. 1 that have been described supra.
In FIG. 2, the real-time database 20 has been updated with the updates 18 extracted from the editorial database 14, as in FIG. 1. Subsequent transmission of the dataset 21 comprising a portion of said updates 18 from the real-time database 20 to the end user 40 may be effectuated by pulling or pushing the dataset 21 into the end-user database 42 of the end user 40. The end user 40 may pull the dataset 21 from the real-time database 20 across the communication interface 30 and into the end-user database 42 of the end user 40 through use of the pull software 44 that is comprised by the user 40. Thus in FIG. 2, the direction of the arrowhead shown on the communication path 7 between the pull software 44 and the end-user database 42 denotes that the pull software 44 is pulling the dataset 21 from the real-time database 20 to the end-user database 42 via across the communication interface 30. Alternatively, the dataset 21 may be pushed from the real-time database 20 across the communication interface 30 and into the end-user database 42 of end user 40 through use of the push software 25 that is coupled to the real-time database 20. Thus, the direction of the arrowhead shown on the communication path 8 between the push software 25 and the real-time database 20 denotes that the push software 25 is pushing the dataset 21 from the real-time database 20 to the end-user database 42 via across the communication interface 30. If the dataset is transmitted into the end-user database 42 immediately or shortly after the real-time database is updated (as described supra), then the end-user database 42 may be viewed as being updated in real time.
Transmitting, via pulling or pushing as described supra, the dataset from the real-time database 20 to the end-user database 42 of the end user 40 may be triggered to occur upon satisfaction of a condition. The condition may be individualized for individual end users. The condition may be time dependent. For example, one end user may have arranged for the dataset 21 to be transmitted to the end-user database 42 at 8:00AM every day, while another end user may have arranged for the dataset to be transmitted to the end-user database 42 at 12:00AM
every Sunday. The condition may be event dependent. For example for TV
scheduling updates, an end user may have arranged for the dataset to be transmitted to the end-user database 42 whenever the updates 18 include the appearance of a new TV program. The condition may be content dependent. For example for TV scheduling updates, an end user may have arranged for the dataset to be transmitted to the end-user database 42 whenever the updates 18 include strong language or adult situations. The condition may be primary key dependent. For example, the condition may comprise a requirement that a primary key of the dataset matches a key in a list of keys, wherein the primary key makes the dataset unique within the real-time database. To illustrate for FIGS. 4-7, the list of primary keys may include the station identifier primary key of the station record (see FIG. 5) and the program identifier primary key of the program record (see FIG. 6), so that if the dataset is a station record or a program record then the dataset will be transmitted from the real-time database 20 to the end-user database 42. The condition may include a requirement that the updates 18 include a specified data item that is being changed to a preselected value (e.g., the data item is: availability of closed captioning;
and the value in the updates 18 is: YES, meaning that closed captioning is available). The condition may be expressed in any form such as a logical expression involving logical operators (e.g., AND, OR, NOT, etc.) and having any degree of logical complexity.
FIG. 3 illustrates a computer system 90 for distributing entertainment scheduling data to end users from the real-time database 22 of FIGS. 1 and 2, in accordance with embodiments of the present invention. The computer system 90 comprises a processor 91, an input device 92 coupled to the processor 91, an output device 93 coupled to the processor 91, and memory devices 94 and 95 each coupled to the processor 91. The input device 92 may be, inter alia, a keyboard, a mouse, etc. The output device 93 may be, inter alia, a printer, a plotter, a computer screen, a magnetic tape, a removable hard disk, a floppy disk, a magnetic tape, an optical storage such as a compact disc (CD) or a digital video disc (DVD), a dynamic random access memory (DRAM), a read-only memory (ROM), etc. The memory device 95 includes a computer code 97.
The computer code 97 includes algorithms associated with any or all of the software of FIGS. 1 and 2 described supra, namely the real-time software 16 (see FIG. 1), the push software 24 (see FIG. 1), the push software 26 (see FIG. 1), the pull software 44 (see FIG. 1), the pull software 54 (see FIG. 1), and the push software 25 (see FIG. 2). The processor 91 executes the computer code 97. The memory device 94 includes input data 96. The input data 96 includes input required by the computer code 97. The output device 93 displays output from the computer code 97. Either or both memory devices 94 and 95 (or one or more additional memory devices not shown in FIG. 9) may be used as a computer usable medium (or a computer readable medium or a program storage device) having a computer readable program code embodied therein and/or having other data stored therein, wherein the computer readable program code comprises the computer code 97. Generally, a computer program product (or, alternatively, an article of manufacture) of the computer system 90 may comprise said computer usable medium (or said program storage device).
While FIG. 3 shows the computer system 90 as a particular configuration of hardware and software, any configuration of hardware and software, as would be known to a person of ordinary skill in the art, may be utilized for the purposes stated supra in conjunction with the particular computer system 90 of FIG. 9. For example, the memory devices 94 and 95 may be portions of a single memory device rather than separate memory devices.
The computer system 90 of FIG. 3 represents any of several different computer systems of the present invention. As a first example, the computer system 90 of FIG. 3 may include some or all of the editorial database 14, the real-time database 20, real-time software 16, push software 24, push software 26, push software 25, and FTP server 22, wherein any or all of the preceding software and databases may be stored in one or both of the memory devices 94 and 95 of FIG. 3.
As a second example, the computer system 90 of FIG. 3 may pertain to an end user such as the end user 40 of FIG. 1 and 2, and thus store the end-user database 42 and pull software 40 in one or both of the memory devices 94 and 95.
While particular embodiments of the present invention have been described herein for purposes of illustration, many modifications and changes will become apparent to those skilled in the art. Accordingly, the appended claims are intended to encompass all such modifications and changes as fall within the true spirit and scope of this invention.
Claims (10)
1. A method for distributing entertainment scheduling content in real-time from an editorial database to a real-time database, and then to a destination server, an then to an end-user database via a communication link, the distribution to the end-user database being based upon a plurality of end-user selection criteria, the method comprising the following steps:
entering the entertainment scheduling content into the editorial database, wherein the editorial database is recorded in a first computer-readable medium and wherein the entertainment scheduling content comprises new entertainment scheduling data not previously stored in the editorial database and correction entertainment scheduling data intended to replace existing data in the editorial database;
extracting the entertainment scheduling content from the editorial database wherein extraction of the content from the editorial database is based on factors other than a target environment context of any end users;
updating the real-time database with the extracted entertainment scheduling content by pushing via real-time software the entertainment scheduling content from the editorial database to the real-time database, wherein the real-time database is recorded in a second computer-readable medium;
adapting a portion of the entertainment scheduling content stored in the real-time database into an end-user specific dataset by applying a plurality of end-user selection criteria to the entertainment scheduling content stored in the real-time database;
pushing the end-user specific dataset to the destination server, wherein the destination server stores the dataset in a third computer-readable medium;
pulling the dataset from the destination server to the end-user database wherein the dataset is pulled to the end-user database via pull software running on the end user database, wherein the end-user database is recorded in a fourth computer-readable medium, the end-user database corresponds to the end-user selection criteria, and the dataset is adapted to be transmitted to the end-user database via the communication link between the destination server and the end-user database; and updating the end-user database with the dataset without logical modification of the dataset.
entering the entertainment scheduling content into the editorial database, wherein the editorial database is recorded in a first computer-readable medium and wherein the entertainment scheduling content comprises new entertainment scheduling data not previously stored in the editorial database and correction entertainment scheduling data intended to replace existing data in the editorial database;
extracting the entertainment scheduling content from the editorial database wherein extraction of the content from the editorial database is based on factors other than a target environment context of any end users;
updating the real-time database with the extracted entertainment scheduling content by pushing via real-time software the entertainment scheduling content from the editorial database to the real-time database, wherein the real-time database is recorded in a second computer-readable medium;
adapting a portion of the entertainment scheduling content stored in the real-time database into an end-user specific dataset by applying a plurality of end-user selection criteria to the entertainment scheduling content stored in the real-time database;
pushing the end-user specific dataset to the destination server, wherein the destination server stores the dataset in a third computer-readable medium;
pulling the dataset from the destination server to the end-user database wherein the dataset is pulled to the end-user database via pull software running on the end user database, wherein the end-user database is recorded in a fourth computer-readable medium, the end-user database corresponds to the end-user selection criteria, and the dataset is adapted to be transmitted to the end-user database via the communication link between the destination server and the end-user database; and updating the end-user database with the dataset without logical modification of the dataset.
2. The method of claim 1, wherein entering the entertainment scheduling content into the editorial database ends at time T1 and updating the real-time database with the extracted entertainment scheduling contend ends at time T2, wherein T2 - T1 does not exceed about 240 minutes.
3. The method of claim 1, said method further comprising repeating N times said updating the real-time database with additional entertainment scheduling content derived from the editorial database, wherein N is at least 1, wherein for each updating, .DELTA.T indicates T2 - T1 for the respective updating, wherein .DELTA.T AVE is the statistical average computed as .SIGMA.
(.DELTA.T)/N, and wherein .DELTA.T AVE does not exceed about 10 minutes.
(.DELTA.T)/N, and wherein .DELTA.T AVE does not exceed about 10 minutes.
4. The method of claim 3, wherein the statistical average is an arithmetic average.
5. The method of claim 1, wherein said updating comprises multi-threaded updating of said real-time database with said content.
6. The method of claim 1, wherein said entertainment scheduling data comprises television program scheduling data, and wherein said entertainment scheduling content comprises television program scheduling content.
7. The method of claim 1, wherein said entertainment scheduling data comprises movie-theatre scheduling data, and wherein said entertainment scheduling content comprises movie-theatre scheduling content.
8. The method of claim 1, wherein said entertainment scheduling data comprises scheduling data selected from the group consisting of sports events scheduling data, musical performance scheduling data, and live theatre scheduling data, and wherein said entertainment scheduling content comprises scheduling content selected from the group consisting of sports scheduling content, musical performance content, and live theatre scheduling content.
9. The method of claim 1, wherein the destination server is a File Transfer Protocol (FTP) server.
10. The method of claim 1, wherein the communication link comprises the Internet.
Applications Claiming Priority (2)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| US10/265,564 US7971218B2 (en) | 2002-10-04 | 2002-10-04 | Distribution of real-time entertainment scheduling data |
| US10/265,564 | 2002-10-04 |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CA2442634A1 CA2442634A1 (en) | 2004-04-04 |
| CA2442634C true CA2442634C (en) | 2012-01-31 |
Family
ID=32042482
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CA2442634A Expired - Lifetime CA2442634C (en) | 2002-10-04 | 2003-09-25 | Distribution of real-time entertainment scheduling data |
Country Status (4)
| Country | Link |
|---|---|
| US (1) | US7971218B2 (en) |
| EP (1) | EP1411447A3 (en) |
| CA (1) | CA2442634C (en) |
| MX (1) | MXPA03008831A (en) |
Families Citing this family (14)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US20060064721A1 (en) * | 2004-03-10 | 2006-03-23 | Techfoundries, Inc. | Method and apparatus for implementing a synchronized electronic program guide application |
| US20050278195A1 (en) * | 2004-05-28 | 2005-12-15 | Getz Harry L | Method for scheduling viewing of a live medical procedure |
| GB0420814D0 (en) * | 2004-09-18 | 2004-10-20 | Koninkl Philips Electronics Nv | Managing stored service information |
| US7673240B2 (en) * | 2005-12-30 | 2010-03-02 | Polaroid Labs, Llc | Ubiquitous navbar user interface across multiple heterogeneous digital media devices |
| WO2007136423A2 (en) * | 2005-12-30 | 2007-11-29 | Bmo Llc | Digital content delivery via virtual private network(vpn) incorporating secured set-top devices |
| US20080281718A1 (en) * | 2007-01-08 | 2008-11-13 | Barrett Morgan | Household network incorporating secure set-top devices |
| US20090112676A1 (en) * | 2007-03-09 | 2009-04-30 | Dts, Inc. | System and method for cinema exhibition management |
| US8341675B2 (en) * | 2007-12-19 | 2012-12-25 | The Directv Group, Inc. | Method and system for providing program guide data from a content provider to a user device through a partner service provider based upon user attributes |
| US9137018B2 (en) * | 2007-12-19 | 2015-09-15 | The Directv Group, Inc. | Method and system for providing a generic program guide data from a primary content provider to a user network device through a partner service provider |
| US20090165088A1 (en) * | 2007-12-19 | 2009-06-25 | Kapil Chaudhry | Method and system for providing a content list and content clips to a user network device through an intermediate web provider |
| US20090271399A1 (en) * | 2008-04-28 | 2009-10-29 | The Directv Group, Inc. | Method and system for searching content at a primary service provider through a partner service provider |
| JP2010028691A (en) * | 2008-07-24 | 2010-02-04 | Nec Corp | Method and device for receiving and reproducing content |
| US9485536B1 (en) * | 2008-09-03 | 2016-11-01 | The Directv Group, Inc. | Method and system for updating programming listing data for a broadcasting system |
| CN103914573B (en) * | 2014-04-29 | 2017-11-03 | 国家电网公司 | A kind of site moving method and device |
Family Cites Families (17)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US5790198A (en) * | 1990-09-10 | 1998-08-04 | Starsight Telecast, Inc. | Television schedule information transmission and utilization system and process |
| US6239794B1 (en) | 1994-08-31 | 2001-05-29 | E Guide, Inc. | Method and system for simultaneously displaying a television program and information about the program |
| US5666645A (en) * | 1995-04-26 | 1997-09-09 | News America Publications, Inc. | Data management and distribution system and method for an electronic television program guide |
| US6807558B1 (en) * | 1995-06-12 | 2004-10-19 | Pointcast, Inc. | Utilization of information “push” technology |
| US6707503B1 (en) * | 1995-07-27 | 2004-03-16 | Hitachi, Ltd. | Video signal processing device for automatically adjusting phase of sampling clocks |
| US5657072A (en) | 1996-04-10 | 1997-08-12 | Microsoft Corporation | Interactive entertainment network system and method for providing program listings during non-peak times |
| WO1998026584A1 (en) | 1996-12-10 | 1998-06-18 | United Video Properties, Inc. | Internet television program guide system |
| US6453471B1 (en) * | 1996-12-13 | 2002-09-17 | Starsight Telecast, Inc. | Electronic programming guide with movie preview |
| US5893091A (en) | 1997-04-11 | 1999-04-06 | Immediata Corporation | Multicasting with key words |
| US6209130B1 (en) * | 1997-10-10 | 2001-03-27 | United Video Properties, Inc. | System for collecting television program data |
| US6536041B1 (en) * | 1998-06-16 | 2003-03-18 | United Video Properties, Inc. | Program guide system with real-time data sources |
| US6268849B1 (en) * | 1998-06-30 | 2001-07-31 | United Video Properties, Inc. | Internet television program guide system with embedded real-time data |
| US6317881B1 (en) | 1998-11-04 | 2001-11-13 | Intel Corporation | Method and apparatus for collecting and providing viewer feedback to a broadcast |
| US6904609B1 (en) * | 1999-03-18 | 2005-06-07 | Microsoft Corporation | Systems and methods for electronic program guide data services |
| US6427137B2 (en) * | 1999-08-31 | 2002-07-30 | Accenture Llp | System, method and article of manufacture for a voice analysis system that detects nervousness for preventing fraud |
| WO2002017075A2 (en) * | 2000-08-22 | 2002-02-28 | Symbian Limited | A method of enabling a wireless information device to access data services |
| US6968334B2 (en) * | 2001-05-15 | 2005-11-22 | Nokia Corporation | Method and business process to maintain privacy in distributed recommendation systems |
-
2002
- 2002-10-04 US US10/265,564 patent/US7971218B2/en active Active
-
2003
- 2003-09-25 CA CA2442634A patent/CA2442634C/en not_active Expired - Lifetime
- 2003-09-29 MX MXPA03008831A patent/MXPA03008831A/en active IP Right Grant
- 2003-10-02 EP EP03256232A patent/EP1411447A3/en not_active Ceased
Also Published As
| Publication number | Publication date |
|---|---|
| MXPA03008831A (en) | 2004-04-20 |
| EP1411447A2 (en) | 2004-04-21 |
| US7971218B2 (en) | 2011-06-28 |
| CA2442634A1 (en) | 2004-04-04 |
| US20040068742A1 (en) | 2004-04-08 |
| EP1411447A3 (en) | 2006-07-05 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CA2442634C (en) | Distribution of real-time entertainment scheduling data | |
| US6295092B1 (en) | System for analyzing television programs | |
| JP4363806B2 (en) | Audiovisual program management system and audiovisual program management method | |
| US7209942B1 (en) | Information providing method and apparatus, and information reception apparatus | |
| DK2418594T3 (en) | Visualization and grouping method of maintaining the order of the assets in a playlist. | |
| US7835920B2 (en) | Director interface for production automation control | |
| US20030097657A1 (en) | Method and system for delivery of targeted programming | |
| US20040073919A1 (en) | Commercial recommender | |
| US20120079385A1 (en) | Systems and methods for using playlists | |
| US9118949B2 (en) | System and method for networked PVR storage and content capture | |
| Jiang et al. | Live: an integrated production and feedback system for intelligent and interactive tv broadcasting | |
| US11564004B2 (en) | Systems and methods for generating a playback timeline | |
| US11489923B2 (en) | Network controlled content recording using network and local storage | |
| US20200382841A1 (en) | Systems and methods for generating a playback timeline | |
| CN101657858B (en) | Analysing video material | |
| JP4656202B2 (en) | Information processing apparatus and method, program, and recording medium | |
| JP4656203B2 (en) | Information processing apparatus and method, program, and recording medium | |
| US11209958B2 (en) | Behavior-influenced content access/navigation menus | |
| JP2002176401A (en) | Method and system for generating program-related information | |
| Ryu et al. | Structured modeling for video databases | |
| Juuso | METADATA TOOLS FOR DIGITAL MOTION PICTURE ARCHIVES | |
| AU2006230809A1 (en) | Schedules of a broadcast management system |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| EEER | Examination request | ||
| MKEX | Expiry |
Effective date: 20230925 |