JP6060065B2 - Data conversion apparatus, data conversion method, and data conversion program - Google Patents

Description

  The present invention relates to product production management technology, and more particularly to technology for creating master data.

  In recent years, production management of products is often performed by a scheduler using a computer.

  For example, when creating a schedule of a product produced by a plurality of processes, the scheduler creates a schedule by assigning equipment and tools used in the process and necessary personnel to each process (Patent Document) 1 etc.). At this time, the scheduler refers to a database that stores a lot of information that becomes a constraint when creating a schedule and an order that includes product type, quantity, delivery date, and the like, and generates a schedule that complies with the constraint and delivery date.

JP-A-11-66181

  Here, in order to meet the recent demands for small quantity and variety of products, quick delivery, reduction of inventory, etc., and to create an efficient schedule, it is necessary to satisfy many constraints, There are an enormous number of items to be registered. In this database, for each product to be manufactured, there are various information related to personnel required for manufacturing, various information regarding equipment, production patterns, various information regarding semi-finished products and final products generated during the production of final products. , Accumulated as constraints.

  In addition, some information stored in the database needs to be updated frequently. When the database is enlarged, it becomes difficult to keep the information up-to-date. That is, there may be a case where the database cannot be maintained in a realistic time.

  If the database is not up-to-date, the schedule created by the scheduler will not match the substance and cannot be implemented. In such a case, in order to match the schedule with the entity, the schedule created by the scheduler must be further modified by the planner, resulting in trouble. Also, such corrections are often based on undocumented information, such as in the planner's mind, and some highly proficient plans that are used to such corrections. If you are not a planner, you may not be able to correct it. Therefore, it is desirable that the database is the latest information even if the amount of information to be accumulated becomes enormous.

  Accordingly, an object of the present invention is to provide a new database that can be scheduled in the same manner as the scheduling using the database even if the number of items in the database increases, and is easy to maintain.

  In one aspect of the present invention, the data conversion device is a data conversion device that converts master data having a data structure configured by associating each of a plurality of resources required for processing a product with the product. The resource is associated with one or more products, and among the resources, the resource group generating means that groups all the resources with the same associated products into one resource group; A simplified master data generating means for generating new simplified master data having the same data structure as the data structure by associating the resource group grouped by the resource group generating means with the product; To do.

  The data conversion method according to another aspect of the present invention has a data structure configured by associating each of a plurality of resources necessary for processing a product with the product, and the resource includes one or more resources. A data conversion method used in a data conversion apparatus for converting master data associated with a product of the above, wherein resources having the same associated products among the resources are grouped into one A simplified master that generates a new simplified master data having the same data structure as the resource structure by associating the resource group generated in the resource group generating step and the resource group grouped in the resource group generating step with the product. And a data generation step.

  A data conversion program according to another aspect of the present invention has a data structure configured by associating each of a plurality of resources necessary for processing a product with the product, and the resource includes one or more resources. A data conversion program for use in a data conversion apparatus for converting master data associated with a product of the above, wherein resources having the same associated products among the resources are grouped into one A simplified master that generates new simplified master data having the same data structure as the data structure by associating the resource group generated in the resource group generating step with the resource group generated in the resource group generating step. A data conversion program for causing a computer to execute data generation processing.

  According to the data conversion device, the data conversion method, and the data conversion program having such a configuration, resources are grouped from master data having a large number of registered resources, and the number of resources is less than the number of resources. Simplified master data having the same data structure as that of the master data is created by associating groups with products. Therefore, the amount of information is the same as that of the master data, but simplified master data with a small number of data associated with the product can be used instead of the master data having the same data structure. In addition, since the number of data is small, the search speed is increased, and as a result, processing using simplified master data can be performed in a shorter time than when using master data. . Furthermore, since the number of data is small, maintenance is easy and it is always easy to keep the latest state. The “product” includes intermediates.

  In the above data conversion apparatus, the simplified master data is deleted by adding a resource group, adding a resource group, or changing a product associated with the resource group. A simplified master changing means for generating simplified master data, wherein the resource group generating means is a product associated with the resource group of the new simplified master data generated by the simplified master changing means. Are grouped as one new resource group, and the simplified master data generating means associates the new resource group generated by the resource group generating means with the product, It is preferable to generate simplified master data.

  According to this configuration, when the simplified master data is deleted or added in the resource group unit or the product corresponding to the resource is changed, the changed simplified master data is converted into the master data. Since the data can be converted and the data can be converted, the simplified master data to which data has been added, etc. should always be compact and simplified master data that has been updated without complicating or enlarging the data. Is possible.

  Such a scheduler that uses simplified master data that is easy to maintain and has a smaller number of data can reduce the data search time than using master data, and therefore has the same accuracy as when using master data. There is a high possibility that a schedule can be created in a shorter time.

  The data conversion apparatus according to the present invention can provide a new database that can perform the same scheduling as the scheduling using the database even if the number of items in the database increases, and that is easy to maintain. .

