JP5157282B2 - Equipment information collection management system - Google Patents

Description

  The present invention relates to a facility information collection management system, particularly for processing and assembly type production facilities, and can flexibly cope with changes in manufacturing process, equipment configuration, equipment model, and display according to business purposes. The present invention relates to a facility information collection management system that can quickly change production information even if it changes.

  Conventionally, it is difficult to change a once-produced production system even if an attempt is made to change the production process or the configuration of equipment due to a change in a product to be produced, progress in production technology, or the like. In other words, even if an attempt is made to change the production system by changing the product to be manufactured, progress in manufacturing technology, etc., a production support / management system with a function to collect various information from the facility has not been established, or the production support / In general, management systems lack flexibility and are difficult to change easily.

Therefore, in the following Patent Document 1, when changing an existing line or the like, a virtual factory that models the factory is created, and the function data of the actual equipment can be set in the virtual equipment of the virtual factory. Change the existing line based on the simulation result of at least simulation of the production status and physical distribution status by performing pseudo production in the virtual factory so that it has data such as various setup conditions and operation conditions (including processing conditions) A virtual factory system that executes the above has been proposed.
JP 2002-373018 A

  Production systems differ in equipment, process, and tool configuration used depending on the product manufacturing process, and it is not easy to create a virtual factory by making a data model of a factory such as the above-mentioned Patent Document 1. First, since the production process and equipment configuration has been changed due to changes in the products that manufacture the production system and advances in manufacturing technology, it has a function to collect various information from the equipment when there is a change. Since the production support / management system cannot respond, there was a problem that it was not possible to meet the demand to flexibly cope with this.

  In general, a production system has a lot of production information that you want to display depending on the purpose of your business, and you can meet the demand for providing as much production information as possible according to your business needs with limited information system resources. There was no problem.

  Furthermore, because the production information to be displayed differs depending on the purpose of the business, and the screen specifications to be displayed are also different, it has not been able to respond to the request that the necessary information can be easily displayed in the required form with limited information system resources. There was a problem. In particular, there was a problem that it was not possible to meet the demand for making it possible to change the display specification easily and quickly when it was desired to change the display specification.

  An object of the present invention is to provide a facility information collection management system capable of solving at least one of the above-described problems.

The facility information collection management system of the present invention stores a collection computer (for example, a PC (PC)) that collects facility information related to a change in manufacturing process, facility configuration, or model, and stores the collected facility information in the entire production facility. In a facility information collection management system comprising a database server that stores configuration information, management information, definition information, and the like, and an application server that controls the overall management operation of production facilities based on the collected facility information, the database server is Define the contents (data items), position, data attributes, etc. displayed on the screen as an information set, and classify them according to different display methods such as screens, trees, tables, etc., and manage them in the management group ID Display content can be changed by setting the display content definition management means and information link to the display item data displayed on the screen. A display information link defining means for displaying the mutual relationship between the production facility resources and the first hierarchical display means for displaying the mutual relationship structure of the production facility resources in a hierarchical tree structure. a second hierarchical display means for displaying the structure hierarchical tree structure, various included in the display target in response to the display object in each layer of the structure of the interrelationship of the structure or the correlation information of the resource And a data extraction / acquisition means for displaying information based on a plurality of settings .

  According to the present invention, it is possible to collect and store various types of information of a production system composed of various types of production facilities flexibly and easily, and it is possible to quickly display necessary information from various points of view in various types of stored production information. .

  In addition, according to the present invention, information can be collected flexibly even if the manufacturing process, equipment configuration, equipment model changes, and a database that manages this even if the manufacturing process, equipment configuration, equipment model changes. It is possible to quickly and accurately manage the facility information by quickly changing the system information.

  Further, according to the present invention, when it is desired to change the production information to be displayed depending on the business purpose, the production information corresponding to the change can be quickly displayed only by changing the link setting of the table for managing the display.

Hereinafter, embodiments of the present invention will be described with reference to the drawings.
FIG. 1 is a block diagram showing a configuration of a facility information collection management system according to an embodiment of the present invention. 1, the facility information collection management system of the present invention is mainly composed of a collection PC (personal computer) 250, a DB (database) server 260, and an AP (application) server 270. In FIG. 1, the data flow is indicated by a dotted line, and the control flow is indicated by a solid line.

In the collection PC (personal computer) 250 , the data collection driver 252 collects data related to devices and apparatuses to be collected and passes the data to the data collection unit 253. The data collection unit 253 executes data collection based on information from the collection content, method, collection source related definition data acquisition unit 255 and collection scheduler 256. Data collected by the data collection unit 253 (hereinafter simply referred to as “collected data”) is stored in a process data file (collected system temporary data) 254. The collected data stored in the process data (collection system temporary data) file 254 is passed to the data linkage unit 257 controlled by the instruction of the definition data acquisition unit 255 related to the collection contents, method, and collection source, and the data linkage unit 257 The data is supplemented and linked with the trigger. As a result, the collected data that has been subjected to data supplementation / linking triggers in the data linkage unit 257 is transferred to the trend data file 261 of the DB server 260 as the trend data, and the trend data file 261 stores the trend data. The trend data is used to grasp the latest state of the data collection target device or apparatus when there is information change in the data collection target apparatus or device.

