JP4177997B2 - Database search apparatus, database search method, computer program, and computer-readable recording medium - Google Patents

Description

[0001]
BACKGROUND OF THE INVENTION
  The present invention relates to a data mining technique for finding a specific pattern from a database of complex events such as scientific data and economic data, and more specifically, a record group having a large number of fields.CompoundFor databases,CompoundTo systematically find causal relationships that are implicitly implied in the database,CompoundThe present invention relates to a database search device, a database search method, a computer program, and a computer-readable recording medium that expands a component into a component and performs operations between attributes of the component and data reorganization.
[0002]
[Prior art]
  Complex system behavior cannot be expressed completely and explicitly due to constraints such as observation means, measurement method, and data description. For complex events, the data stored in the event database is different from actual events. Therefore, numerical data that can be obtained from the literature, a measurement method for obtaining the numerical data, a description related to the measurement conditions (hereinafter, this description is referred to as “related parameters”), and a document that describes these contents ( A fragmentary database will be constructed by combining bibliographic items related to (source). Attempts to construct an event database using such methods have failed. An event database constructed in accordance with an original data model composed of a combination of data and related parameters is extremely difficult to obtain a satisfactory evaluation from the user.
[0003]
  In general, in using a database, a user inputs a plurality of search conditions or selects a desired search condition from a search condition menu. The database creates a record set that matches each search condition, extracts a desired record group by a logical operation of the record set, and executes display or printing.
[0004]
  By such processing, in the case of a document database, document information and bibliographic items suitable for the purpose can be obtained. In the case of an event database, attribute values such as numerical values, text, diagrams, and photographs can be obtained. In either case of the document database or the event database, a record group as a subset of the accumulated record group can be obtained together with the attribute value.
[0005]
  Further, in both case of the literature database and the event database, the search result for the event not stored as a record in the database is an empty set. An event database constructed in accordance with the original data model often returns an empty set in response to a search request due to the difficulty of data editing.
[0006]
  In other words, in order to build a database search system that can satisfy users, it is assumed that the fact that the observed facts can be accurately described without excess or deficiency is an exception. It is important to consider whether to supplement.
[0007]
[Problems to be solved by the invention]
  Currently, in order to overcome the “language ambiguity” which is one of the attributes of natural language, keywords are prepared for each field, and search using such keywords is widely used. However, the exact definition and usage of keywords cannot be enforced. For this reason, there is a limit to support by a thesaurus or natural language processing, and the search result necessarily includes noise or a search leak occurs. Therefore, the validity of the search result is left to the user.
[0008]
  In addition, the event database inevitably has a small amount of information in search results when the data amount and data quality are insufficient. In the former case, it is difficult to draw a valid conclusion, and in the latter case, it is easy to lead to a wrong conclusion. That is, there is a problem that it is difficult to draw an effective conclusion because an extremely high-quality work is required to construct an event database with both quality and quantity.
[0009]
  The use of knowledge processing technology overcomes these limitations. However, knowledge processing technology is a technology related to the reuse of knowledge that is logically defined and established, and it is almost impossible to build a knowledge base for complex events. In the case of complex events, it is necessary to acquire new knowledge from a data group in which a logical relationship is defined only implicitly, and consider using the knowledge acquired on the spot. Therefore, the conventional knowledge processing technology has a problem that it is not effective for the problem of searching for solutions in which knowledge acquisition and knowledge use proceed simultaneously, such as solutions for design solutions, business strategies and preventive maintenance. .
[0010]
  In view of such a problem, an object of the present invention is to provide a database search apparatus, a database search method, a computer program, and a computer-readable recording medium that can easily search for a solution suitable for the problem of interest. And
[0011]
[Means for Solving the Problems]
  In order to achieve such an object, the invention described in claim 1 is a database search device,Many compoundsA first record having a plurality of fields for describingCompoundConfigureelementStorage means for storing a second record having a plurality of attributes for describingThe attribute value of the field of interest selected from the plurality of fields for describing the compound is not a null value and is less than a certain threshold, and the attribute value of the field of interest is not a null value. A record that is equal to or greater than a threshold value from the first record.Extraction means for extracting and stored in the storage meansAboveSelected from the second recordOf the elementsattributeAttribute valueWith variablesTrySetting means for setting at least two trial functions to:The compound of the record extracted by the extraction unit is expanded into elements, and the combination of the expanded elements is combined with the setting unit.SetAboveTrial functionAnd the results of the calculation are arranged on a graph with coordinate values as numerical values obtained by at least two trial functions, andBy the extraction meansFrom the first recordExtractedAboveOf the field of interest in the recordattributevalueBy determining whether or not exceeds a certain threshold,Classification means to classify andThe graph in which the calculation result is arranged is changed by changing the display form of the calculation result of each compound according to the determination result by the classification means as to whether or not the attribute value of the field of interest exceeds a certain threshold value. Display means for displaying;It is provided with.
[0012]
  The invention described in claim 2 is the database search apparatus according to claim 1, further comprising creating means for creating a new attribute based on the attribute stored in the storage means.
[0013]
  Further, the invention according to claim 3 is the database search device according to claim 1 or 2, wherein the setting means includes a first accepting means for accepting selection of the attribute and an input of a mathematical operation. And a means for creating the trial function based on the attribute accepted by the first accepting means and the mathematical operation accepted by the second accepting means. And
[0014]
  Further, the invention according to claim 4 is the database search device according to any one of claims 1 to 3, wherein the classification means includes calculation means for executing calculation of a trial function set by the setting means;Graph with coordinate values as numerical values obtained by at least two trial functionsAbove, an arrangement means for arranging the calculation result executed by the calculation means, a value of the field of interest corresponding to a reference point selected from the calculation results arranged by the arrangement means, and the reference point And comparison means for comparing the value of the field of interest corresponding to other calculation results existing around the.
[0015]
  Claims5The invention described inMany compoundsA first record having a plurality of fields for describingCompoundConfigureelementA database search method in a database search device storing a second record having a plurality of attributes for describingThe extraction means of the database search device comprises:SaidThe attribute value of the field of interest selected from the plurality of fields for describing the compound is not a null value and is less than a certain threshold, and the attribute value of the field of interest is not a null value. A record that is equal to or greater than a threshold value from the first record.Extract andThe setting means of the database search device includes theSelected from the second recordOf the elementsattributeAttribute valueWith variablesTrySet at least two trial functions toThe categorizing means of the database search device expands the compound of the record extracted by the extracting means into elements, and for the combination of the expanded elements, the setting meansSetAboveTrial functionThe calculation results are arranged on a graph having coordinate values as numerical values obtained by the at least two trial functions, and extracted from the first record by the extraction means.ExtractedAboveOf the field of interest in the recordattributevalueBy determining whether or not exceeds a certain threshold,ClassificationThe calculation result of each compound according to the determination result by the classification means whether or not the display means of the database search device exceeds a certain threshold value of the attribute value of the field of interest Change the display form of the above, and display the graph with the same calculation resultIt is characterized by.
[0016]
  Claims6The invention described in is a computer program,Many compoundsA first record having a plurality of fields for describingCompoundConfigureelementStoring a second record having a plurality of attributes for describingIn addition,SaidThe attribute value of the field of interest selected from the plurality of fields for describing the compound is not a null value and is less than a certain threshold, and the attribute value of the field of interest is not a null value. A record that is equal to or greater than a threshold value from the first record.ExtractionExtracting means forSelected from the second recordOf the elementsattributeAttribute valueWith variablesTrySet at least two trial functionsAnd setting means for expanding the compound of the record extracted by the extracting means into elements, and for the combination of the expanded elements, the setting meansSetAboveTrial functionThe calculation results are arranged on a graph having coordinate values as numerical values obtained by the at least two trial functions, and extracted from the first record by the extraction means.ExtractedAboveOf the field of interest in the recordattributevalueBy determining whether or not exceeds a certain threshold,ClassificationThe calculation result is arranged by changing the display form of the calculation result of each compound according to the determination result by the classification means and whether the attribute value of the field of interest exceeds a threshold value or not. And function as a display means for displaying the graph.It is characterized by that.
[0017]
  Claims7The invention described in claim 1 is a computer-readable recording medium.6The computer program described in 1 is recorded.
[0018]
  In the present invention, a search problem of a solution such as a design solution of a compound isCompoundUsing a database, the problem is solved by exhaustive search of the solution space combining trial functions and solution sorting functions. Design is an act of deriving a set of facts that satisfy any condition from requirements specifications and available resources, axioms and theorems for composition and attribute prediction of resources. The solution space of the design solution is a space derived from the record corresponding to the fact about this action.
[0019]
  CompoundThe database determines the function system of the trial function for approximating the space where the solution exists, by exhaustive search of the solution space that combines the execution of the trial function consisting of multiple field operations and the sorting function, Try to solve the problem.
[0020]
  Moreover, the search history of the solution space can be recorded as a trial and error history of solution search, and can be accumulated as a reusable knowledge base after protocol analysis.
[0021]
DETAILED DESCRIPTION OF THE INVENTION
  Hereinafter, embodiments of the present invention will be described in detail with reference to the drawings. In the following explanation,CompoundMeans a recognized individual composed of one or more attributes (fields).The data model is a process of abstracting information, and is a method of holding data such as the data representation format unit in the abstracted world, a method of representing data interrelationships, and a system of these overall operation methods. This is a model for making rules independent of the algorithm of each application program.
[0022]
  FIG. 1 is a block diagram showing a hardware configuration of a database search apparatus according to an embodiment of the present invention.
[0023]
  The database search apparatus 200 shown in the figure includes a system memory 204, a CPU (Central Processing Unit) 206, and a plurality ofCompoundConsist of a collection of dataCompoundA database (DB) 208 and a ROM (Random Access Memory) 210 are connected to the system bus 221.
[0024]
  The system memory 204 stores a DB control program 212 and data 213 referred to by this program.
[0025]
  The DB control program 212CompoundThis is a program for performing processing such as data registration, update, and deletion for the database 208.CompoundThe database 208 is a set of data registered by executing the DB control program 212. These sets of data are registered on an internal or external storage device such as a hard disk, a magnetic disk, an optical disk, or a magneto-optical disk.
[0026]
  Further, a display 230, a speaker 232, a keyboard 234, and a mouse 236 are connected to the system bus 221 as peripheral devices.
[0027]
  The display 230 displays an image edited by the CPU 206, and an LCD (Liquid Crystal Display), a CRT (Cathode-Ray Tube), or the like can be used. The speaker 232 converts the electrical signal into sound and outputs it. The keyboard 234 and the mouse 236 are input devices used for controlling the cursor on the display 230 and inputting commands to the CPU 206. The display 230, the speaker 232, the keyboard 234, and the mouse 236 are all connected to the system bus 221 via an input / output (I / O) interface (not shown).
[0028]
  The functions related to the present invention are as follows. The CPU 206 reads out and executes a program stored in the ROM 210 or the system memory 204, or stores a computer-readable recording medium storing the program related to the present invention in the database search apparatus 200. This is achieved by supplying. In the latter case, the CPU 206 of the database search apparatus 200 reads and executes the program stored in the recording medium.
[0029]
  As a recording medium for supplying a program to the database search device 200, specifically, a flexible disk, a hard disk, a magneto-optical disk, an optical disk, a CD-ROM, a CD-R, a magnetic tape, a nonvolatile memory card, and a ROM, A flash memory such as a compact flash (registered trademark) can also be used, but the present invention is not limited to these media.
[0030]
  Further, the term “program” used in the present embodiment refers to what is described in a program language such as a high-level programming language such as BASIC, C language, or C ++, an assembly language, or a machine language. It is not limited to these languages.
[0031]
  Next, referring to FIG. 2, the database retrieval apparatus 200 according to the present embodiment is installed.CompoundDescribe the contents of the database.
[0032]
  CompoundDatabase 208 contains compounds of two kinds of elementsCompoundData 601;elementData 602 is stored.CompoundData 601 isCompoundIs a set of records having a plurality of fields (attributes) for describing.CompoundThe records that make up the data are melting point, density, hardness, lattice constant, precipitate size, dislocation density, grain size, neutron cross section, tensile strength, yield strength (yield strength) ) Etc.elementData 602 isCompoundConfigureelementIs a set of records having a plurality of fields (attributes) for describing, and includes fields such as a Mendeleev number, an elastic modulus, a Young's modulus, an elastic constant, and an electronegativity. In the following description:CompoundData andelementTo avoid confusion with data fields,CompoundThe field of data is “field”,elementThe data field is described as “attribute”.
