JP2008310602A - Retrieval program, retrieval method and retrieval device - Google Patents

Abstract

<P>PROBLEM TO BE SOLVED: To determine which retrieval condition has been instructed to cause a retrieved retrieval result, in regard to the retrieval result stored in a storage part. <P>SOLUTION: This retrieval program makes a computer execute a retrieval method for retrieving information stored in a database by instructing the retrieval condition to the database. Each storage area having the same structure as a structure formed by associating respective configuration units, divided in each the configuration unit is generated in the storage part controlled by the computer, and each retrieval expression generated as an instruction statement allowing an instruction to the database is used about each the retrieval condition related to each the configuration unit, so that information stored in the database is retrieved in each the configuration unit, and each the retrieved retrieval result in each the configuration unit is associated in each the configuration unit and is stored in each the generated storage area. <P>COPYRIGHT: (C)2009,JPO&INPIT

Description

  The present invention relates to a search program, a search method, and a search device.

  Conventionally, various techniques have been developed to search information stored in a database by instructing a search condition to the database. A search device to which such a technique is applied is utilized, for example, when a new product is developed by using information on past products. More specifically, the search device diverts to a new product by instructing a search condition for each part that constitutes a new product to a database that stores information for each part that constitutes a past product. Search for possible information.

  Further, for example, Patent Literature 1 discloses a technique that is utilized when a new system is developed by using past design information. More specifically, the design support apparatus disclosed in Patent Document 1 is obtained by diverting or remodeling diversion source information that is past design information reused in design work, or the diversion source information. It has a database that stores association information including diversion destination information and know-how related to the reuse process (for example, reasons for adopting past design information, purpose of modification, modification method, addition method, etc.). The past design information that can be reused is retrieved by instructing the association information having the reuse history that matches the required specifications of the system to be developed as a retrieval condition.

JP-A-9-212353

  By the way, in the above-described conventional technology, as described below, it is impossible to determine which search condition is the search result for the search result stored in the storage unit by instructing the search result. was there. Specifically, using the above example, when the search device searches for information that can be used for a new product, the search results for the parts that make up the new product are stored in the storage unit. A user who uses the apparatus cannot determine which part is a search result by specifying a search condition regarding which part of the search result stored in the storage unit.

  Similarly, when specifically described using the above-described example, when the design support apparatus searches for reusable past design information, the search result of the past design information is stored in the storage unit. The user who uses the design support apparatus cannot determine which association information is designated as the search result for the search result stored in the storage unit.

  Note that the above-mentioned problems are not limited to diverting past product information or past design information, but by instructing the database to search conditions, If the stored information is to be searched, it is similarly a problem.

  Therefore, the present invention has been made to solve the above-described problems of the prior art, and for the search result stored in the storage unit, it is determined which search condition is used to indicate the search result. It is an object of the present invention to provide a search program, a search method, and a search device that can be discriminated.

  In order to solve the above-described problems and achieve the object, the invention according to claim 1 causes a computer to execute a search method for searching for information stored in the database by instructing a search condition to the database. A storage area that is a search program and that has the same structure as the structure formed by associating each of the structural units, and generates each of the storage areas that are divided for each structural unit in the storage unit controlled by the computer Retrieval that searches information stored in the database for each constituent unit by using each of the search formulas that are generated as command statements that can be instructed to the database for the generation procedure and the search conditions for each of the constituent units Each of the search results for each structural unit searched by the procedure and the search procedure in the storage area A search result storage procedure for storing in association with each the structural unit in the storage area each produced by forming procedure, characterized by causing a computer to execute the.

  The invention according to claim 2 is the above invention, wherein the database is a plurality of databases, and the storage area generation procedure generates each storage area further divided for each database, and the search procedure Is to search each database for information stored in the database by using each search expression for each database generated as a command statement that can be instructed to the database, the search result storage procedure, Each search result searched for each database by the search procedure is stored in association with each database in each storage area generated by the storage area generation procedure.

  Further, in the invention according to claim 3, in the above invention, when receiving an instruction to collectively search for each of the structural units forming the predetermined structure, information indicating each of the structural units forming the predetermined structure is obtained. Each of the search conditions for each of the structural units indicated by the acquired information is stored in advance in the storage unit as a command sentence excluding the substitution of the search conditions. By sequentially substituting in the command statement, the computer further executes a search formula generation procedure for generating each search formula related to the predetermined structure, and the search procedure is generated in a batch by the search formula generation procedure. The information stored in the database is collectively searched by using each of the search formulas.

  According to a fourth aspect of the present invention, in the above invention, the search result storing procedure is the same even though each search result searched by the search procedure is a search result of a different constituent unit. If there is a duplicate search result of the content of, the entity information is stored for one search result among the plurality of duplicate search results, and the entity exists for the other search results Reference information for referring to information is stored.

  Further, in the invention according to claim 5, in the above invention, the information indicating each structural unit forming the structure is the same structure as that of the structure, and is divided into the structural units for a predetermined output unit. When the selection of information indicating a predetermined structural unit among the information indicating the output procedure to be output and the information indicating each of the structural units output by the output procedure is received at a predetermined input unit, the selection is received. A search result output procedure for acquiring a search result of a structural unit from the storage area stored by the search result storage procedure and outputting the acquired search result to a predetermined output unit is further executed by the computer. And

  The invention according to claim 6 is a search method for searching information stored in the database by instructing a search condition to the database in the above invention, wherein each of the structural units is associated. A storage area generation step for generating each storage area having the same structure as that formed in the above and divided for each constituent unit in a storage unit controlled by the computer, and each search condition relating to each constituent unit A search step for searching information stored in the database for each constituent unit by using each of the search formulas generated as command statements that can be specified in the database, and the constituent unit searched by the search step Each search result for each storage area generated by the storage area generation step Characterized in that it contains, and the retrieval result storage step of storing in association with the and.

  The invention according to claim 7 is the search device according to the above invention, wherein the search unit searches the information stored in the database by instructing the search condition to the database, and the structural units are associated with each other. Storage area generating means for generating a storage area having the same structure as that formed in the above and divided for each constituent unit in a storage unit controlled by the computer, and each search condition relating to each constituent unit By using each of the search formulas generated as command statements that can be instructed to the database, search means for searching information stored in the database for each constituent unit, and the constituent units searched by the search means Each of the search results for each storage area generated by the storage area generation means Characterized in that and a retrieval result storage means for storing in association with the and.

  According to the invention of claim 1, 6 or 7, there is provided a search program for causing a computer to execute a search method for searching information stored in the database by instructing a search condition to the database. A storage area that is the same as the structure formed by associating each of the storage units and that is divided for each structural unit is generated in a storage unit controlled by the computer, and a search condition for each structural unit is stored in a database. By using each of the search formulas generated as instructionable statements, information stored in the database is searched for each structural unit, and each search result for each searched structural unit is configured in each generated storage area. Since it is stored in association with each unit, which search condition is instructed for the search result stored in the storage unit It is possible to determine whether the search results searched by the.

  According to the invention of claim 2, the database is a plurality of databases, and the search program generates each storage area further divided for each database, and the database generated as a command statement that can be instructed to the database By using each search expression for each database, information stored in the database is searched for each database, and each search result searched for each database is stored in association with each generated storage area for each database. Even when searching for information stored in a plurality of databases, search results for which information stored in which database is searched by specifying which search condition is specified for the search results stored in the storage unit It becomes possible to determine whether or not.

  According to the invention of claim 3, when the search program receives an instruction to search collectively for each of the structural units forming the predetermined structure, the search program stores information indicating each of the structural units forming the predetermined structure as information. From the storage unit that stores in advance, each of the search conditions for each of the structural units indicated by the acquired information is sequentially converted into a fixed command statement stored in advance in the storage unit as a command statement excluding the substitution of the search condition By substituting, the search formulas related to the predetermined structure are generated in a lump, and by using each search formula generated in a lump, the information stored in the database is searched in a lump. In addition, information stored in the database can be easily searched.

  According to the invention of claim 4, the search program includes a case where search results having the same contents are duplicated in the search results that have been searched, even though the search results are different structural units. Stores the actual information for one search result among a plurality of search results existing in duplicate, and stores the reference information for referring to the actual information for the other search results. In addition, it is possible to reduce the capacity of search results stored in the storage unit.

  According to the invention of claim 5, the search program outputs the information indicating each structural unit forming the structure to the predetermined output unit after being divided into the structural units having the same structure as the structure. Then, when selection of information indicating a predetermined structural unit among the information indicating each structural unit output is received at a predetermined input unit, a search result of the predetermined structural unit for which the selection has been received is acquired from the storage area. Since the acquired search result is output to a predetermined output unit, the search result can be easily output in addition to the above-described effects.

  Embodiments of a search program, a search method, and a search device according to the present invention will be described below with reference to the accompanying drawings. In the following, the main terms used in the embodiment, the outline and features of the search device according to the first embodiment, the configuration of the search device according to the first embodiment, the processing procedure by the search device according to the first embodiment, and the first embodiment. Next, another embodiment will be described.

