JP2000090093A - Method and system for full-text retrieval and record medium recording full-text retrieval program - Google Patents

Abstract

PROBLEM TO BE SOLVED: To enable retrieval based upon a numerical number condition such as a date condition only by full-text retrieval by performing conversion to a retrieval condition which enables full-text retrieval for a converted character string and performing full-text retrieval from a full-text retrieval data base according to an inputted retrieval condition and converted retrieval condition. SOLUTION: A registered information editing process part 3 edits inputted document information and date information converted by a date retrieval object converting process part 4 to the format for registration in the full-text retrieval data base 1. In order to perform date retrieval by full-text retrieval, the date retrieval object converting process part 4 converts the date information which is sent from the registered information editing process part 3 and specifies a range included in an inputted document into a full-text retrieval object character string by date parts which can be so specified that they are in the range and sends the converted date information back to the registered information editing process part 3. This date retrieval object converting process part 4 converts the date information included in the document to the format suitable for the full-text retrieval.

Description

DETAILED DESCRIPTION OF THE INVENTION

[0001]

BACKGROUND OF THE INVENTION 1. Field of the Invention The present invention relates to a full-text search method and a full-text search system for performing a search using the full text of a document.

[0002]

2. Description of the Related Art In a full-text search system, a search term is specified as a search condition, a database (full-text search database) storing documents to be searched is searched, and a document in which the search term exists is used as a search result. Therefore, usually, it is not possible to search only a specific part in the document.

[0003] Therefore, a search method has been conceived and realized in which a specific portion in a document is cut out as an item, registered in a full-text search database, and a document in which a search term exists only in that item is retrieved. This makes it possible for a full-text search database to perform a search similar to a structural database search like a relational database. However, comparing a numerical value such as a date that can be generally performed in a relational database requires a full-text search. It is not possible with the system. On the other hand, it is impossible to build a full-text search system using a relational database because it is difficult for the relational database to search for documents such as a full-text search function.

Conventionally, a technique for solving such a problem and enabling a full-text search system to perform a search based on numerical conditions is disclosed in, for example, JP-A-6-215041. In this method, first, a full-text search is performed under conditions other than numerical conditions, and all the documents resulting from the search are output once and retained, and then, as post-processing, the retained full-text search results It converts a number, which is a character string contained in a document, into a numerical value and searches for numerical conditions. Date search can be performed in the same way by replacing the numerical value with the date.

[0005]

However, in the above-mentioned conventional technology, a two-stage search of a full-text search and a numerical condition search for subsequent processing is required, and the search time becomes long.
There is a problem that processing becomes complicated. Furthermore, it is necessary to hold the output full-text search result document for post-processing,
There is also a problem that requires many resources (memory resources).

An object of the present invention is to provide a full-text search only,
It is an object of the present invention to provide a full-text search method and a full-text search system that enable a search based on numerical conditions such as a date condition, and a recording medium on which a program for the search is recorded.

[0007]

According to one aspect of the present invention, there is provided a full-text search method for performing a search using a full-text of a document by a full-text search database storing a search target document. When registering a document in the full-text search database, the information indicating the range included in the input document is converted into a character string suitable for full-text search that can specify that any numerical value is within the range. Registering the input document and the converted character string in a full-text search database, and when searching for a document in the full-text search database, converting the numerical search condition included in the input search condition into the converted character string To full-text search conditions,
A full-text search is performed on a full-text search database based on the input search conditions and the converted search conditions.

According to a second aspect of the present invention, in the full-text search method according to the first aspect, information indicating a range included in an input document is used as a full-text search target that can specify that an arbitrary numerical value is within the range. When converting to a character string in a format suitable for, the change should be made so that all digits of the value are targeted at the beginning and end of the range, and the upper digits of the value are sequentially targeted at the other parts. Features.

According to a third aspect of the present invention, there is provided a full-text search system for performing a search using a full-text of a document by using a full-text search database storing a document to be searched, and a means for inputting a document to be registered in the full-text search database; Means for converting information indicating a range included in the document into a character string in a format suitable for full-text search capable of specifying that an arbitrary numerical value is within the range; and the input document and the converted character string Means for editing the information, means for registering the edited information in a full-text search database, means for inputting a condition for searching the full-text search database, and numerical conversion conditions included in the input search conditions. Means for converting the input character string into a search condition capable of full-text search, means for editing the input search condition and the converted search condition, A means for performing a full-text search on the full-text search database according to the collected search conditions; a means for editing a search result in a format capable of being output; and a means for outputting the edited search result. I do.