[0033]
  Next, the database search method according to the present embodiment will be described with reference to the flowchart of FIG.
[0034]
  In the present embodiment, for a compound composed of two elements, for example, the hiding that exists between the characteristics of some compounds such as crystal structure or melting point and the attributes of components (elements) such as Mendeleev number or electronegativity Search for correlations. The attributes of the two elements are combined by several mathematical operations (eg, the maximum number of atoms), and this combination is called a trial function. An attribute and a plurality of mathematical operations on the attribute are selected by the user. The database search apparatus 200 combines the selected attributes with a mathematical operation to set a trial function, and executes a trial function for all elements to search for a solution. In the following description, the purpose of the search is to find a solution space that well separates the properties of different compounds by boundaries, such as a crystal structure.
[0035]
  First, in step S102, the database search device 200CompoundSearch the database 208 and assume that the field of interest is a dependent variable (DV). Then, a record that is a field of interest and in which a field having a correlation between the fields is not a null value is extracted, and a set of extracted records is created.
[0036]
  The field of interest is a field related to the problem that the user is trying to analyze. For example, when focusing on the strength of a material (chemical substance) as a characteristic of a design target compound, that is, when the strength of a material becomes a dependent variable, the fields of tensile strength, yield strength, and hardness Field ". Similarly, fields (lattice constant, precipitate size, dislocation density, crystal grain size) corresponding to parameters describing the consistency of the two-phase interface can be set as the “field of interest”. On the other hand, a field that is unrelated to the strength of the material, such as the cross-sectional area of neutrons, is not a “field of interest”.
