JP3508842B2 - Database search system and recording medium storing database search program - Google Patents

Description

Detailed Description of the Invention

[0001]

TECHNICAL FIELD The present invention relates to text, images,
Regarding a database management system that can manage data in multiple media such as music, especially when searching for data that spans multiple media or data that is closed in a single media, it is possible to clearly indicate the information related to the narrowing condition. The present invention relates to a possible database search system and a recording medium recording a database search program.

[0002]

2. Description of the Related Art FIG. 4 (a) is a diagram for explaining a conventional database search, in which numeral 51 indicates an application program (AP), 52 a database management system (DBMS), and 53 a database (DB). It represents.

Here, a case is shown in which a condition a (including apples) and a condition b (including oranges) are presented from a certain image collection to retrieve an image name. In such a search, the application program 51 presents the condition a and the condition b to the database management system 52 and requests the search.

The database management system 52 searches the database 53 to select data that meets the specified conditions, and outputs the result to the application program 51.
Let us know. Conventionally, when performing a search by designating a plurality of conditions for such a multimedia database, information about which condition the search result was narrowed down was not reflected.

[0005]

As described above, conventionally, when a multimedia database is searched by specifying a plurality of conditions, the information indicating which condition the search result is narrowed down is reflected. Since it was not done, what kind of condition was narrowed down the search results,
If the information is required, the application program 51 must cope with this.

FIG. 4 (b) is a diagram for explaining the situation, and the numerical symbols are the same as those in FIG. 4 (a). In the figure, when a condition a (including an apple) and a condition b (including an orange) are presented from a certain image collection to search for an image name, the application program 51
At the time of search, presents condition a and condition b to the database management system 52 and requests the search.

The database management system 52 searches the database 53 to select data that meets the specified conditions, and outputs the result to the application program 51.
Let us know. At this time, the database management system 52 does not inform the application program 51 of the conditions under which the hit occurs.

Therefore, the application program 5
It is necessary for 1 to perform a plurality of searches, such as individually searching for condition a (including apples) and condition b (including oranges), and to create a narrowed-down result from the results.

In order to solve the above-described conventional problems, the present invention provides a search result with "printing conditions depending on which condition" in order to realize to show the information of the narrowing down result to the user, which is required in the multimedia application. The purpose is to realize the function to reflect the information of "embedded" in the database management system.

[0010]

According to the invention, the aforesaid problems are solved by the means defined in the claims .

[0011]

1. The invention according to claim 1 is an application.
When a search request containing a query is received from
Whether the statement is a query statement that should reflect the narrowed result
Reflection possibility determination means for determining whether or not the reflection possibility determination
It is a query statement that reflects the narrowing down result by means
If it is determined that the condition is extracted from the query statement
IDs are attached to the extraction means and the conditions extracted by the extraction means.
Condition ID giving means to give, and extracted by the extracting means
Store a set of conditions and the ID assigned by the ID assigning means.
The condition ID storage means and the conditions extracted by the extraction means.
And a search means for executing a search and a search result of the search means.
Search result storage means for storing the result for each condition, and the condition
Using the set stored in the ID storage means, the search result is obtained.
Search results stored for each condition in the result storage means
Search result ID assigning means for assigning an ID to
Use the search results that have been given an ID by the fruit ID giving means.
And create search results for return to the application
And a return search result creating means for
It is a database search system.

[0012]

2. The invention according to claim 2 is the method according to claim 1.
In the database search system, the return
Included in the return search results created by the search result creation means
The ID stored in the condition ID storage means
It is characterized by comprising a replacement means for replacing the condition by using
Database search system.

The invention according to claim 3 is an application.
When a search request containing a query is received from
Whether the statement is a query statement that should reflect the narrowed result
Reflection propriety judgment procedure for judging whether or not, and the above-mentioned reflection propriety judgment
It is a query statement that reflects the narrowing down result in the procedure
If it is determined that the condition is extracted from the query statement
ID is added to the extraction procedure and the conditions extracted in the extraction procedure.
The condition ID giving procedure to be given and the condition ID extracted by the extracting procedure
Store a set of conditions and the ID assigned in the ID assignment procedure.
Condition ID storage procedure and the conditions extracted in the extraction procedure.
And the search result of the above search procedure.
A search result storing procedure for storing the result for each condition, and the condition
The search result storage is performed by using the set stored in the ID storage procedure.
Assign ID to search results stored for each condition in the procedure
Search result ID assigning procedure, and the search result ID assigning procedure
Using search results with IDs assigned in order,
Search for return to create search results for return to application
A database search program having a search result creation procedure,
It is a recording medium on which a program is recorded.