[Explanation of terms]
First, main terms used in the following examples will be described. A “database” is a device that stores various types of information. In general, the “database” includes a large-capacity hard disk, and a large amount of various information is stored in the hard disk. For this reason, a user who uses the “database” must first search for information stored in the “database”. Specifically, the user searches for information stored in the “database” using a “search device” having a function of instructing “search conditions” for the “database”. For example, if the user inputs the part number “BBB-0001-11” as “search condition” in “search device”, the “search device” will have the part number “BBB-0001-11” for “database”. As the “search condition”, the information corresponding to the part number “BBB-0001-11” is searched from the information stored in the “database”, and the search result is searched for the “search device”. Store in the storage.

  Here, the “search device” indicates only one “search condition” such as the part number “BBB-0001-11”, and stores the search result searched by specifying one “search condition”. It is not only stored in the department. The “search device” instructs a plurality of “search conditions” to the “database”, such as sequentially specifying a plurality of “search conditions” or instructing a plurality of “search conditions” at once. A plurality of search results searched by instructing a plurality of “search conditions” must be stored in the storage unit.

  If this is the case, it is considered that there are often multiple search results searched by specifying one "search condition", but the search results searched by specifying multiple "search conditions" It is considered that there are many cases where there are a large number and a large amount, and therefore, a plurality of large amounts of search results are mixedly stored in the storage unit of the “search device”. On the other hand, for users who use the “database”, it is possible to determine which “search condition” is the search result for the search result stored in the storage unit of the “search device”. It is desirable to be. The “search device” according to the present invention meets such needs.

  By the way, the “component” used in the following embodiment corresponds to “component” when information is managed in units of components constituting the new product, for example, when developing a new product. It is. To give specific examples, “parts” means that information is managed in parts such as “body”, “tire”, and “interior” when developing new automobile products. It corresponds to “body”, “tire”, “interior” etc. In addition, “parts” may have a hierarchical structure or a group structure so that information is managed in parts such as “engine” and “muffler” as a hierarchy below “body”. In the following embodiments, a hierarchical structure or a group structure formed by associating each “configuration unit” is called a “structure”.

[Outline and Features of Search Device According to Embodiment 1]
Next, the outline and features of the search device according to the first embodiment will be described with reference to FIG. FIG. 1 is a diagram for explaining the outline and features of the search device according to the first embodiment. In the following first embodiment, it is assumed that the “configuration unit” corresponds to the “part” when the information is managed in units of “parts” constituting the new product. The invention is not limited to this. For example, assuming that the information corresponds to a “line” when the information is managed in units of a “line” in a factory, the “structural unit” is a search result searched by the “search device”. Any one can be used as long as it can be conceptually separated as a separation when managed.

  As described above, the search device according to the first embodiment provides an overview of searching for information stored in a database by instructing a search condition for the database, and the search result stored in the storage unit. The main feature is that the search result is determined by specifying which search condition.

  To briefly explain this main feature, in the first embodiment, the “component” is the “component” when information is managed in units of components constituting the new product, for example, when developing a new product. Assuming that it is equivalent, as shown in Fig. 1, it is assumed that it corresponds to part number "AAA-0003", "BBB-0001-00", "BBB-0004-00", etc. And Further, in the first embodiment, the “structure” is assumed to be a hierarchical structure formed by associating each “component” with each other. As shown in FIG. 1, for example, the component number “AAA-0003” In the lower hierarchy, information is also managed in part units with part numbers “BBB-0001-00” and “BBB-0004-00”. In the hierarchy below part number “BBB-0001-00”, the part number “CCC” -0001-00 "and" CCC-0002-00 "It is assumed that information is managed even in units of parts.

  Under such a configuration, the search device according to the first embodiment first searches each storage area that has the same structure as the hierarchical structure formed by associating the parts with each other and is divided for each part. It is generated in a storage unit controlled by the apparatus (see (1) in FIG. 1). For example, as illustrated in FIG. 1, the search device generates a folder in the storage unit that has the same structure as the hierarchical structure of the parts constituting the new product and is classified for each part.

  Next, the search device according to the first embodiment searches for information stored in the database for each part by using each search expression generated as a command statement that can be instructed to the database for each search condition for each part. (See (2) in FIG. 1).

  Then, the search device according to the first embodiment stores the search results for each searched part in association with each part in each storage area (see (3) in FIG. 1). For example, as shown in FIG. 1, the search device stores each search result for each searched component in association with each folder in each folder.

  In this way, the search device according to the first embodiment stores each search result for each part in association with each part in each folder. Therefore, which part of the search result stored in the storage unit is selected. By specifying as a search condition, it is possible to determine whether the search result is a search result.