According to a fourth aspect of the present invention, there is provided a computer-readable recording medium storing a full-text search program for performing a search using a full-text of a document by a full-text search database for storing a document to be searched. In the document registration mode to the search database, the information indicating the range included in the input document is converted to a character string suitable for full-text search that can specify that an arbitrary numerical value is within the range. A process for registering the input document and the converted character string in a full-text search database;
In the document search mode of the full-text search database, a numerical search condition included in the input search condition is converted into a search condition capable of performing a full-text search on the converted character string,
A process for performing a full-text search on a full-text search database based on the input search conditions and the converted search conditions is recorded.

[0011]

Embodiments of the present invention will be described below with reference to the drawings. In the following description of the embodiments, date information included in a document is targeted, but the present invention is not limited to date information.

FIG. 1 is a block diagram showing a configuration of a full-text search system according to an embodiment of the present invention. This full-text search system includes a full-text search database 1 for storing documents,
A registration information input unit 2, a registration information editing processing unit 3, a date search object conversion processing unit 4, a registration processing unit 5, which constitute a processing system for document registration in the full text search database 1, and a document search from the full text search database 1 The processing system includes a search condition input unit 6, a search condition edit processing unit 7, a date search target conversion processing unit 8, a search processing unit 9, a search result edit processing unit 10, and a search result output unit 11. Actually, this full-text search system is constructed using hardware resources of a so-called computer system having a keyboard, a mouse, a display, a CPU, a memory device, and the like.

A registration information input unit 2 inputs information of a document to be registered in the full-text search database 1. The user may directly input a document using a keyboard or the like, or may input a document stored in advance on a floppy disk or the like. The registration information editing processing unit 3 edits the input document information and the date information converted by the date search target conversion processing unit 4 into a format for registration in the full-text search database 1. The date search target conversion processing unit 4 performs a date search by full-text search.
The date information that can be specified in the range included in the input document sent from the registration information editing processing unit 3 is converted as a full-text search target character string for each date portion that can be specified within the range. The returned date information (full-text search target character string) is returned to the registration information editing processing unit 3. The date information included in the document is converted by the date search object conversion processing unit 4 into a format suitable for full text search. The specific processing will be described later. The registration processing unit 5 stores the edited document information and the converted date information (full-text search target character string) in the registration information editing processing unit 3 in the full-text search database 1.
Register with.

On the other hand, the search condition input section 6 inputs conditions for searching the full-text search database 1. The search condition editing processing unit 7 edits the input search conditions and the date search conditions converted by the date search target conversion processing unit 8 into a format for searching the full-text search database 1. The date search target conversion processing unit 8 converts the date search conditions included in the input search conditions sent from the search condition edit processing unit 7 into date information (full-text search) converted by the date search target conversion processing unit 4. In order to enable full-text search for the target character string), it is converted as a search condition for each date unit, and the converted date search condition is returned to the search condition editing processing unit 7. Specific processing in the date search target conversion processing unit 8 will be described later. The search processing section 9 uses the search conditions edited by the search condition editing processing section 7 to execute the full-text search database 1.
Search for. The search result edit processing unit 10 includes the search processing unit 9
Obtain the search result in and edit it in a format suitable for output. The search result output unit 11 outputs the edited search result.

According to the full-text search system, a date search can be performed such that an arbitrary date is included in the range by a single full-text search for date information that can specify a range included in a document. This will be described in detail below using specific examples.

The data record 21 of FIG. 2 shows a specific example of the result obtained by converting the date information contained in the document into a format suitable for full-text search by the date search object conversion processing unit 4. January 13, 2010 to October 22, 2010
This is a conversion example in a case where date information such as a date is included in a document. Here, the data record 21 is a character string 22 to 2
8. Note that “_” indicates a delimiter. The character string 22 is 199 from January 13, 1998.
A range of year, month, and day until January 19, 2008 (for example, 19
980113 indicates January 13, 1998), and the character string 23 is from January 20, 1998 to January 31, 1998.
The range of year, month, day, with the first digit of the day up to and including the day omitted (for example, 198012 is January 20-29, 1998, 1
998013 indicates January 30-31, 1998),
The character string 24 is in the range of the year and the month from February 1998 to December 1998 (for example, 199802 becomes 1998).
The character string 25 is 200 since 1999.
Yearly ranges up to nine years (eg, 1999 is 1999
Indicates the year), and the character string 26 is 201 from January 2010.
Range of year and month unit until September 0 (for example, 201001
Indicates January 2010), and the character string 27 is a range of year-month-day units (for example, 201010) in which the first digit of the day from October 1, 2010 to October 19, 2010 is omitted.
0 is October 1-9, 2010, 2010101 is 20
The character string 28 is 2
A range from October 20, 2010 to October 22, 2010 (for example, 20101020 is 20
10/20/2010).

