JP2005108073A - Component information management device, component information management method, and data - Google Patents

Abstract

<P>PROBLEM TO BE SOLVED: To provide data for management of component information with low data quantity. <P>SOLUTION: A PS master 90 includes a used component field storing names of components used for any of respective products, a number column field consisting of a plurality of columns matching the respective products individually and storing the number of components, which constitute the product matching each of the columns, in each of the columns, a basic machine type field storing a basic machine type name of basic machine types to which the products belong respectively, a sequence number field storing a sequence number in association with the basic machine type, and a remark field storing additional information about the component stored in the used component field. <P>COPYRIGHT: (C)2005,JPO&NCIPI

Description

  The present invention relates to a data and component information management apparatus and method, and more particularly to data and a component information management apparatus and method for causing a computer to manage product component information.

In the manufacturing industry such as the home appliance industry and the automobile industry, even after the products are shipped, they have repair parts for the products. The holding period is generally over 7 years in Japan. For this reason, it is necessary to manage part information used in each product.
Conventionally, various methods have been proposed as such a component information management method (see, for example, Patent Documents 1 to 3). In the conventional parts information management method, what kind of part is used in which product is stored and managed as a parts table.

  FIG. 35 is a diagram showing an example of a conventional parts table. 35 stores a product model name, a used part name used in the model, the number of used parts, and remarks such as a cautionary note on the used parts. For example, for a product whose model name is “K-001-K”, nine types of parts such as “BUHIN001” and “BUHIN002” are used, and the number of parts “BUHIN002” is two. It is shown that the number of the other eight types of parts is one each. For example, the remarks column shows that the part “BUHIN002” is a part that needs to be noted when welding.

By referring to such a parts table, it is possible to know what parts are used in each model, which can be used for product repair.
JP-A-7-230508 JP 2001-87963 A JP 2001-350823 A

However, due to recent demands from the market and affiliated companies, the holding period of repair parts is expanding. For example, some parts, such as car parts, are long and have been held for more than 20 years, while others, such as airplane parts, are kept semipermanently as long as the airplane is in operation.
In recent years, consumer needs have been diversified, and even for products having the same function, the number of derivative models having different colors and shapes has increased. Furthermore, in the case of products for overseas, the power supply parts must be changed. In this way, the manufacturing method has shifted from mass production to high-mix low-volume production.

Against this background, the number of parts of products that each company must manage is increasing year by year.
As described above, in the conventional parts table as shown in FIG. 35, the names of used parts, the number (number) of used parts, and remarks are stored for each model. For this reason, every time a model is added to the parts table, the number of rows in the parts table increases by the number of used parts of that model.

  However, if the basic design is the same for different models, the parts used are almost the same. For this reason, in the conventional parts table, there is a problem that overlapping information is stored in the used parts column and the remarks column, and the data capacity of the storage device storing the parts table is pressed. In particular, in a precision instrument composed of tens of thousands of parts, the number of parts table columns increases by tens of thousands of rows each time one model is added, and this problem is remarkable.