[0037]
  In addition, when there is a correlation between fields, for example, when the environment is changed, such as increasing the temperature of the compound, the attribute value of the field assumed to be a dependent variable changes with a certain relationship, In addition to the relationship to temporal changes, it also includes the relationship to physical changes.
[0038]
  Whether or not there is a correlation can be determined as follows. Now, the problem that the user wants to analyze is based on the characteristics of the two elements, between the crystal structure of those compounds (whether they are NaCl or CsCl structures) and the attribute values of the elements constituting the compounds. Suppose that it is to find a correlation. When determining the temperature correlation, all compounds that crystallize into the NaCl or CsCl structure should beCompoundA set of data records (data set 1) is created. Then, for all those compounds, the temperature was changedCompoundA set of records for data (data set 2) is created. Finally, the data set 2 is subtracted from the data set 1. Then, the difference between the data sets 1 and 2 is evaluated.
[0039]
  The process of assuming the field of interest as a dependent variable is displayed on the display 230.CompoundThe list can be set by displaying a list of all fields included in the data and accepting selection of fields from the list. In this case, the dependent variable is determined according to the selection operation by the user using the input device.
[0040]
  Further, a problem to be noted (for example, material strength, substance stability, etc.) is displayed on the display 230 as a selection menu, and the problem is dealt with according to the problem selected by the user using the input device. A field may be set as a dependent variable.
