JP2008262324A - Information processor, information processing method and program - Google Patents

Abstract

<P>PROBLEM TO BE SOLVED: To retrieve query definition information by a free keyword with performance same as when of using the query definition information and retrieving data without using both of them. <P>SOLUTION: A design part 11 generates the query definition information. A division part 12 extracts a character string included in the query definition information to be used for character string information 21, sets a character string ID to a part from which the character string is extracted instead of the character string, and sets the query definition information set with the character string ID as query definition information 22 except the character string. A keyword retrieval part 15 acquires a retrieval keyword 3 for retrieval of the query definition information from a user, and retrieves the character string information 21 corresponding to the retrieval keyword 3 to retrieve the query definition information by the free keyword. A merg part 13 replaces the character string ID with the corresponding character string in the character string information 21 so for count retrieval of data, and merges the query definition information 22 except the character string and the character string information 21 to reproduce the query definition information. <P>COPYRIGHT: (C)2009,JPO&INPIT

Description

  The present invention relates to a technique for performing a tabular search on data stored in a database.

In recent years, the amount of data handled by corporations has increased, and in order to utilize the data for management, data analysis after storage in a database is essential.
OLAP (On-line Analytical Processing) is a system that instantly aggregates and searches data and visualizes it in charts and graphs. The department that requires the analysis results, not the information system department, directly uses the system. It is operated and analyzed.
For this reason, users of OLAP tools have already created and stored design users (such as information system departments) who create information (herein referred to as query definition information) for performing aggregate search and result display of the database. It is divided into search users who acquire the total search results using the query definition information.
When both users use the query definition information created and stored, the target query definition information is searched from the list. Especially, in the case of the OLAP tool used in the Web environment, the query definition information is stored on the Web server. In many cases, the user cannot easily search with the search function attached to the OS.
In addition, since the query definition information stores information necessary for the aggregate search, extra query definition information may be picked up by using a general search function such as a normal document file.
Therefore, in general, in order to make it easy to find the target query definition information from the list, the OLAP tool relaxes the name size limit so that an easy-to-understand name can be given to the query definition information name, and provides a comment addition function. Yes.
However, this method requires the skill and additional work of the design user.

For example, in the technique disclosed in Patent Document 1, in order to provide a search function in the system, a search extracted from the form data based on the form data corresponding to the query definition information text and the management data sentence structure information set in advance. Document data document management technology has been proposed in which management data is associated and managed and searched in a database.
Further, for example, in the technology disclosed in Patent Document 2, in order to display a form for each group or user in the electronic form providing system to the user terminal, a form ID, a group ID, a user ID, a material date, a display A method for searching a form using an index file in which attributes and the like are stored has been proposed.
Japanese Patent Laid-Open No. 2002-73637 JP, 2002-109456, A Claim 4

  The conventional form data document management technology that manages and searches in the database by associating the form with the search data extracted from the form has dual search data separately from the form, making the management complicated and storing There was a problem that the area also increased.

  The method of storing the form attributes in the index file and using it for the search can control the display of the form list to be shown to the search user by the attribute, but the index file stores only the fixed items, so the user However, there was a problem that the form list could not be searched with free keywords.

  One of the main purposes of the present invention is to solve the above-mentioned problems, and it is possible to use a free keyword with the same performance as when double holding query definition information and search data instead of double holding. The main purpose is to make it possible to search the query definition information, and to facilitate the management by not having double.

An information processing apparatus according to the present invention includes:
For each item of item information having a plurality of items, it is determined whether the item is an extraction target item including at least a part of the extraction target character string or a non-extraction target item not including the extraction target character string. An item determination unit;
The extraction target character string in the item determined to be the extraction target item is extracted from the item information, character string information indicating the extracted character string is generated, and the character string extraction portion of the item information after the character string extraction is generated. And a character string extracting unit that sets a character string identifier representing the extracted character string and generates post-extraction item information in which the character string identifier is set instead of the character string.

According to the present invention, the character string information indicating the character string included in the item information is provided separately from the item information, but since the extracted item information has a character string identifier instead of the character string, Information is not double-held, which makes it easy to manage information and makes more efficient use of hardware resources.
In addition, since the character string information is managed independently from the item information, the item information can be efficiently searched by a free keyword search using the character string information.

