BACKGROUND OF THE INVENTION1. Field of the Invention
The present invention relates to a system for searching TV program data via the Internet, and particularly to a system that manages TV program data received from broadcasting stations and provides users with TV program data and tabulated data of searches performed by the user on the TV program data.
2. Description of the Related Art
Examples of media used conventionally to provide users with information on TV programs include advertisements on TV programs and TV guide magazines. Advertisements of TV programs include those that are broadcast during station breaks between programs and those broadcast during a program to advertise upcoming programs in the series. However, the time period in which programs are advertised is determined by the broadcasting stations and, due to the varied lifestyles of viewers and the limitations of broadcasting times, it is not possible to reach all viewers with this advertising method.
While TV guide magazines are not restricted by time, as are the TV program advertisements, they have less impact on the viewers than the TV program advertisements because the magazines cannot include video or sound.
Further, viewer percentages for TV programs are obtained for periods during and at the end of a broadcast. This data is published after the program has been aired. However, an index showing the interest of viewers for programs to be broadcast in the future is not available.
SUMMARY OF THE INVENTIONIn view of the foregoing, it is an object of the present invention to provide a system for searching TV program data, which system manages TV program data received from broadcasting stations via the Internet and provides users with the TV program data and tabulated data on searches that viewers have performed on the TV program data.
These objects and others will be attained by a system for searching TV program data via the Internet for managing TV program data supplied by broadcasting stations via the Internet and providing TV program data and tabulated data on results of searching the TV program data to a user.
The system comprises broadcasting station terminals provided for broadcasting stations supplying the TV program data; user terminals for receiving the TV program data; and a data management apparatus connected to the broadcasting station terminals and user terminals via the Internet.
The data management apparatus comprises a communication connection controller connected to the Internet via a firewall; a database; a web server that receives via the Internet search requirements from the user terminals and transmits via the Internet results of searching the database; a database server for searching and updating the database; a data management terminal for managing the database; and a central processing controller.
The database comprises a program data database including a timetable for recording data of the broadcasting schedule for TV programs, and a subject matter table for storing program guide data; a user table for recording user registration data of users searching the TV program data; a usage fees table for recording usage data of the users; and a user database formed of a search tabulation table for recording tabulation data of searches performed by the user.
The central processing controller comprises program data recording means that includes broadcasting schedule recording means for receiving entry requirements from the broadcasting station terminals and recording broadcasting schedule data in the timetable and subject matter recording means for recording program guide data in the subject matter table; user contract recording means that includes user registration means for receiving requirements from user terminals and recording user registration data in the user table and contract time recording means for receiving requirements from the data management terminal and storing contract time data in the user table and the usage fees table; program data searching means for receiving requirements from the user terminals and searching for broadcasting schedule data and program guide data recorded in the program data database; and tabulation usage fees recording means that includes search tabulation recording means for recording the search tabulation data in a search tabulation table, the search tabulation data being the number of searches performed on TV program data recorded in the timetable by the program data searching means and tabulated according to broadcasting date, user attributes, program category, and program, and usage fees data recording means for recording usage fees data for searching TV program data in the usage fees table.
According to another aspect of the present invention, the program data searching means comprises month specific searching means for searching the timetable for broadcasting schedule data and program guide data according to a specified broadcast month; day specific searching means for searching the timetable for broadcasting schedule data and program guide data according to a specified broadcast day; program category specific searching means for searching the timetable for broadcasting schedule data and program guide data according to a specified program category; and station data access ratio searching means for calculating the access ratio of program data according to programs by user attributes, programs by program category, and program according to tabulated search data recorded in the search tabulation table by the search tabulation recording means and searching the search tabulation data in the reverse order of the program data access ratio.
According to another aspect of the present invention, the TV program data includes television program data of Internet TV broadcasting stations that broadcast via the Internet.
BRIEF DESCRIPTION OF THE DRAWINGSIn the drawings:
FIG. 1 is an explanatory diagram showing the construction of a system of the present invention for searching TV program data via the Internet;
FIG. 2 is a flowchart showing the process flow in a central processing controller of the present invention;
FIG. 3 is a flowchart showing the process flow in a central processing controller of the present invention; and
FIG. 4 is a flowchart showing the process flow in a central processing controller of the present invention.
DESCRIPTION OF THE PREFERRED EMBODIMENTSA system for searching TV program data via the Internet according to preferred embodiments of the present invention will be described while referring to the accompanying drawings.FIG. 1 is an explanatory diagram showing the construction of asystem100 of the present invention for searching TV program data via the Internet.
As shown inFIG. 1, thesystem100 includesbroadcasting station terminals1 provided for broadcasting stations supplying the TV program data; user terminals2 for receiving the TV program data; and adata management apparatus50 connected to thebroadcasting station terminals1 and user terminals2 via the Internet.
The data management apparatus includes acommunication connection controller4 having a firewall for connecting thesystem100 to the Internet; adatabase10; aweb server5 that receives via the Internet search requirements from the user terminals2 and transmits via the Internet results of searching thedatabase10; a database server6 for searching and updating thedatabase10; adata management terminal7 for managing thedatabase10; and acentral processing controller20. In addition a LAN8 is provided to connect thecommunication connection controller4, theweb server5, and thedatabase10 to each other.
The database includes aprogram data database11 comprising atimetable11a for recording data of the broadcasting schedule for TV programs and a subject matter table11b for storing program guide data; auser database12 formed of a user table12a for recording user registration data of users searching the TV program data, a usage fees table12b for recording usage data of the users; and a search tabulation table12c for recording tabulation data of searches performed by the users.
The time table11a records broadcast schedule data. Data stored in thetimetable11a includes year and month search keys comprising a broadcasting station code, broadcast year and month, broadcast starting time, broadcast day of the week, and broadcast day; broadcast year, month, and day search keys comprising a broadcasting station code, broadcast year, month, and day, broadcast day of the week, and broadcast starting time; program search keys comprising broadcast codes, program category codes, and program codes; and program titles, program times, and subject matter codes are stored in a data section.
The program category codes are set to such broad categories as sports, music, serial shows, movies, comedies, documentaries, specials, and new programs. Codes are further set for more specific categories on two levels under these broad categories.
The subject matter table11b records program guide data. Data stored in the subject matter table11b includes subject matter search keys comprising broadcasting station codes and subject matter codes; and a station guide employing audio and video stored in the data section.
Theuser database12 is configured of a user table12a, a usage fees table12b, and a search tabulation table12c.
The user table12a records user registration data. The user table12a stores user codes belonging to the search key section and user attribute data belonging to the data section, including the user name, address, telephone number, remaining time on contract, sex, age, and occupation.
The usage fees table12b records usage data. The usage fees table12b stores user codes belonging to the search key section and such data belonging to the data section as the process category, search start year, month, and day, search start time, search end year, month, and day, search end time, length of search time, and remaining time on contract. The process category is set to “contract” when entering a contract time and to “search” when searching for program data.
The search tabulation table12c records search tabulation data. The search tabulation table12c stores broadcast date data belonging to the search key section and comprising broadcast year, month, and day and broadcast day of the week; user attribute data comprising the user's sex, age, and occupation; search tabulation keys including program data comprising a broadcasting station code, program category code, and program code; and number of searches belonging to the data section.
In response to request signals received from thebroadcasting station terminals1, user terminals2, anddata management terminal7 via the Internet3. Thecentral processing controller20 searches and updates thedatabase10. The procedure for searching and updating thedatabase10 will be described next with reference to the diagrams.FIGS. 2,3, and4 show the flow of processes in thecentral processing controller20 of the present invention. The process flow is configured of the following four procedures.
Thecentral processing controller20 includes program data recording means21 that includes broadcasting schedule recording means21a for receiving entry requirements from the broadcasting station terminals and recording broadcasting schedule data in the timetable, and subject matter recording means21b for recording program guide data in the subject matter table.
Thecentral processing controller20 further includes user contract recording means22 that includes user registration means22a for receiving requirements from user terminals and recording user registration data in the user table and contract time recording means22b for receiving requirements from the data management terminal and storing contract time data in the user table and the usage fees table.
Thecentral processing controller20 further includes a program data search means23 comprising month specific searching means23a for searching the timetable for broadcasting schedule data and program guide data according to a specified broadcast month; day specific searching means23b for searching the timetable for broadcasting schedule data and program guide data according to a specified broadcast day; program category specific searching means23c for searching the timetable for broadcasting schedule data and program guide data according to a specified program category; and station data access ratio searching means23d for searching search tabulation data recorded in the search tabulation table.
Thecentral processing controller20 further includes tabulation usage fees recording means24 comprising search tabulation recording means24a for recording the tabulation data for searches on TV program data in the search tabulation table after the programdata search means23 is executed, and usage fees data recording means24b for recording usage fees charged for searching TV program data in the usage fees table.
First, the terminal ID and password input from thebroadcasting station terminals1, user terminals2, ordata management terminal7 are verified to determine user authorization. If the ID and password are authorized, then a web page corresponding to the selection input in the menu is transmitted. Next, the process of the program data recording means21 will be described.
In the process of the broadcast schedule recording means21a (S10), a web page for recording the broadcast schedule is transmitted to thebroadcasting station terminal1 in response to a signal requesting a to record a broadcast schedule. A broadcast data file is received from thebroadcasting station terminal1 and recorded in thetimetable11a. As described above, the file stores the year and month search keys comprising the broadcasting station code, broadcast year and month, broadcast starting time, broadcast day of the week, and broadcast day; broadcast year, month, and day search keys comprising a broadcasting station code, broadcast year, month, and day, broadcast day of the week, and broadcast starting time; program search keys comprising broadcast codes, program category codes, and program codes; and program titles, program times, and subject matter codes are stored in a data section. After recording the data, a web page indicating that the broadcast schedule recording process has completed is transmitted to thebroadcasting station terminal1.
When the user of thebroadcasting station terminal1 selects “end,” a web page displaying a menu of selections is transmitted to thebroadcasting station terminal1.
In the process of the subject matter recording means21b (S11), a web page for recording subject matter is transmitted to thebroadcasting station terminal1 in response to a signal requesting to record such data is received therefrom. A program guide data file is received and recorded in the subject matter table11b. The file includes the subject matter search keys comprising broadcasting station codes and subject matter codes; and a station guide employing audio and video stored in the data section. After recording is completed, a web page indicating that the recording process has completed is transmitted to thebroadcasting station terminal1.
When the user of thebroadcasting station terminal1 selects “end,” a web page displaying a menu of selections is transmitted to thebroadcasting station terminal1.
In the process of the user recording means22a (S20), a user registration web page is transmitted to the user terminal2 in response to a signal by the user requesting to register. The user enters such registration data as user name, address, telephone number, sex, age, and occupation. The registration data is received and an auto-numbered user code for the search key section is stored along with the registration data for the data section in the user table12a. A web page showing an edited display of the user code and the user registration data and indicating the end of the user registration process is transmitted to the user terminal2.
When the user of thebroadcasting station terminal1 selects “end,” a web page displaying a menu of selections is transmitted to thebroadcasting station terminal1.
In the process of the contract time recording means22b (S21), a web page for recording the contract date and inputting a user code is transmitted to thedata management terminal7 in response to a signal requesting to enter such data. After receiving input of the user code and contract year, month, and day from thedata management terminal7, the user table12a is searched using the input user code as a search key. The user code and user registration data including the user name, address, telephone number, remaining time on contract, sex, age, and occupation stored in the user table12a is edited and output on a web page for recording and inputting the contract time. This web page is transmitted to thedata management terminal7. After receiving a contract time input from thedata management terminal7, this input contract time is added to the remaining contract time in the user table12a, and the user table12a is updated. The user code, the process category set to “contract,” the search start time set to the contract year, month, and day, and the added remaining contract time are recorded in the usage fees table12b. A web page showing an edited display of the user code and the user registration data and indicating the end of the contract time registration process is transmitted to the user terminal2.
When the user of thebroadcasting station terminal1 selects “end,” a web page displaying a menu of selections is transmitted to thebroadcasting station terminal1.
In the user code input process (S30), a web page for inputting a user code is transmitted to the user terminal2 in response to a signal from the user terminal2 requesting to search program data. After receiving the user code input from the user terminal2, the user table12a is searched using this user code as a search key. Further checks are performed on the user code registration and remaining contract time. If the contract has not expired, then the user makes a selection from among the month specific search means23a, broadcast day specific search means23b, program category selection search means23c, and program data access ratio search means23d.
The time elapsed during searches is monitored by acquiring the system date and system time during the process performed by the program data search means23. When the remaining time on the contract expires, a web page indicating that the contract has expired for using the TV program search system is transmitted to the user terminal2 and the process of the program data search means23 is interrupted.
In the process of the month specific search means23a (S31), a web page for specifying a month of program data is transmitted to the user terminal2 in response to a signal from the user terminal2 requesting such a search. After receiving the year and month search start key input from the user terminal2, including the broadcasting station code and broadcasting year and month, thetimetable11a is searched based on this data to acquire broadcast schedule data comprising the broadcast start time, day of the week, day, program code, program title, and program time. A web page for searching program data, specifying a month, or selecting a program is transmitted to the user terminal2. The web page shows an edited display of the year and month search start key data as the header with the program code, program title, and program time listed according to broadcast start time, day of the week, and date. After receiving a selection of program search key data from the user terminal2 comprising a broadcasting station code, program category code, and program code, thetimetable11a is searched to acquire subject matter search key data and the subject matter table11b is searched to acquire a program guide. Next, a web page indicating completion of the program data search and selection outputting the audio and video of the program guide is transmitted to the user terminal2, and the search tabulation record process in S40 is executed.
In the process of the broadcast day specific search means23b (S32), a web page for performing a broadcast date specific program data search is transmitted to the user terminal2 in response to a signal there from requesting such a search. After receiving input from the user terminal2 that includes year, month, and day search start key data comprising a broadcasting station code and broadcast year, month, and day, thetimetable11a is searched to obtain broadcast schedule data comprising the broadcast day of the week, the broadcast start time, and the program title and time. A web page for searching program data, specifying the broadcast day, and selecting a program is output to the user terminal2. The web page shows an edited display of program titles and times according to the broadcast start time with a header containing the date search start key data and broadcast day of the week. After receiving a selection of program search key data from the user terminal2 comprising a broadcasting station code, program category code, and program code, thetimetable11a is searched to acquire subject matter search key data and the subject matter table11b is searched to acquire a program guide. Next, a web page indicating completion of the program data search and selection outputting the audio and video of the program guide is transmitted to the user terminal2, and the search tabulation record process in S40 is executed.
In the process of the program category selection search means23c (S33), a web page for searching program data and selecting a program category is transmitted to the user terminal2 in response to a signal requesting such a search. After receiving a selection from the user terminal2 for program search start key data comprising a broadcasting station code, thetimetable11a is searched to obtain a program category code. A web page for searching program data and selecting a program category is sent to the user terminal2. The web page displays an edited list of program category codes with the broadcasting station code as the header. After receiving a selection of program search key data from the user terminal2 comprising a broadcasting station code, program category code, and program code, thetimetable11a is searched to acquire the program title and time and the broadcast day of the week and year, month, and day. Next, a web page for searching program data, selecting a program category, and selecting a program is transmitted to the user terminal2. The web page displays an edited list of programs comprising program titles, broadcast days of the week and dates, and broadcast start times with a header containing the broadcasting station code and program category code. After receiving a selection from the user terminal2 for the program search key data comprising the broadcasting station code, program category code, and program code, thetimetable11a is searched to obtain the subject matter search key data, and the subject matter table11b is searched to obtain a program guide. Next, a web page indicating completion of the program data search and selection outputting the audio and video of the program guide is transmitted to the user terminal2, and the search tabulation record process in S40 is executed.
In the program data access ratio search means23d (S34), a web page for searching program data access ratios is transmitted to the user terminal2 in response to a signal requesting such a search. After receiving input from the user terminal2 comprising the broadcast period and user attribute data, search tabulation data between the start and end date input for the broadcast period is extracted from the search tabulation table12c. The number of search hits for data having the same user attribute data, broadcast data, and TV program data is tabulated based on the input user attribute data. The program data access ratio (program data access ratio=search number+user table record number×100) is found for the search tabulation data. The data is sorted based on the reverse order of the access ratio found. Next, a program data access ratio search end web page is transmitted to the user terminal2. The web page displays an edited list of program data access ratios with a header containing the broadcast period and user attributes. The search tabulation record process in S40 is executed.
The process of the search tabulation recording means24a (S40) is performed after the process executed by the program data search means23. Here, the user table12a is searched using the user code input in S30 as the search key data, and the user attribute data, including the user's sex, age, and occupation, is extracted. The search tabulation table12c is searched using search key data of the search tabulation key, including user attributes, broadcast day data comprising the broadcast date and day of the week acquired by the usage fees tabulation recording means24, and program data comprising the broadcasting station code, program category code, and program code. The number of searches is incremented by 1 and the search tabulation table12c is updated.
When the user of thebroadcasting station terminal1 selects “end,” a web page displaying a menu of selections is transmitted to thebroadcasting station terminal1. When “end” is selected on the web page, the usage fees data recording process of S41 is performed.
The process in S41 is performed by the usage fees data recording means24b following the process of the usage fees tabulation recording means24. The user table12a is searched using the user code input in S30 as the search key data. The remaining contract time in the user table12a is updated after subtracting the search time of searches performed by the usage fees tabulation recording means24 from the remaining contract time. The user code, process category set to “search,” search start date and time and end date and time and search duration for searching with the usage fees tabulation recording means24, and the calculated remaining contract time are recorded in the usage fees table12b. A TV program data search system end web page is transmitted to the user terminal2.
While the invention has been described in detail with reference to specific embodiments thereof, it would be apparent to those skilled in the art that many modifications and variations may be made therein without departing from the spirit of the invention, the scope of which is defined by the attached claims.
The system for searching TV program data via the Internet of the present invention can target users having a wide variety of lifestyles and enables such users to select and search TV program data of their interest via the Internet at a time suiting their lifestyles.
Further, the functions for searching TV program data of the present invention include searching TV programs not only in the range of one day or one week, but also in the range of one month. If the name of the program is not known, the user can specify the genre of the program to find that program's name and broadcast date and time.
Unlike conventional TV program data, the present invention enables users to search TV program data prior to the program's broadcast to find programs of a high interest for use as statistical data.