[0041]
  Next, in step S104, the database search device 200CompoundTheelementExpand to.
[0042]
  CompoundDatabase 208 is a compound composed of two kinds of elementsTheSince this is something to remember,CompoundIs the basic component, ieElementalBe expanded. For example, NiTi used as a shape memory alloy is developed into Ni and Ti. Database search device 200 has been deployedelementofelementDataCompoundExtract from database 208.
[0043]
  At the same time, the database search apparatus 200 is preliminarily provided as necessary.elementBased on the attribute value stored in the data, a new attribute value that can be an independent variable for the target dependent variable is calculated. For example, if the strength of the material becomes a dependent variable, the independent variable may be the total energy of the atom, the first derivative of the total energy, the second derivative,CompoundIf the database stores in advance the total energy of an element as an attribute value, the first and second derivatives can be calculated based on the stored data.
[0044]
  Next, in step S106, the database search device 200 displays all the expanded files.elementFor the above, a set of records composed of attribute values that can be independent variables with respect to the dependent variables and that are not null values is created.
[0045]
  The database search device 200element, A value must exist and a field that is assumed to be an independent variable for the above dependent variable is combined into one record,elementA set of records about (elementDatabase).
[0046]
  Next, in step S108, the database search device 200elementA selection of a specific attribute is received from attributes constituting the database, and an input of a mathematical operation for the selected attribute is received. Then, a trial function is set based on the received attribute (independent variable) and mathematical operation.