Embodiment 1 FIG.
FIG. 1 is a diagram illustrating a configuration example of an OLAP tool apparatus 1 (information processing apparatus) according to the present embodiment.
In FIG. 1, the OLAP tool device 1 is connected to a database 4.
In the OLAP tool apparatus 1, the design unit 11 designs a data analysis method for the database 4. That is, the design unit 11 designs (generates) query definition information.
The information classification unit 17 classifies each item of the query definition information into an item including a character string used for keyword search of the query definition information and other items.
The dividing unit 12 divides the query definition information into character string information 21 and query definition information 22 other than character strings based on the classification by the information classifying unit 17 and stores them in a predetermined storage device (not shown). The dividing unit 12 is an example of an item determining unit and a character string extracting unit.
Note that the character string information 21 and the query definition information 22 other than the character strings after being divided by the dividing unit 12 are elements of the post-division query definition information 2.
The merge unit 13 assembles the query definition information from the character string information 21 and the query definition information 22 other than the character string (reproduces the query definition information).
The list output unit 14 generates a list of query definition information assembled by the merge unit 13 and outputs the generated list to a display device (not shown) to display the list of query definition information.
The keyword search unit 15 acquires the search keyword 3 for searching the query definition information from the user, and searches for the query definition information that matches the search keyword 3.
The tabulation search unit 16 tabulates and searches the database data using the query definition information and displays the result.

Although FIG. 1 shows a form in which the OLAP tool device 1 exists in a stand-alone computer, the design unit 11 may exist on another computer connected via a network such as a LAN (Local Area Network).
The post-partition query definition information 2 may also be stored on the same computer as the OLAP tool device 1, or may be stored on another computer or storage.

The design unit 11, the information classification unit 17, and the division unit 12 are functions used by a design user (such as an information system department) who creates query definition information, and includes a merge unit 13, a list output unit 14, and a keyword search unit 15. The total search unit 16 is a function used by a search user who acquires the total search result using the query definition information already created and stored.
Therefore, for example, as shown in FIG. 7, an OLAP tool apparatus (for design user) 100 including a design unit 11, an information classification unit 17, and a division unit 12, a merge unit 13, a list output unit 14, and a keyword search unit 15. Alternatively, the OLAP tool apparatus (for search user) 101 including the total search unit 16 may be divided into different computers, and each computer may be connected via a network such as a LAN.

In the present embodiment, the OLAP tool device 1 makes it possible to search for query definition information using free keywords with the same performance as when the query definition information and search data are not held double, but are held double.
Specifically, the design unit 11 generates query definition information, and the dividing unit 12 extracts a character string included in the query definition information as character string information 21, and sets a character string at a position where the character string is extracted. The character string ID to be represented is set instead of the character string, and the query definition information in which the character string ID is set is referred to as query definition information 22 other than the character string.
In addition, the keyword search unit 15 acquires the search keyword 3 for searching the query definition information from the user, and searches for the character string information 21 including the character string that matches the search keyword 3. The query definition information can be searched.
Further, when displaying a list of query definition information or performing a total search on the database 4 using the query definition information, the merging unit 13 sets the character string ID of the query definition information 22 other than the character string as a character string. Substitution is performed with a corresponding character string in the information 21, and the query definition information 22 other than the character string and the character string information 21 are merged to reproduce the query definition information.
The total search unit 16 performs a total search of the database 4 using the reproduced query definition information, and displays the total search result.