The invention according to claim 4 is the same as that of claim 3.
In the recording medium, the database search program
Was created by the above-mentioned procedure for creating search results for return.
The ID included in the return search result is stored as the condition ID storage procedure.
Has a replacement procedure that replaces the condition with the set stored in
It is a recording medium characterized by the following.

[0015]

[0016]

[0017]

[0018]

[0019]

[0020]

[0021]

[0022]

The present invention is a database management system (DBM
In S), a language processing function for interpreting a query including a function for reflecting the narrowing-down result and a search function for executing the query are realized. In the language processing function, it is determined whether or not the time is set to reflect the narrowing-down result. In the case of an inquiry that reflects the result, that effect is transmitted to the search function.

In the search function, when an inquiry and a reflection of the narrowed result are received, firstly, the search result is held. Second, the search phrase is processed from the result of each condition.
At that time, the result of narrowing down is also added to each search result.

As described above, the result of narrowing down can be reflected in the "search in which a plurality of conditions are specified by the user" on the side of the database management system (DBMS) which is the object of the present invention. With this function, a complicated operation can be performed on multimedia data and the application program (AP) can be simplified, so that the application program can be easily created.

[0025]

DESCRIPTION OF THE PREFERRED EMBODIMENTS FIG. 1 is a diagram for explaining the principle of the present invention. In the figure, numeral 10 is a database management system (DBMS), 11 is a language processing mechanism, 12 is a search mechanism, and 13 is a storage mechanism. Also, 1 to 7
Represents the processing, and the contents are as follows. 1. Extract the query condition. 2. An ID is given to each condition. 3. A pair of ID and condition is stored. 4. Perform a search for each condition. 5. The search result is stored for each condition. 6. An ID is given to the search result for each condition. 7. A search result for return to the application is created using the search result including the ID.

A first example of the embodiment of the present invention will be described below with reference to FIGS. 2 (a) and 2 (b). This example shows the case of a closed inquiry on a single medium. This figure shows a similarity search regarding music, and an application program (AP) issues an inquiry in which a plurality of closed conditions are specified in the same medium.

In FIG. 2A, numeral 21 is an application program (AP), 22 is a database management system (DBMS), and 23 is a database (D).
B), 24 are inquiry sentences, and 25 is a search phrase. This example shows that a similar song title is searched from the songbook based on condition 1 and condition 2 that characterize (numerize) a part of the song input as the search key (see the figure. To facilitate the above, Condition 1 and Condition 2 are represented by musical notation marks).

By adding [MATCH CONDITION] to the search phrase 25, it means that the search "reflects the narrowed result in the result". The inquiry condition is each key obtained by dividing the music input to the application program (AP).

The database management system (DBMS) performs the following processing as shown in FIG. (1) Extract condition 1 and condition 2 from the inquiry sentence. (2) Condition ID 1 for "partial song similar () note 1",
Condition ID 2 is assigned to "partial song similar () note 2". (3) ““ Partial song similar () note 1 ”, 1”, ““ partial song similar () note 2 ”, 2” are stored. (4) Similarity search for each condition. (5) Hold the search result (similarity) for each condition (card stack in the figure). (6) A condition ID is added to the search result. (7) The results including the condition ID are merged and sorted. (8) The result is returned to the application program (AP).

Since the result returned from the database management system (DBMS) is given a predicate ID, it is possible to easily grasp the narrowing-down result by referring to the search statement. In this example, “Sakura Sakura” in the search results of FIG. 2 corresponds to Condition 2, and “Spring” corresponds to Condition 1.

Next, a second example of the embodiment of the present invention will be described with reference to FIGS. 3 (a) and 3 (b). In this example, an inquiry is issued in which a plurality of conditions are specified across a plurality of media. In the figure, numeral 21 is an application program (AP), 22
Is a database management system (DBMS), 23 is a database (DB), 24 is an inquiry sentence, 25 is a search phrase, and 26 is a partial image of an apple.