[0047]
  In this case, the user associates the dependent variable (field of interest) with the independent variable (attribute of each element)elementSelect at least one desired attribute value from the database and select at least two mathematical operations on the selected attribute. The database search apparatus 200 sets and stores a trial function by combining the attribute value selected by the user and a mathematical operation.
[0048]
  The attribute value assumed to be the dependent variable of interest can be set by displaying a list of candidate attribute values that can be independent variables on the display 230 and accepting selection of the attribute value from this list. In this case, it is set according to the selection operation from all attribute values by the user using the input device. Similarly, mathematical operations can be set by displaying a list of candidates on the display 230 and accepting a selection from the list.
[0049]
  Finally, in step S110, the database search device 200setIn order to execute the classification based on the values of the dependent variables, a systematic calculation of the trial function and sorting of the values of the dependent variables are combined to perform an exhaustive search for classification. This operation attempts to find a solution in order to find the optimal trial function for distinguishing the values of the dependent variables based on a certain threshold.
[0050]
  FIG. 4 is a flowchart showing the process in step S110 in more detail. The database search apparatus 200 executes the plurality of trial functions set in step S108 for a certain element combination (S801). Specifically, when the set trial function is “ratio of Mendeleev number of two elements” and “maximum value of Mendeleev number of two elements”, the database search apparatus 200 picks up two kinds of elements and extracts them. Perform trial function calculations.
[0051]
  The database search apparatus 200 determines, for each calculation result, whether or not the value of the dependent variable in the compound composed of the two elements used in the calculation exceeds a certain threshold (CompoundAssortment). Based on this determination, the calculation result can be divided into a characteristic that the value of the dependent variable is less than the threshold value and a characteristic that the value of the dependent variable is equal to or greater than the threshold value (S802).
[0052]
  Then, the calculation result is arranged on a solution space defined by each trial function (S803). That is, the calculation result is arranged on a solution space where the x-axis is “ratio of Mendeleev number of two elements” and the y-axis is “maximum value of Mendeleev number of two elements”. Such calculation and arrangement are performed brute force for all elements (S804), and finally all calculation results are arranged on the solution space (sorting).
[0053]
  Next, the database search device 200 sets one point as a reference point from the points arranged in the solution space (S805), and determines the characteristics of the reference point. Next, one or more points closest to the point are found, the characteristics of the found point are compared with the characteristics of the reference point, and it is determined whether the characteristics are the same (S806). Then, the probability that the characteristic of the point closest to the reference point is the same as the characteristic of the reference point is calculated.
[0054]
  Next, one or more points closest to the reference point are found, and the probability that the characteristic of the found point is the characteristic of the reference point is obtained in the same manner as described above. Such processing is repeated for all points arranged in the solution space (S807).