[Configuration of Search Device According to Embodiment 1]
Next, the configuration of the search device according to the first embodiment will be described with reference to FIGS. FIG. 2 is a block diagram illustrating the configuration of the search apparatus according to the first embodiment, FIG. 3 is a diagram for explaining a conceptual parts table creation screen, and FIG. 4 is a diagram for explaining a search condition setting screen. FIG. 5 is a diagram for explaining the search result display screen, FIG. 6 is a diagram for explaining the conceptual parts table storage unit, and FIG. 7 shows the search condition setting storage unit. FIG. 8 is a diagram for explaining a folder configuration storage unit, FIG. 9 is a diagram for explaining a search formula generation formula storage unit, and FIG. 10 is a search formula. FIG. 11 is a diagram for explaining a storage unit, FIG. 11 is a diagram for explaining a parts database, and FIG. 12 is a diagram for explaining a document management database.

  First, the configuration of the search device according to the first embodiment will be described with reference to FIG. 2. The search device 10 according to the first embodiment includes an input unit 11, an output unit 12, an input / output control I / F unit 13, and the like. The storage unit 20 and the control unit 30 are configured.

  The input unit 11 inputs information used for various types of processing by the control unit 30 and operation instructions for performing various types of processing to the search device 10, and is a keyboard, a mouse, a storage medium, a communication unit, or the like. It is. Specifically, the input unit 11 inputs information stored in a concept parts table storage unit 21 and a search condition setting storage unit 22 described later. The input unit 11 inputs a search instruction for searching by a search unit 35 described later, an output instruction for outputting a search result by a search result output unit 38 described later, and the like.

  The output unit 12 outputs the results of various processes by the control unit 30 and operation instructions for performing various processes to the search device 10 and is a monitor, a printer, or the like. Specifically, the output unit 12 includes a concept parts table creation screen output by a concept parts table creation unit 31 described later, a search condition setting screen output by a search condition setting unit 32 described later, or a search described later. The search result display screen output by the result output unit 38 is output.

  For example, the monitor which is the output unit 12 outputs a concept parts table creation screen shown in FIG. Here, the conceptual parts table creation screen shown in FIG. 3 will be described. In the first embodiment, the search device 10 according to the present invention is utilized when developing information on past products and developing new products. Therefore, for example, the left half of the screen in FIG. 3 shows a parts table of past products. The past product part number “AAA-0001” is composed of the part numbers “BBB-0001-00” and “BBB-0002-00”. Similarly, the past product part number “AAA-0002” Is composed of part numbers “BBB-0003-00” and “BBB-0004-00”.

  On the other hand, for example, in the right half of the screen in FIG. 3, a conceptual parts table of a new product is shown. The new product part number “AAA-0003” is composed of part numbers “BBB-0001-00” and “BBB-0004-00”. This new product conceptual parts table is displayed on the conceptual parts table creation screen output to the output unit 12 by the later-described conceptual parts table creation unit 31 (from the user using the search device 10). It is an example of an image in which a conceptual parts table is input.

  For example, the monitor which is the output unit 12 outputs a search condition setting screen as shown in FIG. Here, the search condition setting screen shown in FIG. 4 will be described. In the first embodiment, the search apparatus according to the present invention includes a plurality of databases including a parts database (see FIG. 11) and a document management database (see FIG. 12). Therefore, for example, in the column “target DB” in FIG. 4, “part DB” and “document management DB” are illustrated as search target databases. In the first embodiment, it is assumed that the search device according to the present invention performs a batch search for each part of a new product that forms a hierarchical structure. For example, in the “search condition” column of FIG. As a search condition, “concept 1001” meaning the entire hierarchical structure of a new product is illustrated. These search conditions are input by the input unit 11 (from the user using the search device 10) on the search condition setting screen output to the output unit 12 by the search condition setting unit 32 described later. It is an example of an image.

  For example, the monitor which is the output unit 12 outputs a search result display screen as shown in FIG. Here, the search result display screen shown in FIG. 5 will be described. In the first embodiment, the search device according to the present invention classifies information indicating each component forming the hierarchical structure and outputs the information to the output unit 12. When selection of information indicating a predetermined part is accepted by the input unit 11, a search result of the part is acquired from the folder unit 24 described later and output to the output unit 12. For example, the part number “CCC-0001-00” in FIG. 5 expressed in black means that it is a predetermined part for which selection has been accepted. In the first embodiment, the search device according to the present invention retrieves each search result retrieved for each of the parts database and the document management database for each database in each of the generated “CAD file” folder and “document file” folder. For example, when the selection of the part number “CCC-0001-00” is accepted, the output unit 12 displays the “CAD file” folder and the right side window as shown in FIG. Display the icon of the “Document file” folder.

  The input / output control I / F unit 13 controls information transfer between the input unit 11 and the output unit 12, and the storage unit 20 and the control unit 30.

  The storage unit 20 stores information used for various types of processing by the control unit 30, and particularly as closely related to the present invention, as shown in FIG. 2, a conceptual parts table storage unit 21 and a search condition setting storage unit 22, a folder configuration storage unit 23, a folder unit 24, a search formula generation formula storage unit 25, and a search formula storage unit 26. The storage unit 20 corresponds to a “storage unit” recited in the claims.

  The concept parts table storage unit 21 stores a concept parts table. Specifically, the concept parts table storage unit 21 stores the concept parts table created by the concept parts table creation unit 31 to be described later. The search expression generation unit 34 or the output unit 37 is used.

  For example, as shown in FIG. 6, the conceptual parts table storage unit 21 stores “concept part No.”, “part number”, and “hierarchy information” in association with each other. Here, the information illustrated in FIG. 6 represents the hierarchical structure and the classification of each part in the form of a table for the conceptual product table of the new product illustrated in FIG.

  In the first embodiment, these pieces of information stored in the conceptual parts table storage unit 21 are displayed on the conceptual parts table creation screen output to the output unit 12 (monitor) by the conceptual parts table creation unit 31 (described later) ( Although it is assumed that the component table of the new product is input by the input unit 11 (from the user who uses the search device 10), the present invention is not limited to this. For example, when a conceptual parts table of a new product is created in advance, these pieces of information stored in the conceptual parts table storage unit 21 are stored in advance by a storage medium or a communication unit. Also good.

  The search condition setting storage unit 22 stores search conditions set in the search device 10. Specifically, the search condition setting storage unit 22 stores search conditions set by a search condition setting unit 32 (to be described later), and the stored search conditions are processed by the search expression generation unit 34 (to be described later). Used.

  For example, as shown in FIG. 7, the search condition setting storage unit 22 stores “concept part No.”, “search target DB”, and “search condition” in association with each other. Here, in the first embodiment, it is assumed that the search device 10 according to the present invention searches a plurality of databases of the parts database and the document management database. For example, the column “Search Target DB” in FIG. “Parts database” and “Document management database” are illustrated. Further, in the first embodiment, it is assumed that the search device 10 according to the present invention performs a batch search for each part of a new product that forms a hierarchical structure. For example, in the column “Search condition” in FIG. Exemplifies “concept 1001” which means the entire hierarchical structure of a new product as a search condition.

  In the first embodiment, the information stored in the search condition setting storage unit 22 is displayed on the search condition setting screen output to the output unit 12 (monitor) by the search condition setting unit 32 (to be described later). Although it is assumed that the search condition is input by the input unit 11 (from a user who uses 10), the present invention is not limited to this. For example, when a search condition is set in advance, the information stored in the search condition setting storage unit 22 may be stored in advance by a storage medium, a communication unit, or the like.

  The folder configuration storage unit 23 stores the folder configuration of folders for storing search results. Specifically, the folder configuration storage unit 23 stores a folder configuration generated by a folder generation unit 33 to be described later, and the folder generation unit 33 generates a folder in the storage unit 20 by the folder generation unit 33. It is used for processing.

  For example, as shown in FIG. 8, the folder configuration storage unit 23 stores “folder No.”, “concept part No.”, “part number”, “DB type”, and “folder configuration information” in association with each other. is doing. Here, “folder configuration information” is address information on the storage unit 20 relating to each of the folders (folders No. “1” to “14”) generated by the folder generation unit 33. As can be seen from the “folder configuration information”, each folder has the same structure as the hierarchical structure of the new product shown in FIG. 6 and is divided into parts and generated on the storage unit 20.

  Note that these pieces of information stored in the folder configuration storage unit 23 are information that is generated each time information generated by a folder generation unit 33 described later.

  The folder part 24 is a folder for storing search results. Specifically, the folder unit 24 is a folder generated by the folder generation unit 33 based on the folder configuration stored in the folder configuration storage unit 23 (folder configuration generated by the folder generation unit 33 described later). Yes, the folder is used for processing by a search result storage unit 36 and a search result output unit 38 to be described later. As described in the folder configuration storage unit 23, the folder unit 24 has the same structure as the new product hierarchical structure shown in FIG. 6, is divided into parts, and is generated on the storage unit 20.

  The search formula generation formula storage unit 25 stores a search formula generation formula for generating the search formulas at once. Specifically, the search formula generation formula storage unit 25 stores in advance a search formula generation formula input from the input unit 11 (from a user using the search device 10), and stores the search formula generation stored therein. The formula is used for processing by the search formula generation unit 34 to be described later.

  For example, as shown in FIG. 9, the search formula generation formula storage unit 25 includes “collective designation search key”, “search target DB”, “search formula generation formula (1)”, and “search formula generation formula (2)”. Are stored in association with each other. Here, the “search formula generation formula (1)” and the “search formula generation formula (2)” are standard commands stored in the search formula generation formula storage unit 25 in advance as command statements excluding search condition substitution. It is a sentence. For example, when searching for information stored in the “CAD database” as “search target DB”, for example, “concept part number” is used as a search condition (eg, search key). Can be specified. The “concept part number” is “concept 1001”, which means the entire hierarchical structure of a new product.

  Here, looking at the column of “search expression generation formula (1)”, it is “Select part number from concept part table database Where (concept part number = [concept part number])”. This is an example of a search expression generation formula described in the SQL (Structured Query Language) language. By substituting a specific value using “concept part number” as a search condition, a concept part table database (concept This means that a search expression for searching for “part number” associated with “designed part number” designated from the parts table storage unit 21) is generated. Further, looking at the column of “search formula generation formula (2)”, there is “Select CAD file storage location from component database Where (component number = actual search key)”. This is also an example of a search expression generation formula written in the SQL language. By substituting a specific value with “part number” as a search condition, a parts database (a CAD file to be searched is stored) is shown. This means that a search expression for searching for the “CAD file storage location” associated with the designated “part number” is generated.

  In the first embodiment, the information stored in the search formula generation formula storage unit 25 stores in advance the search formula generation formula input from the input unit 11 (from a user using the search device 10). However, the present invention is not limited to this. For example, the search formula generation formula creation screen output to the output unit 12 (monitor) by the search formula generation unit 34 to be described later stores the input of the search formula generation formula by the input unit 11. Good.

  The search formula storage unit 26 stores the generated search formula. Specifically, a search expression generated by a search expression generation unit 34 (described later) (stored using information stored in the search expression generation storage unit 25) is stored, and the stored search expression is: It is used for processing by the search unit 35 described later.

  For example, as shown in FIG. 10, the search formula storage unit 26 stores “concept part No.”, “part number”, “search target DB”, and “search formula” in association with each other. Here, the “search formula” is a search formula generated by the search formula generation unit 34. Specifically, for example, “Select CAD file storage location from parts database Where (part number = AAA-0001)” is stored in the above-described search expression generation expression storage unit 25. This is a search formula generated by substituting a specific value for “part number” as a search condition in “formula generation formula (2)”, and is associated with the part number “AAA-0001” specified in the part database. The database is instructed to search the “CAD file storage location”.

  Note that these pieces of information stored in the search formula storage unit 26 are stored each time information generated by a search formula generation unit 34 to be described later.

  The control unit 30 controls the search device 10 to execute various processes, and particularly those closely related to the present invention include a conceptual parts table creation unit 31 and a search condition setting unit 32 as shown in FIG. A folder generation unit 33, a search expression generation unit 34, a search unit 35, a search result storage unit 36, an output unit 37, and a search result output unit 38. The folder generation unit 33 corresponds to the “storage area generation procedure” described in the claims, and the search expression generation unit 34 corresponds to the “search expression generation procedure” described in the claims. The unit 35 corresponds to the “search procedure” described in the claims, the search result storage unit 36 corresponds to the “search result storage procedure” described in the claims, and the output unit 37 corresponds to the claim. The search result output unit 38 corresponds to the “search result output procedure” described in the claims.

  The concept parts table creation unit 31 creates a concept parts table. Specifically, the conceptual parts table creation unit 31 outputs a conceptual parts table creation screen to the output unit 12 (monitor), and the new product input by the input unit 11 (from the user using the search device 10). When the conceptual parts table is received, the received conceptual parts table is stored and stored in the conceptual parts table storage unit 21.

  For example, the conceptual parts table creation unit 31 outputs a conceptual parts table creation screen as shown in FIG. 3 to the output unit 12. Here, FIG. 3 illustrates an image in which the conceptual parts table of the new product has already been input by the input unit 11. That is, according to the example of FIG. 3, the part number “AAA-0003” which is a new product is changed by the part numbers “BBB-0001-00” and “BBB-0004-00” which are parts constituting the past product. It can be read that it is possible to develop a new product by diverting information on the part numbers “BBB-0001-00” and “BBB-0004-00”.

  The search condition setting unit 32 sets search conditions for instructing the database. Specifically, the search condition setting unit 32 causes the output unit 12 (monitor) to output a search condition setting screen and sets the search condition input by the input unit 11 (from a user using the search device 10). When accepted, the accepted search condition is stored and stored in the search condition setting storage unit 22.

  For example, the search condition setting unit 32 outputs a search condition setting screen as shown in FIG. 4 to the output unit 12. Here, FIG. 4 illustrates an image in which the setting of the search condition has already been input by the input unit 11. That is, according to the example of FIG. 4, the search apparatus 10 determines that “concept part number” is “concept 1001” for two databases, “part database” and “document management database”. It is possible to read that the situation is that the information stored in the two databases is searched.

  As shown in FIG. 4, when the search condition setting unit 32 uses the attribute information of all the parts included in the concept part of the new product as the search condition, the search condition is not the individual part number but the concept. Can be specified collectively by part number. Further, as shown in FIG. 7, the search condition setting unit 32 stores and stores the input search condition in the search condition setting storage unit 22 so as to be associated with the concept part number.

  The folder generation unit 33 generates a folder for storing search results. Specifically, the folder generation unit 33 generates the folder structure of each folder having the same structure as the hierarchical structure formed by associating the parts with each other and divided for each part. Remember me. Further, the folder generation unit 33 generates a folder as the folder unit 24 based on the folder configuration stored in the folder configuration storage unit 23.

  For example, the folder generation unit 33 generates a folder based on “folder configuration information” as shown in FIG. Here, looking at the “folder configuration information”, the folder created based on the “folder configuration information” has the same structure as the hierarchical structure formed by associating each component, and for each component. It turns out that it is what was divided. In the first embodiment, since it is assumed that the search device 10 searches for information stored in a plurality of databases, folders are further divided for each database. The folder generation unit 33 uses, for example, information stored in the conceptual parts table storage unit 21, so that “folder configuration information” that has the same structure as the hierarchical structure of the new product and is classified for each part. Generate a folder that has the same structure as the hierarchical structure of the new product and is divided for each part.

  In this way, the folder generated by the folder generation unit 33 is generated by being classified for each component, and as described later, the search results are stored in association with each component in the folder. The user who uses the search device 10 is the search result searched by instructing which search condition for the search result stored in the folder unit 24 (for example, by searching for which part is specified) It is possible to determine whether it is a search result. That is, by instructing a plurality of search conditions, even if the search apparatus 10 acquires a plurality of search results, a plurality of search results are not mixedly stored in the storage unit. Even in this case, the user can determine which search condition indicates the search result searched.

  The search expression generation unit 34 generates a search expression (a search expression generated as a command statement that can be instructed to the database regarding the search condition). Specifically, the search expression generation unit 34 acquires information indicating each component forming the hierarchical structure of the new product from the conceptual component table storage unit 21 and the like, and sets each search condition regarding each component indicated by the acquired information. , By sequentially substituting into the search expression generation formula (the fixed-form instruction sentence stored in the search expression generation expression storage unit 25 in advance as a command sentence excluding the substitution of the search condition), The generated search formula is stored in the search formula storage unit 26 and stored.

  For example, the search expression generation unit 34 generates the search expressions at once by sequentially substituting the search conditions into the search expression generation expression as shown in FIG. For example, when the search expression generation unit 34 generates each search expression related to “concept 1001”, which means the entire hierarchical structure of a new product, “Select part number from concept part table database Where (concept part no. . = [Conceptual part number]) ”is assigned to the specified“ concept part number ”by substituting a specific value in the search expression generation formula (1) using“ concept part number ”as a search condition. A search expression for searching the “part number” in the concept parts table database (concept parts table storage unit 21) is generated. Next, the search formula generation formula 34 is concretely set by using “part number” as a search condition in the search formula generation formula (2) of “Select CAD file storage location from parts database Where (part number = actual search key)”. By substituting various values, a search expression for searching the “CAD file storage location” associated with the designated “part number” from the parts database is generated in a batch. The search expression generated in this way is as shown in FIG. 10, and is generated for each database as a command statement that can be instructed to the database.

  The search unit 35 searches information stored in the database. Specifically, the search unit 35 searches the information stored in the database for each component by using each of the search formulas stored in the search formula storage unit 26 for each search condition for each component.

  Moreover, in Example 1, the search part 35 searches the information memorize | stored in the some database for every database by using each search formula for every database.

  The search result storage unit 36 stores the search results in a folder. Specifically, the search result storage unit 36 stores each search result for each component searched by the search unit 35 in association with each folder (folder unit 24) generated by the folder generation unit 33 for each component. And memorize it.

  That is, as described above, since the folder generated by the folder generation unit 33 is generated by being classified for each part, the search result storage unit 36 associates the search result with each folder for each part. By storing, the user who uses the search device 10 indicates which search condition the search result stored in the folder unit 24 indicates by searching (for example, which component is specified) It is possible to determine whether the search result is a search result. That is, by instructing a plurality of search conditions, even if the search apparatus 10 acquires a plurality of search results, a plurality of search results are not mixedly stored in the storage unit. Even in this case, the user can determine which search condition indicates the search result searched.

  It should be noted that the search result storage unit 36 includes, in the search results searched by the search unit 35, search results having the same contents in duplicate even though they are search results for different parts. For one search result among a plurality of duplicate search results, actual information is stored, and for the other search results, reference information (for example, a shortcut) for referring to the actual information is stored. May be. In this case, the search device 10 can reduce the capacity of search results stored in the folder unit 24.

  The output unit 37 outputs a search result display screen. Specifically, the output unit 37 outputs the information indicating each component forming the hierarchical structure to the output unit 12 (monitor) with the same structure as the hierarchical structure as well as being classified for each component.

  For example, the output unit 37 outputs a search result display screen as shown in FIG. Here, FIG. 5 illustrates an image in which the part number “CCC-0001-00” has already been selected as a predetermined part.

  The search result output unit 38 outputs the search result. Specifically, the search result output unit 38 receives the selection of information indicating a predetermined component from the information indicating each component output by the output unit 37 when the input unit 11 receives the selection. The search result of the part is acquired from the folder (folder unit 24), and the acquired search result is output to the output unit 12 (monitor).

  For example, when the part number “CCC-0001-00” is selected as a predetermined part on the search result display screen as shown in FIG. 5, the search result output unit 38 receives the part number “CCC-0001-00”. Or the icons of the “CAD file” folder and the “document file” folder are displayed in the right window as shown in FIG. In the latter case, the search result output unit 38 displays the search result of the CAD file or document file with the part number “CCC-0001-00” by clicking these icons by the user of the search device 10. Display it. The search result is not limited to actual information, but may be information that can refer to the target folder, information that can download the search result, and the like.

[Procedure for Processing by Retrieval Device According to Embodiment 1]
Next, a processing procedure by the search device according to the first embodiment will be described with reference to FIG. FIG. 13 is a flowchart illustrating search processing according to the first embodiment.

  First, the search device 10 according to the first embodiment creates a conceptual parts table in the conceptual parts table creation unit 31 (step S101). Specifically, the conceptual parts table creation unit 31 causes the output part 12 (monitor) to output a conceptual parts table creation screen (see FIG. 3), and the input unit 11 (from the user using the search device 10). When the input concept parts table of the new product (parts that make up past products) is received, the received concept parts table is stored and stored in the concept parts table storage unit 21.

  Next, the search device 10 sets a search condition in the search condition setting unit 32 (step S102). Specifically, the search condition setting unit 32 is triggered by the click of the “search condition setting” icon on the conceptual parts table creation screen (see FIG. 3), for example, as shown in FIG. ) Is output to the output unit 12 (monitor), and the setting of the search condition input by the input unit 11 (from a user using the search device 10) is received, the received search condition is stored in the search condition setting storage unit 22. Store and remember.

  Subsequently, the search device 10 determines whether or not a search instruction has been received (step S103). When the search instruction is received (Yes in step S103), the folder generation unit 33 generates a folder for storing the search results. (Step S104). Specifically, the folder generation unit 33 uses the information stored in the conceptual parts table storage unit 21, so that the “folder” has the same structure as the hierarchical structure of the new product and is divided for each part. Configuration information ”is generated and stored in the folder configuration storage unit 23. Further, the folder generation unit 33 generates a folder as the folder unit 24 based on the “folder configuration information” stored in the folder configuration storage unit 23.

  Then, the search device 10 generates a search formula (a search formula generated as a command statement that can be instructed to the database regarding the search condition) in the search formula generation unit 34 (step S105). Specifically, the search expression generation unit 34 acquires information indicating each part forming the hierarchical structure of the new product from the conceptual parts table storage unit 21 and the like, and sets each search condition related to each part as a search expression generation expression storage unit. By sequentially substituting into the fixed-form command sentence stored in 25, each search expression related to the new product is generated in a lump, and the generated search expression is stored and stored in the search expression storage unit 26.

  Here, the processing in the search formula generation unit 34 will be described in more detail. The search formula generation unit 34 determines whether “concept part number” is instructed as the search condition stored in the search condition setting storage unit 22. Determine whether. When “concept part number” is instructed, the search expression generation unit 34 specifies the “concept part number” in the search expression generation expression (1) stored in the search expression generation expression storage unit 25. By substituting as a correct value, a search expression for searching the “part number” associated with the designated “concept part number” from the concept part table storage unit 21 is generated. Subsequently, the search expression generation unit 34 executes the generated search expression to search for and acquire “part number” associated with “concept part number”, and stores it in the search expression generation expression storage unit 25. The stored location of the information associated with the specified “part number” is stored in the database by assigning a specific value to the stored search expression generation formula (2) using “part number” as the search condition. Generate search expressions to search from all at once.

  On the other hand, when “concept part number” is not instructed, the search expression generation unit 34 searches the search expression generation expression (2) stored in the search expression generation expression storage unit 25 for “part number”. By substituting a specific value as a condition, a search expression for searching the storage location of information associated with the designated “part number” from the database is generated.

  Next, the search device 10 searches the information stored in the database in the search unit 35 (step S106). Specifically, the search unit 35 searches the information stored in the database for each component by using each of the search formulas stored in the search formula storage unit 26 for each search condition for each component.

  Subsequently, the search device 10 stores the search result in a folder in the search result storage unit 36 (step S107). Specifically, the search result storage unit 36 stores each search result for each component searched by the search unit 35 in association with each folder (folder unit 24) generated by the folder generation unit 33 for each component. And memorize it.

  Then, the search device 10 outputs a search result display screen at the output unit 37 (step S108). Specifically, the output unit 37 acquires information indicating each component forming the hierarchical structure of the new product from the conceptual parts table storage unit 21 and the like, and displays information indicating each component forming the hierarchical structure as the hierarchical structure. In addition to having the same structure, each part is divided and output to the output unit 12 (monitor) (see FIG. 5).

  Next, the search device 10 outputs the search result in the search result output unit 38 (steps S109 to S110). Specifically, the search result output unit 38 receives the selection when the input unit 11 receives a selection of information indicating a predetermined component from the search result display screen output by the output unit 37 (Yes in step S109). The search result of the predetermined part is acquired from the folder unit 24, and the acquired search result is output to the output unit 12 (monitor) (step S110).

  For this reason, the search device according to the first embodiment stores each search result for each part in association with each part in each folder. Therefore, which part of the search result stored in the storage unit is selected. Can be discriminated as a search condition.

  In the first embodiment, it is assumed that a process of creating a new conceptual parts table (step S101) and a process of setting search conditions (step S102) are performed before the search process by the search apparatus 10. However, the present invention is not limited to this. For example, when a new concept parts table is created in advance and the search condition is set in advance, the search process by the search device 10 may be started from step S103.

  In the first embodiment, it is determined whether or not the search device 10 has received a search instruction in the step S103. However, the present invention is not limited to this. For example, after the process of creating a new concept parts table (step S101), a process of generating a folder for storing the search result (step S104) may be performed.

  In the first embodiment, the search device 10 stores a search result in a folder and then outputs a search result display screen (step S108) or outputs a search result (step S110). It is not limited to. For example, the search device 10 may only store the search result in a folder and may not output a search result display screen thereafter.

  In other words, in other words, the search device 10 according to the present invention can change, delete, or add processing procedures as appropriate according to the operation mode or the like.

