JP2002032376A - Method for constructing database and device for retrieving database - Google Patents

Abstract

PROBLEM TO BE SOLVED: To realize highly flexible retrieval such as to perform retrieval from a part, etc., of the text of a song that slightly remains in memory or such as to retrieve a piece of music related to a work flashing into one's mind through feeling, such as 'summer', 'sea' and 'drive'. SOLUTION: This database-retrieving device consists of a 1st database (13), where the song text information of all pieces of music to be a keyword retrieval object is stored; a 2nd database (14) where an optional keyword is stored where associated with any piece of music that has the keyword in the text of a song and is stored in the 1st database; a retrieving means (121) for retrieving a piece of music having a designated keyword, retrieval results selecting means (122 and 123) with which a user can select his desired piece of music from retrieval results; and a selection result storing means (124) for associating the designated keyword with the selected piece of music and storing them in the 2nd database, in response to selection, that is made by the retrieval results selecting means among retrieval results obtained from retrieving the 1st database.

Description

DETAILED DESCRIPTION OF THE INVENTION

[0001]

The present invention particularly relates to a database construction method and a database search apparatus suitable for use in a music content distribution system.

[0002]

2. Description of the Related Art Music content online distribution technology has entered a practical stage, and content distribution systems for music have appeared one after another. All of the basic configurations of the distribution systems are almost the same, such as a copyright management technology for realizing copyright protection, a data compression technology for music content typified by MP3 (MPEG1 audio layer 3), and a fee for collecting the price of the content. Consisting of technology.

[0003]

By the way, in the above-mentioned music site, when searching for music information that the client wants to listen to, usually, input of data corresponding to a search key such as a music name, an artist name, etc. is required. Therefore, for example, a search method with high flexibility, such as searching from a part of lyrics that are slightly memorized, or searching for a word-related song inspired by the mood, such as “summer”, “sea”, “drive”, etc. Was not offered.

The present invention has been made in view of the above circumstances, and every time a user accesses through the operation of a music site, an appropriate keyword is extracted from a database in which the full text of lyrics is stored, and the keyword is extracted. By creating a database and publishing these databases, search from a part of the slightly memorable lyrics described above, or search for word-related songs inspired by moods such as "summer", "sea", "drive" It is an object of the present invention to provide a database construction method and a database search device that realize a highly flexible search.

[0005] It is another object of the present invention to provide a database construction method and a database search device that can develop a new business model for music distribution by virtually integrating a music site and its database and publishing it on the Web. And

[0006]

In order to solve the above-mentioned problems, a database construction method according to the present invention uses a first method in which lyrics information of all songs to be searched for a keyword is stored.
When a user selects a desired song from a search result obtained by performing a keyword search using a designated keyword specified by the user with respect to the database of the user, the keyword designated by the user is associated with the song selected by the user. In the database construction method according to the present invention, all the songs to be searched for the keyword are distributed from an information providing site via a web.

Further, in the database construction method of the present invention, the first and second databases are constructed by extracting the full text of the lyrics of the music distributed from the music site via the web and the keywords related to the lyrics, respectively. Features.

[0008] In the database construction method of the present invention, music information selected by a user from a search result of the first database is reflected in the second database.

In the database construction method according to the present invention, the reflection in the second database is triggered by a selection by a user or a download instruction to the music site.

In the database construction method according to the present invention, a predetermined number of words having a high frequency of appearance are extracted from the lyrics in the first database and reflected in the second database.

[0011] In the database construction method of the present invention, among words of a song in the first database, a unique word not found in other songs may be generated and reflected in the second database. It is characterized by.

Further, in the database construction method of the present invention, a search is performed using the second database, and when a hit is made, a button for enabling the search of the first database is displayed as an icon. I do.

Further, in the database construction method of the present invention, a search is performed on the second database, and when no hit is found, the search is forcibly shifted to a search on the first database.