[0055]
  Next, the database search apparatus 200 determines whether the characteristics of the points are well “separated” at a certain distance from the reference point based on the obtained probability. Specifically, this determination is performed by obtaining a boundary line in the solution space where the probability obtained above decreases most rapidly. Then, the solution space with the best separation is identified as the solution space suitable for the problem of interest.
[0056]
  In this step S110, the calculation results (ie, solutions) of the trial function categorized by the value of the dependent variable are displayed on the display by color-coding each point arranged in the solution space according to the determination result. Provided to the user.
[0057]
  In this way, by combining the systematic operation of the trial function and the sorting of the values of the independent variables, and performing an exhaustive search for solutions,CompoundIdentification of solution spaces that better classify
[0058]
  Note that in this embodiment, there is no record that matches the search condition, and only the systematic sorting performed based on the attribute values of the elements constituting the substance, the macro characteristics of the substance and the basic constituent elements (elements) This is particularly effective when the solution space for the correlation with () cannot be identified.
[0059]
  Next, an example of a screen displayed on the display in the database search method according to the present embodiment will be described with reference to FIGS. In the following description, the problem for the user is the stability of the compound, and the analysis of this problem is based on the formation of compounds for compounds and compound formation (components randomly at lattice positions). It is performed by determining the case of being disposed or becoming amorphous. Although this example is used as a sample because the data has been thoroughly examined, the selection as a dependent variable is not limited to this.
[0060]
  FIG. 5 shows an example of an input box displayed on the display in step S108. In the figure, an input box 300 includes an independent variable menu 301 and a mathematical operation menu 302. In the independent variable menu 301, attribute values such as bulk modulus (Bulk Modulus), Young's modulus (Young's Modulus), lateral modulus of elasticity (modulus of rigidity), Mendeleev number, etc. are displayed as selectable independent variables. Yes. In addition, the arithmetic processing menu 302 displays values such as addition (Sum) and subtraction (Difference). The database search apparatus 200 searches for a solution space search using a trial function set based on the result of this menu selection.
[0061]
  The user can operate the mouse 236 to select a desired independent variable from the menu 301 on the input box 300 and a desired mathematical operation from the menu 302. In the figure, “M1 Mendeleev number” in the menu 301 is selected for all the rows in the menu 302. The user can set a trial function by pressing a “Next” button 303. In this manner, a process of accepting selection of an element attribute, accepting a mathematical operation, and creating a trial function by combining the accepted attribute and the mathematical operation is realized.
[0062]
  FIG. 6 is a diagram illustrating an example of display of the calculation result in step S110.
[0063]
  Once the trial function calculation is completed, the screen shown in the figure is displayed on the display. As shown in the figure, in the left window 401, the existence probability of a point having the same characteristics as the reference point is displayed as a function of the distance from the reference point (Neighbors). For example, “20” on the horizontal axis indicates a distance of 20 units from the reference point in the solution space.
[0064]
  The lower right window 403 displays a list of calculation results for each trial function sorted according to the integral of the curve at the closest distance from the reference point (ie, 1 unit from the reference point).
[0065]
  Finally, in the upper right window 402, a list of trial functions is displayed. The window 402 is composed of three items “Profile”, “1”, and “50” in order from the left. Among these items, the name of the trial function is displayed in the item “Profile”. The number in parentheses in the item “1” indicates the probability that the characteristic of the point closest to the reference point is the same as the characteristic of the reference point. The number in parentheses in the item “50” indicates the probability that the characteristic of the point at the 50th position closest to the reference point is the same as the characteristic of the reference point.
[0066]
  According to this window 402, 100% of the points at a distance of 1 unit from the reference point in the solution space defined by the trial function “38-03 / 38-06 / 00-00”, and 50 units About 92% of the points at distance have the same crystal structure as the compound corresponding to the reference point. A curve 404 in the left window 401 indicates a separation state for the trial function “38-03 / 38-06 / 00-00”. These results show a really good “separation” for the two crystal structure patterns, compound form and compound non-former. Therefore, using this trial function,CompoundIs most likely categorized and has a high probability of correctly predicting the structure of new compounds that do not contain dependent variable values in the database.