In addition, since duplicate information is stored in the used parts column and remarks column, when correcting the description in the used parts column or remarks column corresponding to a certain part, a column in which the same part name as that part is described The parts used or remarks column must also be modified. For this reason, there is also a problem that the maintainability of the parts table administrator is poor.
Accordingly, an object of the present invention is to provide data, a component information management device, and a component information management method that can suppress an increase in the amount of data of component information.

  It is another object of the present invention to provide data for managing component information with good maintainability, a component information management device, and a component information management method.

  The data according to an aspect of the present invention is data for causing a computer to manage product component information, and includes first master data composed of a two-dimensional array and second master data. The master data consists of a first predetermined column, a component name storage structure for storing the component name of a component used in any of the products, and a plurality of columns different from the first predetermined column. Each of the plurality of columns corresponds to each product, and the number of parts constituting the product corresponding to the column in each column is stored in association with the position of the part name in the first predetermined column. And the second master data includes a structure for storing identification information of each product, and a column number in the number storage structure in which the number of parts constituting the product is stored. And store it in association with And a structure.

  The first master data corresponds to a “PS master” in an embodiment to be described later, and the second master data corresponds to a “model master”. As described above, the number storage structure (corresponding to the “number column” in the embodiment) stores the number of parts constituting each product for a plurality of products, and the plurality of products are stored in the part name storage structure ( The part name stored in the “used part column” in the embodiment is shared. For this reason, it is not necessary to store the part name for each product, and the part information can be managed with a small amount of data. Further, when the part name is corrected, it is not necessary to correct the part name for each product, and the correction is reflected to a plurality of products by correcting the part name stored in the part name storage structure. For this reason, maintainability improves.

  The first master data further includes a second predetermined column different from the first predetermined column and the plurality of columns, and has a structure in which a group number of a group to which each product belongs is stored. The second master data further has a structure for storing a group number of a group to which each product belongs in association with the identification information, and the number storage structure includes a predetermined number of columns, The column specified by the number and the group number may correspond to a column that stores the number of each product. Preferably, the group number may be updated every time the number of products exceeds a multiple of the number of columns of the number storage structure.

The group number corresponds to the “sequence number” in the embodiment. Thus, since the number of columns included in the number storage structure is a predetermined number, even if the number of products increases, the number of columns of the first master data can be a fixed number.
The first master data further includes a second predetermined column different from the first predetermined column and the plurality of columns, and a structure in which a group name of a group to which each product belongs is stored; A first predetermined column and a third predetermined column different from the plurality of columns, and a structure in which a subgroup number of a subgroup included in each group is stored in association with the group name; The second master data further includes a structure for storing a group name of a group to which the product belongs in association with the identification information; a subgroup number of a subgroup to which each product belongs; and the identification information. The component name storage structure includes, for each group, a part name of a part used in any of the products included in the group. Stored in association with a loop name, and in the component name storage structure, for each subgroup, a component name of a component used in any of the products included in the subgroup is associated with the subgroup number. The number storage structure is composed of a predetermined number of columns, and the column specified by the column number, the group name, and the subgroup number corresponds to the column storing the number of each product. May be.

The group name corresponds to “basic model” in the embodiment, and the subgroup number corresponds to “sequence number” in the embodiment. With such a configuration, even when information on a plurality of “basic models” is included in the master data, the component information can be stored with a small amount of data and maintaining maintainability.
A part information management apparatus according to another aspect of the present invention is a part information management apparatus that manages part information of a product, and stores first master data composed of a two-dimensional array and second master data. Storage means, and additional means for receiving information on the new product from the outside and adding the information to the first and second master data, the first master data comprising a first predetermined column, A part name storage structure for storing part names of parts used in any of the products, and a plurality of columns different from the first predetermined column, each of the plurality of columns corresponding to each product. Each of the columns has a number storage structure in which the number of components constituting the product corresponding to the column is stored in association with the position of the component name in the first predetermined column, and the second master data Stores the identification information of each product An identification information storage structure, and a structure for storing a column number in the number storage structure in which the number of parts constituting the product is stored in association with the identification information. Means for receiving information from outside, means for additionally storing the identification information in the identification information storage structure of the second master data based on the identification information of the product included in the additional product information, and the additional Means for additionally storing a column number indicating the storage position in the number storage structure of the number of parts constituting the product included in product information in the storage position information storage structure of the second master data; and the additional product If there is no column for storing the number of parts constituting the product included in the information, a column for storing the number is inserted into the number storage structure, The Number and additional memory, when the columns for storing the number of members is present, and a number of members additional storage means for adding storing the number of members in the column.

  The first master data corresponds to a “PS master” in an embodiment to be described later, and the second master data corresponds to a “model master”. As described above, the number storage structure (corresponding to the “number column” in the embodiment) stores the number of parts constituting each product for a plurality of products, and the plurality of products are stored in the part name storage structure ( The part name stored in the “used part column” in the embodiment is shared. In this component management apparatus, the number addition storage means sequentially adds a column for additionally storing the number to the number storage structure, and additionally stores the number information. For this reason, it is not necessary to store the part name for each product, and the part information can be managed with a small amount of data. Further, when the part name is corrected, it is not necessary to correct the part name for each product, and the correction is reflected to a plurality of products by correcting the part name stored in the part name storage structure. For this reason, maintainability improves.

  The present invention can be realized not only as a component information management device as described above, but also as a component information management method using the steps as a step, or as a program that causes a computer to function as the component information management device. You can also It goes without saying that such a program can be distributed via a recording medium such as a CD-ROM (Compact Disc-Read Only Memory) or a transmission medium such as the Internet.

According to the present invention, component information can be managed with a small amount of data.
In addition, the maintainability of the component information is improved.

Hereinafter, a component information management system according to an embodiment of the present invention will be described with reference to the drawings.
(Part information management system)
FIG. 1 is an external view showing a schematic configuration of a component information management system. The component information management system 40 is a system for managing component information of products and the like. The component information management system 40 includes a component information management database server 48 and terminal devices 42 and 44 connected to the component information management database server 48 via a computer network 46. Prepare.

The component information management database server 48 is a database server that manages product component information. The parts information management database server 48 will be described in detail later.
The terminal device 42 is installed in a development department or a manufacturing department of a company, and the terminal device 44 is installed in a product repair center or the like. The terminal device 42 and the terminal device 44 are devices for browsing the component information registered in the component information management database server 48. In particular, every time a new product is developed, the terminal device 42 transmits the component information to the component information management database server 48. The component information management database server 48 registers the component information transmitted from the terminal device 42 in the component information management database.

(Part information management database server)
The internal configuration of the component information management database server 48 will be described with reference to FIGS. FIG. 2 is a block diagram showing a hardware configuration of the component information management database server 48. The component information management database server 48 includes a main unit 50 that performs processing for managing component information, a display unit 52 that displays processing results in the main unit 50, a keyboard 54 and a mouse 56 for giving instructions to the main unit 50, It has.

The main unit 50 includes a CPU (Central Processing Unit) 62, a ROM (Read Only Memory) 64, a RAM (Random Access Memory) 66, a hard disk 68, a communication modem 70, a CD-ROM device 74, and the like. And a bus 72 connected to each other.
The CPU 62 executes a program for managing component information. The ROM 64 stores programs and data necessary for the operation of the main body unit 50. The RAM 66 stores data such as parameters at the time of program execution. The hard disk 68 stores programs and data. The communication modem 70 exchanges data with the terminal device 42 and the terminal device 44 via the computer network 46. In addition, the communication modem 70 reads a program distributed via the computer network 46. The CD-ROM device 74 reads a program stored in the CD-ROM 76.

  A database (hereinafter referred to as a “part information management database”) for managing product part information is stored in the hard disk 68, and includes a model master and a PS (Parts Structure) master, which will be described later. The model master is a database that stores information related to parts other than the used parts of each product, and the PS master is a database that stores information related to used parts of each product.

Next, the model master and the PS master will be described with specific examples. FIG. 3 is a diagram illustrating an example of a model master, and FIG. 4 is a diagram illustrating an example of a PS master.
(Model Master)
The model master 80 has a two-dimensional array structure as shown in FIG. 3, and the model name of the product (“K-001-K”, “K-005-K”, etc.) is stored in the first column. In the second column, the basic model names (“K-001”, “K-005”, etc.) of the products having the model names stored in the first column are stored. For example, a product whose basic model name is “K-001” indicates a VTR (Video Tape Recorder) having the same basic design, and a product whose basic model name is “K-005” is a drum-type laundry having the same basic design. It is assumed that the machine is shown. The VTR with the basic model name “K-001” includes products such as the model names “K-001-K” and “K-001-S”, and the drum type washing machine with the basic model name “K-005”. Includes products such as model names “K-005-K” and “K-005-ZZ”.

  In the third and fourth columns of the model master 80, sequence numbers (denoted as “SEQ” in the figure) and column numbers used for associating with information stored in the PS master 90 are shown. Are stored. The sequence number and column number will be described in detail later. Information (for example, destination and color) related to parts other than the used parts of each model is stored in the fifth column and thereafter of the model master 80.

  For example, when attention is paid to the product of model name “K-001-K”, the basic model name is “K-001”, and it can be seen that the product is a black product for Japan from the destination column and the color column. Further, it can be seen that the information regarding the used parts of the product is stored in the storage position in the PS master designated by the sequence number “1” and the column number “1”. The association between the model master 80 and the PS master will be described in detail later.

(PS Master)
The PS master 90 has a two-dimensional array structure as shown in FIG. 4, and the basic model name of the product (“K-001”, “K-005”, etc.) is displayed in the second column. In the third column, the used part names (“BUHIN001”, “BUHIN002”, etc.) of the basic model described in the first column are stored. Further, the number of used parts used in each model is stored in the 4th to 33rd columns (number columns 1 to 30) of the PS master 90, respectively. Further, the 34th column of the PS master 90 is provided with a remarks column in which notes for parts used are stored. The number column will be described in detail later.

According to the PS master 90, for example, a product with the basic model name “K-001” is created by selecting several types of parts from among 11 types of parts such as the parts “BUHIN001” and “BUHIN002”. . Further, it can be seen from the remarks column that the part “BUHIN222A” is a part used only for the black model.
Note that the PS master 90 stores the numbers of different basic models “K-005” in the same number column (for example, “number column 1”) as shown in the figure.

(Association between model master and PS master)
Next, the association between the model master and the PS master will be described with reference to FIGS. 5 and 6. As shown in FIG. 5, when the model name “K-001-20K” of the model master 80 is selected, the basic model name “K-001”, the sequence number “1”, and the column number “3” (see FIG. 5). 5), the PS master 90 is searched for. That is, in the PS master 90 shown in FIG. 6, a row is selected based on the basic model “K-001” and the sequence number “1”, and a column is selected based on the column number “3”. The numbers described at the positions designated by these three data (hatched positions in FIG. 6) indicate the number of parts used in the product of the model name “K-001-20K”.

For example, it is indicated that one part “BUHIN001” and four parts “BUHIN002” are used in the product. A blank indicates that the number is zero. For this reason, it is indicated that the part “BUHIN222B” is not used in the product.
Note that the PS master 90 has only 30 number columns. However, there are 33 types of models with the basic model name “K-001”. For this reason, for the 31st and subsequent models, a row of sequence number “2” having the same number of rows as the row of sequence number “1” is provided, and the number is stored at any position in the number column 1-30. The In the used parts column and the remarks column, the same data as that described in the used parts column and the remarks column of the sequence number “1” is stored. Similarly, when 61 or more types of products exist for one basic model, a row having a sequence number “3” is provided and the number is stored. In this way, it is possible to cope with an increase in the number of models by sequentially increasing the sequence number.

(Part information management database search processing)
Next, the search processing of the component information management database will be described with reference to FIGS. FIG. 7 is a flowchart of the search process. Here, the parts information management database search process in the parts information management database server 48 will be described, but the parts information management database search process in the terminal device 42 (44) is also performed in the same manner.

  The component information management database server 48 displays a search screen as shown in FIG. 8 on the display unit 52 (S2) and accepts input from the user. On the search screen, a basic model name input field 102, a used component name input field 104, a search execution button 106, and a cancel button 108 are displayed. The basic model name input field 102 is provided for inputting a basic model name that is a search condition, and the used part name input field 104 is provided for inputting a used part name that is a search condition. The search condition is input by the user using the keyboard 54 or the like. The search execution button 106 and the cancel button 108 can be pressed by the user by using the mouse 56 or the like. The search execution button 106 is a button for searching the parts information management database based on the search condition. The cancel button 108 is a button for ending the search process.

After the search screen is displayed, the parts information management database server 48 stands by until either the search execution button 106 or the cancel button 108 is pressed (S4). When the part information management database server 48 detects that any button is pressed (YES in S4), it checks whether the pressed button is the search execution button 106 (S6). If the pressed button is not the search execution button 106 (NO in S6), the cancel button 108 is pressed. Therefore, the search process ends.
If the pressed button is the search execution button 106 (YES in S6), it is checked whether or not a search condition is input in the basic model name input field 102 and the used part name input field 104 (S8 to S12).

As shown in FIG. 9, the basic model name input field 102 and the used part name input field 104 are respectively input with the basic model name (here, “K-005”) and the used part name (here “BUHIN002”). In this case (YES in S8, YES in S10), the PS master 90 is searched using the input basic model name and used part name as search conditions (S14). For example, when the PS master 90 shown in FIG. 10 is searched using the basic model name “K-005” and the used part name “BUHIN002” as search conditions, the line indicated by the arrow (hatched line) in the figure is the search result. It becomes.

Thereafter, the parts information management database server 48 displays the search result as shown in FIG. 11 on the display unit 52 (S20), and ends the search process. In FIG. 11, only the number columns 1 to 4 of the search results are displayed, but a horizontal scroll bar 112 is also displayed in order to display other number columns. The user can display another number column by operating the horizontal scroll bar 112 using the mouse 56 or the like. FIG. 12 shows a screen display example in which the number columns 27 to 30 are displayed by operating the horizontal scroll bar 112. Here, the number columns 27 to 30 are blank.

  As shown in FIG. 13, when the basic model name ("K-005" in this case) is entered in the basic model name input field 102 and the used part name input field 104 is blank (YES in S8, NO in S10). The PS master 90 is searched using the input basic model name as a search condition (S16). For example, when the PS master 90 shown in FIG. 14 is searched using the basic model name “K-005” as a search condition, the row indicated by the arrow (the hatched row) in the figure becomes the search result.

Thereafter, the parts information management database server 48 displays the search result as shown in FIG. 15 on the display unit 52 (S20), and ends the process.
As shown in FIG. 16, when the basic model name input field 102 is blank and the used part name ("BUHIN002" in this case) is entered in the used part name input field 104 (NO in S8, YES in S12). ), The PS master 90 is searched using the input used part name as a search condition (S18). For example, when the PS master 90 shown in FIG. 17 is searched using the used component name “BUHIN002” as a search condition, the row indicated by the arrow (hatched row) in the figure becomes the search result.