Further, the database construction method of the present invention comprises:
A logical search of the first database is performed, and only the music selected by the user among the search results is stored in the second database.
Is reflected in the database.

[0015] In the database construction method of the present invention, a logical search of the first database is performed, and a result of expanding a music piece selected by a user among the search results is reflected in the second database. It is characterized by.

[0016] Thus, every time a user accesses through the operation of the music site, an appropriate keyword is extracted from the first database in which the full text of the lyrics is stored, and the keyword is converted into a database as the second database. By publishing these databases, searching from a part of the slightly memorable lyrics mentioned above, or searching for word related songs that inspire by mood such as "summer", "sea", "drive", etc. Searches can be implemented in a flexible way. In addition, a new business model for music distribution can be developed by virtually integrating a music site and its database and publishing it on the Web.

The database search device of the present invention stores a first database in which lyrics information of all songs to be searched for a keyword is stored, and a first database in which any keyword is used and the keyword is included in the lyrics. A second database for associating and storing any one of the selected songs, a search unit for searching for a song having a specified keyword, and a search result selection for allowing a user to select a desired song from search results by the search unit Means for associating the specified keyword with the selected song in response to the selection by the search result selecting means from the search results for the first database, And a selection result storing means for storing.

Further, in the database search device of the present invention, the search means first performs a keyword search on the second database, and when a keyword specified in the second database exists, the search result is obtained. In addition to the display, when the specified keyword does not exist, the process shifts to the search of the first database.

With the above arrangement, each time a user accesses the system through the operation of the music site, an appropriate keyword is extracted from the first database in which the full text of the lyrics is stored, and the keyword is converted into a database as the second database. By publishing these databases, searching from a part of the slightly memorable lyrics mentioned above, or searching for word related songs that inspire by mood such as "summer", "sea", "drive", etc. A database search device that realizes a search by a highly flexible method can be provided. It is also possible to develop a new business model for music distribution by virtually integrating a music site and its database and publishing it on the Web.

[0020]

DESCRIPTION OF THE PREFERRED EMBODIMENTS FIG. 1 is a diagram cited for explaining a business model for realizing a database search method according to the present invention.

In FIG. 1, reference numeral 1 denotes a virtual integrated database (DB) server system, which includes a content server 11 located at a music site, a search server 12 located at a site providing a search mediation service, and all the songs to be searched by a keyword. Lyrics full text DB1 that stores the lyrics information of
3, and an automatic growth DB.

When the user selects a desired song from a search result obtained by performing a keyword search using a designated keyword, the automatic growth DB 14 stores the keyword designated by the user and the song selected by the user in association with each other. Is done.

In implementing the present invention, a search mediation site that provides a service using a virtual integrated database needs to purchase content from a music site by contract or take in content by license.

Reference numeral 2 denotes a client computer, a reproduction software 21 and a local database (LDB) storing downloaded music, a speaker 2
3 and a CD-R device 24. The client computer 2 is connected to the virtual integration server 1 via the Internet 3.

FIG. 2 is a block diagram showing the function of the inside of the search server 12 shown in FIG. Search server 1
Reference numeral 2 denotes a search unit 121 serving as a search body, a search result display unit 122, a selection input unit 123, and a selection result storage unit 1
24.