In addition to the trend data file 261 for storing trend data, the DB server 260 includes a facility information tab group definition information file T002 (262) for managing a plurality of management group IDs with a single tab group ID, and a serial number assigned to each management group. The equipment information item master file T005 (263) that manages the item IDs, the equipment information link item information file T006 (264) that manages the link item information of the equipment information screen from display items to trend data, Equipment information group management master file T001 (265) that manages tabs with management group IDs, item information file 266 that stores data for each item, as shown in tables T007 to T028, which will be described later, and the association between tab groups and trees A configuration definition information file (tree display item master) T003 (267) managed by ID is provided. The structure of these files will be described later in detail.

  The AP server 270 forms a head quota of the facility information collection management system, that is, the headquarters, and displays information associated with the collected production facility information on the facility information screen in a format that matches the search conditions. In other words, the AP server 270 is provided with a condition search unit 271 to perform a search by setting the conditions for which data to be displayed is displayed, and the display data extraction / acquisition unit 272 selects data that matches the search condition. The data extracted and acquired from the various data files of the DB server 260 described above is displayed on the data display unit 273. Further, the AP server 270 is provided with a configuration definition unit 274 relating to facility information / configuration information, and the definition information is extracted from various data definition tables of the DB server 260 to extract / acquire information that matches the configuration definition. This is displayed on the display unit 275. In the above, when adding, changing, or deleting various data definition files of the DB server 260, various data definition files of the DB server 260, that is, the equipment management group master file 265, items Add, change, or delete definition file 265 and configuration definition information file 267. This will be described later.

  FIG. 2 is a diagram illustrating an example of a link relationship between tables related to collected information. FIG. 2 illustrates a trace information (process payout history) table T089, a control device registration item information table T012, a model master T058, and a process C / T item information table T016. ) Is indicated by an arrow line. In addition, although there is no link source even if indicated by an arrow line, for example, the system serial number (1 to n) and the system serial number of the process C / T item information table T016 are input again. The trace information (process payout history) table T089 shown in FIG. 2 is the collected information collected, and the table contents are satisfied by the data linkage unit 257 of FIG. 1, which becomes the trend data shown in FIG. It is stored in the data file 261. Although not shown in FIG. 1, the contents of the trend data file 261 are used for updating the related data table at a predetermined cycle. At that time, data update registration is performed based on the above-described link relationship.

  3 to 38 are diagrams showing the structures of various data tables according to the facility information collection management system of the present invention. FIG. 3 shows the data structure of the equipment information group master table T001, which is a table holding the management group of the attribute items of equipment information. The management group ID for managing the tab of the equipment information screen with the management group ID, and the registration screen SQL ORDER BY clause that specifies the management group language key that specifies the language dictionary key registered in the language dictionary master for the characters to be displayed, the table name that specifies the item information table name associated with the management group ID, and the sort condition for the item to be searched Each sort condition specified in is defined.

  FIG. 4 shows a data structure of the equipment information tab group master table T002, which is a table storing equipment information tab groups. A tab group ID for managing a plurality of management group IDs, and a management group ID linked to the tab group ID A display group ID for designating, a tab group language key for designating a language dictionary key registered in the language dictionary master of characters to be displayed on the tab, a tab display order for designating the display order of the tabs, and the like are defined.

  FIG. 5 shows the data structure of the equipment information tree display item master table T003, and is a table for storing equipment information tree display items. The tree ID for managing the association with the tab group and the language of the characters displayed in the tree Specify the tree language key that specifies the language dictionary key registered in the dictionary master, the tab group ID that specifies the tab group ID that is displayed when the tree is selected, the tree category that specifies the tree category, and the file name of the icon that is displayed in the tree An icon file name, a parent tree ID, a tree display order for specifying the tree display order of each information, a management group ID, an item ID, and a deletion procedure name for setting a stored procedure name at the time of deletion are defined.

  FIG. 6 shows the data structure of the equipment information individual screen call master table T004, and is a table for storing information on the equipment information individual screen call button. The management group ID for specifying the management group ID to be linked, Defines the serial number in the group that specifies the serial number, the management group language key that specifies the language dictionary key for the characters displayed on the button, the program name that specifies the program name of the screen displayed when the button is clicked.

  FIG. 7 shows a data structure of the equipment information item master table T005, which is a table for managing equipment information attribute items, and designates a management group ID for designating a management group ID to be linked and a tab group ID to be linked. Tab group ID, item ID consisting of serial number assigned to each management group, item language key, unit language key, input type, data type, number of significant digits, number of decimal places, display area width, registration area width, display area height, Registration area height, when displaying data list, data display position to specify left justification, center alignment, right justification, display order to specify display order of data list display, registration sub screen display, required, minimum value, maximum value , Search condition display destination, search input type, conversion format 1, conversion format 2, conversion format 3, ini file name, section name, key name, own item data extraction SQL, own item Number, key item ID, linked item ID, own item display parameter name, calculation formula format, aggregation presence / absence, aggregation type, character information master reference presence / absence, character information master type, record ID information, export column number, import DB item name, Define import update key, valid / invalid, field change impossible flag etc.

  FIG. 8 shows the data structure of the equipment information link item information table T006, and is a table for managing the equipment item link item information. The management group ID for designating the management group ID to be linked and the item ID to be linked are designated. A link item data extraction SQL describing an SQL for extracting data to be displayed at a link destination, a link data output destination item ID for designating an item ID for outputting a result of the link item data extraction SQL, and the like are defined.

  FIG. 9 shows a data structure of the factory registration item information table T007, which is a table for managing attribute item data of the factory registration information, and a record that stores a group ID that specifies a management group ID to be linked and a serial number in the record registration order. ID, item ID1 data to item ID100 data, etc. are defined.

  FIG. 10 shows the data structure of the factory registration item information table T008, which is a table for managing the attribute item data of the factory registration information. The record stores the group ID that specifies the management group ID to be linked and the serial number in the record registration order. Item ID1 data to item ID100 data, etc., in which one item and one item correspond to one item master record, are defined.

  FIG. 11 shows a data structure of the line registration information item information table T009, which is a table for managing the attribute item data of the line registration information, and stores a group ID for specifying a management group ID to be linked and a serial number in the record registration order. The record ID, item ID1 data to item ID100 data corresponding to one item master record are defined.