Thereafter, the parts information management database server 48 displays the search result as shown in FIG. 18 on the display unit 52 (S20), and ends the process.
As shown in FIG. 8, when the basic model name input field 102 and the used part name input field 104 are blank (NO in S8, NO in S12), the part information management database server 48 is as shown in FIG. The PS master 90 itself is displayed on the display unit 52 (S22), and the process is terminated. In the search result shown in FIG. 19, the horizontal scroll bar 112 and the vertical scroll bar 114 are also displayed in order to display other fields.

(Part information management database update processing)
Next, update processing of the component information management database will be described with reference to FIGS. FIG. 20 is a diagram schematically showing the update process of the component information management database, and FIG. 21 is a flowchart of the update process.

  The parts information management database server 48 stands by until it receives additional information 120 related to the new product from the terminal device 42 (S32). The additional information 120 is information relating to the new product, and the additional information 120 includes additional model information 122 relating to the model of the new product and additional part information 124 relating to the part used in the model. When the component information management database server 48 receives the additional information 120 from the terminal device 42 (YES in S 32), the model master 80 is updated by additionally registering the additional model information 122 in the model master 80, and a new model master 82 is obtained. Is created (S34). Further, the parts information management database server 48 updates the PS master 90 by additionally registering the additional parts information 124 in the PS master 90, creates a new PS master 92 (S36), and ends the updating process.

  Next, the update process of the parts information management database will be described in more detail with a specific example. FIG. 22 is a diagram illustrating an example of the additional information 120. FIG. 22A is a diagram illustrating an example of the additional model information 122, and FIG. 22B is a diagram illustrating an example of the additional component information 124. As shown in FIG. 22A, the additional model information 122 includes a model name (“K-001-60K”), which is information related to a model of a new product to be additionally registered in the PS master 90, and a basic model name ( “K-001”), destination (“Italy”), color (“black”) and the like are included. Further, as shown in FIG. 22B, the additional part information 124 includes part names (“BUHIN001”, “BUHIN002”, etc.) of parts used in the model “K-001-60K” and the number of parts. And are included.

  FIG. 23 is a flowchart of additional model information registration processing (S34 in FIG. 21). The parts information management database server 48 checks whether or not the same basic model name as the basic model name included in the additional model information 122 is registered in the model master 80 (S42). If the same basic model name is registered (YES in S42), a new line is inserted between the last line and the next line of the area where the basic model name is registered in the model master 80 and added. The model information 122 is additionally registered (S44). For example, when the additional model information 122 shown in FIG. 22A is additionally registered in the model master 80 shown in FIG. 3, the same basic model as the basic model “K-001” of the additional model information 122 is obtained. It exists in the model master 80. Therefore, a new line is provided in the line next to the last line (line of model name “K-001-60G”) in the area where the basic model “K-001” is registered, and additional model information 122 is registered. The FIG. 24 shows the model master 80 after the additional model information 122 is registered as described above. At this time, the sequence number column and the column number column are blank.

