Information management system and option management apparatus

An information management system comprising one or more processors configured to function as:

• a first control section configured to perform
• first processing of assigning option IDs to combinations of item names and item values of fields constituting a record, the option IDs being different for each of the fields, and producing option master data pieces each including the option ID, the item name, and the item value,
• second processing of producing, for each one of the fields, related option master data pieces by setting the option ID of each of the other fields as a related option ID, the number of the produced related option master data pieces corresponding to the number of the other fields, and
• third processing of registering the option master data pieces and the related option master data pieces in a predetermined storage area;
• and
• a second control section configured to
• output, on a search screen showing the fields set as search items, the item values as options of the search items, and
• when an option is specified in a first search item, extract at least one of the related option master data pieces that includes the option ID of the specified option as the related option ID, and output, as an option of a second search item, the item value of the option ID linked to the extracted at least one related option master data piece,
• wherein the record is manufacturing achievement data and includes a first field indicating a manufacturing place of products, a second field indicating a line where a process operation is performed, a third field indicating details of a process operation, a fourth field indicating a facility used in a process operation, a fifth field indicating a product number assigned to products of the same type, a sixth field indicating a date and time of a process, and a seventh field indicating an end date and time associated with the start date and time, and
• the first control section is configured to perform the first processing, the second processing, and the third processing on a new record at a timing of registration of the new record as the manufacturing achievement data or a timing at predetermined time intervals.

A non-transitory computer readable recording medium storing a program comprising instructions executable by a computer, wherein the instructions, when executed by the computer, cause the computer to provide:

• a first function of assigning option IDs to combinations of item names and item values of fields constituting a record, the option IDs being different for each of the fields, and producing option master data pieces each including the option ID, the item name, and the item value;
• a second function of producing, for each one of the fields, related option master data pieces by setting the option ID of each of the other fields as a related option ID, the number of the produced related option master data pieces corresponding to the number of the other fields;
• a third function of registering the option master data pieces and the related option master data pieces in a predetermined storage area;
• and
• a fourth function of outputting, on a search screen showing the fields set as search items, the item values as options of the search items, and when an option is specified in a first search item, extracting at least one of the related option master data pieces that includes the option ID of the specified option as the related option ID, and outputting, as an option of a second search item, the item value of the option ID linked to the extracted at least one related option master data piece,
• wherein the instructions cause the computer to provide the first function of
• producing, when records have different item values in the same fields, the option master data pieces as many as the different item values, and
• producing, when the records have the same item values in the same fields, the option master data pieces so as to avoid duplicate combinations of item names and item values of the fields, and
• wherein the instructions cause the computer to produce, from one of the records, for each one of the fields, the related option master data piece including the option ID of each of the other fields set as the related option ID by
• determining whether data to be produced is identical to any of the related option master data pieces already produced from any of the other records, and
• when it is determined that the data is identical, performing control not to produce duplicate related option master data.

An option management apparatus comprising one or more processors configured to function as:

• a first processing section configured to assign option IDs to combinations of item names and item values of fields constituting a record, the option IDs being different for each of the fields, and produce option master data pieces each including the option ID, the item name, and the item value;
• a second processing section configured to produce, for each one of the fields, related option master data pieces by setting the option ID of each of the other fields as a related option ID, the number of the produced related option master data pieces corresponding to the number of the other field;
• and
• a third processing section configured to register the option master data pieces and the related option master data pieces in a predetermined storage area,
• wherein, on a search screen showing the fields set as search items, when one of options is specified in a first search item where the item values are output as the options, the related option master data pieces are referred to extract at least one option in a second search item associated with the first search item and are used to extract the option ID including, as the related option ID, the option ID of the option specified in the first search item,
• wherein the first processing section is configured to
• produce, when records have different item values in the same fields, the option master data pieces as many as the different item values, and
• produce, when the records have the same item values in the same fields, the option master data pieces so as to avoid duplicate combinations of item names and item values of the fields, and
• where the second processing section is further configured to
• produce, from one of the records, for each one of the fields, the related option master data piece including the option ID of each of the other fields set as the related option ID by
• determining whether data to be produced is identical to any of the related option master data pieces already produced from any of the other records, and
• when it is determined that the data is identical, performing control not to produce duplicate related option master data.

A non-transitory computer readable recording medium storing a program comprising instructions executable by a computer, wherein the instructions, when executed by the computer, cause the computer to provide:

• a first function of assigning option IDs to combinations of item names and item values of fields constituting a record, the option IDs being different for each of the fields, and producing option master data pieces each including the option ID, the item name, and the item value;
• a second function of producing, for each one of the fields, related option master data pieces by setting the option ID of each of the other fields as a related option ID, the number of the produced related option master data pieces corresponding to the number of the other fields;
• a third function of registering the option master data pieces and the related option master data pieces in a predetermined storage area;
• and
• a fourth function of outputting, on a search screen showing the fields set as search items, the item values as options of the search items, and when an option is specified in a first search item, extracting at least one of the related option master data pieces that includes the option ID of the specified option as the related option ID, and outputting, as an option of a second search item, the item value of the option ID linked to the extracted at least one related option master data piece,
• wherein the record is manufacturing achievement data and includes a first field indicating a manufacturing place of products, a second field indicating a line where a process operation is performed, a third field indicating details of a process operation, a fourth field indicating a facility used in a process operation, a fifth field indicating a product number assigned to products of the same type, a sixth field indicating a date and time of a process, and a seventh field indicating an end date and time associated with the start date and time, and
• the instructions cause the computer to perform the first function, the second function, and the third function on a new record at a timing of registration of the new record as the manufacturing achievement data or a timing at predetermined time intervals.

An option management apparatus comprising one or more processors configured to function as:

• a first processing section configured to assign option IDs to combinations of item names and item values of fields constituting a record, the option IDs being different for each of the fields, and produce option master data pieces each including the option ID, the item name, and the item value;
• a second processing section configured to produce, for each one of the fields, related option master data pieces by setting the option ID of each of the other fields as a related option ID, the number of the produced related option master data pieces corresponding to the number of the other field;
• and
• a third processing section configured to register the option master data pieces and the related option master data pieces in a predetermined storage area,
• wherein, on a search screen showing the fields set as search items, when one of options is specified in a first search item where the item values are output as the options, the related option master data pieces are referred to extract at least one option in a second search item associated with the first search item and are used to extract the option ID including, as the related option ID, the option ID of the option specified in the first search item,
• the record is manufacturing achievement data and includes a first field indicating a manufacturing place of products, a second field indicating a line where a process operation is performed, a third field indicating details of a process operation, a fourth field indicating a facility used in a process operation, a fifth field indicating a product number assigned to products of the same type, a sixth field indicating a date and time of a process, and a seventh field indicating an end date and time associated with the start date and time, and
• the first processing section, the second processing section, and the third processing section are configured to perform processing on a new record at a timing of registration of the new record as the manufacturing achievement data or a timing at predetermined time intervals.