In FIG. 2, the character strings 22 to 28 are shown on separate lines for convenience.
To 28 are continuous character strings separated by a delimiter "_". According to the data record 21 in FIG.
An arbitrary date in the range up to October 23, 2010 can be searched for a full-text search date included in the range.

FIGS. 3 to 9 show the date search object conversion processing unit 4.
5 is a detailed flowchart of the first embodiment. In each flowchart, it is assumed that the way of counting the number of digits follows the example of 31.

FIG. 3 is a flowchart for creating a character string 22 (a character string in units of year, month and day) of the data record 21. In FIG. 3, when the start date of the range of the date to be converted is smaller than the end date (step 32), “_” and “start date” are added to the data record 21 as delimiters (step 33). If the start date is the same as the end date (step 32), the flowchart of FIG. 3 ends, and the process proceeds to the flowchart of FIG. The day part of the start date is "3
If it is not "1" (step 34), the day portion of the start date is incremented by 1 (step 341). Day part of start date is 3
1 (step 34), and the month portion of the start date is “1”.
If it is not "2" (step 35), the month portion of the start date is incremented by 1 and the day portion is set to "1" (step 35).
1). The start date is “31” (step 3
4) If the month portion of the start date is "12" (step 35), the year portion of the start date is increased by 1 (step 3).
6). If the year, month, and tens place of the start date have been changed (step 37), the flowchart of FIG. 3 ends, and the process proceeds to the flowchart of FIG. If not changed (step 37), the process returns to step 32 to continue the process.

FIG. 4 is a flowchart for creating a character string 23 portion of the data record 21 (a character string in units of year, month and day with the first digit day omitted). In FIG. 4, when the year, month, and day of the start date changed in the process of FIG. 3 are smaller than the year, month, and day of the end date (step 4).
2) Add "_" as a delimiter and the tens place of the start date year, month and day to the data record 21 (step 4).
3). The year, month, and tens place of the start date are the year, month,
If it is the same as the tens place of the day (step 42), the flow chart of FIG. 4 ends, and the process proceeds to FIG. If the tens place of the start day is not "3" (step 44), the tens place of the start day is increased by one (step 441). If the day part of the start date is "3" (step 44) and the month part of the start day is not "12" (step 45), the month part of the start day is increased by one and the day part is set to "1". (Step 45
1). The start date part is "3" (step 44),
If the month part of the start date is "12" (step 4
5) Increment the year part of the start date by 1 (step 46).
If the year and month of the start date are changed (Step 4
7), the flowchart of FIG. 4 ends, and the process proceeds to FIG. If not changed (step 47), step 42
The process returns to the process of and is continued.

FIG. 5 is a flowchart for creating a character string 24 (a character string in units of years and months) of the data record 21. In FIG. 5, when the year and month of the start date changed in the process of FIG. 4 are smaller than the year and month of the end date (step 5).
2) Add “_” as a delimiter and the date of the start date to the data record 21 (step 53). If the start date year and month are the same as the end date year and month (step 5
2), the flowchart of FIG. 5 is terminated, and the process proceeds to the flowchart of FIG. If the month portion of the start date is not "12" (step 54), the month portion of the start date is incremented by 1 (step 541). If the month portion of the start date is "12" (step 54), the year portion of the start date is incremented by 1 (step 55). If the year of the start date has been changed (step 56), the flow chart of FIG. 5 ends, and the flow proceeds to the flow chart of FIG. If not changed (step 56), the process returns to step 52 to continue the process.

FIG. 6 is a flow chart for creating a character string 25 portion (a character string in units of years) of the data record 21. In FIG. 6, when the year of the start date changed in the process of FIG. 5 is smaller than the year of the end date (step 62), “_” and the year of the start date are added to the data record 21 as separators (step 62). 63). The year part of the start date is increased by 1 (step 64). Returning to the processing of step 62, the processing is continued. If the year of the start date is the same as the year of the end date (step 62), the flowchart of FIG. 6 ends, and the process proceeds to the flowchart of FIG.

FIG. 7 is a flowchart for creating a character string 26 (a character string in units of years and months) of the data record 21. In FIG. 7, when the year and month of the start date changed in the process of FIG. 6 are smaller than the year and month of the end date (step 7).
2) Add "_" as a delimiter and the year and month of the start date to the data record 21 (step 73). The month portion of the start date is incremented by 1 (step 74). Returning to the processing of step 72, the processing is continued. If the year and month of the start date are the same as the year and month of the end date (step 72), the flow chart of FIG. 7 ends, and the flow proceeds to the flow chart of FIG.

