JP4481290B2 - Database server for online karaoke system - Google Patents

Description

  The present invention relates to a technical improvement for improving the entertainment of karaoke, and in particular, a database creation technology for analyzing and storing related music according to the taste of a karaoke user who likes a certain karaoke music based on performance results. About.

  As is well known, the communication karaoke system is composed of a large number of karaoke terminals and a karaoke host device that distributes karaoke data that is the origin of karaoke accompaniment music and lyrics images via an information communication network. The karaoke host device also has a function as a database server, and collects operation logs such as performance histories and error histories recorded by each karaoke terminal in a timely manner and stores them in its own external storage. Then, the collected operation log is used as reference data when the karaoke company operates various services, or is processed into ranking information presented to the user.

The karaoke host device also includes a member information database that stores and manages personal information and history information related to karaoke use in association with member IDs (personal IDs) of registered users. For example, the member information is downloaded to each karaoke terminal and used as appropriate when each member uses karaoke. Japanese Patent Laid-Open No. 2003-345370 discloses that personal information such as performance history is collected on a server using a personally owned mobile phone, or downloaded from a server to a personally owned mobile phone when using karaoke. A communication karaoke system to be used is disclosed. Moreover, in the communication karaoke system disclosed in Japanese Patent Application Laid-Open No. 2005-49706, favorite music is registered in a storage area for each user in the karaoke host device, and the registered music is selected when the karaoke is used. It can be used.
JP 2003-345370 A JP 2005-49706 A

  The operation log and member performance history accumulated in the karaoke host device, or information on the favorite music registered by each member, is the music selection tendency of a specific individual, a group including that individual, or the overall karaoke user Potentially contains information to understand

  Therefore, the present inventors have made it possible for the user who has selected a certain piece of music to make it suitable for the user by properly linking specific information from the enormous operation log and member performance history accumulated in the karaoke host device. I thought that other songs along the way could be presented as the next song selection candidates. If this is possible, users will be able to find and select their favorite songs one after another, and the music selection operation itself will be fun. If the willingness to sing the presented music is divided, the repertoire will increase and karaoke will become more fun. You don't have to worry about music selection, and you can enjoy listening to other people's songs and singing and enjoying the karaoke experience. As a result, the entertainment of karaoke increases dramatically. The present invention has been created in anticipation of such an effect.

The present invention is specified by the following items (1) to (14).
(1) A performance record database, a favorite song database, a related song database, and a database server that includes control means and communicates with a plurality of karaoke apparatuses via a network. (2) The performance record database includes a song ID, Aggregating the association information of the number of performances (3) The favorite song database aggregates the association information of the personal ID and the favorite song ID set (4) The related song database is the clue song ID and the related song ID set (5) The control means performs favorite song download processing, favorite song upload processing, concentration processing, database creation processing, and distribution processing (6) favorite song download processing When a personal ID is received from a karaoke device, a favorite corresponding to the personal ID from the favorite song database Transmitting the song ID set (7) When the favorite song upload process receives the association information between the personal ID and the song ID from the karaoke device, the favorite song upload process updates the information corresponding to the personal ID in the favorite song database (8). ) Concentration processing collects performance record information from each karaoke device and updates the performance record database. (9) The database creation process performs the first to fourth processes.
(10) The first process selects a plurality of music IDs with a large number of performances as clue music IDs from the performance record database. (11) The second process includes one clue music ID selected in the first process. Extracting favorite song song ID set from favorite song database (12) The third process merges a plurality of favorite song song ID sets extracted in the second process and refers to the performance record database to merge the songs Extracting a plurality of music pieces from the entire set in descending order of the number of performances (13) The fourth process is one clue music ID and a plurality of music IDs extracted in the third process based on the music ID. (14) The distribution process distributes the created related music database to each karaoke device. When

  According to the database server according to the present invention, it is possible to statistically analyze operation logs and member information collected by the communication karaoke system, and to create a database composed of a set of music pieces with matching preferences. If this database is used, for example, when a karaoke user selects a song, a song that the song selector seems to like or a song similar in style can be presented as the next song selection candidate. . As a result, for example, there was such a song that I forgot, I could sing such a song, the range of song selection widened, I did not know this song, but I liked it, it was a song that was easy for me to sing In other words, there is a high possibility that it will lead to fresh discoveries.

  It leads to an opportunity to sing various new songs as well as regular songs. In addition, since it is presented from member selections of similar tastes, it can be effectively presented as a recommended song. You can enjoy the original karaoke enjoyment of singing and listening to other people's songs without worrying about the music selection operation.