The search unit 121 searches for music having the keyword specified by the client, and the search results of the search unit 121 are displayed by the search result display unit 122 as a search result list. The client selects a desired song to be searched from the selection input unit 123 and sends the selected song to the full-text DB 13 (first
Input section 1 from the search results for the database
23, the specified keyword is associated with the selected music in response to the selection by the automatic growth DB 23.
14 (second database).

FIG. 3 is a hardware block diagram showing the internal configuration of the search server. The search server 12 is a CPU
121 is the control center, ROM 122, RAM 123,
TCP / IP (Transport Control Protocol / Intern
et Protocol) interface 124, hard disk controller (HDC) 125, display controller (G
DC) 126, keyboard controller (KBC) 12
7 is commonly connected to a system bus 132 composed of a plurality of lines for address, data, and control.

The CPU 121 executes a search program recorded in the ROM 122 or the RAM 123 shown in the flowchart of FIG. 4, and causes the search unit 121 shown in FIG. 2 to function. The TCP / IP interface 124 is a communication controller serving as an interface for connecting to the Internet 3. The HDC 125 includes a full-text DB 13 and an automatic growth DB 14 built on an HDD as an external recording medium.
And controls the interface with the CPU 121. The HDC 125 causes the selection result storage unit 124 shown in FIG. 2 to function.

The GDC 126 stores the display data developed in the work area of the RAM 123 in a bit map memory 128.
(BMM), and the data is read out in synchronization with the raster timing in order to display the data on the CRT monitor 129. The KBC 127 senses an input from the connected KB 130 and mouse 131, and
Tell The man-machine interface constituted by the KB 127 and the CRT monitor 126 functions as the search result display unit 122 and the selection input unit 123 shown in FIG.

FIG. 4 is a flowchart showing the flow of processing by the search server 12 for implementing the database construction method of the present invention. FIG. 5 is a diagram showing screen development for executing a search operation.

Hereinafter, referring to FIGS. 4 and 5, FIGS.
The operation of the embodiment of the present invention shown in FIG. 3 will be described in detail.

First, a search input screen is activated by the client computer 2 (step S41). Here, the music search page shown in FIG. 5A appears, and the client is prompted by the client to select a DB to search (step S42). If the automatic growth DB 14 is selected and the automatic growth DB 14 has not grown, for example, if the hit rate is less than 30%, the client can only search the full-text DB 13.

After the search of the full-text DB 13 is completed (step S4)
3), a list of search results shown in FIG. 5B is displayed (step S44). Here, for each music ID, only the entry information composed of the title name, the first name, the release date, and the lyrics of the chorus portion is displayed for the hit. When the client selects only the music information that the user wants to browse, the desired music information is displayed (step S45).
The song selected at the same time is additionally updated in the automatic growth DB 14 as a song related to the search word (step S4).
6, 47).

The additional trigger to the automatic growth DB 14, that is, the client's selecting action is not limited to browsing music information, but may be a download command. In addition, the operation of extracting the inspection keywords from the whole DB 13 is as follows.
This is performed by an automatic generation program recorded in the ROM 122 or the RAM 123. For example, a frequently used word of about 10 to 20 words frequently appearing in lyrics or all unique words not found in other songs are used as search keywords. Is extracted.

On the other hand, after the automatic growth DB 14 has grown to some extent (step S48), the client can search the full-text DB 13 or select either the automatic growth DB 14 for the search. In the case of the full-text DB 13 search, the processing of steps S43 to S47 described above is performed. When the automatic growth DB 14 is searched (step S49), the presence or absence of a hit is checked (step S50). When the search result is hit, the result is displayed and the full-text DB 13 can be searched continuously. A command button (FIG. 5B) for searching the full-text DB 13 is displayed.

If there is no hit as a result of the search, a message to that effect is displayed, and the full text DB 13 search is automatically forcibly shifted to the search. In this case, the above-described step S4
From 3 to step S47 are performed.

Next, in the full-text DB search and the automatic growth DB search in steps S43 and S49, additional updating of the selection result to the automatic growth DB 14 when a search using a logical expression is performed instead of a search using a word will be described. .

Here, it is assumed that only selected ones of the search results are added to the automatic growth DB 14. For example, there are 120 hits in "Summer x Coast", of which A,
When the user selects two songs B, the automatic growth DB 14 stores a result of “summer × shore = A, B”.

When the logical formula is expanded and updated, for example, when 120 hits are made in "summer x coast" and the user selects two songs A and B, the automatic growth DB 14 "Summer x Coast = A,
B, "summer = A, B", and "shore = A, B" are stored.