The query definition information is information shown in FIGS. 2A and 2B, for example.
The query definition information is composed of a row of identifiers and a row of items, and the number of rows and columns of items varies depending on the identifier and the number of items and the number of rows. For example, when the identifier means a dimension axis or aggregated data, the row in which the items are listed is as shown in FIG. The first line in FIG. 2B is an example in which column dimension items are expanded, and the second line is an example in which aggregated data is expanded.
That is, FIG. 2A is a diagram showing an overview of query definition information, and FIG. 2B is a diagram showing a breakdown of FIG. 2A.
Each item of FIG. 2B shows data necessary for performing a total search of data from the database and displaying a total search result.
In the example of FIG. 2B, the item type, data display name, data type, data length, database name, and the like are shown.
As described above, the query definition information includes management information, reference information, search text, total information, and the like for performing a total search on the database.
Further, the total search unit 16 can create an SQL sentence from the search sentence included in the query definition information, and can execute a total search of the database 4.
Furthermore, the total search result can be displayed as a table or a graph using the total data that is the execution result of the total search unit 16 and the display items in the query definition information.
The query definition information is an example of item information.

2 (c) and 2 (d) show examples of query definition information after division by the dividing unit 12, FIG. 2 (d) shows an example of character string information 21, and FIG. c) shows an example of query definition information 22 other than a character string.
That is, the query definition information is divided and stored by the dividing unit 12 into the query definition information 22 other than the character string in FIG. 2C and the character string information 21 in FIG.
The character string information 21 is information indicating a character string that can be the search keyword 3 by the keyword search unit 15. The query definition information 22 other than the character string is information after the character string indicated by the character string information 21 is extracted from the query definition information.
In the present embodiment, in the query definition information 22 other than the character string, as shown in FIG. 2C, a character string identifier (representing the extracted character string) is displayed at the character string extraction position where the character string is extracted. <Str 0> etc.) is set.
The query definition information 22 other than the character string is an example of post-extraction item information.

  Next, the operation of the OLAP tool device 1 according to the present embodiment will be described.

First, the flow of creating query definition information by the design unit 11 of the OLAP tool device 1 will be described.
The user executes the design unit 11 of the OLAP tool device 1 to design a database data analysis method. That is, query definition information as shown in FIG.
The designed information is classified and temporarily stored by the information classification unit 17.

The classification will be described with reference to FIG.
FIG. 3 shows an example of holding query definition information in the design unit 11.
Before the division by the dividing unit 12, the query definition information stores items together with flags as shown in FIG. FIG. 3 is an example in which a flag is set in the query definition information in FIG. The information classification unit 17 sets a flag for each item of the query definition information, that is, classifies each item.
The flag “0” is an item necessary only for the total search, the flag “1” is a display item used for the result display, and the flag “2” is an item including a character string that is necessary for the total search but can be a search keyword.
For example, the data type and length of the database column is “0”, the query definition information name, the creator name or administrator name, the comment, the dimension axis name, the axis item, and the aggregate data name are “1”, and the SQL statement is “ 2 ”.
In this classification, “0” is an item stored as query definition information 22 other than a character string as it is, “1” is an item stored as character string information 21, and “2” is a content stored as character string information 21 from the data. Means that it is an item to be cut out, and is used in the next step of division processing.
The design unit 11 designs a plurality of types of query definition information. The information classification unit 17 classifies each item of the query definition information according to the type of query definition information designed by the design unit 11 (flag). Set).
The information classification unit 17 classifies each item of the query definition information based on the identifier of the query definition information (sets a flag).

  Of the items in the query definition information, items for which the flag “0” is set are examples of non-extraction target items, and items for which the flag “1” is set are examples of first extraction target items. Yes, the item for which the flag “2” is set is an example of the second extraction target item.

When the design by the design unit 11 and the classification of items by the information classification unit 17 are completed, the division unit 12 is called.
The dividing process of the dividing unit 12 will be described with reference to FIGS.
FIG. 4 is a flowchart of the dividing process (item determining step, character string extracting step) in the dividing unit 12.