In this example, the condition 1 is compared with the feature amount of the image specified from the image collection in which the image and the commentary are written,
It indicates that the similarity search is performed based on the condition 2 in which Aomori prefecture is specified as the keyword. (In the figure, the partial image 26 of the apple under condition 1 is displayed in a schematic view.

By adding [MATCH CONDITION] to the search phrase 25, it means that the search "reflects the narrowed down result in the result". The inquiry conditions are related to each media. As mentioned above, this example is an example of a query that spans multiple media.

The application program (AP) issues an inquiry in which a plurality of conditions across a plurality of media are designated. When an image is specified in the inquiry condition, it may be a whole image, a partial image, or a sketch image. When specifying the text, it may be a word or a long sentence.

FIG. 3B shows the operation in the database management system (DBMS). The database management system (DBMS) performs the following processing. (1) Extract condition 1 and condition 2 from the inquiry sentence. (2) Condition ID in "partial image similar () key-image"
1. Assign condition ID 2 to "commentary similar () 'Aomori prefecture'". (3) "" Partial image similar () key-image ", 1",
Memorize "" Commentary similar () 'Aomori Prefecture'",2". (4) Similarity search for each condition. (5) Hold the search result (similarity) for each condition (card stack in the figure). (6) A condition ID is added to the search result. (7) The results including the condition ID are merged and sorted. (8) Replace the condition ID with a condition statement. (9) The result is returned to the application program (AP). Since the condition statement is added to the result returned from the database management system (DBMS), the narrowed-down result can be easily grasped. "In this example," landscape picture 3.jpg "in the search result of Fig. 3 corresponds to the condition of" partial picture similar () key-image ", and" dining table 1.jpg "is" commentary similar ()
It indicates that the condition "Aomori Prefecture" has been met. "

The main functions of the present invention described above are realized by software. Therefore, it is possible to create the logical structure of this software as a program in a desired language. It goes without saying that a recording medium recording such a program is also included in the scope of the present invention.

[0037]

As described above, according to the present invention,
In a database management system capable of managing data in a plurality of media such as texts, images and music, a database management system (DBMS) searches for data spanning a plurality of media or data closed in a single medium. There is an advantage that it is possible to execute a “search that can reflect the narrowing-down result”.

That is, in the past, in order to execute the "search capable of reflecting the narrowed-down result", all of it had to depend on the application program. However, according to the present invention, "what Was it imprinted according to the conditions? "
It becomes possible to perform the function of reflecting the information in the database management system, and it is possible to realize the requirement of the multimedia application to show the information of the narrowing-down result to the user.

[Brief description of drawings]

FIG. 1 is a diagram for explaining the principle of the present invention.

FIG. 2 is a diagram illustrating a first example of an embodiment of the present invention.

FIG. 3 is a diagram illustrating a second example of the embodiment of the present invention.

FIG. 4 is a diagram illustrating a conventional DBMS.

[Explanation of symbols]

21 Application Program 22 Database management system 23 Database 24 inquiry text 25 Search phrase 26 Apple partials

─────────────────────────────────────────────────── ─── Continuation of the front page (72) Inventor Takashi Nishinishi 2-3-1, Otemachi, Chiyoda-ku, Tokyo Inside Nippon Telegraph and Telephone Corporation (56) Reference JP-A-7-21193 (JP, A) ( 58) Fields surveyed (Int.Cl. ⁷ , DB name) G06F 17/30 G06F 12/00 JISST file (JOIS)

Claims (4)

(57) [Claims] 1. A search including an inquiry sentence from an application
When a request is received, the above-mentioned inquiry sentence will
Whether to reflect whether it is a query text to be displayed
The result of the narrowing down is reflected by the judgment means and the reflection possibility judgment means.
If it is determined that the query text is
And a condition I for assigning an ID to the condition extracted by the extracting unit.
D adding means, the conditions extracted by the extracting means, and the ID adding means
A condition ID storage unit that stores a set with a given ID, and a search that executes a search for each condition extracted by the extraction unit
Means and search results for storing the search results of the search means for each condition
Using the storage means and the set stored in the condition ID storage means,
It is stored for each condition in the search result storage means.
A search result ID assigning unit that assigns an ID to the search result, and a search result ID assigned by the search result ID assigning unit.
Search for return to the application using the search results
A database search system comprising: a return search result creating means for creating a result . 2. The database search system according to claim 1.
In addition, the search result creation means for return
The ID included in the returned search result is the condition ID
A device that replaces a condition using a set stored in the storage means.
Database search system characterized by including a conversion means
Tem. 3. Retrieval including an inquiry sentence from an application
When a request is received, the above-mentioned inquiry sentence will
Whether to reflect whether it is a query text to be displayed
Reflect the narrowing down result in the judgment procedure and the above-mentioned reflection possibility judgment procedure.
If it is determined that the query text is
Condition for assigning an ID to the condition extracted in the extraction process
D assignment procedure, the conditions extracted in the extraction procedure, and the ID assignment procedure
A condition ID storage procedure for storing a set with a given ID, and a search for executing a search for each condition extracted in the extraction procedure
And instructions, search results to search results stored for each condition of the search procedure
The search is performed by using the storage procedure and the set stored in the condition ID storage procedure.
I is added to the search result stored for each condition in the result storage procedure.
Search result ID giving procedure of giving D, and the search result I
Use the search result that ID is assigned by the D assignment procedure
Te, the search result for the return to create a return for the search results to the application
A recording medium recording a database search program having a creation procedure.
body. 4. The recording medium according to claim 3, wherein
The database search program further includes the return inspection.
Included in the return search results created in the search result creation procedure
A condition is stored by using a set stored in the condition ID storage procedure.
A recording medium having a replacement procedure for replacing
body.