After the additional model information 122 is additionally registered, the component information management database server 48 increments the column number of the line immediately before the line additionally registered in the model master 80 by one (S46). In the example of FIG. 24, since the column number of the immediately preceding row (the row of the model name “K-001-60G”) is 3, the incremented column number is 4.
The component information management database server 48 determines whether the incremented column number exceeds 30 (S48). This is because the PS master 90 has only 30 factor columns. If the column number exceeds 30 (YES in S48), the value obtained by incrementing the sequence number of the previous line by one is set as the sequence number of the line additionally registered in the model master 80 (S50), and additionally registered. The column number of the row is set to 1 (S52). Thereafter, the sequence number and the column number are inserted into the additionally registered line of the model master 80 (S54), and the process is terminated. For example, when the additional model information 142 shown in FIG. 25 is additionally registered in the model master 144 shown in FIG. 26, 30 products of the basic model “K-007” are currently registered in the model master 144. ing. Therefore, when the additional model information 142 is additionally registered in the model master 144, the model master 144 becomes as shown in FIG. 27, and the sequence number of the model “K-007-70G” is incremented by 1 to “2”, and the column number Becomes “1”.

  When the incremented column number is 30 or less (NO in S48), the sequence number of the immediately preceding row and the incremented column number are inserted into the additionally registered row of the model master 80 (S54), and the process is performed. finish. FIG. 28 is a diagram showing the model master 82 after the sequence number and the column number are additionally registered in the model master 80 shown in FIG. That is, the sequence number of the additionally registered line (the line indicated by the arrow in the figure) is the same as the sequence number of the previous line, and the column number is obtained by incrementing the column number of the previous line by one. is there.

  If the same basic model name as the basic model name included in the additional model information 122 is not registered in the model master 80 (NO in S42), a new line is inserted after the last line of the model master 80, and the additional model Information 122 is additionally registered (S56). Thereafter, the component information management database server 48 sets the sequence number of the additional model information 122 to 1 (S58), sets the column number to 1 (S60), and then inserts the additional model information 122 into the additionally registered line (S54). The process is terminated. For example, when the additional model information 132 shown in FIG. 29 is additionally registered in the model master 80 shown in FIG. 3, the same basic model as the basic model “K-008” in the additional model information 132 is the model master 80. Does not exist. Therefore, as shown in FIG. 30, a new line is provided after the last line of the model master 80, the additional model information 132 is registered, and the model master 82 is created. At that time, 1 is inserted into the sequence number column and the column number column.