[Effect of Example 1]
As described above, according to the first embodiment, there is provided a search program for causing a computer to execute a search method for searching for information stored in a database by instructing a search condition to the database. A storage area that is the same as the structure formed by associating each of the storage units and that is divided for each structural unit is generated in a storage unit controlled by the computer, and a search condition for each structural unit is stored in a database. By using each of the search formulas generated as instructionable statements, information stored in the database is searched for each structural unit, and each search result for each searched structural unit is configured in each generated storage area. Since it is stored in association with each unit, which search condition is indicated for the search result stored in the storage unit Possible to determine whether the search results searched by allowing.

  For example, in the early stages of new product development, information about past products is often used, but searches are performed on multiple databases (systems) and information stored in multiple databases (systems) is collected. It takes time to do. By creating a conceptual parts table for a new product at the design concept stage, if the parts that make up the past product are used in the new product, its attributes (part number, figure number, name, etc.) Is specified as a search condition for all related databases (systems), so that related information can be automatically collected. In addition, by collecting the collected information in a folder used in a new development project, it becomes possible to develop a new product using information about the design gathered in one place.

  In addition, according to the first embodiment, the database is a plurality of databases, and the search program generates each storage area further divided for each database, and for each database generated as a command statement that can be instructed to the database. By using each search expression, information stored in the database is searched for each database, and each search result searched for each database is stored in association with each generated storage area for each database. Even if the information stored in the database is searched, the search result stored in the database is searched by specifying which search condition for the search result stored in the storage unit. Can be determined.

  Further, according to the first embodiment, when the search program receives an instruction to search collectively for each of the structural units forming the predetermined structure, the search program stores information indicating each of the structural units forming the predetermined structure in advance. Each of the search conditions related to each of the structural units indicated by the acquired information is sequentially substituted into the standard command sentence stored in advance as a command sentence excluding the substitution of the search condition. Thus, each search formula related to a predetermined structure is generated in a lump, and by using each search formula generated in a lump, the information stored in the database is searched in a lump. In addition, the information stored in the database can be easily searched.

  In addition, according to the first embodiment, the search program, when the search results having the same contents are duplicated in each of the searched search results even though the search results are different structural units, In addition to the above-mentioned effects, since substantial information is stored for one search result among a plurality of duplicate search results, reference information for referring to substantial information is stored for the other search results. It is also possible to reduce the capacity of search results stored in the storage unit.

  Further, according to the first embodiment, the search program outputs the information indicating each structural unit forming the structure to the predetermined output unit while being the same structure as the structure and divided into the structural units. When selection of information indicating a predetermined structural unit is received in a predetermined input unit from among the information indicating each output structural unit, a search result of the predetermined structural unit for which the selection has been received is acquired from the storage area and acquired. Since the retrieved result is output to a predetermined output unit, it is possible to easily output the retrieved result in addition to the effects described above.

