Abstract: In a screen generation system (100), an item name management unit (201) stores item name information (211) that defines a correspondence relation between a 5 master item name being a fixed item name and a used item name being a variable item name. A data acquisition unit (420) acquires, from a database (300), an item name set for each item in a table (301) and data stored in each item in the table (301). An item name conversion unit (431) refers to the item name information (211) stored in the item name management unit (201), so as to identify a master item name coiTesponding to the 10 same used item name as the item name acquired by the data acquisition unit (420), and converts the item name acquired by the data acquisition unit (420) into the identified master item name. A screen generation unit (440) generates a screen (441) to display the item name after being converted by the item name conversion unit (431) and the data acquired by the data acquisition unit (420).
Description
Title of Invention:
SCREEN GENERATION SYSTEM, SCREEN GENERATION METHOD, AND 5 SCREEN GENERATION PROGRAM
Technical Field
[0001] The present invention relates to a screen generation system, a screen generation method, and a screen generation program.
10
Background Art
[0002] Conventionally, there is a system that performs production management across a plurality of factories (for example, see Patent Literature 1). In this system, each factory is connected with a production management side via a network. Data of
15 production results of each factory is assembled in the production management side using item names and formats which are unified. The item names are, specifically, item names in a table of a database. The formats are, specifically, formats of data stored in the table of the database.
20 Citation List
Patent Literature
[0003] Patent Literature 1: JP 2006-221305 A
Summary of Invention 25 Technical Problem
2
[0004] In the conventional system, it is premised that the item names and formats in
the database to store the data of the production results of each factory are fixed. By
unifying the item names and formats in the databases of all the factories, production
states of all the factories can be managed in the production management side. If the 5 item names and formats in the databases vary among the factories, differences in the
item names and formats among the factories are absorbed by converting the item names
and formats. However, only predetermined item names and formats can be converted,
so that each factory cannot change an item name and a format without permission from
the production management side. 10 [0005] In an actual manufacturing site such as a factory, improvement activities are
performed daily and the improvement activities are never ending. If the item names
and formats in the database are fixed, the flexibility of data management required in the
site is restricted.
[0006] It is an object of the present invention to flexibly deal with a change in an item 15 name when a screen to display data stored in each item in a table of a database is
generated.
Solution to Problem
[0007] A screen generation system according to one aspect of the present invention
includes:
20 an item name management unit to store item name information that defines a
correspondence relation between a master item name being a fixed item name and a
used item name being a variable item name;
a database having a table consisting of items for each of which an item name is
set, the database storing data in each item in the table;
25 a data acquisition unit to acquire, from the database, the item name set for each
3
item in the table and the data stored in each item in the table;
an item name conversion unit to refer to the item name information stored in
the item name management unit, so as to identify a master item name corresponding to
a same used item name as the item name acquired by the data acquisition unit, and 5 convert the item name acquired by the data acquisition unit into the identified master
item name; and
a screen generation unit to generate a screen to display the item name after
being converted by the item name conversion unit and the data acquired by the data
acquisition unit. 10 Advantageous Effects of Invention
[0008] In the present invention, a correspondence relation between a master item name
being a fixed item name and a used item name being a variable item name is defined.
When data stored in each item in a table of a database is displayed, a master item name
corresponding to the same used item name as the item name set for each item is 15 displayed together with the data. Therefore, according to the present invention, it is
possible to flexibly deal with a change in an item name when a screen to display the
data stored in each item in the table of the database is generated.
Brief Description of Drawings
20 [0009] Fig. 1 is a block diagram illustrating a configuration of a screen generation system according to a first embodiment;
Fig. 2 is a block diagram illustrating a configuration of a factory management apparatus of the screen generation system according to the first embodiment; Fig. 3 is a block diagram illustrating a configuration of an integrated 25 management apparatus of the screen generation system according to the first
4
embodiment;
Fig. 4 is a flowchart illustrating operation of the screen generation system according to the first embodiment;
Fig. 5 is a flowchart illustrating operation of the screen generation system 5 according to the first embodiment;
Fig. 6 is a diagram illustrating an example of item name information before being updated and item name information after being updated according to the first embodiment;
Fig. 7 is a diagram illustrating an example of a change history of item names 10 according to the first embodiment;
Fig. 8 is a diagram illustrating an example of format information before being updated and format information after being updated according to the first embodiment;
Fig. 9 is a diagram illustrating an example of a change history of formats
according to the first embodiment;
15 Fig. 10 is a diagram illustrating an example in which a production management
screen is generated from report tables of a plurality of factories by the screen generation system according to the first embodiment;
Fig. 11 is a diagram illustrating an example of a selection screen according to
the first embodiment;
20 Fig. 12 is a diagram illustrating an example of the item name information
before being updated and the item name information after being updated according to the first embodiment;
Fig. 13 is a diagram illustrating an example of the change history of the item
names according to the first embodiment;
25 Fig. 14 is a diagram illustrating an example of the item name information
5
before being updated and the item name information after being updated according to the first embodiment;
Fig. 15 is a diagram illustrating an example of the change history of the item
names according to the first embodiment;
5 Fig. 16 is a block diagram illustrating a configuration of a screen generation
system according to a second embodiment;
Fig. 17 is a block diagram illustrating a configuration of a screen generation system according to a third embodiment;
Fig. 18 is a block diagram illustrating a configuration of a factory management 10 apparatus of the screen generation system according to the third embodiment;
Fig. 19 is a block diagram illustrating a configuration of a screen generation system according to a fourth embodiment; and
Fig. 20 is a diagram illustrating an example of a hardware configuration of the factory management apparatus and the integrated management apparatus of each of the 15 screen generation systems according to the embodiments of the present invention.
Description of Embodiments
[0010] Embodiments of the present invention will be described hereinafter with
reference to the drawings. Note that like reference numerals denote like or 20 corresponding parts throughout the drawings. In the description of the embodiments,
descriptions of like or corresponding parts may be omitted or simplified as appropriate.
[0011] First Embodiment
A configuration of a system according to this embodiment, operation of the
system according to this embodiment, and effects of this embodiment will be 25 sequentially described hereinafter.
6
[0012] *** Description of Configuration ***
With reference to Fig. 1, a configuration of a screen generation system 100 being the system according to this embodiment will be described. [0013] The screen generation system 100 is a system that optimizes the production 5 management of a factory A 110 and a factory B 120 as a plurality of factories by
utilizing a cloud 130. The cloud 130 is a cloud computing system. The cloud 130 is used by an administrator who performs the production management across the plurality of factories. The cloud 130 is connected, via a network 140, with the factoryA 110 and the factory B 120 as the factories to be managed. Note that the number of
10 factories is not limited to two, and may be one, or may be three or more.
[0014] The screen generation system 100 has a factory management apparatus 200 and a database 300 in each of the factoryA 110 and the factory B 120. The factory management apparatus 200 manages item names and formats in the database 300 of each factory. The database 300 stores data of production results. The factory
15 management apparatus 200 and the database 300 are connected with each other in each factory. When a change occurs in an item name or a format in the database 300 of each factory, the factory management apparatus 200 manages the change. [0015] The screen generation system 100 has an integrated management apparatus 400 and a database 500 in the cloud 130. The integrated management apparatus 400
20 cooperates with each of the factory management apparatuses 200 of ail the factories,
namely, the factoryA 110 and the factory B 120 in this embodiment. The database 500 stores data of the database 300 transmitted from each of the factoryA 110 and the factory B 120. The integrated management apparatus 400 and the database 500 are connected with each other in the cloud 130.
25 [0016] With reference to Fig. 2, a configuration of the factory management apparatus
7
200 will be described.
[0017] The factory management apparatus 200 has an item name management unit
201 to manage item names, an item name change management unit 202 to manage a
change history 221 of the item names, a format management unit 203 to manage
5 formats, a format change management unit 204 to manage a change history 222 of the formats, an item addition unit 205 to cause addition of a new item to be reflected in the item name management unit 201, an item name update unit 206 to cause a change in an item name to be reflected in the item name management unit 201, and a format update unit 207 to cause a change in a format to be reflected in the format management unit
10 203.
[0018] With reference to Fig. 3, a configuration of the integrated management apparatus 400 will be described.
[0019] The integrated management apparatus 400 has a change management unit 410 to manage a change in the database 300 of each factory, a data acquisition unit 420 to
15 acquire data from the database 300 of each factory, a data conversion unit 430 to
convert an item name and a format, and a screen generation unit 440 to automatically generate a production management screen for the administrator to compare production states. The change management unit 410 has an item name change management unit 411 to manage a change in an item name, a format change management unit 412 to
20 manage a change in a format, and an additional item management unit 413 to manage an additional item. The data conversion unit 430 has an item name conversion unit 431 to convert an item name and a format conversion unit 432 to convert a format. [0020] As illustrated in Fig. 1, the cloud 130 is connected with a screen output apparatus 150. The screen output apparatus 150 outputs the production management
25 screen generated by the screen generation unit 440.
8
[0021] As described above, the screen generation system 100 has the item name management unit 201, the database 300, the data acquisition unit 420, the item name conversion unit 431, and the screen generation unit 440.
[0022] The item name management unit 201 stores item name information 211 that 5 defines a correspondence relation between a master item name being a fixed item name and a used item name being a variable item name. The database 300 has a table 301 consisting of items for each of which an item name is set. Data is stored in each item in the table 301. In this embodiment, the data is data of the production results of each factory. The data acquisition unit 420 acquires, from the database 300, the item name
10 set for each item in the table 301 and the data stored in each item in the table 301. The item name conversion unit 431 refers to the item name information 211 stored in the item name management unit 201, so as to identify a master item name corresponding to the same used item name as the item name acquired by the data acquisition unit 420. The item name conversion unit 431 converts the item name acquired by the data
15 acquisition unit 420 into the identified master item name. The screen generation unit 440 generates a screen 441 to display the item name after being converted by the item name conversion unit 431 and the data acquired by the data acquisition unit 420. In this embodiment, the screen 441 is the production management screen described above. [0023] The screen generation system 100 further has the item name update unit 206.
20 [0024] When the item name set for one of the items in the table 301 is changed, the
item name update unit 206 updates, in the item name information 211 stored in the item name management unit 201, the same used item name as the item name before being changed to an item name after being changed. [0025] The screen generation system 100 further has the format management unit 203
25 and the format conversion unit 432.
9
[0026] The format management unit 203 stores format information 212 that defines a correspondence relation between a master format being a fixed format and a used format being a variable format. The format conversion unit 432 refers to the format information 212 stored in the format management unit 203, so as to identify a master 5 format corresponding to the same used format as the format used in the data acquired by the data acquisition unit 420. The format conversion unit 432 converts the data acquired by the data acquisition unit 420 into data in the identified master format. The screen 441 generated by the screen generation unit 440 is a screen to display the item name after being converted by the item name conversion unit 431 and the data after
10 being converted by the format conversion unit 432.
[0027] The screen generation system 100 further has the format update unit 207. [0028] When the format used in the data stored in one of the items in the table 301 is changed, the format update unit 207 updates, in the format information 212 stored in the format management unit 203, the same used format as the format before being changed
15 to a format after being changed.
[0029] Note that if the data in the database 300 of each factory is duplicated in the database 500 in the cloud 130, the same table 301 as that in the database 300 also exists in the database 500. In this case, the database 500 in the cloud 130 can substitute for the database 300 of each factory.
20 [0030] If the database 500 in the cloud 130 substitutes for the database 300 of each factory, the item name management unit 201 and the item name update unit 206, which are included in the factory management apparatus 200 of each factory in this embodiment, may be included in the integrated management apparatus 400 in the cloud 130. That is, the item name management unit 201 and the item name update unit 206
25 may be implemented in the cloud 130.
10
[0031] Similarly, if the database 500 in the cloud 130 substitutes for the database 300 of each factory, the format management unit 203 and the format update unit 207, which are included in the factory management apparatus 200 of each factory in this embodiment, may be included in the integrated management apparatus 400 in the cloud 5 130. That is, the format management unit 203 and the format update unit 207 may be implemented in the cloud 130.
[0032] If the database 500 in the cloud 130 substitutes for the database 300 of each factory, the data acquisition unit 420 may acquire the item name set for each item in the table 301 and the data stored in each item in the table 301 from the database 500 in the
10 cloud 130.
[0033] The data acquisition unit 420, the item name conversion unit 431, the format conversion unit 432, and the screen generation unit 440, which are included in the integrated management apparatus 400 in the cloud 130 in this embodiment, may be included in the factory management apparatus 200 of one of the factories.
15 [0034] The screen generation system 100, which is applied to the production management of factories in this embodiment, may be applied to any type of management other than the production management of factories, such as the operation management of offices and the sales management of shops. [0035] *** Description of Operation ***
20 With reference to Fig. 4 and Fig. 5, the operation of the screen generation
system 100 will be described. The operation of the screen generation system 100 is equivalent to a screen generation method according to this embodiment. The operation of the screen generation system 100 is equivalent to a processing procedure of a screen generation program according to this embodiment.
25 [0036] In the following description, the database 300 of each factory will be referred
11
to as the ''factory DB", and the database 500 in the cloud 130 will be referred to as the "cloud DB".
[0037] Although not illustrated, as an initial operation, the screen generation system 100 collects information in the factory DB of each factory into the cloud DB. The 5 screen generation system 100 generates, by schema matching, a comparison screen for performing the production management. In the comparison screen, match confirmation on item names and formats as well as modification thereof as required are performed manually. The "match confirmation" means to check correctness of a correspondence relation between a master item name and a used item name and a
10 correspondence relation between a master format and a used format that are defined by schema matching using an item name and a format used in the table 301 of the factory DB as the used item name and the used format, respectively. Any incorrect correspondence relation is corrected. The definitions of the correspondence relations corrected as appropriate are given to the item name management unit 201 and the
15 format management unit 203 as the item name information 211 and the format information 212, respectively.
[0038] In Sll, it is assumed that a change has occurred in the table 301 of the factory DB. [0039] In SI 2, it is determined whether the type of the change in Sll is an item name
20 change. If it is an item name change, the flow proceeds to S13. If it is not an item name change, the flow proceeds to S18.
[0040] In S13, it is detennined whether the type of the change in Sll is deletion of an existing item. If it is deletion of an existing item, the flow proceeds to S34. If it is not deletion of an existing item, the flow proceeds to S14.
25 [0041] S14 to S17 arc an item name update process, hi the item name update
12
process, the item name infonnation 211 and the change history 221 of the item names are updated. Fig. 6 illustrates an example of the item name infonnation 211 before being updated and the item name information 211 after being updated. Fig. 7 illustrates an example of the change history 221 of the item names. 5 [0042] In S14, the item name update unit 206 queries the item name management unit 201 about the identifier (ID) of the changed portion. That is, the item name update unit 206 acquires the item name ID that identifies the changed item name from the item name information 211 stored in the item name management unit 201. In the item name information 211, item names used in the production management screen are master item
10 names, and item names used in the factory DB are used item names. One master item name corresponds to one used item name with regard to each item name ID. In the example in Fig. 6, before the change in the item name, the item name information 211 indicates that the master item name "Date-time" conesponds to the used item name "Datetime" with regard to the item name ID "1".
15 [0043] In SI5, the item name update unit 206 updates, in the item name infonnation 211 stored in the item name management unit 201, the same used item name as the item name before being changed to an item name after being changed. In the example in Fig. 6, the used item name "Datetime" is changed to "Time" and the item name update unit 206 updates, in the item name information 211, the used item name "Datetime" of
20 the item name ID "I" acquired in S14 to "Time". Therefore, after the change in the item name, the item name information 211 indicates that the master item name "Datetime" conesponds to the used item name "Time" with regard to the item name ID "1". [0044] In SI6, the item name update unit 206 adds new information to the change
25 history 221 stored in the item name change management unit 202. In the change
13
history 221, a date together with an item name before being changed and an item name after being changed on the date are recorded with regard to each item name ID. In the example in Fig. 7, changing of the item name "Datetime" to "Time11 on the date "20140501" is recorded in the change history 221 with regard to the item name ID "1". 5 The change history 221 is referred to in order to check a correspondence relation between a previous item name and a master item name when the production management screen is generated by using a backup or the like of the table 301 before a change in an item name. [0045] In SI7, the item name update unit 206 notifies the integrated management
10 apparatus 400 of the change. After SI 7, the flow proceeds to S23.
[0046] In S18, it is determined whether the type of the change in Sll is a format change. If it is a format change, the flow proceeds to S19. If it is not a format change, the flow proceeds to S25. [0047] S19 to S22 are a fonnat update process. In the format update process, the
15 fonnat information 212 and the change history 222 of the formats are updated. Fig. 8 illustrates an example of the format information 212 before being updated and the format information 212 after being updated. Fig. 9 illustrates an example of the change history 222 of the formats. [0048] In S19, the fonnat update unit 207 queries the format management unit 203
20 about the ID of the changed portion. That is, the format update unit 207 acquires the format ID that identifies the changed format from the format information 212 stored in the format management unit 203. In the format information 212, formats used in the production management screen are master formats, and formats used in the factory DB are used formats. One master format corresponds to one used fonnat with regard to
25 each format ID. In the example in Fig. 8, before the change in the format, the fonnat
14
information 212 indicates that the master format "YYYYMMDD" corresponds to the used format "YYYYMMDD" with regard to the format ID "1". [0049] hi S20, the format update unit 207 updates, in the format information 212 stored in the format management unit 203, the same used format as the format before 5 being changed to a format after being changed. In the example in Fig. 8, the used
format "YYYYMMDD" is changed to "MMDDYYYY" and the format update unit 207 updates, in the format information 212, the used format "YYYYMMDD" of the format ID "1" acquired in S19 to "MMDDYYYY". Therefore, after the change in the format, the format information 212 indicates that the master format "YYYYMMDD"
10 corresponds to the used format "MMDDYYYY" with regard to the format ID "1".
[0050] In S21, the format update unit 207 adds new information to the change history 222 stored in the format change management unit 204. In the change history 222, a date together with a format before being changed and a format after being changed on the date are recorded with regard to each format ID. In the example in Fig. 9,
15 changing of the format "YYYYMMDD" to "MMDDYYYY" on the date "20140501" is recorded in the change history 222 with regard to the format ID "1". The change history 222 is referred to in order to check a correspondence relation between a previous format and a master format when the production management screen is generated using a backup or the like of the table 301 before a change in a format.
20 [0051] In S22, the format update unit 207 notifies the integrated management apparatus 400 of the change.
[0052] S23 is a data acquisition process, an item name conversion process, and a format conversion process. [0053] In S24, the data acquisition unit 420 acquires, from the database 300, the item
25 name set for each item in the table 301 and the data stored in each item in the table 301.
15
The item name conversion unit 431 refers to the item name information 211 stored in the item name management unit 201, so as to identify a master item name corresponding to the same used item name as the item name acquired by the data acquisition unit 420. In the example in Fig. 6, when the item name "Time" is acquired 5 from the table 301 by the data acquisition unit 420, the master item name "Datetime" corresponding to the same used item name "Time" as the acquired item name is identified by the item name conversion unit 431. The item name conversion unit 431 converts the item name acquired by the data acquisition unit 420 into the identified master item name. The format conversion unit 432 refers to the format information
10 212 stored in the format management unit 203, so as to identify a master format
corresponding to the same used format as the format used in the data acquired by the data acquisition unit 420. In the example in Fig. 8, when the data in the format "MMDDYYYY" is acquired from the table 301 by the data acquisition unit 420, the master format "YYYYMMDD" corresponding to the same used format
15 "MMDDYYYY" as the format of the acquired data is identified by the format
conversion unit 432. Note that the format conversion unit 432 may analyze the data acquired by the data acquisition unit 420 to determine the format used in the data, or may refer to meta-information of the table 301 to determine the format used in the data. The format conversion unit 432 converts the data acquired by the data acquisition unit
20 420 into data in the identified master format.
[0054] S24 is a screen generation process. In the screen generation process, the production management screen is generated. Fig. 10 illustrates an example in which the production management screen is generated from report tables of the plurality of factories.
25 [0055] In S24, the screen generation unit 440 generates the production management
16
screen being the screen 441 to display the item name after being converted by the item name conversion unit 431 and the data acquired by the data acquisition unit 420. In the example in Fig. 10, the production management screen displays the data "20140820" of the factory A 110 whose format has been converted from 5 "MMDDYYYY" to the master format "YYYYMMDD", as the data of the item under the master item name "Datetime" which corresponds to the item name "Time" in the report table of the factory All 0 being the table 301. After S24, the flow ends. [0056] In S25, it is determined whether the type of the change in S11 is addition of a new item. If it is addition of a new item, the flow proceeds to S27. If it is not
10 addition of a new item, the flow proceeds to S26.
[0057] In S26, the administrator of the integrated management apparatus 400 is notified that a change other than a change in an item name or a format has occurred in the table 301 of the factory DB. Therefore, the administrator can deal with a case where an unexpected change or the like has occurred.
15 [0058] S27 to S32 are an item addition process.
[0059] In S27, the item addition unit 205 outputs a selection screen 230 for selecting a master item corresponding to the additional item to a user who performs data management at the factory. Fig. 11 illustrates an example of the selection screen 230. [0060] In S28, it is determined whether the master item corresponding to the
20 additional item has been selected by the user. If the master item has been selected, the flow proceeds to S29. If there is no corresponding master item and "None" has been selected, the flow proceeds to S33.
[0061] In the item addition process, if the master item corresponding to the additional item is selected, the item name information 211 and the change history 221 of the item
25 names are updated. Fig. 12 illustrates an example of the item name infonnation 211
17
before being updated and the item name information 211 after being updated. Fig. 13
illustrates an example of the change history 221 of the item names.
[0062] In S29, the item addition unit 205 queries the item name management unit 201
about an unused ID. That is, the item addition unit 205 identifies an unused item name 5 ID in the item name information 211 stored in the item name management unit 201. In
the example in Fig. 12, before the change in the item name, the item name ID "3" is not
used.
[0063] In S30, the item addition unit 205 adds, as the used item name, the item name
of the additional item and adds, as the master item name, the item name of the master 10 item selected in the selection screen 230 to the item name information 211 stored in the
item name management unit 201. In the example in Fig. 12, it is added to the item
name information 211 that the master item name "Humidity" corresponds to the used
item name "Humid" with regard to the item name ID "3".
[0064] In S31, the item addition unit 205 adds new information to the change history 15 221 stored in the item name change management unit 202. hi the example in Fig. 13,
addition of the item having the item name "Humid" on the date "20140501" is recorded
in the change history 221 with regard to the item name-ID "3".
[0065] In S32, the item addition unit 205 notifies the integrated management apparatus
400 of the change. After S32, the flow proceeds to S23. 20 [0066] In S33, the administrator of the integrated management apparatus 400 is
notified that the new item having no corresponding master item has been added to the
table 301 of the factory DB. Therefore, the administrator can manually deal with the
addition of the item.
[0067] S34 to S37 are an item deletion process. In the item deletion process, the item 25 name information 211 and the change history 221 of the item names are updated. Fig.
18
14 illustrates an example of the item name information 211 before being updated and
the item name information 211 after being updated. Fig. 15 illustrates an example of
the change history 221 of the item names.
[0068] In S34, the item name update unit 206 queries the item name management unit 5 201 about the ID of the deleted portion. That is, the item name update unit 206
acquires the item name ID of the deleted item from the item name information 211
stored in the item name management unit 201.
[0069] In S35, the item name update unit 206 deletes the portion related to the same
used item name as the item name of the deleted item from the item name information 10 211 stored in the item name management unit 201. In the example in Fig. 14, the
portion indicating that the master item name "Temperature" corresponds to the used
item name "Temp" is deleted from the item name information 211 with regard to the
item name ID "2".
[0070] In S36, the item name update unit 206 adds new information to the change 15 history 221 stored in the item name change management unit 202. In the example in
Fig. 15, deletion of the item having the item name "Temp" on the date "20140501" is
recorded in the change history 221 with regard to the item name ID "2".
[0071] In S37, the item name update unit 206 notifies the integrated management
apparatus 400 of the change. After S37, the flow proceeds to S25. 20 [0072] *** Description of Effects ***
In this embodiment, a correspondence relation between a master item name
being a fixed item name and a used item name being a variable item name is defined.
When the data stored in each item in the table 301 of the database 300 is displayed, the
master item name corresponding to the same used item name as the item name set for 25 each item is displayed together with the data. Therefore, according to this
19
embodiment, when the screen 441 to display the data stored in each item in the table
301 of the database 300 is generated, it is possible to flexibly deal with a change in an
item name.
[0073] In this embodiment, a change in an item name and a change in a format in the 5 table 301 are managed as needed, so as to make item names and formats in each factory
variable. Therefore, the production management screen reflecting the changes can be
automatically generated.
[0074] According to this embodiment, even if a change in a format for recording dates
and times or production volumes occurs in a certain factory, for example, the same 10 production management screen as that before the change can be automatically
generated. Therefore, the administrator can easily perform the production
management of the plurality of factories.
[0075] Second Embodiment
With regard to this embodiment, differences from the first embodiment will be 15 mainly described.
[0076] With reference to Fig. 16, a configuration of a screen generation system 100
according to this embodiment will be described hereinafter.
[0077] Production results of a factory A 110 and production results of a factory B 120
are managed in a Manufacturing Execution System 600 (MES) of the factory A 110 and 20 an MES 600 of the factory B 120, respectively. A factory management apparatus 200
of the factory A 110 is included in the MES 600 of the factory A 110. A factory
management apparatus 200 of the factory B 120 is included in the MES 600 of the
factory B 120.
[0078] As in the first embodiment a database 300 is installed in each of the factory A 25 110 and the factory B 120 as a plurality of factories. Data stored in each item in a
20
table 301 of the database 300 is data indicating the production results of the factory in which the database 300 is installed among the plurality of factories. That is, the data in the database 300 of the factory A 110 is data indicating the production results of the factory A 110, and the data in the database 300 of the factory B 120 is data indicating 5 the production results of the factory B 120.
[0079] A database 500 in a cloud 130 assembles the data in the database 300 of the factory A 110 and the data in the database 300 of the factory B 120. An MES 700 in the cloud 130 manages production execution of all the factories using the database 500. An integrated management apparatus 400 is included in the MES 700. That is, a
10 screen generation unit 440 and so on illustrated in Fig. 3 are implemented in the cloud 130.
[0080] A screen 441 generated by the screen generation unit 440 is a screen to display an item name after being converted by an item name conversion unit 431 and data which is acquired by a data acquisition unit 420 and indicates the production results of
15 the factory A 110 and the production results of the factory B 120.
[0081 ] According to this embodiment, the MES 600 and the MES 700 can be operated with the flexibility of data management in each factory being maintained. [0082] Third Embodiment
With regard to this embodiment, differences from the second embodiment will
20 be mainly described.
[0083] With reference to Fig. 17, a configuration of a screen generation system 100 according to this embodiment wil! be described hereinafter.
[0084] In the second embodiment, the production management across the plurality of factories is performed by cooperation of the MES 600 including the factory
25 management apparatus 200 in each factory and the MES 700 including the integrated
21
management apparatus 400 in the cloud 130, whereas in this embodiment the
production management of a factory A 110 alone is performed by an MES 600 of the
factory A 110.
[0085] Production results of the factory A 110 are managed by the MES 600 of the 5 factory A 110. A factory management apparatus 200 of the factory A 110 is included
in the MES 600 of the factory A 110.
[0086] A database 300 is installed in the factory A 110. Data stored in each item in a
table 301 of the database 300 is data indicating the production results of the factory A
110. 10 [0087] With reference to Fig. 18, a configuration of the factory management apparatus
200 will be described.
[0088] A data acquisition unit 420, a data conversion unit 430, and a screen generation
unit 440, which are included in the integrated management apparatus 400 in the cloud
130 in the second embodiment, are included in the factory management apparatus 200 15 of the factory A 110. That is, the data acquisition unit 420, an item name conversion
unit 431, a format conversion unit 432, and the screen generation unit 440 are
implemented in the MES 600 of the factory A 110.
[0089] A screen 441 generated by the screen generation unit 440 is a screen to display
an item name after being converted by the item name conversion unit 431 and data 20 which is acquired by the data acquisition unit 420 and indicates the production results of
the factory A 110.
[0090] According to this embodiment, the MES 600 can be operated with the
flexibility of data management in the factory A 110 being maintained.
[0091] Fourth Embodiment
25 With regard to this embodiment, differences from the second embodiment will
22
be mainly described.
[0092] With reference to Fig. 19, a configuration of a screen generation system 100 according to this embodiment will be described hereinafter.
[0093] In this embodiment, management of a change in an item name and a change in 5 a format is performed entirely in a cloud 130.
[0094] A factory management apparatus 200 of a factory A 110 is included in an MES 700 in the cloud 130, instead of an MES 600 of the factory A 110. A factory management apparatus 200 of a factory B 120 is also included in the MES 700 in the cloud 130, instead of an MES 600 of the factory B 120. That is, an item name
10 management unit 201, a format management unit 203, an item name update unit 206, and a format update unit 207 illustrated in Fig. 2 are implemented in the cloud 130. Note that the factory management apparatus 200 of the factory A 110 and the factory management apparatus 200 of the factory B 120 may be implemented on a single computer, and may be implemented on the same computer as the computer on which an
15 integrated management apparatus 400 is implemented.
[0095] According to this embodiment, the MES 600 and the MES 700 can be operated with the flexibility of data management in each factory being maintained. Further, it is no longer necessary to devote resources of the MES 600 of each factory to the management of a change in an item name and a change in a format, and the
20 management of a change in an item name and a change in a format can be performed efficiently by the MES 700 in the cloud 130 in which resources can be enhanced easily. [0096] With reference to Fig. 20, an example of a hardware configuration of each of the factory management apparatus 200 and the integrated management apparatus 400 of each of the screen generation systems 100 according to the embodiments of the present
25 invention will be described hereinafter.
23
[0097] In the example in Fig. 20, each of the factory management apparatus 200 and the integrated management apparatus 400 is a computer, and has hardware such as an output device 910, an input device 920, a storage device 930, and a processing device 940. The hardware is used by each one described as a "unit" in the description of the 5 embodiments of the present invention.
[0098] The output device 910 is, for example, a display device such as a Liquid Crystal Display (LCD), a printer, or a communication module. The output device 910 is used to output or transmit data, information, and a signal by each one described as a "unit" in the description of the embodiments of the present invention.
10 [0099] The input device 920 is, for example, a keyboard, a mouse, a touch panel, or a communication module. The input device 920 is used to input or receive data, information, and a signal by each one described as a "unit" in the description of the embodiments of the present invention. [0100] The storage device 930 is, for example, a Read Only Memory (ROM), a
15 Random Access Memory (RAM), a Hard Disk Drive (HDD), or a Solid State Drive (SSD). The storage device 930 stores a program 931 and a file 932. The program 931 includes a program for executing a process of each one described as a "unit" in the description of the embodiments of the present invention. The file 932 includes data, information, a signal, and the like for which calculation, processing, reading, writing,
20 use, input, output, and the like are performed by each one described as a "unit" in the description of the embodiments of the present invention.
[0101] The processing device 940 is, for example, a Central Processing Unit (CPU). The processing device 940 is connected to other hardware devices via a bus or the like and controls the hardware devices. The processing device 940 reads the program 931
25 from the storage device 930 and executes the program 931. The processing device 940
24
is used for calculation, processing, reading, writing, use, input, output, and the like by each one described as, a "unit" in the description of the embodiments of the present invention.
[0102] Each one described as a "unit" in the description of the embodiments of the 5 present invention may be the one for which the "unit" is replaced by a "circuit", a
"device", or an "appliance". Further, each one described as a "unit" in the description of the embodiments of the present invention may be the one for which the "unit" is replaced by a "step", a "procedure", or a "process". That is, each one described as a "unit" in the description of the embodiments of the present invention is realized solely
10 by software, solely by hardware, or by a combination of the software and the hardware. The software is stored in the storage device 930 as the program 931. The program 931 causes the computer to function as each one described as a "unit" in the description of the embodiments of the present invention. Alternatively, the program 931 causes the computer to execute a process of each one described as a "unit" in the description of the
15 embodiments of the present invention.
[0103] The embodiments of the present invention have been described above. Some of the embodiments may be implemented in combination. Alternatively, one or some of the embodiments may be implemented partially. For example, only one of the ones each described as a "unit" in the description of the embodiments may be employed, or
20 any arbitrary combination of some of the ones may be employed. Note that the present invention is not limited to the embodiments, and various modifications can be made as necessary.
Reference Signs List
25 [0104] 100: screen generation system, 110: factory A, 120: factory B, 130: cloud, 140:
25
network, 150: screen output apparatus, 200: factory management apparatus, 201: item name management unit, 202: item name change management unit, 203: fonnat management unit, 204: format change management unit, 205: item addition unit, 206: item name update unit, 207: format update unit, 211: item name infonnation, 212: 5 fonnat infonnation, 221: change history, 222: change history, 230: selection screen, 300: database, 301: table, 400: integrated management apparatus, 410: change management unit, 411: item name change management unit, 412: format change management unit, 413: additional item management unit, 420: data acquisition unit, 430: data conversion unit, 431: item name conversion unit, 432: fonnat conversion unit, 10 440: screen generation unit, 441: screen, 500: database, 600: MES, 700: MES, 910: output device, 920: input device, 930: storage device, 931: program, 932: file, 940: processing device
| # | Name | Date |
|---|---|---|
| 1 | Translated Copy of Priority Document [19-06-2017(online)].pdf | 2017-06-19 |
| 2 | PROOF OF RIGHT [19-06-2017(online)].pdf | 2017-06-19 |
| 3 | Power of Attorney [19-06-2017(online)].pdf | 2017-06-19 |
| 4 | Form 5 [19-06-2017(online)].pdf | 2017-06-19 |
| 5 | Form 3 [19-06-2017(online)].pdf | 2017-06-19 |
| 6 | Form 18 [19-06-2017(online)].pdf_24.pdf | 2017-06-19 |
| 7 | Form 18 [19-06-2017(online)].pdf | 2017-06-19 |
| 8 | Form 1 [19-06-2017(online)].pdf | 2017-06-19 |
| 9 | Drawing [19-06-2017(online)].pdf | 2017-06-19 |
| 10 | Description(Complete) [19-06-2017(online)].pdf_23.pdf | 2017-06-19 |
| 11 | Description(Complete) [19-06-2017(online)].pdf | 2017-06-19 |
| 12 | CLAIMS UNDER RULE 1 (PROVISIO) OF RULE 20 [19-06-2017(online)].pdf | 2017-06-19 |
| 13 | Correspondence by Agent_Form1_20-06-2017.pdf | 2017-06-20 |
| 14 | Other Document [30-06-2017(online)].pdf | 2017-06-30 |
| 15 | Marked Copy [30-06-2017(online)].pdf | 2017-06-30 |
| 16 | Form 13 [30-06-2017(online)].pdf | 2017-06-30 |
| 17 | Description(Complete) [30-06-2017(online)].pdf_836.pdf | 2017-06-30 |
| 18 | Description(Complete) [30-06-2017(online)].pdf | 2017-06-30 |
| 19 | 201747021344-FORM 3 [07-12-2017(online)].pdf | 2017-12-07 |
| 20 | 201747021344-FER.pdf | 2020-07-13 |
| 1 | SearchUpdatedE_09-06-2020.pdf |
| 2 | SearchE_05-06-2020.pdf |