1 is an overall configuration diagram illustrating a master data conversion device and its peripheral devices according to an embodiment. It is a functional block diagram of the master data converter shown in FIG. It is a figure which shows the example of a structure and content of the master data of the master data converter shown in FIG. It is a figure which shows the example of a structure and content of the simplification master data of the master data converter shown in FIG. It is a figure which shows the example of a structure and content of the resource correspondence table of the master data converter shown in FIG. It is a figure which shows the example of a structure and content of the resource correspondence table of the master data converter shown in FIG. It is a figure which shows the flowchart of the data conversion process in the master data converter shown in FIG. It is a figure which shows the example of the resource correspondence table for demonstrating the maintenance of the simplification master data shown in FIG. It is a figure which shows the example of the simplification master data for demonstrating the maintenance of the simplification master data shown in FIG. It is a figure which shows the example of the simplification master data for demonstrating the maintenance of the simplification master data shown in FIG. It is a figure which shows the example of the resource correspondence table for demonstrating the maintenance of the simplification master data shown in FIG. It is a figure which shows the example of the simplification master data for demonstrating the maintenance of the simplification master data shown in FIG. It is a figure which shows the example of the simplification master data for demonstrating the maintenance of the simplification master data shown in FIG. It is a figure which shows the example of the resource correspondence table for demonstrating the maintenance of the simplification master data shown in FIG. It is a figure which shows the example of the simplification master data for demonstrating the maintenance of the simplification master data shown in FIG.

<Embodiment>
FIG. 1 is an overall configuration diagram illustrating a master data conversion apparatus 1000 and its peripheral devices according to the embodiment.

  The schedule creation device 3000 creates a schedule for producing a plurality of products produced by one or more processes before each delivery date, and includes a simplified master data storage unit 2200, a plan master data storage unit 3200, an order A data storage unit 3300, a plan engine unit 3100, and a schedule storage unit 3400 are provided.

  The simplified master data storage unit 2200 stores simplified master data that is data indicating resources necessary for manufacturing (processing) a product. Usually, a resource is composed of a main resource and a sub resource. For example, the main resource is equipment, and the sub resource includes tools, jigs, personnel, and the like.

  Further, the plan master data storage unit 3200 stores data necessary for planning such as product manufacturing process and facility performance, and the order data storage unit 3300 stores order data including product type, quantity, delivery date, and the like. ing.

  The plan engine unit 3100 reads necessary data from the simplified master data storage unit 2200, the plan master data storage unit 3200, and the order data storage unit 3300, creates a schedule, and outputs the created schedule to the schedule storage unit 3400 To do.

  The planning engine unit 3100 creates a schedule by assigning equipment used in the process and a processing time zone to each process of the product. For example, when equipment (resources) is assigned to a process, a resource assigned to a process is created so that it is not assigned to another process at the same time.

  Master data conversion apparatus 1000 reads master data from master data storage unit 2000, creates a resource correspondence table and simplified master data, and stores them in resource correspondence table storage unit 2100 and simplified master data storage unit 2200, respectively. .

  The master data stored in the master data storage unit 2000 is data indicating resources necessary for manufacturing a product to be scheduled. The planning engine unit 3100 creates a schedule with reference to this master data.

  The simplified master data stored in the simplified master data storage unit 2200 is data created by the master data conversion apparatus 1000 from the master data, and is created according to the same format (data structure) as the master data. Therefore, the planning engine unit 3100 can create a schedule using the simplified master data instead of the master data.

  The simplified master data has the same amount of information as the master data, but has fewer data items than the master data. Therefore, the maintenance is easier than the master data.

  Here, before explaining the configuration of the functional blocks of the master data conversion apparatus 1000 of the present embodiment, the master data and the simplified master data will be explained.