[Other embodiments]
Although the embodiments of the present invention have been described so far, the present invention may be implemented in various different forms other than the embodiments described above.

[System configuration, etc.]
In the first embodiment, the case where the search device and the database are configured by different devices has been described, but the present invention is not limited to this. The present invention can be similarly applied to a case where the search device and the database are configured by a single device.

  In the first embodiment, the case where the search device searches for information stored in a plurality of databases has been described. However, the present invention is not limited to this. The present invention can be similarly applied to a case where the search device searches for information stored in a single database.

  Further, in the first embodiment, the search device virtually creates a folder as each storage area that has the same structure as the structure formed by associating the structural units with each other and is divided for each structural unit. Although the method has been described, the present invention is not limited to this. For example, the present invention can be similarly applied to a method in which the search device generates a physically partitioned storage area as each partitioned storage area.

  In addition, among the processes described in the present embodiment, all or a part of the processes described as being automatically performed (for example, the process of outputting the search result display screen) can be manually performed ( For example, an icon for inquiring whether or not to output the search result display screen is output to the output unit, and when the user clicks the icon, the search result display screen is output), or manually. It is also possible to automatically perform all or a part of the processing described as a thing (for example, processing for creating a new conceptual parts table) by a known method (for example, a new conceptual parts table created by a different device). By reading, a new conceptual parts table in the search device is stored). In addition, the processing procedure (for example, FIG. 13 etc.), control procedure, specific name, and information including various data and parameters shown in the drawings and drawings are arbitrarily changed unless otherwise specified. be able to.

  Each component of each illustrated apparatus is functionally conceptual, and does not necessarily need to be physically configured as illustrated (for example, FIG. 2). In other words, the specific form of distribution / integration of each device is not limited to that shown in the figure, and all or a part thereof may be functionally or physically distributed or arbitrarily distributed in arbitrary units according to various loads or usage conditions. It can be configured in an integrated manner (for example, various storage units may be configured as a single storage unit by associating them). Further, all or any part of each processing function performed in each device may be realized by a CPU and a program analyzed and executed by the CPU, or may be realized as hardware by wired logic.