As described above, the additional model information 122 is inserted into the model master 80. Further, by inserting the sequence number and column number of the additional model, the storage position of the part information related to the additional model in the PS master 90 is newly indicated.
Each time the column number exceeds 30, the sequence number is incremented by one. However, the sequence number is not limited to 30, and if the number of column columns of the PS master 90 does not exceed, the other numbers are used. Also good.

  FIG. 31 is a flowchart of additional part information registration processing (S36 in FIG. 21). The component information management database server 48 checks whether or not the column number of the additional model information 122 additionally registered in the model master 82 in the additional model information registration process (S34 in FIG. 21, FIG. 23) is 1 (S72). If the column number is 1 (YES in S72), an area for additionally registering the additional model information 122 does not exist in the PS master 90. For this reason, a new line for registering used component information is inserted into the PS master 90, and the used component column of the PS master 90 is filled (S74). For example, assuming that the PS master 90 shown in FIG. 4 inserts a line for registering used component information of the basic model “K-001”, the basic model “K-005”, the sequence number “1”, and Eleven lines are inserted immediately before the used part “BUHIN002”. Thereafter, the sequence number assigned to the additional model information 122 in the additional model information registration process (S34 in FIG. 21, FIG. 23) is inserted into the sequence number column of the added line (S76). Finally, the parts information management database server 48 inserts the number of the additional parts information 124 into the number column 1 of the additionally registered line (S78), and ends the process.

  If the column number of the additional model information 122 additionally registered in the model master 82 is not 1 (NO in S72), the number of the additional part information 124 is inserted into the column specified by the sequence number and column number of the additional model information 122. (S78), and the process ends. For example, the additional model information 122 shown in FIG. 22A is registered with the sequence number “2” and the column number “4” on the model master 82 as shown in FIG. Therefore, as shown in FIG. 32, the number information of the additional part information 124 is hatched as specified by the basic model “K-001”, the sequence number “2”, and the column number “4” of the PS master 92. Stored in the designated area.

By doing this, even if it becomes impossible to store the number in the number column column, a row corresponding to the new sequence number is inserted, and an area for storing the number in the number column column is generated. Is done.
Note that the updating operation of the model master 80 and the PS master 90 may be performed manually.

  As described above, according to the present embodiment, the PS master shares information on the used parts column and the remarks column for 30 models. In addition, the number column is shared among multiple models. For this reason, component information can be managed with a smaller amount of data than in the conventional method.

  Further, in the conventional method, when a correction occurs in the remarks column, the same correction must be made for the remarks column for all models. In this embodiment, the remarks column has 30 models. Share on. For this reason, when the remarks column is corrected, the correction is reflected in 30 models, and the maintainability is improved. The same can be said when the part name used is changed.

As mentioned above, although the parts information management system concerning the present invention was explained based on an embodiment, the present invention is not limited to this embodiment.
For example, in the PS master 90, the number of columns in the number column is 30, but this restriction may be eliminated. FIG. 33 is a diagram showing a model master 150 having the same model information as the model master 80 shown in FIG. The model master 150 does not have a sequence number column existing in the model master 80. Instead, the column number of the model whose sequence number is “2” starts from the 31st.

FIG. 34 is a diagram showing a PS master 160 having the same component information as the PS master 90 shown in FIG. In the PS master 160, the number of columns in the number column is 33. When the component information of the basic model “K-001” is added, the number column 34 is added, and the number information is stored in the column.
By eliminating the restriction on the number column in this way, when the remarks column or the used part name is corrected, the correction is reflected in all models belonging to the same basic model. For this reason, the maintainability is further improved.

The basic model handled by the model master and the PS master may be one type. In this case, the basic model column existing in the model master and the PS master is not necessary.
Furthermore, the PS master may be stored in a different file for each basic model.
Furthermore, it goes without saying that the model master or PS master may include other information such as a circuit number.

Further, in one or both of the model master and the PS master, rows and columns may be interchanged.
Further, in the present embodiment, description has been given by taking the part information of the product as an example, but this is only an example, and the system according to the present embodiment may be applied to other information.

  As described above, the data and the component information management apparatus and method according to the present invention have a small amount of component information and good maintainability. Therefore, it is suitable for causing a computer to manage product part information.