FIG. 12 shows a data structure of the process registration information item information table T010, which is a table for managing the attribute item data of the process registration information, and stores a group ID for specifying a management group ID to be linked and a serial number in the record registration order. The record ID, item ID1 data to item ID100 data corresponding to one item master record are defined.

  FIG. 13 shows the data structure of the equipment registration information item information table T011, which is a table for managing the attribute item data of equipment registration information, and stores the group ID for designating the management group ID to be linked and the serial number in the record registration order. The record ID, item ID1 data to item ID100 data corresponding to one item master record are defined.

  FIG. 14 shows the data structure of the control device registration information item information table T012, which is a table for managing the attribute item data of the control device registration information. The group ID, record ID, 1 item for designating the management group ID to be linked Defines item ID1 data to item ID100 data corresponding to the item master 1 record.

  FIG. 15 shows the data structure of the tool registration information item information table T013, which is a table for managing the attribute item data of the tool registration information, and stores the group ID for designating the management group ID to be linked and the serial number in the record registration order. The record ID, item ID1 data to item ID100 data corresponding to one item master record are defined.

  FIG. 16 shows the data structure of the component registration information item information table T014, which is a table for managing the attribute item data of the component registration information. The group ID for designating the management group ID to be linked and the serial number in the record registration order are stored. The record ID, item ID1 data to item ID100 data corresponding to one item master record are defined.

  FIG. 17 shows the data structure of the character information item information table T015, which is a table for storing pull-down selected character information. The type, data code, dictionary key, character color, character color comment, etc. are defined.

  FIG. 18 is a table in which the item “type” in the character information item information table T015 of FIG. 17 is subdivided to expand the master type and the master name, and further expand the data code according to the master name. The data code is specifically defined with reference to a language dictionary master T059, which will be described later, by category, language key, Japanese, and English.

  FIG. 19 shows a data structure of the process C / T item information table T016, which is a table for managing attribute item data of cycle time information. A group ID for specifying a management group ID to be linked, and a serial number in the record registration order. The record ID to be stored and the item ID1 data to the item ID100 data corresponding to the item master 1 record are defined.

  FIG. 20 shows a data structure of the C / T item information table T017, which is a table for managing attribute item data of cycle time information. A group ID for designating a management group ID to be linked and a serial number in the record registration order are stored. The record ID, item ID1 data to item ID100 data corresponding to one item master record are defined.

  FIG. 21 shows the data structure of the operation information item information table T018, which is a table for managing the attribute item data of the operation information. The group ID that specifies the management group ID to be linked, and the record ID that stores the serial numbers in the record registration order. 1 item defines item ID1 data to item ID100 data corresponding to one item master record.

FIG. 22 shows a data structure of the equipment alarm item information table T019, which is a table for managing attribute item data of equipment alarm information, a record that stores a group ID that specifies a management group ID to be linked, and a serial number in the record registration order. Item ID1 data to item ID100 data, etc., in which one item and one item correspond to one item master record, are defined.

  FIG. 23 shows the data structure of the tool list information item information table T020, which is a table for managing the attribute item data of the tool list information, and stores the group ID for designating the management group ID to be linked and the serial number in the record registration order. The record ID, item ID1 data to item ID100 data corresponding to one item master record are defined.

  FIG. 24 shows a data structure of the tool exchange history item information table T021, which is a table for managing attribute item data of the tool exchange history information. A group ID for specifying a management group ID to be linked and a serial number in the record registration order are stored. The record ID and the item ID1 data to the item ID100 data corresponding to the item master 1 record are defined.

  FIG. 25 shows the data structure of the parts list information item information table T022, which is a table for managing the attribute item data of the parts list information. The group ID for specifying the management group ID to be linked and the serial numbers are stored in the record registration order. The record ID, item ID1 data to item ID100 data corresponding to one item master record are defined.

  FIG. 26 shows the data structure of the component replacement history item information table T023, which is a table for managing the attribute item data of the component replacement history information. The group ID for specifying the management group ID to be linked and the serial number in the record registration order are stored. The record ID and the item ID1 data to the item ID100 data corresponding to the item master 1 record are defined.

  FIG. 27 shows a data structure of the program information table T024, which is a table for managing program information, and defines a line code, a machine code, a control device system serial number, a switching name, a program name, a program number, and the like.

  FIG. 28 shows the data structure of the history information-program information table T025, and is a table for managing the history of program information collection time. Record number, collection time, direct, line code, machine code, control device system serial number, latest Define the version number, updater code, update time, program classification code, collection item, display file name, program name, binary flag, system, etc.

  FIG. 29 shows the data structure of the collection schedule information table T028, and is a table for managing the collection schedule. Line code, backup unit, day, hour, minute, 1st, 2nd, 3rd, Monday to Sunday, etc. Define.

  FIG. 30 shows the data structure of the equipment information basic condition master table T035, a table for managing which item ID of each item information is the basic condition item on the equipment information screen, and management specifying the management group ID of the basic condition item When the group ID and flag 1 are set, the condition type for which the management group ID becomes a fixed condition, the table name for specifying the item information table name to be searched, the search key item ID for specifying the search key item ID, and the search key item ID A display content item ID for designating a display content item ID corresponding to is defined.

  FIG. 31 shows a data structure of the QC terminal registration information item information table T039, which is a table for managing attribute item data of the QC terminal registration information, and defines group ID, record ID, item ID1 data to item ID100 data, and the like. .