[program]
By the way, the various processes described in the first embodiment can be realized by executing a prepared program on a computer such as a personal computer or a workstation. In the following, an example of a computer that executes a search program having the same function as that of the first embodiment will be described with reference to FIG. FIG. 14 is a diagram illustrating a computer that executes a search program.

  As shown in FIG. 14, the computer 40 is configured by connecting a cache 41, a RAM 42, an HDD 43, a ROM 44, and a CPU 45 through a bus 46. Here, the ROM 44 has a search program that exhibits the same function as that of the first embodiment, that is, as shown in FIG. 14, a conceptual parts table creation program 44a, a search condition setting program 44b, and a folder generation program 44c. An expression generation program 44d, a search program 44e, a search result storage program 44f, an output program 44g, and a search result output program 44h are stored in advance.

  Then, the CPU 45 reads out and executes these programs 44a to 44h, so that each program 44a to 44h has a concept parts table creation process 45a, a search condition setting process 45b, and a folder generation process 45c as shown in FIG. A search expression generation process 45d, a search process 45e, a search result storage process 45f, an output process 45g, and a search result output process 45h. Each process 45a to 45h includes the conceptual parts table creation unit 31, the search condition setting unit 32, the folder generation unit 33, the search expression generation unit 34, the search unit 35, the search result storage unit 36, and the output shown in FIG. This corresponds to the unit 37 and the search result output unit 38, respectively.

  Further, as shown in FIG. 14, the HDD 43 is provided with a concept parts table table 43a, a search condition setting table 43b, a folder configuration table 43c, a folder table 43d, a search formula generation formula table 43e, and a search formula table 43f. Each table 43a to 43f includes the conceptual parts table storage unit 21, the search condition storage unit 22, the folder configuration storage unit 23, the folder unit 24, the search formula generation formula storage unit 25, and the search formula storage shown in FIG. Each corresponds to the part 26.

  By the way, the above-mentioned programs 44a to 44h are not necessarily stored in the ROM 44. For example, a flexible disk (FD), a CD-ROM, an MO disk, a DVD disk, and a magneto-optical disk to be inserted into the computer 40. , "Portable physical media" such as IC cards, or "fixed physical media" such as hard disk drives (HDD) provided inside and outside of the computer 40, as well as public lines, the Internet, LAN, WAN, etc. The program may be stored in “another computer (or server)” connected to the computer 40 via the computer 40, and the computer 40 may read and execute the program from these.