1 is an external view showing a schematic configuration of a parts information management system according to an embodiment of the present invention. Block diagram showing the hardware configuration of the component information management database server Diagram showing an example of the model master Diagram showing an example of PS master The figure which shows matching with the model master and PS master The figure which shows matching with the model master and PS master Flow chart of search processing of parts information management database The figure which shows an example of the search screen displayed on a display part The figure which shows an example of the search screen after a search condition is input Diagram for explaining search process The figure which shows an example of the search result displayed on a display part The figure which shows an example of the search result displayed on a display part The figure which shows an example of the search screen after a search condition is input Diagram for explaining search process The figure which shows an example of the search result displayed on a display part The figure which shows an example of the search screen after a search condition is input Diagram for explaining search process The figure which shows an example of the search result displayed on a display part The figure which shows an example of the search result displayed on a display part The figure which shows the update processing of parts information management database typically Flow chart of update processing of parts information management database (A) Diagram showing an example of additional model information (b) Diagram showing an example of additional component information Flow chart of registration process of additional model information included in additional information Diagram for explaining additional model information registration process Diagram for explaining additional model information registration process Diagram for explaining additional model information registration process Diagram for explaining additional model information registration process Diagram for explaining additional model information registration process Diagram for explaining additional model information registration process Diagram for explaining additional model information registration process Flow chart of registration process of additional component information included in additional information Diagram for explaining registration process of additional parts information The figure showing the model master which has the same model information as the model master shown in FIG. A diagram representing a PS master having the same component information as the PS master shown in FIG. A diagram showing an example of a conventional parts table

Explanation of symbols

40 Parts Information Management System 42, 44 Terminal Device 46 Computer Network 48 Parts Information Management Database Server 50 Main Body 52 Display Unit 54 Keyboard 56 Mouse 68 Hard Disk 70 Communication Modem 72 Bus 74 CD-ROM Device 80, 82, 84, 144, 150 Model master 90, 92, 160 PS master 102 Basic model name input field 104 Used part name input field 106 Search execution button 108 Cancel button 112 Horizontal scroll bar 114 Vertical scroll bar 120 Additional information 122, 132, 142 Additional model information 124 Additional parts information

Claims (31)

