JP2017027131A - Component management system and program - Google Patents

Abstract

PROBLEM TO BE SOLVED: To display a list of component information searched from a component information database along with related information even if a database for storing other related information relating to components exists independently of the component information database for storing component information.SOLUTION: An information transmission/reception part 41 extracts related information registered in component information searched by a component search part 42 from databases 33-27 as a collaborative information database. A display control part 43 performs control so as to display a list of component information searched by the component search part 42 on display parts of terminal devices 21-23 along with a plurality of tabs for switching which related information is included in the list of the component information from among pieces of related information extracted by the information transmission/reception part 41 and is displayed, and includes related information corresponding to a tab selected from among the plurality of tabs in the list of component information searched by the component search part 42 and displays the list.SELECTED DRAWING: Figure 4

Description

  The present invention relates to a parts management system and a program.

  Patent Document 1 stores part information composed of a plurality of items related to parts and data sufficiency indicating the ratio of information in each item for each item. A search support apparatus is disclosed in which a search screen is generated based on the data sufficiency and transmitted to a search terminal.

  Patent Document 2 discloses a hierarchical structure that reads a character string from a specific area of drawing information, acquires a drawing name of the drawing, determines the type of the drawing from the acquired character string, and manages drawing information A hierarchical structure construction apparatus that automatically constructs is disclosed.

JP 2007-072645 A JP2015-007955A

  Within a company that designs, manufactures, and sells products, various types of parts information can be registered, and when necessary, the parts information conditions that are desired can be set and searched to obtain a parts list that meets the conditions. A parts information database is used.

  However, even within the same company, a procurement department that procures parts from a parts company builds a database that mainly stores cost information for each part and information about suppliers, and a manufacturing department uses which parts for which products. There is a case where a database that mainly stores information on whether or not it is stored is constructed. In addition, the quality control department may have built a database mainly using market quality information for each product.

  Since each department built its own database, even if multiple departments use the parts information database in common, when product development designers select parts for new products, cost information, There is a problem that parts cannot be selected in consideration of various information such as market quality information.

  For example, even if such a database is accessible between departments, if a development designer wants to obtain part information by searching the parts information database and know the cost information of that part It is necessary to access the purchasing department database again to obtain cost information of the parts. In addition, in order to know the market defect information of the part, the development designer must access the quality management department database to obtain the quality information about the part.

  In the first place, quality information such as trouble data fed back from the market is information in which trouble type information is associated with the model name and the serial number of the device. However, it is not easy to grasp the transition of the market defect rate before and after the design change of parts from such quality information alone. This is because the serial number of the unit used in the device is checked from the serial number of the device in which the problem occurred, and the introduction information of the design change parts is separately checked, and the relationship between this introduction information and the serial number of the device is determined. This is because it is necessary to grasp.

  Also, if the development designer wants to know cost information and quality information for other parts as well, he / she has to obtain the information he wants to access the purchasing department data and the quality management department database again. In order to select a part with reference to such information, a troublesome work is required.

  An object of the present invention is to provide related information in a list of component information retrieved from the component information database even when there is a database storing other related information related to the components, independent of the component information database storing the component information. It is an object to provide a parts management system and program that can be displayed together.

[Parts management system]
The present invention according to claim 1 is a first receiving means for receiving selection of a component classification that matches a newly registered component from a plurality of preset component classifications;
Second receiving means for receiving input of component information including attribute information and a component number set for the selected component classification;
A component information database for storing component information in which attribute information and a component number are input by the second accepting unit;
Search means for searching for component information that matches a specified condition from the component information stored in the component information database;
One or a plurality of linkage information databases for storing information other than the component information for the component number;
Extraction means for extracting related information registered for the component information searched by the search means from the one or more linkage information databases;
Along with a plurality of tabs for switching which relevant information of the relevant information extracted by the extracting means is to be displayed with respect to the parts information list retrieved by the retrieving means. Display control means for controlling to display,
The display control unit is a component management system that performs control to display a list of component information searched by the search unit including related information corresponding to a tab selected from the plurality of tabs.

The present invention according to claim 2 is a first receiving means for receiving a selection of a component classification that matches a newly registered component from a plurality of preset component classifications;
Second receiving means for receiving input of component information including attribute information and a component number set for the selected component classification;
A component information database for storing component information in which attribute information and a component number are input by the second accepting unit;
Search means for searching for component information that matches a specified condition from the component information stored in the component information database;
One or a plurality of linkage information databases for storing information other than the component information for the component number;
Extraction means for extracting related information registered for the component information searched by the search means from the one or more linkage information databases;
Display control means for controlling to display a list of parts information searched by the search means including related information extracted by the extraction means;
The display control means uses the part information list as a first axis, the part number as a first axis, and one or more attribute items selected from the attribute information or one or more selected from the related information This is a parts management system that performs control such that the item is displayed two-dimensionally as the second axis.

The present invention according to claim 3 is a first receiving means for receiving selection of a component classification that matches a newly registered component from a plurality of preset component classifications;
Second receiving means for receiving input of component information including attribute information and a component number set for the selected component classification;
A component information database for storing component information in which attribute information and a component number are input by the second accepting unit;
Search means for searching for component information that matches a specified condition from the component information stored in the component information database;
One or a plurality of linkage information databases for storing information other than the component information for the component number;
Extraction means for extracting related information registered for the component information searched by the search means from the one or more linkage information databases;
The list of component information searched by the search means is rearranged based on the attribute item selected from the attribute information or the item selected from the related information, or set for the attribute item or item Correction means for narrowing down based on the specified conditions,
A component management system comprising: a display control unit that controls to display a list of component information after being rearranged or narrowed down by the correcting unit, including related information extracted by the extracting unit.

The present invention according to claim 4 is a first receiving means for receiving selection of a component classification that matches a newly registered component from a plurality of preset component classifications;
Second receiving means for receiving input of component information including attribute information and a component number set for the selected component classification;
A component information database for storing component information in which attribute information and a component number are input by the second accepting unit;
Search means for searching for component information that matches a specified condition from the component information stored in the component information database;
A production information database for storing production information consisting of a model number and a serial number of a product in which the part is mounted with respect to the part number;
One or a plurality of linkage information databases for storing information other than the part information and the production information for the part number;
The model number and manufacturing number of the product on which the part specified by the part information searched by the searching means is mounted are extracted from the production information database, and the relationship registered for the extracted model number and manufacturing number. Extraction means for extracting information from the one or more linked information databases;
A component management system comprising: a display control unit that controls to display a list of component information retrieved by the retrieval unit including related information extracted by the extraction unit.