(Supplementary Note 1) A search program for causing a computer to execute a search method for searching for information stored in a database by instructing a search condition with respect to the database,
A storage area generation procedure for generating, in the storage unit controlled by the computer, each storage area that is the same structure as the structure formed by associating each of the structural units and is divided for each structural unit;
A search procedure for searching for information stored in the database for each constituent unit by using each of the search formulas generated as command statements that can be instructed to the database for each search condition relating to each of the constituent units;
A search result storage procedure for storing each search result for each of the structural units searched by the search procedure in association with each of the storage units generated by the storage area generating procedure;
A search program characterized by causing a computer to execute.

(Appendix 2) The database is a plurality of databases,
The storage area generation procedure generates each storage area further divided for each database,
The search procedure searches for information stored in the database for each database by using each search expression for each database generated as a command statement that can be instructed to the database,
The search result storage procedure stores each search result searched for each database by the search procedure in association with each database in each storage area generated by the storage area generation procedure. The search program according to appendix 1.

(Supplementary note 3) The storage unit that stores information in advance as information indicating each structural unit forming the predetermined structure when an instruction to collectively search for each structural unit forming the predetermined structure is received By sequentially substituting each search condition for each of the structural units indicated by the acquired information into a standard command sentence stored in advance in the storage unit as a command sentence excluding the substitution of the search condition, Causing the computer to further execute a search expression generation procedure for generating each search expression for a predetermined structure in a batch;
Additional search 1 or 2 characterized in that the search procedure collectively searches for information stored in the database by using each of the search formulas collectively generated by the search formula generation procedure. The listed search program.

(Supplementary Note 4) In the search result storage procedure, there are duplicate search results having the same contents in each of the search results searched by the search procedure, even though the search results are different structural units. In such a case, the actual information is stored for one search result among a plurality of search results existing in duplicate, and the reference information for referring to the actual information is stored for the other search results. The search program according to any one of Supplementary notes 1 to 3, which is characterized.

(Additional remark 5) The output procedure which outputs the information which shows each structural unit which forms the said structure to the predetermined | prescribed output part by classifying for every said structural unit while being the same structure as the said structure,
Among the information indicating each of the structural units output by the output procedure, when selection of information indicating a predetermined structural unit is received at a predetermined input unit, the search result of the predetermined structural unit for which the selection has been received is displayed. A search result output procedure for acquiring from the storage area stored by the search result storage procedure and outputting the acquired search result to a predetermined output unit;
The search program according to any one of appendices 1 to 4, further causing the computer to execute the above.

(Appendix 6) A search method for searching information stored in a database by instructing a search condition to the database,
A storage area generation step of generating each storage area that is the same structure as the structure formed by associating each of the structural units and is divided for each structural unit in a storage unit controlled by the computer;
A search step of searching for information stored in the database for each constituent unit by using each of the search formulas generated as command statements that can be instructed to the database for each search condition relating to each of the constituent units;
A search result storage step of storing each search result for each of the structural units searched by the search step in association with each of the storage units generated by the storage region generating step,
The search method characterized by including.

(Appendix 7) The database is a plurality of databases,
The storage area generation step generates each storage area further divided for each database,
The search step searches for information stored in the database for each database by using each search formula for each database generated as a statement that can be instructed to the database,
The search result storing step stores each search result searched for each of the databases by the search step in association with each database in the storage regions generated by the storage region generating step. The search method according to appendix 6.

(Supplementary Note 8) When receiving an instruction to collectively search for each structural unit forming a predetermined structure, information indicating each structural unit forming the predetermined structure is stored in advance as the storage unit. By sequentially substituting each search condition for each of the structural units indicated by the acquired information into a standard command sentence stored in advance in the storage unit as a command sentence excluding the substitution of the search condition, A search expression generating step for generating each search expression for the predetermined structure in a batch;
Additional search 6 or 7 characterized in that the search step collectively searches information stored in the database by using each of the search formulas collectively generated by the search formula generation step. Search method described.

(Supplementary Note 9) In the search result storing step, search results having the same contents are duplicated in each of the search results searched by the search step even though they are search results of different structural units. In such a case, the actual information is stored for one search result among a plurality of search results existing in duplicate, and the reference information for referring to the actual information is stored for the other search results. The search method according to any one of supplementary notes 6 to 8, which is characterized.

(Additional remark 10) The output process which divides | segments the information which shows each structural unit which forms the said structure into the said structural unit with the said structural unit, and outputs it to a predetermined | prescribed output part,
Of the information indicating each of the structural units output by the output step, when selection of information indicating a predetermined structural unit is received at a predetermined input unit, the search result of the predetermined structural unit for which the selection has been received is displayed. A search result output step of acquiring from the storage area stored by the search result storage step, and outputting the acquired search result to a predetermined output unit;
The search method according to any one of supplementary notes 6 to 9, further comprising:

(Supplementary note 11) A search device for searching information stored in a database by instructing a search condition to the database,
A storage area generating means for generating, in a storage unit controlled by the computer, each storage area having the same structure as the structure formed by associating each of the structural units and being divided for each of the structural units;
Retrieval means for retrieving information stored in the database for each structural unit by using each retrieval formula generated as a command statement that can be instructed to the database for each of the retrieval conditions for each structural unit;
Search result storage means for storing each search result for each structural unit searched by the search means in association with each storage unit generated by the storage area generating means for each structural unit;
A search device comprising:

(Supplementary note 12) The database is a plurality of databases,
The storage area generating means generates each storage area further divided for each database,
The search means searches for information stored in the database for each database by using each search formula for each database generated as a statement that can be instructed to the database,
The search result storing means stores each search result searched for each database by the search means in association with each database in each storage area generated by the storage area generating means. The search device according to appendix 11.

(Supplementary Note 13) When receiving an instruction to collectively search for each structural unit forming a predetermined structure, information indicating each structural unit forming the predetermined structure is stored in advance as the storage unit. By sequentially substituting each search condition for each of the structural units indicated by the acquired information into a standard command sentence stored in advance in the storage unit as a command sentence excluding the substitution of the search condition, It further comprises search expression generation means for collectively generating each search expression related to a predetermined structure,
The search means collectively searches for information stored in the database by using each of the search expressions generated collectively by the search expression generation means. The described search device.

(Additional remark 14) The said search result storage means has duplicate search results of the same content in each of the search results searched by the search means, although they are search results of different structural units. In such a case, the actual information is stored for one search result among a plurality of search results existing in duplicate, and the reference information for referring to the actual information is stored for the other search results. The search device according to any one of supplementary notes 11 to 13, which is characterized.

(Supplementary Note 15) Output means for outputting information indicating each structural unit forming the structure, which is the same structure as the structure, and divided into the structural units, to a predetermined output unit;
Of the information indicating each of the structural units output by the output means, when selection of information indicating a predetermined structural unit is received by a predetermined input unit, the search result of the predetermined structural unit for which the selection has been received is displayed. Search result output means for acquiring from the storage area stored by the search result storage means, and outputting the acquired search results to a predetermined output unit;
The search device according to any one of supplementary notes 11 to 14, further comprising:

  As described above, the search program, the search method, and the search device according to the present invention are useful for searching information stored in a database by instructing a search condition for the database, The search result stored in the section is suitable for discriminating which search condition is instructed by specifying which search condition.

BRIEF DESCRIPTION OF THE DRAWINGS FIG. 1 is a diagram for explaining an overview and features of a search device according to a first embodiment. 1 is a block diagram illustrating a configuration of a search device according to Embodiment 1. FIG. It is a figure for demonstrating a design components table | surface preparation screen. It is a figure for demonstrating a search condition setting screen. It is a figure for demonstrating a search result display screen. It is a figure for demonstrating a concept components table | surface storage part. It is a figure for demonstrating a search condition setting memory | storage part. It is a figure for demonstrating a folder structure memory | storage part. It is a figure for demonstrating a search formula production | generation formula memory | storage part. It is a figure for demonstrating a search expression memory | storage part. It is a figure for demonstrating a components database. It is a figure for demonstrating a document management database. 3 is a flowchart illustrating search processing according to the first exemplary embodiment. It is a figure which shows the computer which performs a search program.

Explanation of symbols

DESCRIPTION OF SYMBOLS 10 Search apparatus 11 Input part 12 Output part 13 Input / output control I / F part 20 Storage part 21 Conceptual parts table storage part 22 Search condition setting storage part 23 Folder structure storage part 24 Folder part 25 Search expression generation expression storage part 26 Search expression Storage unit 30 Control unit 31 Conceptual parts table creation unit 32 Search condition setting unit 33 Folder generation unit 34 Search expression generation unit 35 Search unit 36 Search result storage unit 37 Output unit 38 Search result output unit

Claims (7)

A search program for causing a computer to execute a search method for searching information stored in the database by instructing a search condition for the database,
A storage area generation procedure for generating, in the storage unit controlled by the computer, each storage area that is the same structure as the structure formed by associating each of the structural units and is divided for each structural unit;
A search procedure for searching for information stored in the database for each constituent unit by using each of the search formulas generated as command statements that can be instructed to the database for each search condition relating to each of the constituent units;
A search result storage procedure for storing each search result for each of the structural units searched by the search procedure in association with each of the storage units generated by the storage area generating procedure;
A search program characterized by causing a computer to execute. The database is a plurality of databases,
The storage area generation procedure generates each storage area further divided for each database,
The search procedure searches for information stored in the database for each database by using each search expression for each database generated as a command statement that can be instructed to the database,
The search result storage procedure stores each search result searched for each database by the search procedure in association with each database in each storage area generated by the storage area generation procedure. The search program according to claim 1. When receiving an instruction to collectively search for each structural unit forming a predetermined structure, information indicating each structural unit forming the predetermined structure is acquired from the storage unit that stores the information in advance, By sequentially substituting each search condition for each structural unit indicated by the acquired information into a standard command sentence stored in advance in the storage unit as a command sentence excluding the substitution of the search condition, Let the computer further execute a search expression generation procedure for generating each search expression at once,
The search procedure uses the search formulas collectively generated by the search formula generation procedure to search information stored in the database in a batch. Search program described in.   In the search result storing procedure, in each of the search results searched by the search procedure, when search results having the same contents are duplicated even though they are search results of different structural units, Claim information is stored for one search result among a plurality of search results existing in duplicate, and reference information for referencing the information is stored for the other search results. Item 4. The search program according to any one of Items 1 to 3. Information indicating each of the structural units forming the structure, the output procedure is the same structure as the structure and output to a predetermined output unit divided into the structural units,
Among the information indicating each of the structural units output by the output procedure, when selection of information indicating a predetermined structural unit is received at a predetermined input unit, the search result of the predetermined structural unit for which the selection has been received is displayed. A search result output procedure for acquiring from the storage area stored by the search result storage procedure and outputting the acquired search result to a predetermined output unit;
The search program according to any one of claims 1 to 4, further causing the computer to execute. A search method for searching information stored in a database by instructing a search condition for the database,
A storage area generation step of generating each storage area that is the same structure as the structure formed by associating each of the structural units and is divided for each structural unit in a storage unit controlled by the computer;
A search step of searching for information stored in the database for each constituent unit by using each of the search formulas generated as command statements that can be instructed to the database for each search condition relating to each of the constituent units;
A search result storage step of storing each search result for each of the structural units searched by the search step in association with each of the storage units generated by the storage region generating step,
The search method characterized by including. A search device that searches information stored in a database by instructing a search condition for the database,
A storage area generating means for generating, in a storage unit controlled by the computer, each storage area having the same structure as the structure formed by associating each of the structural units and being divided for each of the structural units;
Retrieval means for retrieving information stored in the database for each structural unit by using each retrieval formula generated as a command statement that can be instructed to the database for each of the retrieval conditions for each structural unit;
Search result storage means for storing each search result for each structural unit searched by the search means in association with each storage unit generated by the storage area generating means for each structural unit;
A search device comprising:

Images