First, the dividing unit 12 takes in the query definition information stored in the information classifying unit 17 (S10).
The dividing unit 12 performs the processing after S11 for each item in order from the first item of the query definition information.
The dividing unit 12 determines the flag of each item in S11.
In S11, if the flag is "0", nothing is done and the process proceeds to the next item (S18).
If the flag is “1” in S11, the dividing unit 12 confirms whether the character string indicated in the item exists in the character string information 21 (S12). This is a process for not storing the same character string twice.
If the character string indicated in the item does not exist in the character string information 21 in S12, the character string of the item is stored in the character string information 21 (S13).
Next, an index in the character string information 21 is set as a character string ID at a character string extraction location (S14). That is, a character string ID (character string identifier) representing the extracted character string is set at the character string extraction location.
For example, the second item “year” in FIG. 2B has a flag “1”, and is therefore stored in the character string information 21 (FIG. 2D). A character string ID <str 0> is set instead of the location where the character string “year” is extracted (FIG. 2C). The dividing unit 12 prepares a table for associating the character string with the character string ID, and each time the character string ID is set, the association between the newly set character string ID and the character string is recorded in the table. Alternatively, a pointer that associates the character string ID with the character string may be set.
Then, the dividing unit 12 proceeds to processing for the next item (S18).
S12 to S14 are collectively referred to as S100.

If the flag is “2” in S11, the dividing unit 12 confirms whether the item includes a column name of the database or a display name (dimension axis name, total data name, etc.) in the OLAP tool (S15). ). The dividing unit 12 determines that the character string enclosed in “” is a database column name or a display name in the OLAP tool.
For example, in FIG. 2B, “hiduke” of “EXTRACT (YEAR FROM“ hiduke ”)” is identified as a character string to be extracted.
If not included, the dividing unit 12 proceeds to processing of the next item (S18).
If it is included, S100 is executed (S16).
That is, as described above, if the same character string is not stored repeatedly, the character string included in the item being processed is stored in the character string information 21, and the extracted character string is stored in the character string extraction portion. A character string ID representing the above is set. In the example of “EXTRACT (YEAR FROM“ hiduke ”)” described above, the character string ID <str 1> is set instead at the place where the character string “hiduke” is described.
Next, the dividing unit 12 advances the pointer pointing to the head of the data (S17), and when the column name of the database is not included in the item, the process proceeds to the next item (S18).
If the item being processed is the last item, the entire query definition information after the character string is extracted is stored as query definition information 22 other than the character string (S19).
Thus, the character string information 21 and the query definition information 22 other than the character string are created.
Thereafter, the dividing unit 12 stores the generated character string information 21 and the query definition information 22 other than the character string in association with each other in a storage device (not shown).

As described above, the dividing unit 12 includes, for each item of query definition information (item information) having a plurality of items, an item (extraction target item) including at least a part of an extraction target character string, and an extraction target item Determines whether the item does not contain a character string (non-extraction target item), extracts the extraction target character string in the item determined as the extraction target item from the query definition information, and indicates the extracted character string In addition to generating the character string information 21, a character string identifier representing the extracted character string is set in the character string extraction portion of the query definition information after the character string is extracted, and the character string identifier is set instead of the character string. Query definition information 22 (extracted item information) other than the character string is generated.
Then, the dividing unit 12 includes, as the extraction target item, a first extraction target item (item of flag “1”) configured from the extraction target character string, and a second part of the extraction target character string. Extraction target items (items with flag “2”).
The dividing unit 12 sets items used only for the tabular search as non-extraction target items, sets items including character strings used for displaying the tabulation search results as the first extraction target items, and is used for the tabular search. Thus, an item including a query definition information search character string that can be used for keyword search of query definition information is set as a second extraction target item.
And the division part 12 determines whether it is a 1st extraction object item, a 2nd extraction object item, and a non-extraction object item for every item of query definition information, A character string constituting the determined item is extracted from the query definition information, and a character string to be extracted in the item determined to be the second extraction target item is extracted from the query definition information to generate character string information 21. .