<Master data and simplified master data>
FIG. 3 is a diagram illustrating a configuration example of the master data 2010 and a content example thereof, and FIG. 4 is a diagram illustrating a configuration example of the simplified master data 2210 and a content example thereof. FIG. 5 is a diagram showing a configuration example of the resource correspondence table 2110 and an example of its contents, and FIG. 6 is a diagram showing a configuration example of the resource correspondence table 2120 and an example of its contents.

  First, the master data 2010 in FIG. 3 will be described.

  The master data 2010 indicates resources necessary for manufacturing each product (item), and is stored in the master data storage unit 2000.

  The master data 2010 is expressed in the form of a matrix A (n rows m_a columns) as shown in FIG. The component A_ij of the matrix A is “1” when the type i requires the resource j, and “0” when it is not necessary. The type i indicates an item that is a type of product or intermediate (hereinafter simply referred to as “product”), n indicates the number of items, and m_a indicates the number of resources.

  Specifically, the master data 2010 includes items 2011 and resources 2012, and one record is registered for each item. The last record is a record created by the resource usage number calculation unit 1100 described later.

  An item 2011 indicates an identifier for specifying an item, that is, a product type, and is described as “model 1”, “model 2”, and the like in FIG.

  A resource 2012 indicates a resource necessary for manufacturing the product indicated by the item 2011.

  The resource 2012 includes subfields 2012-1 to 2012-15 of data items corresponding to the number of resources. In the subfield, a resource name “resource 1” or the like is set as an identifier for specifying the resource. The number of resources is the number of all resources necessary to manufacture all products indicated by the item 2011. That is, in FIG. 3, when 10 types of products “model 1” to “model 10” indicated by the item 2011 are manufactured, if there are 15 resources from “resource 1” to “resource 15”, the processing is performed. Indicates what can be done.

  When “1” is set in the sub-field of the resource 2012, it indicates that the resource indicated in the sub-field is necessary for manufacturing the product indicated by the model set as the item 2011 in the record. When “0” is set, it indicates that it is not necessary for manufacturing the product. For example, since “1” is set in the subfield 2012-1 of “resource 1” in the record in which the item 2011 is “model 1”, when the product indicated by “model 1” is manufactured, It indicates that the resource indicated by “resource 1” is necessary, and “0” is set in the subfield 2012-8 of “resource 8”, so that the resource indicated by “resource 8” is unnecessary. Show.

  Next, the simplified master data 2210 in FIG. 4 will be described.

  The simplified master data 2210 is expressed in the form of a matrix B (n rows and m_b columns) as shown in FIG. The component B_ij of the matrix B is “1” when the type i requires the resource group j, and “0” when it is not necessary. Note that n indicates the number of items, and m_b indicates the number of resource groups.

  Specifically, as with the master data 2010, the simplified master data 2210 indicates resources necessary for manufacturing the product indicated by each item, and one record is registered for each item. ing.

  The simplified master data 2210 is stored in the simplified master data storage unit 2200 and includes an item 2211 and a resource Gr2212.

  The item 2211 indicates an identifier for specifying the type of product, like the item 2011 of the master data 2010.

  The resource Gr 2212 indicates a resource group necessary for manufacturing the product indicated by the item 2211. The resource Gr 2212 includes subfields 2212-1 to 2212-9 of data items corresponding to the number of resource groups. In the subfield, a resource Gr name “resource Gr1” or the like is set as an identifier for specifying a resource group. The number of resource groups is the number of all resource groups for manufacturing all products indicated by the item 2211. That is, in FIG. 4, when manufacturing any one of 10 types of items “model 1” to “model 10” indicated by the item 2211, nine resources from “resource Gr source 1” to “resource Gr9” are displayed. Indicates that if there is a group, it can be manufactured.

  When “1” is set in the subfield of the resource Gr 2212, it indicates that the resource group indicated in the subfield is necessary for manufacturing the product indicated by the model set as the item 2211 in the record. When “0” is set, it indicates that it is not necessary for manufacturing the product.

  As described above, the master data 2010 and the simplified master data 2210 are common in that they have a data structure in a matrix format that associates items with resources necessary for manufacturing a product indicated by the items. Therefore, as shown in FIG. 1, scheduling can be performed using the simplified master data 2210 instead of the master data 2010. For example, consider the case where a “model 1” product is manufactured when creating a schedule. When using master data 2010 (see FIG. 3), among resources 2012, “resource 1”, “resource 2”, “resource 3”, “resource 4”, “resource 5”, “resource 6”, “ If the seven resources “resource 7” are not used in the manufacture of other products, it is determined that they can be used. On the other hand, when the simplified master data 2210 (see FIG. 4) is used, three resource groups “resource Gr1”, “resource Gr2”, and “resource Gr3” of the resource Gr2212 are used for manufacturing other products. If not, it is judged that it can be used.

  In this case, “resource 1” to “resource 7” and “resource Gr1” to “resource Gr3” are associated with each other in the resource correspondence table 2110 in FIG. 5 or the resource correspondence table 2120 in FIG. The resource correspondence table 2110 and the resource correspondence table 2120 both manage the correspondence between resources and resource groups, and show substantially the same contents. Accordingly, either one may be stored in the resource correspondence table storage unit 2100.

  The resource correspondence table 2110 is expressed in the form of a matrix C1 (m_a row 1 column). It is a matrix showing the resource Gr to which the resource i belongs.

  Specifically, the resource correspondence table 2110 includes a resource name 2111 and a resource Gr name 2112.

  The resource name 2111 indicates the resource name set in the sub-field of the resource 2012 in the master data 2010.

  The resource Gr name 2112 indicates the name of the resource group to which the resource indicated by the resource name indicated by the resource name 2111 belongs. This resource group name is the resource group name set in the subfield of the resource Gr 2212 in the simplified master data 2210.

  For example, since “resource Gr1” is set as the resource Gr name 2112 in the record in which “resource 1” is set in the resource name 2111, “resource 1” belongs to “resource Gr1”. Become.

  Next, the resource correspondence table 2120 includes a resource Gr name 2121 and a resource name 2122.

  The resource Gr name 2121 indicates the resource group name set in the subfield of the resource Gr 2212 in the simplified master data 2210.

  A resource name 2122 indicates a resource belonging to the resource group indicated by the resource Gr name 2121. The resource name 2122 includes a plurality of subfields, and resource names indicating resources belonging to the group are set in the subfields. This resource name is the resource name set in the sub-field of the resource 2012 in the master data 2010.

  For example, in the resource name 2122 of the record in which “resource Gr1” is set in the resource Gr name 2121, “resource 1”, “resource 2”, and “resource 3” are set in its subfields. The “resource Gr1” is composed of three resources of “resource 1”, “resource 2”, and “resource 3”.

  Here, for example, a case where a product of “Model 1” is manufactured as described above is considered. When using master data 2010 (see FIG. 3), among resources 2012, “resource 1”, “resource 2”, “resource 3”, “resource 4”, “resource 5”, “resource 6”, “ If the seven resources “resource 7” are not used in the manufacture of other products, it is determined that they can be used. On the other hand, when the simplified master data 2210 (see FIG. 4) is used, three resources Gr of “resource Gr1”, “resource Gr2”, and “resource Gr3” are used in the manufacture of other products. If not, it is judged that it can be used. Referring to the resource correspondence table 2120 in FIG. 6, “resource Gr1” is composed of “resource 1”, “resource 2”, and “resource 3”, and “resource Gr2” is “resource 4” and “resource 5”. “Resource Gr3” is composed of “Resource 6” and “Resource 7”. That is, the condition that the three resources Gr of “resource Gr1”, “resource Gr2”, and “resource Gr3” are not used in the manufacture of other products is “resource 1”, “resource 2”, “resource 3”. , “Resource 4”, “resource 5”, “resource 6”, and “resource 7” indicate the condition that they are not used in the manufacture of other products. That is, the combined information amount of the simplified master data 2210 and the resource correspondence table 2120 is the same as the information amount of the master data 2010.

  Therefore, even if the simplified master data 2210 is used instead of using the master data 2010, it is possible to perform the same scheduling as when the master data 2010 is used. Further, since the number of subfields of the resource Gr2212 of the simplified master data 2210 is smaller than the number of subfields of the resource 2012 of the master data 2010, data search can be performed in a shorter time, and as a result, a schedule is created. Time can be shortened.

  Hereinafter, the functional block configuration of the master data conversion apparatus 1000 of this embodiment will be described.