[0067]
  FIG. 7 shows a graphical representation of the solution space for this trial function. In the left window 501 of FIG. 9, the calculation result of the trial function is arranged with the x-axis being the ratio of the Mendeleev number and the vertical axis being the maximum value of the Mendeleev number. Of the points indicating the calculation results, the black points were used for the calculation.elementThis means that a substance consisting of a compound forms a compound, and a white dot indicates that a compound is not formed. As can be seen from the figure, good separation between crystal structure patterns (white dots and black dots) is obtained.
[0068]
  By identifying the solution space in this way, the designer can predict a crystal structure pattern even for a substance without data. The application of this method is not limited to the crystal structure pattern.
[0069]
  In addition, since each point corresponds to the technical literature, it can be predicted that, for example, where the points are densely studied based on the points in the solution space, active research is being conducted. Visualize development trends.
[0070]
  Further, in the example shown in the figure, the solutions are classified according to the color of the points, but they may be displayed using other expression forms such as shapes.
[0071]
  As mentioned above, although embodiment of this invention was described in detail, it cannot be overemphasized that this invention can be implemented with another various form, without being limited to the above-mentioned embodiment.
[0072]
  For example, complexCompoundThe conventional orthodox method for elucidating the mechanism of the method requires careful consideration in setting and executing the trial function, and applied the conventional search method.CompoundA database system requires enormous calculation time and resources. Therefore, the calculation process that is the rate-determining process in the above database search process is performed by a separate calculation server, and the calculation value isCompoundA method of registering in the database may be adopted.
[0073]
  Further, the space represented by the trial function is not limited to two dimensions. FIG. 8 shows an example of the solution space when the space represented by the trial function is three-dimensional.
[0074]
  In addition, by making the mathematical operation of the trial function a simple functional system with only four arithmetic operations and comparison operations, the time required to verify the working hypothesis is significantly reduced to a few minutes, and the idea of the user in the solution process is reduced. Practicality as an information processing device that accelerates can be acquired.
[0075]
  In addition to the above-described design solutions, the present invention is also applied to a business strategy for which the required specifications in the design are a business target, and the required specifications are searched for a solution related to preventive maintenance for maintaining the soundness of an artifact. be able to.
[0076]
【The invention's effect】
  As described above, according to the present invention, it is possible to easily identify a solution space suitable for the problem of interest.
[0077]
  Therefore, it is a collection of factsCompoundAn information system platform is built to support the process of acquiring ideas using the database and the process of adding the acquired ideas as facts.
[Brief description of the drawings]
FIG. 1 is a block diagram showing a hardware configuration of a database search apparatus according to an embodiment of the present invention.
[Figure 2]CompoundStored in the databaseCompoundData andelementIt is a figure which shows an example of the content of data.
FIG. 3 is a flowchart showing a procedure of a database search method according to the embodiment of the present invention.
FIG. 4 is a flowchart showing the process in step S110 in more detail.
FIG. 5 is a diagram showing an example of an input box displayed on the display in step S108.
FIG. 6 is a diagram showing an example of display of calculation results in step S110.
FIG. 7 is a diagram showing an example of a graphical representation of the solution space displayed on the display in step S110.
FIG. 8 is a diagram illustrating an example of a solution space when a space expressed by a trial function is three-dimensional.
[Explanation of symbols]
  200 Database search device
  204 System memory
  206 CPU
  208CompoundDatabase (DB)
  210 ROM
  212 DB control program
  213 data
  221 System bus
  232 Speaker
  234 keyboard
  236 mice
  300 input box
  301, 302 Menu
  303 “Next” button
  401, 402, 403, 501 windows
  404 Curve

Claims (7)