FIG. 32 shows a data structure of the equipment information deletion condition master table T040, which is a table for managing which item ID of each item information is a deletion condition item on the equipment information screen.
To n), a management group ID corresponding to each tree ID, a group ID for specifying the subordinate management group ID, and a deletion key item for specifying a key item ID for specifying a deletion target record of the management group ID Define the ID.

  FIG. 33 shows a data structure of the direct master table T048, which is a table for managing direct data related to working hours, and defines a factory code, factory code, direct, start time, end time, and the like.

  FIG. 34 shows the data structure of the model master table T058, and is a table for managing model information such as model number and model name. Regarding manufacturing code, factory code, line code, model number, attribute, model name, etc. Define.

  FIG. 35 shows the data structure of the language dictionary master table T059, which is a table that defines screen names, item names, button names, and messages to be displayed on the screen, such as classification, dictionary key, language code, display content, display classification, etc. Define about.

FIG. 36 shows the data structure of the language master table T060, which is a table for managing languages, and defines language codes, languages, and the like.
FIG. 37 shows a data structure of the tool item information table T064, and is a table for managing attribute item data of the tool list information, and defines group ID, record ID, item ID1 data to item ID100 data, and the like.

  FIG. 38 shows the data structure of the collected information (trace information (process payout information)) table T089, and stores the collected data of the trace information (process payout history). The record number, collection time, direct, item 1 ~ Define or store data for item 100 etc.

  FIG. 39 is a diagram showing a facility information screen display example according to the facility information collection management system of the present invention, and the facility information is displayed on the screen 901. The screen display of the facility information is shown in FIG. 1 so as to be displayed separately in the data display unit 273 and the structure / information display unit 275, but in actuality, it is displayed on one terminal screen. In the upper part of the screen, from the upper left corner, the factory name, factory name, line name, process name, machine name, control device, tool No. , Equipment information basic items 902 such as component IDs are displayed in a pull-down format. In the left half of the screen 901 that is divided at the approximate center of the screen, a tree selection button that can be selected by checking is displayed, and the structure tree button 903 is checked by selecting the resource structure tree . An information tree button 904 is arranged on the right side of the structure tree button 903. Below these buttons, a change button 905, an add button 906, and a delete button 907 are arranged. These button operations will be described later. Under the change button 905, the add button 906, and the delete button 907, a tree structure 908 divided by icons is displayed.

  Also, tabs 909 divided by buttons are displayed in the right half of the screen 901 divided substantially at the center of the screen. The tabs are managed by the facility information tab group master table T002 described with reference to FIG. The display number of the tab 909 is determined by the item selected in the above-described structure tree 908 (the currently selected item is 'DDD adjustment'), and which of the tabs 909 is displayed is determined by the search condition. The tab 909 is displayed with a different color. Incidentally, the tab in the current screen display shows “C / T (cycle time)”. Under the tab 909, a detailed search button 910 and a CSV button 911 are arranged in this screen display. When the detailed search button 910 is operated, a list of search results is displayed according to the search condition. Further, when the CSV button 911 is operated, the search result list can be downloaded as a CSV file.

Under the detailed search button 910 and the CSV button 911, a search condition 912 for the period is fro.
It can display up to the hour and minute unit in m, to format. Then, the search result list 913 is displayed below the right half of the screen 901 that is divided substantially at the center of the screen.

  FIG. 40A shows a table that defines the search condition 912 for the period shown in FIG. 39, which can be displayed in units of year, month, day, hour, and minute in the from, to format. FIG. 40B shows a table that defines items to be displayed in the search result 913 shown in FIG.

  41 is a diagram showing a screen display example when an information tree is selected on the facility information screen of FIG. 39. On the information tree screen 921, the tree structure 922 is displayed in the same manner as the tree structure 908 of FIG. . The items displayed in the tree structure 922 of the information tree table 921 are similar to the tree structure 908 in FIG. 39, but the facility information related to the structural equipment for the structural equipment items displayed in the tree structure 908, For example, information that is close to work is also displayed although not shown.

  FIG. 42 is a table showing an example of tree display data, which is defined by the equipment information tree display item master table T003 and displayed on the equipment information display screen. If the category set to the tree type 934 is “0”, the tree structure 908 is displayed in the tree structure 922 if it is “1”. The group tab ID 933 is displayed as the same tab as the tab 909 in FIG. 39 if the tab group ID has the same value. “0” indicates that no tab is displayed. The parent tree ID 936 allows the parent to be specified in the hierarchical display of the structure tree. The tree order 937 indicates the hierarchy display order of the tree, and the young number indicates the upper hierarchy.

  FIG. 43 is a diagram for explaining an example in which the management group language key in the equipment information group master T001 (see FIG. 3) is designated on the registration screen. That is, the language key 1013 displayed in the registered language selection on the registration screen 1012 is set by designating the language dictionary key 1014 registered in the Japanese column of the language dictionary master 1011. See FIG. 35 for details of the language dictionary master.

  FIG. 44 is a diagram for explaining the designation of sort conditions in the equipment information group master T001. In FIG. 44, when specifying C / T information for each process, an SQL statement 1025 created by the screen search condition is created, and the sort condition 1026 of the item to be retrieved is designated by the SQL ORDER BY clause, and this is ANDed. Combined to create an SQL statement 1027 to be executed. This will be described in relation to the search condition 1024 in the period of the screen 1023. The search condition 1024 in the period is described as an SQL statement 1025 created by the screen search condition, and a session is used to narrow down the process code. The process code parameter name 1022 of the information table 1021 is specified, and the condition is specified by parentheses (braces). As a result, the SQL statement 1027 to be executed is completed, and a search result list 913 as shown in FIG. 39 is displayed on the screen.

  FIG. 45 is a diagram for explaining an example in which a tab group language key in the equipment information tab group master T002 (see FIG. 4) is designated as a tab on the equipment information screen. That is, the language key displayed on the tab 1033 of the facility information screen 1030 is set by designating the language dictionary key 1032 registered in the Japanese column of the language dictionary master 1031. See FIG. 35 for details of the language dictionary master.

  FIG. 46 is a diagram for explaining the tab display order in the equipment information tab group master T002. 46, the tab display order definition 1041 of the display group 1040 displayed as a tab is displayed in the tab display order 1042, and the tab display order definition 1044 of the display group 1043 displayed as a tab is displayed in the tab display order 1045. Is displayed as follows.