<Configuration>
FIG. 2 is a functional block diagram of the master data conversion apparatus 1000.

  The master data conversion device is, for example, a personal computer or the like configured with a microprocessor and its peripheral circuits, and functionally includes a control unit 1001, an operation unit 1002, a display 1003, a resource usage number calculation unit 1100, and resource usage. A comparison unit 1200, a resource group generation unit 1300, and a simplified master generation unit 1400 are provided.

  The control unit 1001 has a function of controlling each functional unit included in the master data conversion apparatus 1000 to perform data conversion processing and the like.

  The operation unit 1002 is a device that inputs a command for starting a data conversion program and the like, various commands such as a display instruction for master data and simplified master data, and the like to the master data conversion apparatus 1000. For example, a keyboard, a mouse, a touch panel, etc.

  The display 1003 is a device that outputs (presents) a command input from the operation unit 1002, the contents of master data, the contents of simplified master data, and the like. For example, a display device such as a CRT (Cathode Ray Tube) display, an LCD (Liquid Crystal Display), an organic EL (Electro Liminescence) display, and a plasma display.

  The resource usage number calculation unit 1100 reads the master data 2010 (see FIG. 3) from the master data storage unit 2000, calculates the number of items that require this resource for each resource from the read master data 2010, and calculates the total. Has a function to create a record. Specifically, the number of records in which “1” is set in the subfield of the resource 2012 is counted, and the count value is set in the total record that is the last record of the master data 2010. For example, in the case of “resource 7”, “1” is set in the sub-field of “resource 7” because there are three records “model 1”, “model 2”, and “model 3”. “3” is set in the total record column.

  The resource usage comparison unit 1200 groups resources having the same set of items (products) that require the resources, that is, resources having the same required items (products) into one group. It has a function to perform. Specifically, the master data 2010 in which the total record field is set by the resource usage number calculation unit 1100 is referred to, and for each resource having the same total value, whether or not the item (product) that requires the resource is the same. In comparison, all the corresponding items (products) are the same as one group.

  The resource group generation unit 1300 creates the resource correspondence table 2110 or the resource correspondence table 2120 from the grouping result of the resource usage comparison unit 1200, and uses the created resource correspondence table 2110 or the resource correspondence table 2120 as the resource correspondence table storage unit 2100. It has a function to memorize.

  The simplified master generation unit 1400 has a function of creating simplified master data 2210 from the master data 2010, the resource correspondence table 2110, and the like, and outputting the created simplified master data 2210 to the simplified master data storage unit 2200.