Next, a flow of displaying a query definition information list for allowing the OLAP tool apparatus 1 to select various operations from the user will be described. First, the user executes the list output unit 14.
Then, the merge unit 13 is called.
The merge process of the merge unit 13 will be described with reference to the flowchart of FIG.
When the merge unit 13 is called, an identifier indicating which query definition information character string information 21 and query definition information 22 other than character strings are merged is passed from the list output unit 14 to the merge unit 13.
In the merge process, the merge unit 13 inputs character string information 21 corresponding to this identifier and query definition information 22 other than the character string from a storage device (not shown) (S30).
Next, the merging unit 13 checks whether the input content includes a character string ID (S31). While included, the merge unit 13 inputs a character string corresponding to the character string ID from the character string information 21 of the query definition information, The process of replacing the column ID (S32) is repeated.
In this way, the character string information 21 of the necessary part and the query definition information 22 other than the character string are merged, and the query definition information is reproduced.
The list output unit 14 creates and displays a list based on the merge result.
The above merge processing is necessary when displaying details of the contents of the query definition information in the list output. For example, if only the names of the query definition information are displayed in a list, the merge processing is performed. It does not have to be.
However, since it is necessary to reproduce the query definition information when performing the aggregate search on the database 4, if the merge process is not performed when the list is output, the aggregate search is performed at the time of the aggregate search on the database 4 as described later. The unit 16 calls the merge unit 13 and reproduces the query definition information through merge processing by the merge unit 13.

Also, a search field for inputting the search keyword 3 when a list of query definition information is output is provided on, for example, a GUI (Graphical User Interface) screen.
The keyword search unit 15 searches the character string information 21 with the search keyword 3 input from the user.
This keyword search process will be described with reference to FIG.
FIG. 6 is a flowchart of keyword search processing in the keyword search unit 15.
First, the keyword search unit 15 inputs character string information 21 of query definition information (S50).
The character string information 21 including the character string that matches the search keyword 3 input by the user is searched (S51). If there is, the file name of the character string information 21 is set in a buffer that is passed to the list output unit 14 (S52). ).
If there is character string information 21 of other query definition information to be searched as a query definition information list (S53), it is continuously input (S50).
The list output unit 14 displays a list of query definition information extracted by the keyword search unit 15 based on the contents of the buffer.

Lastly, the flow of collecting and searching database data will be described.
When the user operates the total search on the list, the total search unit 16 is executed.
Also at this time, the merge unit 13 is called, the target character string information 21 and the query definition information 22 other than the character string are merged, and the query definition information is reproduced.
Then, the aggregation search unit 16 creates an SQL sentence from the merged query definition information, and executes an aggregation search of the database 4.
From the aggregated data that is the execution result and the query definition information, the aggregated search results are displayed in a table or graph.

As described above, a character string used for query definition information search is provided separately from the query definition information. However, since it is made to function as a part of the query definition information, information is not held double. Therefore, management becomes easy and H / W resources can be used more effectively.
In addition, the OLAP tool device itself has a query definition information search function, and allows the user to search with free keywords, making it easier to find the query definition information to be analyzed more efficiently.

As described above, in the present embodiment, in the OLAP tool that performs the total search and the result display of the data accumulated in the database, when the file storing the OLAP processing information is referred to as query definition information,
Classify the query definition information into a part that is necessary only for aggregate search, a part that is necessary for result display, and a part that contains a character string that can be used as a search keyword.
Based on the classified information, it is divided and saved into character string information used for keyword search and other query definition information,
The query definition information storage method has been described in which the divided character string information and other query definition information are merged and used as one query definition information.

In the present embodiment, in the OLAP tool that performs a total search of data accumulated in the database and the result display, when the file storing the OLAP processing information is referred to as query definition information,
An information classification means for classifying query definition information into a part necessary only for aggregate search, a part necessary for result display, and a part including a character string that is necessary for aggregate search but can be a search keyword;
Based on the classified information, dividing means for dividing and storing character string information used for keyword search and other query definition information,
A query definition information storage device that includes split character string information and merge means for assembling other query definition information into one query definition information has been described.

Finally, a hardware configuration example of the OLAP tool apparatuses 1, 100, and 101 shown in the first embodiment will be described.
FIG. 8 is a diagram illustrating an example of hardware resources of the OLAP tool apparatuses 1, 100, and 101 described in the first embodiment. The configuration in FIG. 8 is merely an example of the hardware configuration of the OLAP tool devices 1, 100, and 101, and the hardware configuration of the OLAP tool devices 1, 100, and 101 is limited to the configuration described in FIG. Alternatively, other configurations may be used.