FIG. 47 is a diagram for explaining the relationship between the tree ID and the tab display in the equipment information tree display item master T003 (see FIG. 5). 47, the tree ID manages the association with the tab group. When the process name DDD adjustment 1052 displayed in the structure tree of the screen display 1050 in FIG. It shows that two tabs, that is, detailed information, C / T, operation history, and equipment alarm are displayed. When a button other than the process name DDD adjustment 1052 displayed in the structure tree is selected, another tab is displayed.

  FIG. 48 is a diagram for explaining tree classification in the equipment information tree display item master T003. As shown in FIG. 48, if “0” is specified in the tree section, the structure tree 1061 is displayed, and if “1” is specified in the tree section, the information tree 1062 is displayed. This is described once in FIG.

  FIG. 49 is a view for explaining icon file names in the equipment information tree display item master T003 (see FIG. 5). As shown in FIG. 49, since the icon displayed in the tree is stored in the file, it can be displayed like the icon 1065 by specifying the file name of the icon.

  FIG. 50 is a diagram for explaining a parent tree ID in the equipment information tree display item master T003. As shown in FIG. 50, when the parent tree ID is defined in the table 1071 in which the hierarchical display is related by the tree ID, the parent ID can be traced by tracing the hierarchically displayed tree ID 1072 by the parent ID. You can know if there is.

  FIG. 51 is a diagram for explaining the display order in the equipment information item master T005 (see FIG. 7). As shown in FIG. 51, in the display of the data list table (including registration and display screen) 1081, the display order is designated from the left to the right of the table. In the registration sub-screen 1082, the display order is specified in order from the top of the screen.

  FIG. 52 is a diagram for explaining an example in which the own item data extraction SQL, the number of own items, the key item ID, and the interlocking item ID in the equipment information item master T005 are individually specified. The own item data extraction SQL describes SQL for acquiring a default display data or a pull-down list in the own item when the input type is text, pull-down (SQL), and input enable pull-down (SQL). The number of own items, key item ID, and linked item ID are used for narrowing down the key information linked by pull-down selection, and the number of own items specifies the number of columns of items to be acquired by own item data extraction SQL The key item ID designates the second and subsequent output destination item IDs (key items) acquired by the own item data extraction SQL, and the linked item ID designates an item ID that operates in conjunction with the pull-down setting. FIG. 52 illustrates an example in which the own item data extraction SQL, the number of own items, the key item ID, and the interlocking item ID are individually specified on the registration screen 1091. As shown in FIG. 52, the self item data extraction SQL 1092, the self item number 1093, the key item ID 1094, and the interlocking item ID 1095 are set.

  FIG. 53 is a diagram for explaining an example in which the own item data extraction SQL, the number of own items, the key item ID, and the interlocking item ID in the equipment information item master T005 are interlocked designation, and the key item ID1 is displayed on the registration screen 1101 in FIG. And the specification method when linking ID3, SQL statements for acquiring the number of items specified by the number of own items are specified in the own item data extraction SQL 1102 and 1103, and the item names are DATA1, DATA2 , ... DATAn is described, DATA1 is set as a pull-down display item, and the item ID can be specified in the Where clause, and if specified, the data of the specified item ID (on the memory) can be replaced. In addition, an output destination item ID after DATA2 is specified for the key item ID, and an item ID to be linked next is specified for the linked item ID (the linkage is terminated when NULL). The default value is obtained by acquiring each data from the session information specified in the own item display parameter name (described later), and then selecting an item that matches the data of the ID specified in the key item ID (the matching item is If there is none, a blank is displayed.)

  FIG. 54 is a diagram for explaining the own item display parameter name in the equipment information item master T005. If the parameter of data to be transferred to the registration sub-screen is set in FIG. 54 based on the definition of the parameter list 1111, the set parameter is displayed. It can be specified as a parameter name to be passed when opening the registration sub-screen 1110 as “own item display parameter name”. Data associated with the parameter is used as an initial value.

  FIG. 55 is a diagram for explaining an example of displaying the aggregation result on the facility information screen based on the designation of the aggregation type in the facility information item master T005. As shown in FIG. On the premise that the flag “1” indicating that the aggregation is valid is set, the aggregation type designation 1120 designates the contents to be aggregated. That is, when the flag is “0”, the maximum, minimum, and average items are displayed in the aggregation, and when the flag is “1”, one item of the total is displayed. When the flag is “2”, the maximum is the aggregation. 4 items, minimum, average and total are displayed. In addition, the output example 1122 of the aggregation result shows a case where “1” is specified for the presence / absence of item ID = 3 (cycle time) and “0” is specified for the aggregation type, and the presence / absence of aggregation is indicated for a plurality of item IDs. When the aggregation type is designated with “1”, the aggregation result is displayed for each item ID in order from the top.

  FIG. 56 is a diagram for explaining an example of designation of the character information master type in the equipment information item master T005. As shown in FIG. 56, it is assumed that the character information master reference presence / absence in the equipment information item master T005 is valid. Specify the character information master type to be displayed. That is, in the screen example 1130 for displaying the status, when the pull-down display 1131 indicating the content of the status is displayed, when the content 1133 of the character information master T015 (see FIG. 17) type: 2 (tool status master) is displayed in the pull-down, The dictionary key 1134 of the content 1133 of the character information master is referred to as the reference key 1135 of the language dictionary master T059 (see FIG. 35), and the display content 1136 is extracted from the language dictionary master to obtain the display character 1132. Data code 1137 is assigned to item information.

  FIG. 57 is a diagram for explaining an example of specifying the order (format) of items to be added to the record ID in the equipment information item master T005. As shown in FIG. 57, the item information is associated with the ID information in the record ID information table 1141. When combining the data 1142 with the 10-digit Oracle sequence to generate a record ID, the number of digits displayed in order from 1 of the ID information based on the number of significant digits of each item defined in the equipment information item master T005 (see FIG. 7) A predetermined record ID is generated by combining character strings with the size of. However, NULL described in the ID information of the record ID information table 1141 is not stored in the record ID.

  FIG. 58 is a diagram for explaining the link item data extraction SQL and the link data output destination item ID in the facility information link item information T006 (see FIG. 8). The link item data extraction SQL describes a SQL statement for extracting data to be displayed at the link destination, and the link data output destination item ID specifies an item ID for outputting the result of the link item data extraction SQL. It is not processed when the input type of the linked item is not text. As shown in FIG. 58, if the link item data extraction SQL statement 1152 is registered, the data determined by the registration information selection pull-down on the registration screen 1151, that is, the data associated with the tool is set to the link data output destination item ID: 7. indicate. In this case, when the SELECT statement 1152 is registered, an alias “DATA” of the acquisition column is added to the SQL statement 1152, and the item ID data enclosed in parentheses (curly brackets) is set in the item code 1 to set the link item data extraction SQL. The result 1153 is output.