In the present invention according to claim 5, the component classification is two-dimensional by a combination of two classifications: a functional classification that is a classification from a design viewpoint and a construction method, a material, and a shape classification that is a classification from a procurement / manufacturing viewpoint. Is the composite part classification set to
The attribute information includes a plurality of attribute information set for the selected composite part classification and different for each composite part classification, and a common attribute set in common for all parts regardless of the composite part classification. The component management system according to any one of claims 1 to 4, wherein information is present.

[program]
The present invention according to claim 6 is a first reception step for receiving selection of a component classification that matches a newly registered component from a plurality of preset component classifications;
A second accepting step for accepting input of part information including attribute information and part number set for the selected part classification;
A storage step of storing in the component information database the component information in which the attribute information and the component number are input in the second receiving step;
A search step for searching for component information that matches a specified condition from component information stored in the component information database;
An extraction step of extracting related information registered for the component information searched in the search step from one or a plurality of linkage information databases storing other information other than the component information for the component number;
Together with a plurality of tabs for switching which relevant information of the relevant information extracted in the extracting step is displayed with respect to the parts information list retrieved in the retrieving step. A display control step for controlling the display to include and display related information corresponding to the selected tab among the plurality of tabs in the part information list searched in the search step. It is a program.

The present invention according to claim 7 is a first reception step of receiving selection of a component classification that matches a newly registered component from a plurality of preset component classifications;
A second accepting step for accepting input of part information including attribute information and part number set for the selected part classification;
A storage step of storing in the component information database the component information in which the attribute information and the component number are input in the second receiving step;
A search step for searching for component information that matches a specified condition from component information stored in the component information database;
An extraction step of extracting related information registered for the component information searched in the search step from one or a plurality of linkage information databases storing other information other than the component information for the component number;
The part information list searched in the search step is displayed including the related information extracted in the extraction step, and the part information list is displayed with the part number as the first axis, And two-dimensionally displaying one or more attribute items selected from the above or one or more items selected from the related information as a second axis.

The present invention according to claim 8 is a first reception step of receiving selection of a component classification that matches a newly registered component from a plurality of preset component classifications;
A second accepting step for accepting input of part information including attribute information and part number set for the selected part classification;
A storage step of storing in the component information database the component information in which the attribute information and the component number are input in the second receiving step;
A search step for searching for component information that matches a specified condition from component information stored in the component information database;
An extraction step of extracting related information registered for the component information searched in the search step from one or a plurality of linkage information databases storing other information other than the component information for the component number;
The list of component information searched in the search step is rearranged based on the attribute item selected from the attribute information or the item selected from the related information, or set for the attribute item or item Correction steps to narrow down based on specified conditions,
It is a program for causing a computer to execute a display control step for controlling to display a list of parts information after being rearranged or narrowed down in the correction step, including related information extracted in the extraction step.

The present invention according to claim 9 is a first reception step of receiving selection of a component classification that matches a newly registered component from a plurality of preset component classifications;
A second accepting step for accepting input of part information including attribute information and part number set for the selected part classification;
A storage step of storing in the component information database the component information in which the attribute information and the component number are input in the second receiving step;
A search step for searching for component information that matches a specified condition from component information stored in the component information database;
The model number and manufacturing number of the product on which the part specified by the part information searched in the search step is mounted, and the production information including the model number and manufacturing number of the product on which the part is mounted with respect to the part number. Extracted from the production information database to be stored, and related information registered for the extracted model number and manufacturing number, and other information other than the part information and the production information for the part number 1 or An extraction step of extracting from a plurality of linkage information databases;
It is a program for causing a computer to execute a display control step for controlling to display a list of component information searched in the search step including related information extracted in the extraction step.

In the present invention according to claim 10, the component classification is two-dimensional by combining a functional classification that is a classification from a design viewpoint and a construction method / material / shape classification that is a classification from a procurement / manufacturing viewpoint. Is the composite part classification set to
The attribute information includes a plurality of attribute information set for the selected composite part classification and different for each composite part classification, and a common attribute set in common for all parts regardless of the composite part classification. The program according to any one of claims 6 to 9, wherein information is present.

  According to the first aspect of the present invention, a component searched from the component information database even when there is a linkage information database storing other related information about the component, independent of the component information database storing the component information. It is possible to obtain an effect that it is possible to display the information list including related information. Furthermore, according to the first aspect of the present invention, by selecting a tab, it is possible to switch whether to display the associated information from which linked information database is displayed in the parts information list obtained by the search. The effect of becoming can be obtained.

  According to the second aspect of the present invention, a component searched from the component information database even when there is a linkage information database storing other related information about the component, independent of the component information database storing the component information. It is possible to obtain an effect that it is possible to display the information list including related information. Furthermore, according to the second aspect of the present invention, it is possible to obtain an effect that it is possible to easily grasp the presence or absence of parts having the same specification.

  According to the third aspect of the present invention, a component searched from the component information database even when there is a linkage information database storing other related information about the component, independent of the component information database storing the component information. It is possible to obtain an effect that it is possible to display the information list including related information. Furthermore, according to the third aspect of the present invention, it is possible to obtain an effect that it is possible to specify and standardize parts having similar attributes from the list of parts obtained by the search.

  According to the fourth aspect of the present invention, a component searched from the component information database even when there is a linkage information database storing other related information about the component, independent of the component information database storing the component information. It is possible to obtain an effect that it is possible to display the information list including related information. Furthermore, according to the present invention according to claim 4, the market before and after the design change of the parts can be obtained by linking the production information database, the parts information database, and the quality information database using the product model number and the manufacturing number as a key. It becomes possible to compare defect occurrence rates and the like.

  According to the present invention according to claim 5, in addition to the effects obtained by the invention according to any one of claims 1 to 4, the development design department and the procurement / manufacturing department (environmental management department / quality department / cost management) The number of attribute items that need to be registered for each part can be reduced compared to setting the same attribute item for all parts. A parts management system can be provided.

  According to the sixth aspect of the present invention, a component searched from the component information database even when there is a linkage information database storing other related information about the component, independent of the component information database storing the component information. It is possible to obtain an effect that it is possible to display the information list including related information. Furthermore, according to the present invention according to claim 6, by selecting a tab, it is possible to switch the display of the part information obtained by the search including the related information from which linked information database. The effect of becoming can be obtained.

  According to the seventh aspect of the present invention, a component searched from the component information database even when there is a linkage information database storing other related information about the component, independent of the component information database storing the component information. It is possible to obtain an effect that it is possible to display the information list including related information. Furthermore, according to the seventh aspect of the present invention, it is possible to obtain an effect that it is possible to easily grasp the presence or absence of parts having the same specification.

  According to the eighth aspect of the present invention, a component searched from the component information database even when there is a linkage information database storing other related information about the component, independent of the component information database storing the component information. It is possible to obtain an effect that it is possible to display the information list including related information. Furthermore, according to the present invention according to claim 8, it is possible to obtain an effect that it is possible to specify and standardize parts having similar attributes from the list of parts obtained by the search.

  According to the ninth aspect of the present invention, a component searched from the component information database even when there is a linkage information database storing other related information about the component, independent of the component information database storing the component information. It is possible to obtain an effect that it is possible to display the information list including related information. Furthermore, according to the present invention of claim 9, the market before and after the design change of the parts can be obtained by linking the production information database, the parts information database, and the quality information database using the product model number and the manufacturing number as a key. It becomes possible to compare defect occurrence rates and the like.

  According to the tenth aspect of the present invention, in addition to the effects obtained by the invention according to any one of the sixth to ninth aspects, the development design department and the procurement / manufacturing department (environmental management department / quality department / cost management) The number of attribute items that need to be registered for each part can be reduced compared to setting the same attribute item for all parts. A program can be provided.