FIG. 8 is a flowchart for creating a character string 27 portion of the data record 21 (a character string in units of year, month and day with the first digit day omitted). In FIG. 8, when the year, month, and day of the start date changed in the process of FIG. 7 are smaller than the year, month, and day of the end date (step 8).
2) Add “_” as a delimiter character and the year, month and day of the start date to the data record 21 (step 8).
3). Increase the tens place of the start date by 1 (step 8
4). Returning to the processing of step 82, the processing is continued. If the year, month and day tens of the start date are the same as the year, month and day tens of the end date (step 82), the flow chart of FIG. 8 ends and the flow proceeds to the flow chart of FIG.

FIG. 9 is a flowchart for creating a character string 28 portion (a character string in units of year, month and day) of the data record 21. In FIG. 9, the start date year changed in FIG.
If the month and day are smaller than the end date year, month and day (step 92), add "_" as a delimiter and the start date year, month and day to the data record 21 (step 9).
3). The day of the start date is increased by 1 (step 94). Returning to the processing of step 92, the processing is continued. Year, month,
If the day is the same as the end date year, month, day (step 9
2) Add "_" as a delimiter and "_" as a delimiter and year, month, and date of the start date to the data record 21, and end the flow chart of the date search target conversion process.

As described above, the data record 21 of FIG. 2 created for the date information included in the document by the date search object conversion processing unit 4 passes through the registration information editing processing unit 3 and the registration processing unit 5. In the full-text search database 1,
Stored together with the corresponding document information.

The data record 101 in FIG. 10 is obtained by converting the date search conditions in the search conditions in the date search target conversion processing unit 8 in the date search target conversion processing unit 4 in FIG.
Is a specific example in which the data record 21 is converted into a date unit so that full-text search can be performed. A date search condition of March 13, 1999 is included in the search condition. It is a conversion example when it is included.

FIG. 11 is a flowchart for creating the data record 101 of FIG. 10 in the date search object conversion processing unit 8. In the flowchart of FIG. 11, it is assumed that the number of digits is counted according to the example of 110. In FIG.
A character string with "_" added as a delimiter on both sides of the year of the date to be searched as a search condition is added (step 11).
1) Add a character string in which "_" is added as a delimiter on both sides of the year and month of the date to be searched as a condition for logical sum (step 112), and the tens place of the year, month and day of the date to be searched A character string with "_" added as a delimiter on both sides of the character string as a logical sum condition (step 113), and a character string with "_" added as a delimiter on both sides of the year, month, and day of the date to be searched Is added as a condition for a logical sum (step 114).

The data record 10 thus created
If a date search is performed using 1 as a full-text search condition, the relevant document can be searched within the period of the date information indicating the period of the document. Similarly, if a full-text search is performed under the condition that none of the character strings of the data record 101 is included, the relevant document can be searched outside the period of the date information.

Now, as a specific example, it is assumed that the document stored in the full-text search database 1 is personal computer course information 115 as shown in FIG. The personal computer course information 115 is converted and edited as shown in FIG. In FIG. 13, reference numeral 116 denotes a document number cell, 117 denotes a document content cell, and 118 denotes a period information cell. Here, the document content cell 117 contains FIG.
The contents (document contents) of the course information 115 are stored as they are, but the date information of the recruitment period included in the course information 115 is stored in the period information cell 118 by the date search target conversion processing unit 4 in FIGS. The data record converted according to the flowchart of No. 9 is stored. By the way, the recruitment period for PC course A in Document 1 is "January 13, 1998-201
The data record of the period information cell 118 is the same as the data record 21 of FIG.

For example, when searching for a personal computer course held on March 13, 1999 in the full-text search database 1 shown in FIG. 13, "PC course, March 13, 1999" is input as a search condition. Then, on March 13, 1999 included in the search condition, the date search target conversion processing unit 8 converts the data record 1 shown in FIG.
01 is converted. Accordingly, the search processing unit 9 sets the condition that “the content of the document includes the word“ PC course ”and the period information includes“ _1999_ ”,“ _199903_ ”,“ _1999031_ ”, or“ _19990313_ ”. , Full-text search database 1
The document 1 and the document 3 can be derived as search results by executing a full-text search only once for.