FIG. 59 shows the association of item information tables T007 to T023 and T039 (see FIGS. 9 to 26, FIG. 31) in which data of items associated with the group ID of the equipment information item master T005 (see FIG. 7) is stored. It is a figure explaining a mode. 59, the data of item ID1 to item ID5 stored in the item information table 1165 is displayed on the display unit 1166 of the equipment information display screen 1161, and in this case, the management group ID is the same as that of the item information table 1165. The item ID1 data 1162 of the item master T005 (see FIG. 7), the item ID2 data 1163,..., And the item ID5 data 1164 are stored in association with the item information table 1165.

FIG. 60 is a diagram showing an additional designation example of individual screen call buttons in the facility information individual screen call master T004 (see FIG. 6). In the facility information display screen 1171 of FIG. 60, a graph display 1174 is designated as an example of the added button. In the facility information individual screen call master T004 (see FIG. 6), the program name of the screen to be displayed when the individual screen call button is clicked is designated. If the program name HagDataGraph.asp is now specified, the parameters P1, P2, ... Pn are passed from the upper left of the detailed condition to the right during execution, and? P1 = 2006 & P2 = 01 & P3 = 09 & P4 = 05 & P5 = 30 & P6 = 2006 & P7 = 01
& P8 = 31 & P9 = 05 & P10 = 30 & P11 = T000100234 & P12 = xxdehajimaru
Moreover, a necessary value is acquired from the session information as a basic condition. The session information refers to the session information list of the own item display parameter name in the equipment information item master T005 (see FIG. 7).

  As a result, the search key 1172 for the period and the dictionary key xxdehajimaru corresponding to the item “starts with” selected in the pull-down 1173 corresponding to “starts with” shown in the table 1175 are passed to the program as text search conditions.

  FIG. 61 is a diagram for explaining management of basic conditions in the equipment information basic condition master T035 (see FIG. 30). The basic condition 1181 is shown in the equipment information display screen 1180 of FIG. 61. This basic condition is the basic condition in the search condition display destination specified in the item 19 of the equipment information item master T005 (see FIG. 7): The item designated as 1 is targeted, and the equipment information basic condition master T035 manages the item ID when searching for item information using the basic conditions.

  FIG. 62 is a diagram for explaining management of deletion conditions in the equipment information deletion condition master T040 (see FIG. 32). In the tree structure 1191 of the equipment information display screen 1190 in FIG. 62, the equipment information deletion condition master T040 manages item IDs that become deletion conditions when deleting the equipment information.

  FIG. 63 is a flowchart for explaining the processing operation of selecting a data item (tree) on the tree and clicking the add / change / delete button to add / change / delete. This addition / change / deletion process is executed by the configuration definition unit 274 in FIG. 63, in step S11, equipment information tree display item master information corresponding to the tree item selected from the equipment information tree display item master T003 (see FIG. 5) is acquired. In step S12, it is determined whether or not to delete. If not, the process proceeds to step S13. In step S13, it is determined whether or not the process is changed. If not, the process proceeds to step S14. In step S14, the upper item of the selected tree item. The information registration screen is displayed with the initial display as the initial display, and “registration information selection” is activated. In step S15, information is input on the registration information selection screen (left part of FIG. 63). Next, in step S16, it is determined whether or not it is registered. If it is not registration, the process ends. If it is registration, the process proceeds to step S17. In step S17, a management group ID corresponding to the item selected in “registration information selection” is acquired. Next, in step S18, the group ID acquired in step S17 is rewritten to the facility information tree display item master information acquired in step S11, and then the tree display order is incremented by 1 to generate new tree information, and the facility information tree Register in the display item master T003 (see FIG. 5). In step S19, correspondence tables T007 to T023 and T039 (see FIGS. 9 to 26 and 31) are determined using the group ID of step S18 as a key, and the record ID and other data IDs required for the group are determined. Create and register management group information. Then, the process ends.