In FIG. 8, the OLAP tool devices 1, 100, and 101 include a CPU 911 (also referred to as a central processing unit, a central processing unit, a processing unit, an arithmetic unit, a microprocessor, a microcomputer, and a processor) that executes a program. The CPU 911 is connected to, for example, a ROM (Read Only Memory) 913, a RAM (Random Access Memory) 914, a communication board 915, a display device 901, a keyboard 902, a mouse 903, and a magnetic disk device 920 via a bus 912. Control hardware devices. Further, the CPU 911 may be connected to an FDD 904 (Flexible Disk Drive), a compact disk device 905 (CDD), a printer device 906, and a scanner device 907. Further, instead of the magnetic disk device 920, a storage device such as an optical disk device or a memory card read / write device may be used.
The RAM 914 is an example of a volatile memory. The storage media of the ROM 913, the FDD 904, the CDD 905, and the magnetic disk device 920 are an example of a nonvolatile memory. These are examples of a storage device or a storage unit.
The communication board 915, the keyboard 902, the scanner device 907, the FDD 904, and the like are examples of an input unit and an input device.
Further, the communication board 915, the display device 901, the printer device 906, and the like are examples of an output unit and an output device.

The communication board 915 can be connected to a network. For example, the communication board 915 may be connected to a LAN (local area network), the Internet, a WAN (wide area network), or the like.
The magnetic disk device 920 stores an operating system 921 (OS), a window system 922, a program group 923, and a file group 924. The programs in the program group 923 are executed by the CPU 911, the operating system 921, and the window system 922.

The program group 923 stores programs that execute the functions described as “˜unit” and “˜means” in the description of the first embodiment. The program is read and executed by the CPU 911.
In the description of the first embodiment, the file group 924 includes “determination of”, “calculation of”, “comparison of”, “setting of”, “update of”, “search of”, Information, data, signal values, variable values, and parameters indicating the results of the processing described as “total of”, “extraction of”, etc. are stored as items of “˜file” and “˜database”. ing. The “˜file” and “˜database” are stored in a recording medium such as a disk or a memory. Information, data, signal values, variable values, and parameters stored in a storage medium such as a disk or memory are read out to the main memory or cache memory by the CPU 911 via a read / write circuit, and extracted, searched, referenced, compared, Used for CPU operations such as calculation, calculation, processing, editing, output, printing, and display. Information, data, signal values, variable values, and parameters are stored in the main memory, registers, cache memory, and buffers during the CPU operations of extraction, search, reference, comparison, calculation, processing, editing, output, printing, and display. It is temporarily stored in a memory or the like.
In addition, the arrows in the flowchart described in the first embodiment mainly indicate input and output of data and signals. The data and signal values are the RAM 914 memory, the FDD 904 flexible disk, the CDD 905 compact disk, and the magnetic disk device. It is recorded on a recording medium such as a 920 magnetic disk, other optical disks, minidisks, and DVDs. Data and signals are transmitted online via a bus 912, signal lines, cables, or other transmission media.

  In addition, what is described as “to part” and “to means” in the description of the first embodiment may be “to circuit”, “to device”, and “to device”. -Step "," -procedure "," -process "may be used. That is, what is described as “˜unit” and “˜means” may be realized by firmware stored in the ROM 913. Alternatively, it may be implemented only by software, or only by hardware such as elements, devices, substrates, and wirings, by a combination of software and hardware, or by a combination of firmware. Firmware and software are stored as programs in a recording medium such as a magnetic disk, a flexible disk, an optical disk, a compact disk, a mini disk, and a DVD. The program is read by the CPU 911 and executed by the CPU 911. That is, the program causes the computer to function as “to part” and “to means” in the first embodiment. Alternatively, the procedure and method of “˜unit” and “˜means” of the first embodiment are executed by a computer.

  As described above, the OLAP tool devices 1, 100, and 101 shown in the first embodiment include a CPU as a processing device, a memory as a storage device, a magnetic disk, a keyboard as an input device, a mouse, a communication board, and a display device as an output device. The computer includes a communication board and the like, and implements the functions indicated as “˜unit” and “˜means” using the processing device, the storage device, the input device, and the output device as described above.