<Operation>
Hereinafter, the operation of the master data conversion apparatus 1000 will be described with reference to FIG.

  FIG. 7 is a flowchart of the data conversion process of the master data conversion apparatus 1000.

  The administrator operates the operation unit 1002 to input a command for instructing the creation of the simplified master data 2210 from the master data 2010 stored in the master data storage unit 2000. It is assumed that master data 2010 is stored in the master data storage unit 2000 in advance.

  Receiving the command via the operation unit 1002, the control unit 1001 instructs the resource usage number calculation unit 1100 to create simplified master data.

  Receiving the instruction, the resource usage number calculation unit 1100 reads the master data 2010 from the master data storage unit 2000 into the work area (step S10). This work area can be accessed from each functional unit of the master data conversion apparatus 1000.

  Here, in the following description, r_j is the number of items (products) that use the resource j for manufacturing, and R_j is all the components of the j columns of the matrix A that is the master data 2010. That is, R_j indicates all items (products) that require the resource j. Note that m_a is the number of resources.

  The resource usage number calculation unit 1100 that has read the master data 2010 calculates the number of required items for each resource. That is, a total record column which is the last record in FIG. 3 is created (step S11).

  Specifically, the resource usage number calculation unit 1100 calculates r_j, which is the number of items using the resource j, in the range of 1 ≦ j ≦ m_a from the matrix A that is the master data 2010. The calculation result of r_j is set in the total record.

  The resource usage number calculation unit 1100 that created the total record requests the resource usage comparison unit 1200 to perform grouping. Upon receiving the request, the resource usage comparison unit 1200 groups the resources required for manufacturing the same item into the same group.

  Specifically, the resource usage comparison unit 1200 sets 0 (zero) as the initial value to the number m_b of resource groups, and performs the following calculation in the range of 1 ≦ j1 and j2 ≦ m_a. However, j1 ≠ j2.

  First, the resource usage comparison unit 1200 compares the values of r_j1 and r_j2. That is, it is determined whether or not the number of items set in the total record in FIG. 3 is the same (step S12: NO, step S13).

  When r_j1 and r_j2 are equal (step S13: YES), the resource usage comparison unit 1200 compares R_j1 and R_j2 (step S14). That is, it is determined whether the resource j1 and the resource j2 are not only the number of items that require the resource but also the items.

  When R_j1 and R_j2 are equal (step S14: YES), the resource usage comparison unit 1200 sets the resource j1 and the resource j2 as the same resource group (step S15). Specifically, the resource usage comparison unit 1200 stores the resource Gr name and the resource name of the resource belonging to the group in association with each other in the work area. If either resource j1 or resource j2 already belongs to a resource group, make the other belong to that resource group, and if neither belongs to the resource group yet, create a resource group and make both belong Let

  On the other hand, when r_j1 and r_j2 are not equal (step S13: NO), or when R_j1 and R_j2 are not equal (step S14: NO), resource j1 and resource j2 belong to any resource group If there is no resource (step S16: NO), the resource usage comparison unit 1200 creates a new resource group (step S17). For example, when both the resource j1 and the resource j2 do not belong to the resource group, two new resource groups to which each of the resource j1 and the resource j2 belongs are created, and only the resource j2 does not belong to the resource group. In this case, one new resource group to which the resource j2 belongs is created. Specifically, the resource usage comparison unit 1200 creates a new resource group, and stores the resource Gr name and the resource names of resources belonging to the group in association with each other. Then, the resource usage comparison unit 1200 repeats the processing from step S12.

  In step S16, when both the resource j1 and the resource j2 belong to the resource group (step S16: YES), the resource usage comparison unit 1200 starts from step S12 without creating a new group. Repeat the process.

  If the resource usage comparison unit 1200 does not compare all resource combinations (step S12: NO), the processing from step S13 is repeated. On the other hand, when all the resource combinations are compared (step S12: YES), the resource usage comparison unit 1200 calculates the resource group number m_b, and creates the resource correspondence table 2110 or the resource correspondence table 2120 in the resource group generation unit 1300. Request. Since the process of step S13 is a process for speeding up the calculation, the process of step S13 may be performed after the process of step S12 without performing the process of step S13.

  Upon receiving the request, the resource group generation unit 1300 creates a resource correspondence table 2110 or a resource correspondence table 2120 based on the group created by the resource usage comparison unit 1200 and the calculated resource group number m_b with reference to the work area. And stored in the resource correspondence table storage unit 2100 (step S18).

  The resource group generation unit 1300 having the resource correspondence table 2110 or the resource correspondence table 2120 stored in the resource correspondence table storage unit 2100 requests the simplified master generation unit 1400 to create simplified master data 2210.

  Upon receiving the request, the simplified master generation unit 1400 creates simplified master data 2210 from the master data 2010 and the resource correspondence table 2110 or the resource correspondence table 2120 in accordance with the format of the matrix B, and the simplified master data 2210 is created. The data is stored in the data storage unit 2200 (step S19). Specifically, the simplified master generation unit 1400 represents simplified master data expressed in the form of a matrix B (n rows m_b columns), where n is the number of items, m_b is the number of resource groups calculated by the resource usage comparison unit 1200. 2210 is created. The simplified master generation unit 1400 sets “1” when the type i requires the resource group j as the component B_ij of the matrix B, and “0” when the type i is not necessary.

  The simplified master generation unit 1400 that has stored the simplified master data 2210 in the simplified master data storage unit 2200 notifies the control unit 1001 that the data conversion processing has been completed. Upon receiving the notification, the control unit 1001 displays on the display 1003 that the process has ended, and ends the process.