If the deletion is determined in step S12, the process proceeds to step S20. In step S20, the authority is confirmed, and if it is recognized as a valid operation, the selection is made within the range specified in the equipment information deletion condition master T040 (see FIG. 32). Delete the equipment information tree display item master information corresponding to the tree item and the registration information of the corresponding management group. Then, the process ends.

  If the change is determined in step S13, the process proceeds to step S21. In step S21, the information registration screen is displayed with the information of the selected tree item as initial display information, and “select registration information” is activated. In step S22, information is input on the registration information selection screen (left part of FIG. 63). Next, in step S23, it is determined whether or not it is registered. If it is not registered, the process ends. If it is registered, the process proceeds to step S24. In step S24, correspondence tables T007 to T023 and T039 (see FIGS. 9 to 26 and 31) are used with the group ID acquired in step S11 as a key. Confirm, generate a record ID and other data ID required for the group, and register the management group information. Then, the process ends.

It is a block diagram which shows the structure of the collection management system of the facility information which concerns on embodiment of this invention. It is a figure which shows an example of the link relationship between the tables which concern on collection information. It is a figure which shows the data structure of the equipment information group master table T001. It is a figure which shows the data structure of the equipment information tab group master table T002. It is a figure which shows the data structure of the equipment information tree display item master table T003. It is a figure which shows the data structure of equipment information separate screen call master table T004. It is a figure which shows the data structure of the equipment information item master table T005. It is a figure which shows the data structure of the equipment information link item information table T006. It is a figure which shows the data structure of the factory registration item information table T007. It is a figure which shows the data structure of the factory registration item information table T008. It is a figure which shows the data structure of line registration information item information table T009. It is a figure which shows the data structure of process registration information item information table T010. It is a figure which shows the data structure of the equipment registration information item information table T011. It is a figure which shows the data structure of control apparatus registration information item information table T012. It is a figure which shows the data structure of tool registration information item information table T013. It is a figure which shows the data structure of components registration information item information table T014. It is a figure which shows the data structure of the character information item information table T015. FIG. 17 is a table in which the item “type” in the character information item information table T015 shown in FIG. 17 is subdivided to expand a master type and a master name, and a data code is further expanded and defined according to the master name. It is a figure which shows the data structure of C / T item information table for processes T016. It is a figure which shows the data structure of C / T item information table T017. It is a figure which shows the data structure of the operation information item information table T018. It is a figure which shows the data structure of the equipment alarm item information table T019. It is a figure which shows the data structure of the tool list information item information table T020. It is a figure which shows the data structure of the tool exchange log | history item information table T021. It is a figure which shows the data structure of components list information item information table T022. It is a figure which shows the data structure of components replacement history item information table T023. It is a figure which shows the data structure of program information table T024. It is a figure which shows the data structure of history information-program information table T025. It is a figure which shows the data structure of collection schedule information table T028. It is a figure which shows the data structure of the equipment information basic condition master table T035. It is a figure which shows the data structure of QC terminal registration information item information table T039. It is a figure which shows the data structure of the equipment information deletion condition master table T040. It is a figure which shows the data structure of direct master table T048. It is a figure which shows the data structure of the model master table T058. It is a figure which shows the data structure of the language dictionary master table T059. It is a figure which shows the data structure of language master table T060. It is a figure which shows the data structure of the tool item information table T064. It is a figure which shows the data structure of collection information (trace information (process delivery information)) table T089. It is a figure which shows the example of a facility information screen display which concerns on the collection management system of the facility information of this invention. (A) is a figure which shows the table which defines the search condition 912 about the period shown in FIG. 39, (b) is a figure which shows the table which defines the item displayed on the search result 913 shown in FIG. . It is a figure which shows the example of a screen display when an information tree is selected on the equipment information screen of FIG. It is a table which shows the example of data for tree display. It is a figure explaining the example which designates the management group language key in the equipment information group master T001 shown in FIG. 3 on a registration screen. It is a figure explaining designation | designated of the sort conditions in the equipment information group master T001 shown in FIG. It is a figure which shows the example which designates the tab group language key in the equipment information tab group master T002 shown in FIG. 4 for the tab of an equipment information screen. It is a figure explaining the tab display order in the equipment information tab group master T002 shown in FIG. It is a figure explaining the relationship between tree ID and tab display in the equipment information tree display item master T003 shown in FIG. It is a figure explaining the tree division in the equipment information tree display item master T003 shown in FIG. It is a figure explaining the icon file name in the equipment information tree display item master T003 shown in FIG. It is a figure explaining the parent tree ID in the equipment information tree display item master T003 shown in FIG. It is a figure explaining the display order in the equipment information item master T005 shown in FIG. It is a figure explaining the example whose own item data extraction SQL, the number of own items, key item ID, and interlocking item ID in the equipment information item master T005 shown in FIG. The figure explaining the example whose own item data extraction SQL in the equipment information item master T005 shown in FIG. 7, own item number, key item ID, and interlocking item ID are interlocking designation | designated. It is a figure explaining the own item display parameter name in the equipment information item master T005 shown in FIG. It is a figure explaining the example which displays a total result on the equipment information screen based on designation | designated of the total type in the equipment information item master T005 shown in FIG. It is a figure explaining the example of designation | designated of the character information master classification in the equipment information item master T005 shown in FIG. It is a figure explaining the example which designates the order (format) of the item added to record ID in the equipment information item master T005 shown in FIG. It is a figure explaining link item data extraction SQL and link data output destination item ID in the facility information link item information T006 shown in FIG. It is a figure explaining the mode of the connection of the item information tables T007-T023, T039 in which the data of the item linked | related with the group ID of the equipment information item master T005 shown in FIG. 7 are stored. It is a figure which shows the additional designation example of the individual screen call button in the equipment information individual screen call master T004 shown in FIG. It is a figure explaining the management of the basic conditions in the equipment information basic condition master T035 shown in FIG. It is a figure explaining the management of the deletion condition in the equipment information deletion condition master T040 shown in FIG. It is a flowchart explaining the processing operation | movement which selects the data item (tree) on a tree, and also adds / changes / deletes by clicking an addition / change / delete button.