Storage means for storing a first record having a plurality of fields for describing a large number of compounds and a second record having a plurality of attributes for describing elements constituting the compound ;
The attribute value of the field of interest selected from the plurality of fields for describing the compound is not a null value, and the attribute value of the field of interest is not a null value. Extracting means for extracting a record that is equal to or greater than a certain threshold from the first record ;
Setting means for setting at least two trial function to try the attribute value of the attribute of the element selected from the second records stored in the storage means as a variable,
Expand compounds of the records extracted by the extraction unit to elemental, for the combination of the expanded elements to perform calculations of the trial function set by the setting means, the calculation result, at least numerical values obtained by the two said trial function is arranged on a graph whose coordinate axes, and the attribute value of the noted field in the record extracted from the first record by the extraction means, a threshold by performing more than whether the determined, and classification means for categorizing said compound,
The display form of the calculation result of each compound is changed according to the determination result by the classification means whether the attribute value of the field of interest exceeds a certain threshold value, and the graph in which the calculation result is arranged is displayed. Display means to
A database search device characterized by comprising:   The database search apparatus according to claim 1, further comprising a creation unit that creates a new attribute based on the attribute stored in the storage unit. The setting means includes
First accepting means for accepting selection of the attribute;
A second receiving means for receiving an input of a mathematical operation;
The means for creating the trial function based on the attribute received by the first receiving means and the mathematical operation received by the second receiving means, 2. The database search device according to 2. The classification means is
Calculation means for performing calculation of the trial function set by the setting means;
Arrangement means for arranging calculation results executed by the calculation means on a graph having coordinate values as numerical values obtained by at least two trial functions ;
The value of the field of interest corresponding to the reference point selected from the calculation results arranged by the arrangement means, and the value of the field of interest corresponding to other calculation results existing around the reference point The database search device according to claim 1, further comprising: a comparison unit that compares Database search method in a database search apparatus storing a first record having a plurality of fields for describing a large number of compounds and a second record having a plurality of attributes for describing elements constituting the compound Because
The extraction means of the database search device selects a record in which the attribute value of the field of interest selected from the plurality of fields for describing the compound is not a null value and less than a certain threshold value, A record whose attribute value is not a null value and is equal to or greater than a certain threshold is extracted from the first record ,
The setting means of the database search device, to set at least two trial function attempts to the attribute value of the attribute of the element selected from the second record as a variable,
Wherein the classification means of the database search device, expand the compound of the records extracted by the extraction unit to elemental, for the combination of the expanded element, the computation of the trial function set by the setting means run, the calculation result, the respective numerical values obtained by at least two of said trial function is arranged on a graph whose coordinate axes, and the interest in the record extracted from the first record by the extraction unit Categorizing the compounds by determining whether the attribute value of the field to be exceeds a certain threshold ,
The display unit of the database search device changes the display form of the calculation result of each compound according to the determination result by the classification unit as to whether or not the attribute value of the field of interest exceeds a certain threshold value. A database search method characterized by displaying the graph in which results are arranged . In a computer storing a first record having a plurality of fields for describing a large number of compounds and a second record having a plurality of attributes for describing elements constituting the compound ,
The attribute value of the field of interest selected from the plurality of fields for describing the compound is not a null value, and the attribute value of the field of interest is not a null value. Extracting means for extracting a record that is equal to or greater than a certain threshold from the first record ;
Setting means for setting at least two trial function attempts to the attribute value of the attribute of the element selected from the second record as a variable,
Expand compounds of the records extracted by the extraction unit to elemental, for the combination of the expanded elements to perform calculations of the trial function set by the setting means, the calculation result, at least numerical values obtained by the two said trial function is arranged on a graph whose coordinate axes, and the attribute value of the noted field in the record extracted from the first record by the extraction means, a threshold Categorizing means for classifying the compound by determining whether or not
The display form of the calculation result of each compound is changed according to the determination result by the classification means whether the attribute value of the field of interest exceeds a certain threshold value, and the graph in which the calculation result is arranged is displayed. Display means to
A computer program characterized by functioning as a computer program. A computer-readable recording medium on which the computer program according to claim 6 is recorded.

Images