Data that allows a computer to manage product part information,
First master data comprising a two-dimensional array;
Second master data,
The first master data is
A part name storage structure that includes a first predetermined column and stores a part name of a part used in any of the products;
It consists of a plurality of columns different from the first predetermined column, each of the plurality of columns corresponding to each product, and the number of parts constituting the product corresponding to the column in each column is the first predetermined column And a number storage structure stored in association with the position of the part name in
The second master data is
A structure for storing identification information of each product;
Data having a structure in which a column number in the number storage structure in which the number of parts constituting the product is stored is stored in association with the identification information. The first master data further includes a second predetermined column different from the first predetermined column and the plurality of columns, and has a structure in which a group number of a group to which each product belongs is stored.
The second master data further has a structure for storing a group number of a group to which each product belongs in association with the identification information,
The number storage structure includes a predetermined number of columns, and a column specified by the column number and the group number corresponds to a column storing the number of each product. data. The data according to claim 2, wherein the group number is updated every time the number of the products exceeds a predetermined multiple. The data according to claim 3, wherein the predetermined number is the same as the number of columns of the number storage structure. The first master data further includes a second predetermined column different from the first predetermined column and the plurality of columns, and has a structure in which a group name of a group to which each product belongs is stored.
The second master data further has a structure for storing a group name of a group to which the product belongs in association with the identification information,
The component name storage structure stores, for each group, a component name of a component used in any of the products included in the group in association with the group name. Data described in. The first master data further includes the first and second predetermined columns and a third predetermined column different from the plurality of columns, and a subgroup number of a subgroup included in each group is the group name. And stored in association with
The second master data further has a structure for storing a subgroup number of a subgroup to which each product belongs in association with the identification information,
In the component name storage structure, for each subgroup, a component name of a component used in any of the products included in the subgroup is stored in association with the subgroup number,
The number storage structure includes a predetermined number of columns, and a column specified by the column number, the group name, and the subgroup number corresponds to a column that stores the number of each product. The data according to item 5. The data according to claim 6, wherein the sub group number is updated every time the number of products belonging to each group exceeds a predetermined multiple. The data according to claim 7, wherein the predetermined number is the same as the number of columns of the number storage structure. The first master data further includes a predetermined column different from the predetermined column and the plurality of columns, and has a structure in which additional information of a component having each component name stored in the component name storage structure is stored. The data according to any one of claims 1 to 8, characterized by comprising: In the data according to any one of claims 1 to 9,
Data characterized by interchange of rows and columns. A component information management device for managing product component information,
Storage means for storing first master data composed of a two-dimensional array and second master data;
Receiving information about a new product from the outside, and adding the information to the first and second master data,
The first master data is
A part name storage structure that includes a first predetermined column and stores a part name of a part used in any of the products;
It consists of a plurality of columns different from the first predetermined column, each of the plurality of columns corresponding to each product, and the number of parts constituting the product corresponding to the column in each column is the first predetermined column And a number storage structure stored in association with the position of the part name in
The second master data is
An identification information storage structure for storing identification information of each product;
A structure for storing a column number in the number storage structure in which the number of parts constituting the product is stored in association with the identification information;
The additional means includes
Means for receiving additional product information from outside;
Means for additionally storing the identification information in the identification information storage structure of the second master data based on the identification information of the product included in the additional product information;
Means for additionally storing a column number indicating a storage position in the number storage structure of the number of parts constituting the product included in the additional product information in the storage position information storage structure of the second master data;
If there is no column for storing the number of parts constituting the product included in the additional product information, a column for storing the number is inserted into the number storage structure, and the number is stored in the column. When there is a column for additionally storing the number, the number additional storage unit for additionally storing the number in the column is included. The first master data further includes a first predetermined number and a second predetermined number different from the plurality of lines, and a first group number storage structure in which a group number of a group to which each product belongs is stored. Have
The second master data further has a second group number storage structure for storing a group number of a group to which each product belongs in association with the identification information,
The number storage structure is composed of a predetermined number of columns, and a column specified by the column number and the group number corresponds to a column storing the number of each product,
The additional means further includes:
Means for determining whether or not a field for storing the number of parts constituting the product included in the additional product information exists in the number storage structure;
When it is determined that there is no field for storing the number of parts in the number storage structure, the group number stored in the second group number storage structure is updated, and the updated group number is set to the group of the product. Means for storing in the second group number storage structure as a number;
Means for providing a row for storing the number of parts in the first master data when it is determined that a column for storing the number of parts does not exist in the number storage structure;
Means for inserting a part name and a group number of the part in a newly provided line,
12. The component information management apparatus according to claim 11, wherein the number addition storage unit additionally stores the number of the components in a column of the number storage structure determined according to a column number and a group number of the product. The component information management apparatus according to claim 12, wherein the group number is updated every time the number of the products exceeds a predetermined multiple. The component information management apparatus according to claim 13, wherein the predetermined number is the same as the number of columns of the number storage structure. The first master data further includes a first predetermined column and a second predetermined column different from the plurality of columns, and a first group name storage structure in which a group name of a group to which each product belongs is stored. Have
The second master data further has a second group name storage structure that stores a group name of a group to which the product belongs in association with the identification information;
In the component name storage structure, for each group, a component name of a component used in any of the products included in the group is stored in association with the group name,
The additional means further includes:
Means for additionally storing a group name of the product included in the additional product information in the second group name storage structure;
A row for inserting the same number of rows as the number of parts constituting the product into the first master data when the group name of the product included in the additional product information is not stored in the first group name storage structure. Insertion means;
Means for additionally storing a part name of a part constituting the product in the part name storage structure when a line is inserted in the line inserting means;
Means for additionally storing the group name of the product in the first group name storage structure when a row is inserted in the row insertion means;
The number addition storage means additionally stores the number in the column of the number storage structure defined according to the column number and group name of the product included in the additional product information, and when the column does not exist, The part information management apparatus according to claim 11, further comprising: inserting a column including the number and storing the number. The first master data further includes the first and second predetermined columns and a third predetermined column different from the plurality of columns, and a subgroup number of a subgroup included in each group is the group name. Having a first subgroup number storage structure stored in association with
The second master data further has a second subgroup number storage structure for storing a subgroup number of a subgroup to which each product belongs in association with the identification information,
In the component name storage structure, for each subgroup, a component name of a component used in any of the products included in the subgroup is stored in association with the subgroup number,
The number storage structure includes a predetermined number of columns, and a column specified by the column number, the group name, and the sub group number corresponds to a column that stores the number of each product.
The additional means further includes:
Means for determining whether or not a field for storing the number of parts constituting the product included in the additional product information exists in the number storage structure;
When it is determined that there is no column for storing the number of parts in the number storage structure, the subgroup number stored in the second subgroup number storage structure is updated, and the updated subgroup number is Means for storing in the second subgroup number storage structure as a subgroup number of the product;
Means for providing a row for storing the number of parts in the first master data when it is determined that a column for storing the number of parts does not exist in the number storage structure;
Means for inserting a part name, a group name, and the subgroup number of the part into a newly provided line;
16. The part information according to claim 15, wherein the number addition storage means additionally stores the number of parts in a column of the number storage structure determined according to a column number, a group name, and a subgroup number of the product. Management device. The component information management apparatus according to claim 16, wherein the subgroup number is updated every time the number of products belonging to each group exceeds a multiple of a predetermined number. The component information management apparatus according to claim 17, wherein the predetermined number is the same as the number of columns of the number storage structure. The first master data further includes a predetermined column different from the predetermined column and the plurality of columns, and has a structure in which additional information of a component having each component name stored in the component name storage structure is stored. Have
The said addition means further has a means to insert the remark information of the said part contained in the said additional product information in the said newly provided line. Any one of Claims 12-14 and 16-18 characterized by the above-mentioned. The component information management device according to the above. In the parts information management device according to any one of claims 11 to 19,
A component information management device characterized by exchanging rows and columns with each other. A component information management method by a component information management device that manages product component information,
The component information management device stores first master data composed of a two-dimensional array and second master data,
The first master data is
A part name storage structure that includes a first predetermined column and stores a part name of a part used in any of the products;
It consists of a plurality of columns different from the first predetermined column, each of the plurality of columns corresponding to each product, and the number of parts constituting the product corresponding to the column in each column is the first predetermined column And a number storage structure stored in association with the position of the part name in
The second master data is
An identification information storage structure for storing identification information of each product;
A structure for storing a column number in the number storage structure in which the number of parts constituting the product is stored in association with the identification information;
Receiving additional product information from outside;
Based on the identification information of the product included in the additional product information, additionally storing the identification information in the identification information storage structure of the second master data;
A step of additionally storing a column number indicating a storage position in the number storage structure of the number of parts constituting the product included in the additional product information in the storage position information storage structure of the second master data;
If there is no column for storing the number of parts constituting the product included in the additional product information, a column for storing the number is inserted into the number storage structure, and the number is stored in the column. And a number addition storage step of additionally storing the number in the column when there is a column for storing the number and storing the number in the column. The first master data further includes a first predetermined number and a second predetermined number different from the plurality of lines, and a first group number storage structure in which a group number of a group to which each product belongs is stored. Have
The second master data further has a second group number storage structure for storing a group number of a group to which each product belongs in association with the identification information,
The number storage structure is composed of a predetermined number of columns, and a column specified by the column number and the group number corresponds to a column storing the number of each product,
Further, determining whether or not a field for storing the number of parts constituting the product included in the additional product information exists in the number storage structure;
When it is determined that there is no field for storing the number of parts in the number storage structure, the group number stored in the second group number storage structure is updated, and the updated group number is set to the group of the product. Storing in the second group number storage structure as a number;
Providing a row for storing the number of parts in the first master data when it is determined that a column for storing the number of parts does not exist in the number storage structure;
Inserting a part name and a group number of the part into a newly provided line,
The component information management method according to claim 21, wherein, in the number addition storage step, the number of components is additionally stored in a column of the number storage structure determined according to a column number and a group number of the product. The component information management method according to claim 22, wherein the group number is updated every time the number of the products exceeds a predetermined multiple. The component information management method according to claim 23, wherein the predetermined number is the same as the number of columns of the number storage structure. The first master data further includes
The first predetermined column and the second predetermined column are different from the plurality of columns, and has a first group name storage structure in which a group name of a group to which each product belongs is stored.
The second master data further includes:
A second group name storage structure for storing a group name of a group to which the product belongs in association with the identification information;
In the component name storage structure, for each group, a component name of a component used in any of the products included in the group is stored in association with the group name,
A step of additionally storing a group name of the product included in the additional product information in the second group name storage structure;
A row for inserting the same number of rows as the number of parts constituting the product into the first master data when the group name of the product included in the additional product information is not stored in the first group name storage structure. An insertion step;
A step of additionally storing a part name of a part constituting the product in the part name storage structure when a line is inserted in the line inserting step;
Storing a group name of the product in the first group name storage structure when a row is inserted in the row inserting step,
In the number addition storage step, the number is additionally stored in a column of the number storage structure determined according to the column number and group name of the product included in the additional product information, and if the column does not exist, the column The part information management method according to claim 21, further comprising: inserting a column including the number and storing the number. The first master data further includes the first and second predetermined columns and a third predetermined column different from the plurality of columns, and a subgroup number of a subgroup included in each group is the group name. Having a first subgroup number storage structure stored in association with
The second master data further has a second subgroup number storage structure for storing a subgroup number of a subgroup to which each product belongs in association with the identification information,
In the component name storage structure, for each subgroup, a component name of a component used in any of the products included in the subgroup is stored in association with the subgroup number,
The number storage structure includes a predetermined number of columns, and a column specified by the column number, the group name, and the sub group number corresponds to a column that stores the number of each product.
Further, determining whether or not a field for storing the number of parts constituting the product included in the additional product information exists in the number storage structure;
When it is determined that there is no column for storing the number of parts in the number storage structure, the subgroup number stored in the second subgroup number storage structure is updated, and the updated subgroup number is Storing the subgroup number of the product in the second subgroup number storage structure;
Providing a row for storing the number of parts in the first master data when it is determined that a column for storing the number of parts does not exist in the number storage structure;
Inserting a part name, a group name, and the subgroup number of the part into a newly provided line,
26. The component information according to claim 25, wherein in the number addition storage step, the number of the component is additionally stored in a column of the number storage structure determined according to the column number, group name, and subgroup number of the product. Management method. 27. The part information management method according to claim 26, wherein the sub group number is updated every time the number of products belonging to each group exceeds a predetermined multiple. The part information management method according to claim 27, wherein the predetermined number is the same as the number of columns of the number storage structure. The first master data further includes
The predetermined column and the plurality of columns are different from the predetermined column, and has a structure in which additional information of a component having each component name stored in the component name storage structure is stored.
The component according to any one of claims 22 to 24 and 26 to 28, further comprising a step of inserting remark information of the component included in the additional product information into the newly provided row. Information management method. The part information management method according to any one of claims 21 to 29,
A component information management method characterized by exchanging rows and columns with each other. A program for causing a computer to function as a part information management device for managing part information of a product,
The parts information management device
Storage means for storing first master data composed of a two-dimensional array and second master data;
Receiving information about a new product from the outside, and adding the information to the first and second master data,
The first master data is
A part name storage structure that includes a first predetermined column and stores a part name of a part used in any of the products;
It consists of a plurality of columns different from the first predetermined column, each of the plurality of columns corresponding to each product, and the number of parts constituting the product corresponding to the column in each column is the first predetermined column And a number storage structure stored in association with the position of the part name in
The second master data is
An identification information storage structure for storing identification information of each product;
A structure for storing a column number in the number storage structure in which the number of parts constituting the product is stored in association with the identification information;
The additional means includes
Means for receiving additional product information from outside;
Means for additionally storing the identification information in the identification information storage structure of the second master data based on the identification information of the product included in the additional product information;
Means for additionally storing a column number indicating a storage position in the number storage structure of the number of parts constituting the product included in the additional product information in the storage position information storage structure of the second master data;
If there is no column for storing the number of parts constituting the product included in the additional product information, a column for storing the number is inserted into the number storage structure, and the number is stored in the column. When there is a column for storing the number and storing the number, the number addition storage means for additionally storing the number in the column is included.

Images