<Maintenance of simplified master data>
Hereinafter, the maintenance procedure of the simplified master data 2210 created as described above will be described.

  Compared to the correction to the master data 2010, the correction to the simplified master data 2210 with a smaller number of data items can be corrected more easily and at a higher speed. Here, two types of maintenance will be described. The first is a case where the resource Gr 2212 is added or deleted. The second is a case where an item (product) requiring the resource Gr is changed, in other words, a case where the use of the resource Gr is changed.

<Addition or deletion of resource group>
First, a case where the resource Gr 2212 is added or deleted will be described.

  For example, consider a case where “resource Gr1” in the resource correspondence table 2120-2 is deleted and “resource Gr10” is added from the simplified master data 2210 shown in FIG. 4 as shown in FIG. It is assumed that “resource 16” and “resource 17” belonging to “resource Gr10” are resources necessary for manufacturing products of “model 2” and “model 5”.

  In this case, first, “resource Gr1” is deleted from the simplified master data 2210 of FIG. 4, and simplified master data 2210-2 to which “resource Gr10” is added is created (see FIG. 9).

  Then, the simplified master data 2210-2 is regarded as master data 2010, and the master data conversion apparatus 1000 performs data conversion. Since the master data 2010 and the simplified master data 2210 have the same data structure, the master data conversion apparatus 1000 can convert the data by regarding the master data 2010 as the master data 2010.

  Hereinafter, a description will be given with reference to the flowchart of FIG.

  The administrator operates the operation unit 1002 to input a command instructing creation of the simplified master data 2210. It is assumed that the simplified master data 2210-2 is stored in the master data storage unit 2000. Also, it is assumed that the “resource Gr10” to be added is composed of “resource 16” and “resource 17”.

  Receiving the command via the operation unit 1002, the control unit 1001 instructs the resource usage number calculation unit 1100 to create simplified master data.

  Upon receiving the instruction, the resource usage number calculation unit 1100 includes the simplified master data 2210-2 from the master data storage unit 2000, and the configuration of the resource group to be added ("resource 16" and "resource 17" belong to "resource Gr10". Are read into the work area (step S10).

  The resource usage number calculation unit 1100 that has read the master data 2010 calculates the number of required items for each resource group (step S11). A total record field as the last record in FIG. 9 is created.

  The resource usage number calculation unit 1100 that created the total record requests the resource usage comparison unit 1200 to perform grouping. Upon receiving the request, the resource usage comparison unit 1200 performs grouping so that the resources Gr required for manufacturing the same item (product) are in the same group (steps S12 to S17).

  When comparing the combinations of all resources Gr (step S12: YES), the resource usage comparison unit 1200 requests the resource group generation unit 1300 to create the resource correspondence table 2110 or the resource correspondence table 2120, and receives the requested resource group The generation unit 1300 creates the resource correspondence table 2120-3 (see FIG. 11) and stores it in the resource correspondence table storage unit 2100 (step S18).

  Next, the simplified master generation unit 1400 obtains simplified master data 2210-3 (see FIG. 10) from the simplified master data 2210-2 and the resource correspondence table 2120-3 according to the matrix B format. Created and stored in the simplified master data storage unit 2200 (step S19).

  When the simplified master data is recreated, the resource Gr name is reassigned, but for the sake of convenience of explanation, the Gr name before reassignment will be described below.

  When the simplified master data 2210-2 is converted, the items that require the added “resource Gr10” are “model 2” and “model 5”, which are the same as “resource Gr7”. Therefore, “resource Gr10” is in the same group as “resource Gr7”, and “resource Gr10” is deleted as shown in simplified master data 2210-3 in FIG. “Resource 16” and “Resource 17” that belonged to “Resource Gr10” belong to “Resource Gr7”, and as shown in the resource correspondence table 2120-3 of FIG. “Resource 16” and “Resource 17” are set in the subfield of the resource name 2122 of the record “Gr7”.

  The created simplified master data 2210-3 can be used in scheduling instead of the master data 2010.

  Here, the case where the resource Gr is added to the simplified master data 2210 has been described. For example, as illustrated in FIG. 15, the simplified master in which “resource 20” and “resource 21” are added to the simplified master data 2210. Data 2210-6 may be created and regarded as master data 2010, and data conversion may be performed by the master data conversion apparatus 1000. In this case, “resource 20” is incorporated into “resource Gr7”, and “resource 21” is incorporated into “resource Gr4”.

<Change of items that require resource Gr>
Next, a case where an item that requires the resource Gr 2212 is changed will be described.

  For example, in the simplified master data 2210 shown in FIG. 4, a case where “resource Gr6” is required for manufacturing the “model 5” product and not required for manufacturing the “model 7” product.

  In this case, as shown in FIG. 12, the component of the “type 5” in the row and the “resource Gr6” in the column is rewritten from “0” to “1”, the “type 7” in the row and the “resource Gr6” in the column The simplified master data 2210-4 is created by rewriting the components from “1” to “0”.

  Then, the simplified master data 2210-4 is regarded as master data 2010, and the master data conversion apparatus 1000 performs data conversion.

  Hereinafter, a description will be given with reference to the flowchart of FIG.

  The administrator operates the operation unit 1002 to input a command instructing creation of the simplified master data 2210. It is assumed that the simplified master data 2210-4 is stored in the master data storage unit 2000.

  Receiving the command via the operation unit 1002, the control unit 1001 instructs the resource usage number calculation unit 1100 to create simplified master data.

  Receiving the instruction, the resource usage number calculation unit 1100 reads the simplified master data 2210-4 from the master data storage unit 2000 into the work area (step S10).

  The resource usage number calculation unit 1100 that has read the master data 2010 calculates the number of required items for each resource Gr (step S11). A total record that is the last record in FIG. 12 is created.

  The resource usage number calculation unit 1100 that created the total record requests the resource usage comparison unit 1200 to perform grouping. Upon receiving the request, the resource usage comparison unit 1200 groups the resources Gr required from the same item into the same group (steps S12 to S17).

  When comparing the combinations of all resources Gr (step S12: YES), the resource usage comparison unit 1200 requests the resource group generation unit 1300 to create the resource correspondence table 2110 or the resource correspondence table 2120, and receives the requested resource group The generation unit 1300 creates the resource correspondence table 2120-4 (see FIG. 14) and stores it in the resource correspondence table storage unit 2100 (step S18).

  Next, the simplified master generating unit 1400 obtains simplified master data 2210-5 (see FIG. 13) from the simplified master data 2210-4 and the resource correspondence table 2120-4 according to the format of the matrix B. Created and stored in the simplified master data storage unit 2200 (step S19).

  When the simplified master data 2210-4 is converted into data, the items that require “resource Gr6” whose items have been changed are “model 2” and “model 5”, and are the same as the items that require “resource Gr7”. It has become. Accordingly, since “resource Gr7” belongs to “resource Gr6”, “resource Gr7” is deleted as shown in the simplified master data 2210-5 in FIG. Since “resource 13” belonging to “resource Gr7” belongs to “resource Gr6”, the resource name of the record whose resource Gr name 2121 is “resource Gr6” as shown in the resource correspondence table 2120-4 of FIG. “Resource 13” is added to the sub-field of 2122.

  In this way, by creating simplified master data with fewer items from master data, even if the master data items become enormous, simplification that can be used in place of master data and can be maintained in a short time Master data can be provided.

  In order to express the present invention, the present invention has been properly and fully described through the embodiments with reference to the drawings. However, those skilled in the art can easily change and / or improve the above-described embodiments. It should be recognized that this is possible. Therefore, unless the modifications or improvements implemented by those skilled in the art are at a level that departs from the scope of the claims recited in the claims, the modifications or improvements are not covered by the claims. To be construed as inclusive.

1000 Master Data Conversion Device 1002 Operation Unit 1003 Display 1100 Resource Usage Number Calculation Unit 1200 Resource Usage Comparison Unit 1300 Resource Group Generation Unit 1400 Simplified Master Generation Unit 2000 Master Data Storage Unit 2100 Resource Correspondence Table Storage Unit 2200 Simplified Master Data Storage Unit 3000 Schedule creation device 3100 Planning engine unit 3200 Planning master data storage unit 3300 Order data storage unit 3400 Schedule storage unit

Claims (3)

A data conversion device for converting master data having a data structure configured by associating a plurality of resources necessary for processing a product with the product,
The resource is associated with one or more products;
Resource group generation means for grouping resources having the same associated products among the resources into one resource group;
A simplified master data generating unit that associates the resource group grouped by the resource group generating unit with the product and generates new simplified master data having the same data structure as the data structure ;
A simplified master that generates second simplified master data by deleting a resource group, adding a resource group, or changing a product associated with the resource group with respect to the simplified master data. Change means,
Equipped with a,
The resource group generation means sets, as one new resource group, resource groups having the same associated products among the new simplified master data resource groups generated by the simplified master changing means. Group,
The simplified master data generating means generates a third simplified master data by associating the new resource group generated by the resource group generating means with the product;
Data conversion device. A data conversion apparatus having a data structure configured by associating each of a plurality of resources required for processing a product with the product, and the resource converting master data associated with one or more products The data conversion method used in
A resource group generation step of grouping resources having the same associated products among the resources into one resource group;
A simplified master data generating step for associating the resource group grouped in the resource group generating step with the product and generating new simplified master data having the same data structure as the data structure ;
A simplified master that generates second simplified master data by deleting a resource group, adding a resource group, or changing a product associated with the resource group with respect to the simplified master data. Change steps,
Equipped with a,
In the resource group generation step, among the new simplified master data resource groups generated in the simplified master change step, a resource group having the same associated products is designated as one new resource group. Grouped as
In the simplified master data generation step, the new resource group generated in the resource group generation step is associated with the product to generate third simplified master data.
Data conversion method. A data conversion apparatus having a data structure configured by associating each of a plurality of resources required for processing a product with the product, and the resource converting master data associated with one or more products A data conversion program used in
A resource group generation process that groups resources associated with the same product among the resources into one resource group;
A simplified master data generation process for generating new simplified master data having the same data structure as the data structure by associating the resource group grouped in the resource group generation step with the product;
A simplified master that generates second simplified master data by deleting a resource group, adding a resource group, or changing a product associated with the resource group with respect to the simplified master data. Change processing,
To the computer,
In the resource group generation process, among the new simplified master data resource groups generated by the simplified master change process, the resource groups having the same associated products are assigned as one new resource group. Grouped as
In the simplified master data generation process, a new resource group generated in the resource group generation process is associated with the product to generate third simplified master data.
Data conversion program.

Images