While the embodiment of the present invention has been described above, the processes of the respective processing units in FIG. 1 can be realized as a full-text search program. The full-text search program is provided by being recorded in a computer-readable format on a recording medium such as an FD or a CD-ROM, and by loading the contents of the recording medium into a computer, the functions of each processing unit in FIG. Is realized.

[0033]

As described above, according to the present invention,
With respect to numerical information such as date information that can specify a range included in a document, it is possible to search for any numerical value within the range using only full-text search conditions. Therefore, even in a system having a full-text search process in which comparison search such as date cannot be performed, conditional search such as date can be performed. In addition, since it is not necessary to perform a condition search such as a date again on the full-text search result, it is possible to reduce resources such as a hard disk and a memory required for the search,
Since the processing is reduced, the full-text search system can be simplified.

[Brief description of the drawings]

FIG. 1 is a block diagram showing a schematic configuration of a full-text search system according to an embodiment of the present invention.

FIG. 2 is a diagram illustrating a specific example of a conversion result of a date search target conversion process at the time of document registration.

FIG. 3 is a flowchart illustrating a first procedure of date search target conversion processing at the time of document registration.

FIG. 4 is a flowchart illustrating a second procedure of a date search target conversion process at the time of document registration.

FIG. 5 is a flowchart illustrating a third procedure of date search target conversion processing at the time of document registration.

FIG. 6 is a flowchart illustrating a fourth procedure of date search target conversion processing at the time of document registration.

FIG. 7 is a flowchart showing a fifth procedure of date search target conversion processing at the time of document registration.

FIG. 8 is a flowchart illustrating a sixth procedure of a date search target conversion process at the time of document registration.

FIG. 9 is a flowchart illustrating a seventh procedure of a date search target conversion process at the time of document registration.

FIG. 10 is a diagram illustrating a specific example of a conversion result of a date search target conversion process during document search.

FIG. 11 is a flowchart illustrating an outline of a date search target conversion process during document search.

FIG. 12 illustrates a specific example of a document.

FIG. 13 is a diagram showing a specific example of a full-text search database.

[Explanation of symbols]

 REFERENCE SIGNS LIST 1 full-text search database 2 registration information input section 3 registration information editing processing section 4 date search target conversion processing section 5 registration processing section 6 search condition input section 7 search condition editing processing section 8 date search target conversion processing section 9 search processing section 10 search Result edit processing unit 11 Search result output processing unit

Claims (4)

[Claims] 1. A full-text search method for performing a search using a full-text of a document by a full-text search database that stores a document to be searched. In a full-text search database, when a document is registered in a full-text search database, the document is included in the input document. Converts the information indicating the range into a character string suitable for full-text search that can specify that an arbitrary numerical value is within the range, and registers the input document and the converted character string in a full-text search database Then, at the time of document search of the full-text search database, a numerical search condition included in the input search condition is converted into a search condition capable of full-text search for the converted character string, and the input search condition and the A full-text search method, wherein a full-text search is performed on a full-text search database based on the converted search conditions. 2. The full-text search method according to claim 1, wherein
When converting the information indicating the range included in the input document into a character string in a format suitable for full-text search that can specify an arbitrary numerical value as the range, the value at the beginning and end of the range For all digits, the rest is
A full-text search method characterized by sequentially changing the upper digits of a value so as to be targeted. 3. A means for inputting a document to be registered in a full-text search database in a full-text search system for performing a search using the full-text of a document by a full-text search database storing a document to be searched, and a range included in the document. Means for converting the information indicating the character string into a character string in a format suitable for full-text search capable of specifying that an arbitrary numerical value is within the range; and a means for editing the input document and the converted character string. Means for registering the edited information in a full-text search database; means for inputting a condition for searching the full-text search database; and numerical search conditions included in the input search conditions with respect to the converted character string. Means for converting the input search conditions and the converted search conditions into a search condition capable of performing full-text search, and a means for editing the input search conditions and the converted search conditions. A means for performing a full-text search on a full-text search database, a means for editing a search result into a format that can be output, and a means for outputting the edited search result. . 4. A computer-readable recording medium which records a full-text search program for performing a search using the full text of a document by a full-text search database storing a document to be searched. In the document registration mode, the information indicating the range included in the input document is converted into a character string in a format suitable for full-text search capable of specifying that an arbitrary numerical value is within the range, and the input A processing process of registering a document and the converted character string in a full-text search database; and, in a document search mode of the full-text search database, a numerical search condition included in an input search condition with respect to the converted character string. Convert to full text searchable search conditions,
A recording medium storing a full-text search program, comprising: a process for performing a full-text search on a full-text search database based on the input search conditions and the converted search conditions.