1 is a diagram illustrating a configuration of an entire system including a component management system 10 according to a first embodiment of the present invention. It is a figure for demonstrating a mode that the components information database 32 and the other databases 33-37 cooperate. It is a figure which shows the hardware constitutions of the management server 31 in the components management system 10 of the 1st Embodiment of this invention. It is a block diagram which shows the function structure of the management server 31 in the components management system 10 of the 1st Embodiment of this invention. It is a figure which shows an example of the production information stored in the production information database 37. It is a figure which shows an example of the drawing data stored in the drawing database. It is a figure which shows the example of a screen displayed when a development designer operates the terminal device 21, specifies "bearing" as a component classification, and searches the components information database 32. FIG. It is a figure which shows the example of a screen when a component with an inner diameter of "6.0", an outer diameter of "10.0", the presence or absence of grease is "present", and the number of balls is "8" is selected as a reference component. FIG. 8 is a diagram illustrating a screen example when a drawing thumbnail image is selected in the screen example illustrated in FIG. 7. It is a figure which shows the example of a screen of the components information list at the time of selecting the tab called "cost information." It is a figure which shows the example of a screen at the time of rearranging a parts information list in order with a low purchase price. It is a figure which shows the example of a screen at the time of carrying out two-dimensional display by making a part number into a 1st axis | shaft and using the "inner diameter" selected from attribute information and "the presence of grease" as a 2nd axis | shaft. It is a figure which shows the outline of the mode of cooperation between each department in the general company which develops, designs, and sells a product. It is a figure for demonstrating the specific example of a composite component classification | category. It is a figure which shows an example of the registration frame frame displayed when the composite component classification | category called "molding cover" is selected. It is a figure which shows an example of a mode at the time of inputting attribute information sequentially with respect to the registration frame frame shown in FIG. It is a figure which shows an example of the registration frame frame displayed when the composite part classification | category of "sheet metal cover" is selected. It is a figure which shows an example of the registration frame frame displayed when the composite part classification | category called "press gear" is selected. It is a figure which shows an example of the component information in which different attribute information was registered for every composite component classification. It is a figure which shows the comparative example at the time of just increasing an attribute item, without setting a different attribute item for every composite component classification | category.

  Next, embodiments of the present invention will be described in detail with reference to the drawings.

[First embodiment]
FIG. 1 is a diagram showing a configuration of the entire system including a component management system 10 according to the first embodiment of the present invention.

  As shown in FIG. 1, the component management system 10 according to the first exemplary embodiment of the present invention is configured to be connected to terminal devices 21 to 23 via a network 30. Here, the terminal devices 21 to 23 are installed in a development design department, a procurement department, and a manufacturing department, respectively. In this embodiment, in order to simplify the description, it is assumed that only three terminal devices 21 to 23 are connected to the component management system 10. However, in reality, a large number of terminal devices are managed as components. It is possible to connect to the system 10.

  The parts management system 10 includes a management server 31, a parts information database 32, a drawing database 33, a purchase information database 34, an environment information database 35, a quality information database 36, and a production information database 37. ing.