Explanation of symbols

250 collection PC
251 Equipment and devices (collected)
252 Data collection driver
253 Data collection unit
254 Process data file
255 Definition data acquisition part
256 Collection scheduler
257 Data Linkage Department
260 DB server
261 Trend data file
262 Equipment information tab group definition information file
263 Equipment information item master file
264 Equipment information link item information file
265 Equipment information group management master file
266 Item information file
267 Configuration definition information file
270 AP server
271 Condition search part
272 Display data extraction / acquisition part
273 Data display section
274 Configuration Definition
275 Structure / Information Display

Claims (10)

A collection computer that collects equipment information related to manufacturing processes, equipment configuration or model changes, a database server that stores the collected equipment information, and stores configuration information, management information, definition information, etc. for the entire production equipment, and collection In a facility information collection and management system consisting of an application server that controls the overall management and operation of production facilities based on the facility information
The database server
Display that defines the contents (data items), position, data attributes, etc. displayed on the screen as an information set, and is classified according to different display methods such as screens, trees, tables, etc., and managed by the management group ID Content definition management means;
A display information link definition means for setting the information link to the display item data to be displayed on the screen and changing the display contents;
Have
Application server
First hierarchical display means for displaying the structure of the mutual relationship of resources of production equipment in a hierarchical tree structure;
A second hierarchical display means for displaying the structure of the mutual relationship of information on production equipment in a hierarchical tree structure;
A structure or data extraction and acquisition means for displaying on the basis of various kinds of information included in the display target in response to the display target of the setting of a plurality of cuts in each layer of the structure of the correlation of the correlation information of the resource ,
Having
A facility information collection and management system. The display content definition management means includes tab group management means for managing tab group IDs for managing a plurality of management group IDs,
The data extraction and acquisition means, the extracting tab group ID from the tab group management unit, the tab group ID according to claim 1, characterized in that to display as demonstrating tab the cut Table示画surface Equipment information collection management system. The application server is
It has a condition search means to narrow down the display contents,
2. The facility information collection management system according to claim 1, wherein the data extraction / acquisition unit extracts display contents that match a search condition set by the condition search unit from various information of the database server. The application server is
2. The facility information collection management system according to claim 1, further comprising a screen display content adding unit that allows the display content definition managing unit of the database server to be accessed to add content to be displayed on the screen.   The screen display content addition means activates the screen display content addition screen, inputs necessary items to confirm the input, acquires the management group ID related to the addition, and corresponds the management group ID to the key 5. The facility information collection management system according to claim 4, wherein a management table information is generated and added to a necessary data item by determining a data table to be processed. The application server is
2. The facility information collection management system according to claim 1, further comprising a screen display content deletion unit that allows the display content definition management unit of the database server to be accessed to delete the content displayed on the screen.   The screen display content deletion means deletes the registration of the display item master information corresponding to the selected display item and the management group information corresponding to the selected display item when it is recognized as an authorized deletion operation. The facility information collection and management system according to claim 6. The application server is
2. The facility information collection management system according to claim 1, further comprising a screen display content changing unit that allows the display content definition management unit of the database server to be accessed to change the content displayed on the screen.   The screen display content change means activates the screen display content change screen, inputs necessary items to confirm the input, further acquires the management group ID related to the change, and corresponds the management group ID to the key 9. The facility information collection and management system according to claim 8, wherein the management table information is generated and changed to a necessary data item by determining a data table to be processed. The collection computer is
Collection contents, method, collection source definition data acquisition means,
Having data linkage means for adding a data supplement / linking trigger to primary equipment information collected under the instruction of the definition data acquisition means;
The facility information collection management system according to claim 1.