=== Network configuration ===
FIG. 1 shows a network configuration of a communication karaoke system including a database server in an embodiment of the present invention. A VPN (Virtual Private Network) 60 using the Internet is connected to a LAN 110 and a karaoke server 70 installed in karaoke stores 100 at various locations of karaoke operators, thereby forming a wide area intranet. In each guest room of the karaoke store 100 having a plurality of guest rooms in various places, a performance terminal 10 of a well-known communication karaoke system and a karaoke music selection device 20 for operating the performance terminal are installed. The performance terminal 10 communicates with the karaoke karaoke music selection apparatus 20 in the same room via the LAN 110, or communicates with the karaoke server 70 via the VPN 60 connected via the router 50.

  The karaoke music selection device 20 is a tablet computer having a touch panel as a main user interface. The built-in hard disk device supports not only a program for causing the tablet computer to function as a karaoke music selection device, but also karaoke music that can be played on the performance terminal 10 with contents information such as song name, artist name, and music genre, corresponding to the music ID. A music index database is also stored. Then, the table of contents information of the music desired by the user is retrieved from the index database and presented by the interactive user interface environment using the touch panel. When a reservation instruction for the presented music is received by user input, a performance reservation message including the music ID of the music is transferred to the performance terminal 10. The performance terminal 10 registers the music ID in the performance processing queue.

=== Database server ===
The karaoke server 70 is a computer system having a basic function as a host device in the communication karaoke system, and includes various databases. The karaoke database accumulates karaoke data that is the origin of karaoke music, and the performance record database records the number of performances of each tune that has been played using the tune ID as a key. It is updated from time to time based on the received operation log. The member information database stores member IDs associated with member personal information and history information related to karaoke use. In this embodiment, the IC card number unique to the IC card held by the user registered as a member is used as the member ID.

  And it communicates with the performance terminal 10 and the karaoke music selection apparatus 20 via VPN60 in a timely manner, distributes karaoke data, collects information related to registration and update of operation logs and member information, and performs performance database and member information. The database is updated from time to time.

  The karaoke server 70 also comes with a favorite song database created based on the member information database. In the favorite song database, a member ID and a song ID group (hereinafter, My list) of a favorite song of each member are recorded in association with each other.

  Each member can operate the karaoke song selection apparatus 20 to send his / her member ID to the karaoke server 70 and log in to the karaoke server 70 to download his / her My List to the karaoke song selection apparatus 20. The user can browse the downloaded My list or select a song to be reserved for performance from the performance terminal 10 from the My list.

  In addition, the My list can be updated such as registration of new music and deletion of registered music. The My list updated by the karaoke music selection apparatus 20 is uploaded to the karaoke server 70 in association with the member ID at an appropriate opportunity such as when the member ends use, and the favorite song database is updated.

=== Related music database ===
The karaoke server 70 of this embodiment is characterized in that it includes a related music database in addition to the above-mentioned various databases. The related music database is updated from time to time based on the favorite song database, and can be used, for example, for recommending other music that matches the taste to the user who has selected a music.

  2 (1) to 2 (3) illustrate the data creation procedure of the related music database. First, at appropriate occasions, such as after regular maintenance hours outside of business hours or after updating the performance record database, the performance record database is referred to, and the song IDs contained therein, for example, in descending order of the number of performances. One is taken out as a clue (for example, 1543-25, hereinafter a). Next, the favorite song database is referred to based on the extracted a, and among the many My lists, those including a are extracted and totaled for each music ID (see FIG. 2 (1)). That is, the My list of a plurality of members who have registered a in the My list is extracted, and the music IDs registered in them are listed. Then, the performance record database is referenced based on the listed music IDs, a predetermined number of music IDs are stored in descending order of the number of performances, and associated with a as a related music ID of a (FIG. 2 (2) to 2). (3)). In this way, the member who likes a and is registered in the My list, for example, the top 10 songs in the descending order of the performance frequency among the many songs that are favorably registered in addition to a, for example, are related songs of a. Can be extracted. These related songs of a are in line with the preferences of a large number of members who prefer a. Therefore, there is a possibility that they all match the preferences of the person who selected a, such as being similar to a. high.

  As a next clue, the karaoke server 70 extracts, for example, a song ID (b) having the highest number of performances after a, and refers to the favorite song database and the performance database based on the extracted b. Then, the related music ID of b is extracted as in the case of a. In this way, the music IDs included in the performance record database are extracted one by one as the clue music ID, and the process of extracting the related music ID for each clue music ID is repeated. Then, the related music data in which the clue music ID and the related music ID are associated with each other are aggregated using the clue music ID as a key to construct a related music database. The clue music ID may be all music IDs included in the performance record database, or may be a predetermined number of music IDs in order of the number of performances, for example, among the music IDs included in the performance record database.

  The karaoke server 70 can appropriately distribute the related music data created in this way to each device via the VPN 60. In the device that received the distribution, the related music database is stored and referenced and used in a timely manner.