The component information database 32 stores component information including component numbers and attribute information of various components. The drawing database 33 stores drawing images of parts as drawing data. The purchase information database 34 stores purchase information such as the unit purchase price, purchase quantity, and information on the purchase destination. The environmental information database 35 stores various environmental information such as CO ₂ (carbon dioxide) emissions for each part. The quality information database 36 stores quality information such as the market failure rate for each part or product. The production information database 37 stores various production information such as the number of products produced for each model, production date, serial number (manufacturing number), production location, or part information used by each model.

  The terminal devices 21 to 23 can access the management server 31 and browse drawing data stored in the drawing database 33 or search for component information stored in the component information database 32. It has become. In the component management system of this embodiment, the component information database 32, the drawing database 33, the purchase information database 34, the environment information database 35, the quality information database 36, and the production information database 37 are linked together, so that only the component search is performed. It is possible to grasp various information such as cost information, environmental information, quality information, and the like of the searched parts.

  Therefore, according to the component management system of the present embodiment, the opening designer who develops and designs a new model, when selecting a component to be used for the new model, such as the technical specifications and characteristics of each component It is possible to obtain not only information but also various information such as cost, market quality, purchase quantity, and environmental load.

  That is, in the parts management system of the present embodiment, as shown in FIG. 2, the parts information database 32 is used as a hub information database, the drawing database 33, the purchase information database 34, the environment information database 35, the quality information database 36, and the production information. By linking with a local information database (cooperation information database) such as the database 37, various information can be obtained in the part search.

  Next, FIG. 3 shows a hardware configuration of the management server 31 in the component management system 10 of the present embodiment.

  As shown in FIG. 3, the management server 31 includes a CPU 11, a memory 12, a storage device 13 such as a hard disk drive (HDD), a user interface (UI) device 14, and a parts information database 32 and various databases 33 via a network 30. 37, and a communication interface (IF) 15 that transmits and receives data to and from external devices such as the terminal devices 21 to 23. These components are connected to each other via a control bus 16.

  The CPU 11 controls the operation of the management server 31 by executing predetermined processing based on a control program stored in the memory 12 or the storage device 13. In the present embodiment, the CPU 11 has been described as reading and executing a control program stored in the memory 12 or the storage device 13, but the program is stored in a storage medium such as a CD-ROM and stored in the CPU 11. It is also possible to provide.

  FIG. 4 is a block diagram showing a functional configuration of the management server 31 realized by executing the control program.

  As shown in FIG. 4, the management server 31 of this embodiment includes an information transmission / reception unit 41, a component search unit 42, and a display control unit 43.

  The information transmitting / receiving unit 41 receives a selection of a component classification that matches a newly registered component from a plurality of preset component classifications (first reception unit).

  Then, the information transmitting / receiving unit 41 receives input of component information including attribute information and a component number set for the selected component classification (second receiving unit).

  The component information database 32 stores the component information in which the attribute information and the component number are input by the information transmitting / receiving unit 41.

  The component search unit 42 searches the component information stored in the component information database 32 for component information that matches the search conditions specified by the terminal devices 21 to 23 via the information transmission / reception unit 41.

  The display control unit 43 performs control such that the component information list searched by the component search unit 42 is displayed on the display unit of the terminal device instructed to search among the terminal devices 21 to 23.

  The local information databases such as the drawing database 33, the purchase information database 34, the environment information database 35, the quality information database 36, and the production information database 37 are linked information databases that store information other than the part information for the part numbers. .

  And the information transmission / reception part 41 extracts the relevant information registered with respect to the component information searched by the part search part 42 from the databases 33-37 which are cooperation information databases (extraction means).

  Then, the display control unit 43 displays the list of component information searched by the component search unit 42 including any related information of the related information extracted by the information transmitting / receiving unit 41 with respect to the list of component information. It controls to display on the display part of the terminal devices 21-23 with several tabs for switching whether to do.

  The display control unit 43 performs control such that the component information list searched by the component search unit 42 is displayed including related information corresponding to the selected tab among the plurality of tabs.

  In addition, the display control unit 43 uses the part number as the first axis in the part information list, and the one or more attribute items selected from the attribute information or the related information selected from the attribute information. Control is performed so that the item is two-dimensionally displayed as the second axis.

  Further, the information transmitting / receiving unit 41 rearranges the list of component information searched by the component search unit 42 based on the attribute item selected from the attribute information or the item selected from the related information. Alternatively, a function for performing a process of narrowing down based on the condition set for the item is provided (correcting means).

  And the display control part 43 controls the display part of the terminal devices 21-23 so that the list of the component information after being rearranged or narrowed down by the information transmission / reception part 41 may be displayed including the extracted related information.

  The production information database 37 stores production information including a model number and a serial number (manufacturing number) of a product on which the part is mounted with respect to the part number. An example of production information stored in the production information database 37 is shown in FIG.

  According to the production information shown in FIG. 5, for example, a product with a serial number of the model name “C7788” having a serial number of 100001 to 10056 uses a part “123A044251A”, and the serial number is 1005717 to 102145. It can be seen that the product after the design change of “123A044251B” is used in the product No. 1).

  Therefore, not only the part information database 32 and the cooperation information database such as the other databases 33 to 37 are linked using the part number as a key, but also the production information such as the product model number and the manufacturing number is used as a key. It is also possible.

  By doing so, the information transmitting / receiving unit 41 extracts the model number and the manufacturing number of the product on which the part specified by the part information searched by the part searching unit 42 is mounted from the production information database 37 and is extracted. The quality information registered for the model number and the production number can be extracted from the quality information database 36.

  If the display control unit 43 controls to display the extracted quality information in the component information list retrieved by the component retrieval unit 42, the market defect rate of the product on which the component is mounted is displayed. Etc. can be grasped.

  Next, specific operations in the component management system 10 of this embodiment will be described with reference to the drawings.

  First, an example of drawing data stored in the drawing database 33 is shown in FIG. The drawing data shown in FIG. 6 is a drawing example of “bearings”, and various types of characteristic information and the like are configured as image information together with the external shape of the component.

  In the following description, the operation of the component management system of the present embodiment will be described based on an operation when a development designer selects a bearing to be mounted on a new model.

  For example, FIG. 7 shows an example of a screen displayed when the development designer operates the terminal device 21 to search the parts information database 32 by designating “bearing” as the part classification.

  The screen example shown in FIG. 7 shows a case where the component classification is divided into a major classification, a middle classification, and a minor classification. Here, a case is shown in which “mechanical parts” is designated as the major classification, “bearings” as the middle classification, and “ball bearings” as the minor classification.

  When a part in the retrieved parts list is selected, a drawing image of the selected part is displayed as a thumbnail image.

  In this screen example, search conditions can be further added. By selecting a search item and entering the search condition, the parts list can be narrowed down based on the input search condition. Can be done. For example, by specifying “Manufacturer name” as a search item, inputting “XXX industry” as a search condition, and operating the search button, parts registered with “XXX industry” as a manufacturer name Only can be extracted.

  Furthermore, in order to cooperate with other information databases such as the drawing database 33 to the production information database 37, the information (common information at the time of data cooperation) is designated and the data transfer button 71 is operated. The information corresponding to the parts list searched by is extracted from another information database.

  In the example shown in FIG. 7, the part number is specified as information that is a key for cooperation. In general, since component information is managed by a component number, the component number is selected as information serving as a key for cooperation.

  Here, when a part in the screen example shown in FIG. 7 is selected as a reference part, as shown in FIG. 8, the attribute information items that are the same as the reference part are displayed in a different color from the other items. It has become so.

  In the screen example shown in FIG. 8, the part having the inner diameter “6.0”, the outer diameter “10.0”, the presence / absence of grease “present”, and the number of balls “8” is selected as the reference part. In the attribute item of the part, the color of the “6.0” portion changes for the inner diameter, the color of the “10.0” portion changes for the outer diameter, and the color of the “present” portion indicates whether there is grease. It can be seen that the color of the portion “8” is changed with respect to the number of balls.

  In this way, it is possible to easily grasp which part is close to the specification of the reference part or which has the same specification.

  FIG. 9 shows an example of a screen when a drawing thumbnail image is selected in the example of the screen shown in FIG. In the example of the screen shown in FIG. 9, it can be seen that the drawing data corresponding to the thumbnail image is captured from the drawing database 33 and displayed in a large size.

  In this way, a development designer who wants to know the details of a drawing can view the drawing data simply by clicking a thumbnail image.

  Further, for example, when it is desired to know cost information such as the purchase price of each part in the part information list obtained by the search, the operator selects a tab “cost information” as shown in FIG. It is possible to view a parts information list in which cost information “purchase price” is added to the parts information.

  Also, as shown in FIG. 11, when a part with a low purchase price is preferentially selected, etc., by selecting this “purchase price” item and instructing sorting (descending or ascending order), Then, it is possible to see the result of rearranging the obtained list in the order of low price (or high order).

  In the example of the screen shown in FIG. 11, a case is shown in which the parts information list is rearranged in order from the lowest purchase price.

  Furthermore, the obtained part information list is displayed in two dimensions (matrix display) with the part number as the first axis and the “inner diameter” and “grease presence” selected from the attribute information as the second axis. An example of the screen is shown in FIG.

  In the screen shown in FIG. 12, the parts are rearranged for each part having the same specification, and the black circles are displayed in the vertical direction for the parts having the same specification. Therefore, the operator can easily grasp which part and which part have the same specification, and can easily know the presence or absence of a part having the same specification as a certain part.

  That is, according to the component management system of the present embodiment, it is possible to geometrically recognize the presence / absence of a component with the same specification and the diffusion state of the component with similar specifications in a certain component classification. For example, when the first axis of the part number is the Y axis and the second axis of the attribute information of the part is the X axis, and a black circle mark is placed at the intersection corresponding to the X axis and the Y axis on the two-dimensional display screen When the black circle marks are arranged in a straight line in the Y-axis direction, it can be determined that there is a possibility that parts having the same specification are registered in duplicate. Further, when the black circle marks are lined up in the vicinity in the Y-axis direction, it can be determined that there is a possibility that many parts having similar specifications are registered.