FIG. 3 is a diagram illustrating a configuration example of an OLAP tool device according to the first embodiment. The figure which shows the example of query definition information other than the query definition information which concerns on Embodiment 1, character string information, and a character string. FIG. 4 is a diagram illustrating an example of item classification according to the first embodiment. FIG. 4 is a flowchart showing an example of a division process according to the first embodiment. FIG. 4 is a flowchart showing an example of merge processing according to the first embodiment. FIG. 3 is a flowchart showing an example of keyword search processing according to the first embodiment. FIG. 3 is a diagram illustrating a configuration example of an OLAP tool device according to the first embodiment. FIG. 3 is a diagram illustrating a hardware configuration example of an OLAP tool device according to the first embodiment.

Explanation of symbols

  DESCRIPTION OF SYMBOLS 1 OLAP tool apparatus, 2 division | segmentation query definition information, 3 search keyword, 4 database, 11 design part, 12 division part, 13 merge part, 14 list output part, 15 keyword search part, 16 total search part, 17 information classification part , 21 Character string information, Query definition information other than 22 character strings, 100 OLAP tool device (for design users), 101 OLAP tool device (for search users).

Claims (7)

For each item of item information having a plurality of items, it is determined whether the item is an extraction target item including at least a part of the extraction target character string or a non-extraction target item not including the extraction target character string. An item determination unit;
The extraction target character string in the item determined to be the extraction target item is extracted from the item information, character string information indicating the extracted character string is generated, and the character string extraction portion of the item information after the character string extraction is generated. A character string extracting unit that sets a character string identifier that represents the extracted character string and generates post-extraction item information in which the character string identifier is set instead of the character string. . The item determination unit
As the extraction target item, a first extraction target item composed of a character string to be extracted, and a second extraction target item partially including the extraction target character string,
For each item of the item information, determine which of the first extraction target item, the second extraction target item, and the non-extraction target item,
The character string extraction unit
A character string constituting an item determined to be the first extraction target item is extracted from the item information, and a character string to be extracted in the item determined to be the second extraction target item is extracted from the item information. The information processing apparatus according to claim 1, wherein the character string information is generated. The item determination unit
As the item information, the query definition information used for the aggregate search for the database is targeted,
Among the items included in the query definition information, an item used only for the aggregation search is determined as the non-extraction target item, and an item including a character string used for displaying the result of the aggregation search is the first extraction target. It is determined as an item, and an item that is used for an aggregate search and includes a query definition information search character string that can be used for a keyword search of query definition information is determined as a second extraction target item.
The character string extraction unit
A character string constituting the item determined as the first extraction target item is extracted from the query definition information, and a query definition information search character string in the item determined as the second extraction target item is extracted from the query definition information. The information processing apparatus according to claim 2, wherein the character string information is generated by extracting the character string information. The information processing apparatus further includes:
The information processing apparatus according to claim 3, further comprising a keyword search unit that searches for specific query definition information by performing a keyword search on a character string indicated by the character string information. The information processing apparatus further includes:
The information processing apparatus according to claim 1, further comprising a merge unit that reproduces the item information by replacing a character string identifier indicated in the item information after extraction with a corresponding character string in the character string information. . For each item of item information having a plurality of items, whether the extraction target item includes at least a part of the extraction target character string or a non-extraction target item that does not include the extraction target character string An item determination step for determining
The computer extracts a character string to be extracted in the item determined to be the extraction target item from the item information, generates character string information indicating the extracted character string, and character string of the item information after the character string extraction A character string extraction step of setting a character string identifier representing the extracted character string at the extraction location, and generating post-extraction item information in which the character string identifier is set instead of the character string. Information processing method. For each item of item information having a plurality of items, it is determined whether the item is an extraction target item including at least a part of the extraction target character string or a non-extraction target item not including the extraction target character string. Item judgment processing,
The extraction target character string in the item determined to be the extraction target item is extracted from the item information, character string information indicating the extracted character string is generated, and the character string extraction portion of the item information after the character string extraction is generated. A character string identifier representing the extracted character string is set, and the computer executes character string extraction processing for generating post-extraction item information in which the character string identifier is set instead of the character string. program.

Images