=== Related music presentation function ===
As a usage form of the related music database, there is an example in which, when a user selects music by operating the karaoke music selection apparatus 20, the related music of the music is presented.

  In the karaoke music selection device 20, a related music database synchronized with the related music database of the karaoke server 70 is stored in the hard disk device. The karaoke server 70 distributes the updated difference data and the like to the karaoke song selection device 20 via the VPN 60 at an appropriate occasion such as when the related song database is updated, and the karaoke song selection device 20 updates its own related song database. To do.

  The karaoke music selection apparatus 20 refers to the related music database in a timely manner, presents table of contents information for a certain music, accepts a performance reservation for the music, and makes the performance terminal 10 reserve a performance reservation. It has a next song presentation function that presents related songs (hereinafter called next song) that would be suitable for a song.

  3 to 5 show screen transitions related to the next song presentation function in the karaoke music selection apparatus 20. When the karaoke music selection device 20 transfers the performance reservation message to the performance terminal 10, the karaoke music selection device 20 displays a “next song” button 31 on the reservation completion confirmation screen or the like (FIG. 3). When the user inputs an instruction for the “next song” button 31, the related music database is referred to using the music ID included in the transferred performance reservation message as the clue music ID, and the music ID associated with the clue music ID is associated with the music ID. Extract groups. Then, the song index database is referred to for the related song ID group, and the song name and artist name of the next song are displayed as a list on the touch panel (FIG. 4).

  When the user selects and designates any song from the next song list, detailed information about the song is displayed (FIG. 5). When the transfer button 33 on this detailed screen is instructed, the music can be reserved for performance. Of course, the “next song” button 31 may also be displayed on the detailed screen, and related music related to the music may be displayed. Moreover, you may make it display a related music on the display of the performance terminal 10. FIG.

The performance terminal 10 may have a function of presenting related music. The related music database is also stored in the performance terminal 10, and the karaoke server 70 downloads the updated contents of the related music database to the performance terminal 10 in a timely manner and synchronizes the related music database of the performance terminal 10. The performance terminal 10 may present the related music of the performance music before the start of performance of the karaoke music or at the end of the performance.
Of course, the performance terminal 10 and the karaoke music selection apparatus 20 may be configured to access the karaoke server 70 and refer to the related music database in a timely manner without storing the related music database.

  As mentioned above, if related music is presented to the user at the karaoke venue, music similar to the selected music and the music that suits the user's taste is presented as the next song, and the music selected Work can be done smoothly. Therefore, you can enjoy the original karaoke enjoyment without being limited by the music selection work. This often leads to the discovery of favorite songs that have been forgotten or unexpectedly favorite, expanding the range of song selection. Also, for example, even when a person different from the previous reservation person reserves the next song, the atmosphere of the place can be made continuous by selecting the song after the previous song selection.

It is a network block diagram of the communication karaoke system containing the database server in the Example of this invention. It is explanatory drawing of the preparation procedure of the data stored in the related music database which concerns on a present Example. It is the figure which illustrated the performance reservation completion screen in the karaoke music selection apparatus of a present Example. It is an example of the display screen of the next song list of a present Example. It is the figure which illustrated the music selection screen of a present Example.

Explanation of symbols

20 Karaoke selection device 70 Karaoke server

Claims (1)

A database server comprising a performance record database, a favorite song database, a related music database, and control means, and communicating with a plurality of karaoke apparatuses via a network,
The performance record database aggregates the association information of the music ID and the number of performances
The favorite song database aggregates the correspondence information between personal IDs and favorite song ID sets,
The related music database aggregates the association information between the clue music ID and the related music ID set,
The control means performs favorite song download processing, favorite song upload processing, concentration processing, database creation processing, and distribution processing,
When the favorite song download process receives the personal ID from the karaoke device, the favorite song download ID set corresponding to the personal ID is transmitted from the favorite song database,
The favorite song upload process updates the information corresponding to the personal ID in the favorite song database when receiving the association information between the personal ID and the music ID from the karaoke device,
Concentration processing collects performance record information from each karaoke device, updates the performance record database,
The database creation process performs the first to fourth processes,
In the first process, a plurality of music IDs having a large number of performances are selected from the performance record database as clue music IDs,
In the second process, a favorite song music ID set including one clue music ID selected in the first process is extracted from the favorite song database,
In the third process, the plurality of favorite song ID sets extracted in the second process are merged, and the performance record database is referenced, and the merged song IDs are extracted from the entire set in the descending order of the number of performances. And
The fourth process creates a related music database by aggregating information associating one clue music ID and a plurality of music IDs extracted in the third process based on the music ID as related music IDs,
The distribution process is a database server of a communication karaoke system that distributes the created related music database to each karaoke device.

Images