[Second Embodiment]
Next, a component management system according to a second embodiment of the present invention will be described.

  Since the basic configuration of the component management system according to the present embodiment is the same as that of the component management system 10 according to the first embodiment illustrated in FIG.

  The parts management system according to the second embodiment of the present invention is a combination of two classifications: a functional classification in which the parts classification is a classification from a design viewpoint, and a construction method / material / shape classification in which a classification is from a procurement / manufacturing viewpoint. This is a composite part classification set two-dimensionally according to the attribute information. The attribute information includes a plurality of attribute information that is set for the selected composite part classification and is different for each composite part classification, and regardless of the composite part classification. It differs from the component management system of the first embodiment described above in that common attribute information that is set in common for components also exists.

  The parts information database 32 in the present embodiment is set two-dimensionally by a combination of two classifications, that is, a functional classification that is a classification from a design viewpoint and a construction method, material, and shape classification that is a classification from a procurement / manufacturing viewpoint. A plurality of component information including different attribute information for each of a plurality of composite component categories, common attribute information set in common for all components regardless of the composite component category, and a component number are stored. Details of the component information database 32 will be described later.

  A parts database in which various attribute information of parts is registered is used by various departments in the company. Therefore, the attribute information desired to be registered for each part is different for each department.

  For example, the development and design department desires a parts database that can obtain information such as whether parts for achieving a required function already exist by classifying parts by function.

  On the other hand, procurement departments such as purchasing departments, manufacturing departments, etc. can select suppliers by using the parts database classified by material and processing method rather than functional classification of parts. I hope. This is because in procurement departments such as purchasing departments, sheet metal parts are ordered from sheet metal parts manufacturers, and resin parts are ordered from resin parts manufacturers, so what is the function of the parts? This is because it is necessary to use such materials and processing methods.

  Therefore, the required specifications differ between the parts database required in the development and design department and the parts database required in the procurement department, manufacturing department, etc., and there are cases where separate databases are constructed and operated.

  However, when trying to reduce the cost of products by reducing the cost of parts, if the parts database of the development and design department is not linked with the parts database of the procurement department, manufacturing department, etc. There is a problem that the development and design department cannot grasp where it is procured from.

  For this reason, when building a database that can be used in common by the development and design department, procurement department, manufacturing department, etc. and that can obtain the necessary information, the number of attribute items to be registered in each part There is a problem that will increase.

  In addition, when selecting parts with the desired specifications from the parts that have already been assigned part numbers, or when trying to reduce the part unit price by integrating parts with similar specifications, the part number Part specifications must be registered.

  However, the attribute items expressing the characteristics of the part differ for each type of part. For example, motors, bearings, and resin parts have completely different attribute items for expressing the characteristics of the parts. For this reason, when the necessary attribute items can be registered for each part number, the number of attribute items becomes enormous as the number of parts increases, making it impossible to use them practically. Therefore, there is a limitation that only common attribute information such as the weight, dimensions, ordering party, and material quality of each part can be registered.

  In order to extract and link attribute items from an enormous number of drawings, it is conceivable to classify each part. Because it is possible to determine the attribute items to be registered for each classification type if the parts are classified, it is easy to determine which attribute information is selected and registered among the attribute items described in the drawing. Because it can. However, this “classification” has been performed as “functional classification” in the design department and “material processing classification” in the procurement / manufacturing department.

  For these reasons, even if you try to build a parts database that can be used in common by procurement departments, manufacturing departments, and development and design departments and that can register the required attribute information for each part, The number of attribute items that need to be registered becomes enormous and exceeds the practically usable range, making it difficult or impossible to use.

  For this reason, this embodiment can be used in common by the development and design department and procurement / manufacturing department (environmental management department, quality department, cost management department, etc.) and must be registered for each part. An object of the present invention is to realize a component management system that can reduce the number of attribute items compared to the case where the same attribute item is set for all components.

  Next, the component management system of this embodiment will be described with reference to FIG. In the following description, only parts different from the component management system of the first embodiment described above will be described.

  The information transmission / reception unit 41 according to the present embodiment is set in a two-dimensional manner by a combination of a function classification that is a classification based on a design viewpoint and a construction method / material / shape classification that is a classification based on a procurement / manufacturing viewpoint. A selection of a composite part classification that matches a newly registered part is received from a plurality of composite part classifications.

  The information transmission / reception unit 41 according to the present embodiment is set for the selected composite part classification, and is set for each part regardless of the composite part classification, a plurality of attribute information different for each composite part classification. The input of the component information including the common attribute information and the component number is received.

  The component information database 32 stores component information that is received by the information transmitting / receiving unit 41 and in which different attribute information is set for each composite component classification.

  More specifically, as described above, the parts information database 32 in the parts management system 10 of the present embodiment is a function classification that is a classification from a design viewpoint and a construction method that is a classification from a procurement / manufacturing viewpoint. -Different attribute information for each of multiple composite part classifications that are set two-dimensionally by the combination of the two classifications of material and shape classification, and common attributes that are commonly set for all parts regardless of the composite part classification A plurality of pieces of component information including information and a component number are stored.

  The reason why different attribute information is set for each composite component classification in the component information stored in the component information database 32 will be described.

  First, FIG. 13 shows an outline of the cooperation between departments in a general company that develops, designs, and sells products.

  Each division of product planning, development, design, procurement, manufacturing, sales, maintenance, etc. in a so-called manufacturer has two axes when classified according to the flow of business execution. One of them is the engineering axis by the departments such as planning, development design, production preparation, production technology, and the other is the departments such as procurement / purchasing, manufacturing, shipping, sales, sales planning, production planning, maintenance, etc. Is the supply chain axis.

  Each of these departments has a different classification method for classifying components when performing component management.

  Specifically, in the engineering axis departments such as planning, development design, production preparation, production technology, etc., it is necessary to manage parts by function classification, which is classification from a design viewpoint. In addition, in the supply chain axis departments such as procurement / purchasing, manufacturing, shipping, sales, sales planning, production planning, maintenance, etc., parts are managed according to the method of construction / material / shape classification, which is a classification from a procurement / manufacturing perspective. There is a need.

  Therefore, in the component management system 10 of the present embodiment, the component information is 2 by a combination of two classifications, that is, a functional classification that is a classification based on a design viewpoint and a construction method / material / shape classification that is a classification based on a procurement and manufacturing viewpoint. Different attribute information can be set for each of a plurality of composite component categories set in a dimensional matrix.

  Next, a specific example of this composite part classification will be described with reference to FIG.

  In the specific example shown in FIG. 14, the classifications of bearings, gears / gears, covers / chutes, and frames are shown as function classifications that are classifications based on design viewpoints (development / design departmental viewpoints). In the specific example shown in FIG. 14, metal cutting / grinding parts, sheet metal / press parts, powder metallurgy parts are classified as construction methods / materials / shape classifications, which are classifications from the viewpoint of procurement and manufacturing (from the viewpoint of procurement and manufacturing departments). Classifications such as resin injection molded parts and resin blow molded parts are shown.

  And as a composite part classification, the above two functional classifications, construction methods / materials / shape classifications are combined two-dimensionally (biaxial), such as ball bearings, cutting frames, press gears, sheet metal covers, sheet metal frames, etc. Classification is shown.

  For example, the composite part classification “ball bearing” is a part classification included in both of the functional classification “bearing” and the construction / material / shape classification “metal cutting / grinding part”.

  In the component management system 10 of this embodiment, different attribute items can be registered for each composite component classification such as “ball bearing”, “cutting frame”, and “press gear”.

  Therefore, when trying to register the part information of a new part in the part information database 32, the user (user) who wants to register the part selects one composite part classification from the plurality of composite part classifications. To do.

  For example, when the composite part classification “molded cover” is selected, a registration frame frame as shown in FIG. 15 is displayed as a registration frame frame for registering part information.

  In the registration frame frame shown in FIG. 15, since the selected composite part classification is “molded cover”, the classification name is “cover” as the function classification and “resin (injection molding)” as the method / material / shape classification. Is already registered.

  And in the registration frame frame of the composite part classification “molding cover” shown in FIG. 15, the items “maximum plate thickness”, “projection area”, “molding pressure”, and “mold clamping force” are attribute items. Is set.

  Therefore, as shown in FIG. 16, the user can make a part number, part name, manufacturer information, weight, XYZ (vertical, horizontal, height) dimensions, maximum plate thickness, projected area, molding for this registered frame frame. Attribute information such as pressure and mold clamping force can be sequentially input and registered as part information.

  FIG. 17 shows an example of a registration frame frame displayed when “Sheet metal cover” is selected in the composite part classification shown in FIG.

  In the example shown in FIG. 17, since the selected composite component classification is “sheet metal cover”, the classification name “cover” as the function classification and “sheet metal / press” as the method / material / shape classification has already been registered. It has become.

  In the registered frame of the composite part classification “sheet metal cover” shown in FIG. 17, the attribute items are “sheet thickness”, “development dimension”, “preston number”, “type type (single / progressive)”. "," Number of stages ", and" Number of holes "are set.

  Further, FIG. 18 shows an example of a registration frame frame displayed when “press gear” is selected in the composite part classification shown in FIG.

  In the example shown in FIG. 18, since the selected composite part classification is “press gear”, the classification name “gear” as the function classification and “sheet metal / press” as the construction method / material / shape classification has already been registered. It has become.

  In the registration frame frame of the composite part classification “press gear” shown in FIG. 18, the attribute items are “number of steps”, “number of teeth”, “outside diameter φ”, “inside diameter φ”, “tooth width”, “ The item “Tooth profile error” is set.

  FIG. 19 shows an example of component information in which different attribute information is registered for each composite component classification.

  As can be seen from FIG. 19, even if the function classification is the same, if the construction method / material / shape classification is different, different attribute items may be set, and if the construction method / material / shape classification is the same, the function classification is different. Different attribute items may be set.

  For example, even if the function classification is “Cover”, the attribute item of the part information differs depending on whether the construction method / material / shape classification is “resin (injection molding)” or “sheet metal / press”. 15, see FIG. Further, for example, even if the construction method / material / shape classification is “sheet metal / press”, the attribute item of the component information differs depending on whether the function classification is “cover” or “gear” (FIG. 17, (See FIG. 18).

  For parts that do not have or cannot be classified, such as “solenoid”, “fan motor”, and “functional members special to the company”, different attribute information can be registered for each function category. It has become.

  For example, in the case of a three-layer roll having a shaft, it is registered as a paper feed roll, and attribute information of the shaft and rubber is registered. This is because it is clear that the “paper feed roll” is stably fixed with a combination of a metal shaft and a rubber roll and a manufacturing method in a time span of 10 to 20 years.

  Moreover, when using it combining a molding resin roll with a metal shaft, it registers as an independent terminal component, respectively.

  Furthermore, in a special case such as a case where a molded resin roll is integrally formed on a metal shaft, it is possible to cope by providing a plurality of material classifications.

  For example, in a material in which EPDM rubber (ethylene / propylene / diene / rubber) is bonded and fixed around a metal shaft and urethane resin is laminated on the surface layer, this roll is a specific functional member that has been conventionally recognized, such as a charging roll. If so, it is registered as one classification by its function name, not by the category of the composite classification. And if it is a component whose function is not recognized and cannot be specified, it can be applied to a composite classification such as a rubber roll, and a method of registering a shaft material and two kinds of organic materials to be laminated as attributes is also possible. If the method, material, and shape classification are not simply rubber, but they are classified into single layer rubber and laminated rubber, they can be registered in the classification such as laminated rubber roll. In any of these classification methods, the number of attributes for classification increases with the number of material types, but it can be significantly reduced compared to the number of general functional classification attributes such as rolls. The difficulty of extracting information from drawings and the like is greatly reduced.

  In the parts management system 10 of the present embodiment, a large number of parts to be managed are classified into two categories: functional classification, which is a classification from a design viewpoint, and construction method, material, and shape classification, which is a classification from a procurement / manufacturing viewpoint. Classification is performed by composite part classification set two-dimensionally by combination. For this reason, the parts management system 10 of this embodiment can be used in common in both the development design department and the procurement / manufacturing department (environmental management department, quality department, cost management department, etc.) and unified throughout the company. It is possible to perform the managed parts.

  In the component management system 10 of the present embodiment, different component information can be registered in each component for each composite component classification. Therefore, the number of attribute items that need to be registered for each component is set. Various specifications and the like of each component can be registered in the component information while keeping the number practically usable.

  In addition, the component composition table created by the classification required for the design department in the past and utilized in the design department, and the component composition table that has been constructed and utilized for each department for each procurement and manufacturing department Since the classifications can be combined with few corrections by the composite classification, there is also an advantage that the departmental asset called the component composition table constructed for each department can be effectively utilized continuously as the company-wide asset.

  For example, FIG. 20 shows a comparative example in which attribute items are simply increased without setting different attribute items for each composite part classification.

  The comparative example shown in FIG. 20 shows a case where the number of registerable attribute items is increased regardless of the type of component. In the example shown in FIG. 25, since attribute items that are not necessary for the part are set, it is difficult to understand which attribute item should be used to register attribute information for the part. It can be seen that is difficult to use.

  Specifically, in the example shown in FIG. 20, an example of registering “resin cover” as a part is shown, and “maximum plate thickness”, “projected area”, “molding pressure” are attribute items. In this example, the attribute information is registered in the item “mold clamping force”. However, it is difficult for the user to know which attribute item the attribute information should be registered.

  On the other hand, the component management system 10 according to the present embodiment prepares a registration frame frame as shown in FIG. 15 just by selecting the category “molded cover” as the composite component category, so that the user Can easily grasp to which attribute item the attribute information should be registered.

  And according to the parts management system 10 of this embodiment, it becomes possible to perform parts management common to all departments without individual parts management between each department, and to build a parts database unified throughout the company. Is possible. Therefore, by using the component management system 10 of the present embodiment, it is possible to effectively promote the cost reduction of the product and contribute to the reduction of the total cost.

  Specifically, by using the component management system 10 according to the present embodiment, it is possible to prevent the generation of a one-part multi-part number in which a plurality of part numbers are set for one part, thereby achieving an appropriate part price. Realization is possible.

  In addition, according to the component management system 10 of the present embodiment, it becomes easy to compare the specification and unit price of the component, so that it is possible to find a component whose price setting is higher than usual, and it is easy to realize an appropriate component price. become.

  In addition, according to the component management system 10 of the present embodiment, components having similar specifications can be easily grasped, and the component types can be reduced by standardizing components, or components having similar attributes can be compared. Therefore, it becomes possible to perform cost-effective component selection.

  Furthermore, by using the parts management system 10 of this embodiment, it becomes possible to know what parts are purchased from what suppliers and how much, and it is easy to grasp the purchase results and the procurement status. It becomes possible to grasp.

  Although not described in the present embodiment, it is possible to link the drawing management system that manages the drawing data of the component part surface with the component management system 10 of the present embodiment. As described above, by linking the drawing management system and the component management system 10, the attribute information can be directly input from the drawing data, and the user can easily view the drawing data of the searched component.

10 parts management system 11 CPU
12 Memory 13 Storage Device 14 User Interface (UI) Device 15 Communication Interface (IF)
16 Control bus 21-23 Terminal device 30 Network 31 Management server 32 Parts information database 33 Drawing database 34 Purchasing information database 35 Environmental information database 36 Quality information database 37 Production information database 41 Information transmission / reception part 42 Parts search part 43 Display control part 71 Data Transfer button

Claims (10)

A first receiving means for receiving selection of a part classification that matches a newly registered part from a plurality of preset part classifications;
Second receiving means for receiving input of component information including attribute information and a component number set for the selected component classification;
A component information database for storing component information in which attribute information and a component number are input by the second accepting unit;
Search means for searching for component information that matches a specified condition from the component information stored in the component information database;
One or a plurality of linkage information databases for storing information other than the component information for the component number;
Extraction means for extracting related information registered for the component information searched by the search means from the one or more linkage information databases;
Along with a plurality of tabs for switching which relevant information of the relevant information extracted by the extracting means is to be displayed with respect to the parts information list retrieved by the retrieving means. Display control means for controlling to display,
The display control unit is a component management system that performs control to display a list of component information searched by the search unit including related information corresponding to a tab selected from the plurality of tabs. A first receiving means for receiving selection of a part classification that matches a newly registered part from a plurality of preset part classifications;
Second receiving means for receiving input of component information including attribute information and a component number set for the selected component classification;
A component information database for storing component information in which attribute information and a component number are input by the second accepting unit;
Search means for searching for component information that matches a specified condition from the component information stored in the component information database;
One or a plurality of linkage information databases for storing information other than the component information for the component number;
Extraction means for extracting related information registered for the component information searched by the search means from the one or more linkage information databases;
Display control means for controlling to display a list of parts information searched by the search means including related information extracted by the extraction means;
The display control means uses the part information list as a first axis, the part number as a first axis, and one or more attribute items selected from the attribute information or one or more selected from the related information A component management system that performs control to display the item in two dimensions as the second axis. A first receiving means for receiving selection of a part classification that matches a newly registered part from a plurality of preset part classifications;
Second receiving means for receiving input of component information including attribute information and a component number set for the selected component classification;
A component information database for storing component information in which attribute information and a component number are input by the second accepting unit;
Search means for searching for component information that matches a specified condition from the component information stored in the component information database;
One or a plurality of linkage information databases for storing information other than the component information for the component number;
Extraction means for extracting related information registered for the component information searched by the search means from the one or more linkage information databases;
The list of component information searched by the search means is rearranged based on the attribute item selected from the attribute information or the item selected from the related information, or set for the attribute item or item Correction means for narrowing down based on the specified conditions,
Display control means for controlling to display a list of parts information after being rearranged or narrowed down by the correcting means, including related information extracted by the extracting means;
Having a parts management system. A first receiving means for receiving selection of a part classification that matches a newly registered part from a plurality of preset part classifications;
Second receiving means for receiving input of component information including attribute information and a component number set for the selected component classification;
A component information database for storing component information in which attribute information and a component number are input by the second accepting unit;
Search means for searching for component information that matches a specified condition from the component information stored in the component information database;
A production information database for storing production information consisting of a model number and a serial number of a product in which the part is mounted with respect to the part number;
One or a plurality of linkage information databases for storing information other than the part information and the production information for the part number;
The model number and manufacturing number of the product on which the part specified by the part information searched by the searching means is mounted are extracted from the production information database, and the relationship registered for the extracted model number and manufacturing number. Extraction means for extracting information from the one or more linked information databases;
Display control means for controlling to display a list of component information searched by the search means, including related information extracted by the extraction means;
Having a parts management system. The part classification is a composite part classification set two-dimensionally by a combination of two classifications: functional classification, which is a classification from a design viewpoint, and construction method, material, and shape classification, which is a classification from a procurement / manufacturing viewpoint. ,
The attribute information includes a plurality of attribute information set for the selected composite part classification and different for each composite part classification, and a common attribute set in common for all parts regardless of the composite part classification. The parts management system according to claim 1, wherein information exists. A first accepting step for accepting selection of a part classification that matches a newly registered part from a plurality of preset part classifications;
A second accepting step for accepting input of part information including attribute information and part number set for the selected part classification;
A storage step of storing in the component information database the component information in which the attribute information and the component number are input in the second receiving step;
A search step for searching for component information that matches a specified condition from component information stored in the component information database;
An extraction step of extracting related information registered for the component information searched in the search step from one or a plurality of linkage information databases storing other information other than the component information for the component number;
Together with a plurality of tabs for switching which relevant information of the relevant information extracted in the extracting step is displayed with respect to the parts information list retrieved in the retrieving step. A display control step for controlling to display and display related information corresponding to the selected tab among the plurality of tabs in the list of component information searched in the search step;
A program that causes a computer to execute. A first accepting step for accepting selection of a part classification that matches a newly registered part from a plurality of preset part classifications;
A second accepting step for accepting input of part information including attribute information and part number set for the selected part classification;
A storage step of storing in the component information database the component information in which the attribute information and the component number are input in the second receiving step;
A search step for searching for component information that matches a specified condition from component information stored in the component information database;
An extraction step of extracting related information registered for the component information searched in the search step from one or a plurality of linkage information databases storing other information other than the component information for the component number;
The part information list searched in the search step is displayed including the related information extracted in the extraction step, and the part information list is displayed with the part number as the first axis, Two-dimensionally displaying, as a second axis, one or more attribute items selected from or one or more items selected from the related information;
A program that causes a computer to execute. A first accepting step for accepting selection of a part classification that matches a newly registered part from a plurality of preset part classifications;
A second accepting step for accepting input of part information including attribute information and part number set for the selected part classification;
A storage step of storing in the component information database the component information in which the attribute information and the component number are input in the second receiving step;
A search step for searching for component information that matches a specified condition from component information stored in the component information database;
An extraction step of extracting related information registered for the component information searched in the search step from one or a plurality of linkage information databases storing other information other than the component information for the component number;
The list of component information searched in the search step is rearranged based on the attribute item selected from the attribute information or the item selected from the related information, or set for the attribute item or item Correction steps to narrow down based on specified conditions,
A display control step for controlling to display a list of parts information after being rearranged or narrowed down in the correction step, including related information extracted in the extraction step;
A program that causes a computer to execute. A first accepting step for accepting selection of a part classification that matches a newly registered part from a plurality of preset part classifications;
A second accepting step for accepting input of part information including attribute information and part number set for the selected part classification;
A storage step of storing in the component information database the component information in which the attribute information and the component number are input in the second receiving step;
A search step for searching for component information that matches a specified condition from component information stored in the component information database;
The model number and manufacturing number of the product on which the part specified by the part information searched in the search step is mounted, and the production information including the model number and manufacturing number of the product on which the part is mounted with respect to the part number. Extracted from the production information database to be stored, and related information registered for the extracted model number and manufacturing number, and other information other than the part information and the production information for the part number 1 or An extraction step of extracting from a plurality of linkage information databases;
A display control step for controlling to display a list of component information searched in the search step including the related information extracted in the extraction step;
A program that causes a computer to execute. The part classification is a composite part classification set two-dimensionally by a combination of two classifications: functional classification, which is a classification from a design viewpoint, and construction method, material, and shape classification, which is a classification from a procurement / manufacturing viewpoint. ,
The attribute information includes a plurality of attribute information set for the selected composite part classification and different for each composite part classification, and a common attribute set in common for all parts regardless of the composite part classification. The program according to any one of claims 6 to 9, wherein information exists.

Images