In the above-described embodiment of the present invention, only an example in which a database is constructed via the web and search is performed is shown, but the present invention is not limited to this embodiment.
The same applies to general full-text database construction and retrieval in a stand-alone form.

[0041]

As described above, according to the present invention, every time a user accesses through the operation of a music site, an appropriate keyword is extracted from a database in which the full text of lyrics is stored, and the keyword is extracted. Create a database and publish these databases to search for some of the slightly memorable lyrics mentioned above, or search for word-related songs that are inspired by the mood, such as "summer,""sea," or "drive." For example, a highly flexible search can be realized. In addition, a new business model for music distribution can be developed by virtually integrating a music site and its database and publishing it on the Web.

The present invention is particularly effective when applied to a communication karaoke system. Also, search results on CD
It can also be used to promote new music by opening the client's access log.

[Brief description of the drawings]

FIG. 1 is a diagram cited for explaining a business model for realizing a database search method of the present invention.

FIG. 2 is a block diagram showing functions of a search server shown in FIG.

FIG. 3 is a hardware block diagram showing an internal configuration of the search server shown in FIG.

FIG. 4 is a flowchart showing the flow of processing by a search server for realizing the database construction method of the present invention.

FIG. 5 is a diagram cited for explaining the operation of the embodiment of the present invention, and is a diagram showing a screen development for executing a search operation.

[Explanation of symbols]

DESCRIPTION OF SYMBOLS 1 ... Virtual integrated database server system, 2 ... Client computer, 3 ... Internet, 11 ... Content server, 12 ... Search server, 13 ... Full-text DB, 1
4 Automatic growth DB 121 Search unit 122 Search result display unit 123 Selection input unit 124 Selection result storage unit

Claims (13)

[Claims] A search result obtained by performing a keyword search using a specified keyword specified by a user on a first database in which lyrics information of all songs to be searched for by a keyword is stored, based on a search result obtained by a user. A database construction method characterized in that, when a song is selected, a keyword designated by the user and a song selected by the user are recorded in a second database in association with each other. 2. The database construction method according to claim 1, wherein all the music pieces targeted for the keyword search are distributed from an information providing site via a web. 3. The first and second databases are constructed by extracting the entire lyrics of a song distributed from a music site via the web and keywords related to the lyrics, respectively. Method of constructing database described in. 4. The database construction method according to claim 3, wherein music information selected by a user from search results of the first database is reflected in the second database. 5. The database construction method according to claim 3, wherein the reflection in the second database is triggered by a selection by a user or a download command to the music site. 6. The database construction method according to claim 5, wherein a predetermined number of words having a high frequency of appearance are extracted from the lyrics in the first database and reflected in the second database. . 7. The method according to claim 5, wherein, out of the lyrics of a song in the first database, a unique word not found in other songs is generated and reflected in the second database. How to build the described database. 8. The database according to claim 3, wherein the second database is searched, and when a hit is made, a button for enabling the search of the first database is displayed as an icon. How to build. 9. The method according to claim 3, wherein a search is performed on the second database, and when no hit is found, the search is forcibly shifted to a search on the first database. . 10. The database according to claim 5, wherein a logical search of the first database is performed, and only the music selected by the user among the search results is reflected in the second database. How to build. 11. The method according to claim 5, wherein a logical search of the first database is performed, and a result of expanding a music piece selected by a user among the search results is reflected in the second database. How to build the described database. 12. A first database in which lyrics information of all songs to be searched for a keyword is stored, and any song stored in the first database having an arbitrary keyword and having the keyword in the lyrics. A second database for storing music data having a specified keyword; a search result selecting means for allowing a user to select a desired music piece from a search result by the search means; In response to the selection made by the search result selection means from the search results for the database of
A search result storing unit that stores the specified keyword in association with the selected song in the second database. 13. The search means first performs a keyword search on the second database, and if a keyword specified in the second database exists, displays the search result and displays the specified keyword. 13. The database search device according to claim 12, wherein when there is no search, the process proceeds to the search of the first database.