CN107003664A - Design of information system aid and design of information system auxiliary program - Google Patents
Design of information system aid and design of information system auxiliary program Download PDFInfo
- Publication number
- CN107003664A CN107003664A CN201480084091.XA CN201480084091A CN107003664A CN 107003664 A CN107003664 A CN 107003664A CN 201480084091 A CN201480084091 A CN 201480084091A CN 107003664 A CN107003664 A CN 107003664A
- Authority
- CN
- China
- Prior art keywords
- data
- picture
- database
- setting
- information system
- Prior art date
- Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
- Granted
Links
Classifications
-
- G—PHYSICS
- G05—CONTROLLING; REGULATING
- G05B—CONTROL OR REGULATING SYSTEMS IN GENERAL; FUNCTIONAL ELEMENTS OF SUCH SYSTEMS; MONITORING OR TESTING ARRANGEMENTS FOR SUCH SYSTEMS OR ELEMENTS
- G05B19/00—Programme-control systems
- G05B19/02—Programme-control systems electric
- G05B19/04—Programme control other than numerical control, i.e. in sequence controllers or logic controllers
- G05B19/05—Programmable logic controllers, e.g. simulating logic interconnections of signals according to ladder diagrams or function charts
-
- G—PHYSICS
- G05—CONTROLLING; REGULATING
- G05B—CONTROL OR REGULATING SYSTEMS IN GENERAL; FUNCTIONAL ELEMENTS OF SUCH SYSTEMS; MONITORING OR TESTING ARRANGEMENTS FOR SUCH SYSTEMS OR ELEMENTS
- G05B19/00—Programme-control systems
- G05B19/02—Programme-control systems electric
- G05B19/04—Programme control other than numerical control, i.e. in sequence controllers or logic controllers
- G05B19/05—Programmable logic controllers, e.g. simulating logic interconnections of signals according to ladder diagrams or function charts
- G05B19/058—Safety, monitoring
-
- G—PHYSICS
- G05—CONTROLLING; REGULATING
- G05B—CONTROL OR REGULATING SYSTEMS IN GENERAL; FUNCTIONAL ELEMENTS OF SUCH SYSTEMS; MONITORING OR TESTING ARRANGEMENTS FOR SUCH SYSTEMS OR ELEMENTS
- G05B23/00—Testing or monitoring of control systems or parts thereof
- G05B23/02—Electric testing or monitoring
- G05B23/0205—Electric testing or monitoring by means of a monitoring system capable of detecting and responding to faults
- G05B23/0259—Electric testing or monitoring by means of a monitoring system capable of detecting and responding to faults characterized by the response to fault detection
- G05B23/0267—Fault communication, e.g. human machine interface [HMI]
- G05B23/0272—Presentation of monitored results, e.g. selection of status reports to be displayed; Filtering information to the user
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/23—Updating
-
- G—PHYSICS
- G05—CONTROLLING; REGULATING
- G05B—CONTROL OR REGULATING SYSTEMS IN GENERAL; FUNCTIONAL ELEMENTS OF SUCH SYSTEMS; MONITORING OR TESTING ARRANGEMENTS FOR SUCH SYSTEMS OR ELEMENTS
- G05B23/00—Testing or monitoring of control systems or parts thereof
- G05B23/02—Electric testing or monitoring
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/22—Indexing; Data structures therefor; Storage structures
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/90—Details of database functions independent of the retrieved data types
- G06F16/93—Document management systems
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F3/00—Input arrangements for transferring data to be processed into a form capable of being handled by the computer; Output arrangements for transferring data from processing unit to output unit, e.g. interface arrangements
- G06F3/01—Input arrangements or combined input and output arrangements for interaction between user and computer
- G06F3/048—Interaction techniques based on graphical user interfaces [GUI]
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F3/00—Input arrangements for transferring data to be processed into a form capable of being handled by the computer; Output arrangements for transferring data from processing unit to output unit, e.g. interface arrangements
- G06F3/14—Digital output to display device ; Cooperation and interconnection of the display device with other functional units
-
- G—PHYSICS
- G05—CONTROLLING; REGULATING
- G05B—CONTROL OR REGULATING SYSTEMS IN GENERAL; FUNCTIONAL ELEMENTS OF SUCH SYSTEMS; MONITORING OR TESTING ARRANGEMENTS FOR SUCH SYSTEMS OR ELEMENTS
- G05B2219/00—Program-control systems
- G05B2219/10—Plc systems
- G05B2219/15—Plc structure of the system
- G05B2219/15041—Sense area of screen, compare if corresponds with correct area
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/28—Databases characterised by their database models, e.g. relational or object models
- G06F16/284—Relational databases
- G06F16/285—Clustering or classification
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/40—Information retrieval; Database structures therefor; File system structures therefor of multimedia data, e.g. slideshows comprising image and additional audio data
- G06F16/41—Indexing; Data structures therefor; Storage structures
Landscapes
- Engineering & Computer Science (AREA)
- Theoretical Computer Science (AREA)
- General Physics & Mathematics (AREA)
- Physics & Mathematics (AREA)
- General Engineering & Computer Science (AREA)
- Databases & Information Systems (AREA)
- Human Computer Interaction (AREA)
- Data Mining & Analysis (AREA)
- Automation & Control Theory (AREA)
- Business, Economics & Management (AREA)
- General Business, Economics & Management (AREA)
- Software Systems (AREA)
- Programmable Controllers (AREA)
- Testing And Monitoring For Control Systems (AREA)
Abstract
A kind of design of information system aid, it is generated for PLC data display, in the setting data of the picture data of display unit and the database stored to the data of the PLC, to be had:Memory cell, it can be shown that the setting means of edit tool and the database is read by picture, and the picture shows that edit tool is shown and edited to picture using the picture data;Input block is set, it receives the data class of the data of the PLC;Picture species input block, it receives the species of the picture of the picture data;Database setup unit, it receives the setting data of the database;And data generating unit, it is directed to each data class, the data that will be associated according to the picture data of the type classification of the picture and the setting data of the database is generated in the memory cell.
Description
Technical field
The present invention relates to a kind of design of information system aid and design of information system auxiliary program, the information system
Build aid and design of information system auxiliary program using improve the productivity ratio and operation rate of production scene as
Purpose and when building information system, generate the picture data being consistent with the purpose of user and various setting data.
Background technology
In information system, PLC (programmable logic controller) collects the information of production scene, will
The data being collected into are stored to database via database attachment means.Database attachment means had the moment via PLC
The creation data of change is put aside to database so as to produce the function of live visual at high speed.Based on the data put aside
Such as production status and equipment working condition are shown in display device.
When building information system, it is necessary to carry out the drafting of picture, the setting of database and database attachment means
Setting.The drafting of picture refers to, such as drafting of equipment picture, the drafting of tendency chart picture.
In the technology disclosed in patent document 1 and 2, peration data periodically to set each instrument, prison
The control data controlled the generation data of device picture and should monitored is sampled and imported, and is shown with graph mode, but for
Which kind of specifically used parameter, then without clear and definite.Therefore, for the purpose of the productivity ratio and operation rate that improve production scene
And when building information system, it is difficult to the picture and chart being consistent with the purpose of user are provided.
In the technology disclosed in patent document 2, periodically the control data that should be monitored is sampled and imported,
Shown with graph mode, but the result for the adjustment being finely adjusted to parameter is shown in chart by specific turn to.Therefore, do not simply fail to
Tendency chart is provided to information system, and the diversified picture of such as equipment picture and searching picture etc can not be provided
Face.
Therefore, in the case where attempting to build information system when the quantity of field instrumentation becomes more, according to above-mentioned existing
Technology, due to not making setting and the setting of database attachment means, such as equipment picture or the tendency chart picture of database
Design and drafting etc picture design and drafting the efficient mechanism of operation, therefore exist more than operation quantitative change
Problem.
Patent document 1:Japanese Unexamined Patent Publication 2004-30345 publications
Patent document 2:Japanese Unexamined Patent Publication 2004-178157 publications
The content of the invention
That is, according to above-mentioned existing technology, in the case where the system scale of the PLC system with multiple PLC becomes big, such as
Fruit user attempts gradually to create system monitoring picture, then because the unit number in a picture and frame numbers become many, therefore draws
Design man-hour needed for face is created becomes many.Meanwhile, the workload of the setting of database also increases, and becomes the burden of user.
The present invention is exactly to propose in view of the above problems, and its object is to obtain a kind of design of information system aid
And design of information system auxiliary program, the design of information system aid and the reduction of design of information system auxiliary program exist
User is in order to carry out the homework burden that the establishment of system monitoring picture and the setting of database are born when building information system.
In order to solve the above problems, realize purpose, the present invention is a kind of design of information system aid, and it, which is generated, is used for
By PLC data display in the setting of the picture data of display unit and the database stored to the data of the PLC
Data, the design of information system aid is characterised by having:Memory cell, it can show edit tool by picture
And the setting means of the database is read, the picture shows that edit tool is shown using the picture data to picture
And editor;Input block is set, it receives the data class of the data of the PLC;Picture species input block, it receives institute
State the species of the picture of picture data;Database setup unit, it receives the setting data of the database;And data generation
Unit, it is directed to each data class, in memory cell generation by according to described in the type classification of the picture
The data that the setting data of picture data and the database are associated.
The effect of invention
Design of information system aid of the present invention realizes following effects, i.e. reduction is when building information system
User is in order to carry out the homework burden that the establishment of system monitoring picture and the setting of database are born.
Brief description of the drawings
Fig. 1 is the frame that illustrates of overall structure of the hardware for the personal computer being related to embodiments of the present invention
Figure.
Fig. 2 is the structure chart for the information system that embodiments of the present invention are related to.
Fig. 3 be represent design of information system aid, picture that embodiments of the present invention are related to show edit tool,
The block diagram of the structure of database setting means and database attachment means setting means.
Fig. 4 is to represent to be shown in the design of information system aid picture of display device in embodiments of the present invention
Figure.
Fig. 5 is the flow that illustrates of action for the design of information system aid being related to embodiments of the present invention
Figure.
Fig. 6 is the figure for the sample picture for representing the equipment picture that embodiments of the present invention are related to.
Fig. 7 is the figure for the sample picture for representing the tendency chart that embodiments of the present invention are related to.
Fig. 8 is the figure for the sample picture for representing the searching picture that embodiments of the present invention are related to.
Fig. 9 is the figure for representing to be shown in the database setting screen of display device in embodiments of the present invention.
Figure 10 is the picture data that embodiments of the present invention are related to and sets the structure chart of the template of data.
Embodiment
Below, design of information system aid of the present invention and information system structure are explained based on accompanying drawing
Build the embodiment of auxiliary program.In addition, the present invention is not limited to present embodiment.
Embodiment
Fig. 1 is the frame that illustrates of overall structure of the hardware for the personal computer 10 being related to embodiments of the present invention
Figure.In addition, as the embodiment of design of information system aid, design of information system aid is equipped on plate end
End, or offer can also be provided by ASP (Application Service Provider), it is right below as an example
Design of information system aid is equipped on personal computer 10 and illustrated.Personal computer 10 has:Input unit 11, its
It is keyboard and using mouse as the pointer device of representative;Display device 12, it is the display unit to user's display information;CPU
The central operation device 13 of (Central Processing Unit) etc;And storage device 14, it is with non-volatile
The memory cell of storage device and volatile storage.Data of the storage device 14 based on template, to by data described later
Equipment picture part, tendency chart, searching picture, database setting data and database connection dress that generation unit 26 is generated
Fixed number evidence is installed collectively to be stored.Storage device 14 also stores the number of the setting value that is inputted as described later by user etc
According to.In addition, as central operation device 13 execution when working storage, the appropriate volatile storage using storage device 14
Device.
Fig. 2 is the structure chart of information system 200 of the present embodiment.Information system 200 has:Carry information system
Build the personal computer 10 of aid;It is used as the database 31 of relational database;By the number of data storage to database 31
According to storehouse attachment means 32;And be connected with database attachment means 32 PLC 71,72 ..., 7n.
In the relational database of database 31, by 1 number of packages according to the set for showing as multiple projects, i.e. field, by data
Set showed in the form of being referred to as table (table) form.First, design of information system is removed in personal computer 10
The relational database management system that is separately carried outside aid carries out the name of database, and carry out table and field are set
Fixed, establishment has database 31.Relational database management system can use the software that market is sold.Relational database management system
The database name, table name and field name of database 31 are set.
PLC 71,72 ..., 7n obtained the production status on production scene and the information of equipment working condition.It is raw
The concrete example for producing the production status at scene is base unit, power consumption, production number, raw material store storage, the working time, unqualified
Number, certified products number and production schedule number.The concrete example of equipment working condition be such as work mechanism operating, stop and
At standby etc operating condition, such as fault message of work mechanism, lighting apparatus, Temperature-controlled appliance and air-conditioning equipment
Information and lighting apparatus, Temperature-controlled appliance and air-conditioning equipment in which of ON states or OFF state state etc
The currency of temperature.Database attachment means 32 collect by PLC 71,72 ..., the obtained data of 7n and store to database 31.
Production status and equipment working condition are shown in display device 12 in the data of database 31 based on putting aside.
Fig. 3 is the design of information system backman for representing to be realized by Fig. 1 central operation device 13 and storage device 14
Tool 100, picture show the knot of edit tool 101, database setting means 102 and database attachment means setting means 103
The block diagram of structure, wherein, the design of information system aid 100 output picture data and setting data, picture display are compiled
Collect instrument 101 and utilize picture data, the database setting means 102 is to utilize the relational database management system for setting data,
The database attachment means setting means 103 utilizes and sets data.Specifically, stored by 13 Duis by central operation device
The software corresponding with each instrument i.e. computer executable program stored in device 14 is handled, and is achieved in Fig. 3 institutes
Each functional module shown.As an example, design of information system aid 100 is deposited by 13 Duis by central operation device
The design of information system auxiliary program for being stored in storage device 14 is handled to realize.
Design of information system aid 100, picture show edit tool 101, database setting means 102 and data
Storehouse attachment means setting means 103 is able to access storage device 14.Therefore, it is defeated by design of information system aid 100
Going out to the picture data of storage device 14 can show that edit tool 101 is utilized by picture, by design of information system aid
100 outputs to the setting data of storage device 14 can set work by database setting means 102 and database attachment means
Tool 103 is utilized.
Design of information system aid 100 has:Menu screen display unit 21, it makes the show tools of display device 12
Menu screen;Set input block 22, its via input unit 11 receive menu screen at from user to setting value
Input;Picture species input block 23, it receives what user selected via input unit 11 from the picture of multiple species
The species of picture;Picture preview display unit 24, it is based on the setting value and choosing received by setting input block 22 from user
The species for the picture selected out and the display picture image of display device 12 is made according to the instruction of user;Database setup unit 25, its
Create the data used in the setting of database 31 and database attachment means 32;Data generating unit 26, it generates picture
Face data and setting data and export to storage device 14;And storage device 14.
Data generating unit 26 is inputted based on the setting value received by setting input block 22 from user, by picture species
The species for the picture that unit 23 is received from user and by database setup unit 25 create in database 31 and data
The data used in the setting of storehouse attachment means 32, generation picture data and setting data.
Picture shows that edit tool 101 is realized by following monitoring softwares, i.e. the monitoring software will can be shown by picture
Show picture data that edit tool 101 or design of information system aid 100 are created to be shown in the picture of display device 12 and
Edlin is entered to the picture by user.
Database setting means 102 is relational database management system, right based on database described later setting data 66
Database name, table name and the field name of database 31 are set.
Database attachment means setting means 103 be by the setting software that database attachment means 32 are set come
The functional module of realization, based on database attachment means described later setting data 67 to the field name of database attachment means 32
Device value with PLC is that linking between label (tag) is set.
Fig. 4 is to represent that the design of information system aid for being shown in display device 12 in embodiments of the present invention is drawn
The figure in face 40.As the initial picture of design of information system aid 100, shown in display device 12 by menu screen
Unit 21 and show the design of information system aid picture 40 shown in Fig. 4.As shown in figure 4, design of information system is aided in
Instrument picture 40 has:Menu display part 41, user is selected in the menu display part 41;Picture preview display part 42, its
The preview for the picture selected in menu display part 41 user is shown;Preview button 43, it is received for being existed with user
The content that menu display part 41 is selected performs picture preview, instruction from user;Database sets button 44, and it connects
Receive for instruction being shown to database setting screen 50 described later, from user;And generation button 45, it is received
Instruction for performing the generation of data based on the content for being selected and being specified by user.
The data selectionbar 410 for carrying out selection for the data class to menu display part 41 has answering for " base unit "
Select the check box 413 of frame 411, the check box 412 of " power consumption " and " production number ".For each data to menu display part 41
The number of devices column 420 that the number of devices of species is inputted has number of devices 421, the number of devices of " power consumption " of " base unit "
422 and the number of devices 423 of " production number ".Species for the picture to menu display part 41 carries out the picture and selecting column of selection
430 have the check box 433 of the check box 431, the check box 432 of " searching picture " and " tendency chart " of " equipment picture ".This
Outside, the number of devices that can carry out selection in menu display part 41 refers to the quantity of production line.1 production line, which is represented, for example " to be moved into
→ manufacturing procedure → inspection operation → take out of " etc series of processes.Menu display part 41 passes through menu screen display unit
21 and be shown in display device 12.
The picture shown as the preview screen in picture preview display part 42, multiple patterns are prepared with according to setting value
Picture.Shown in preview screen such as " equipment picture _ pattern 1 ", " picture of equipment picture _ pattern 2 " etc so that
User can select the picture being consistent with the hobby of oneself.Also, number of devices be set to it is multiple in the case of, be used as " raw
Produce number " picture, can select to show the picture of the i.e. each production line of each equipment, or to multiple equipment is collected after
1 picture shown.In 1 picture after multiple equipment is collected, the aggregate value of the production number of each production line is shown.
Below, the action using Fig. 5 flow chart to design of information system aid 100 is illustrated.Fig. 5 flow
The flow of figure is described by being stored in the design of information system auxiliary program of storage device 14.First, setting input is single
Member 22 receives by input unit 11 in the check box 411 to 413 of the data selectionbar 410 of menu display part 41 to be entered by user
The data class (step S100) chosen is gone.In fig. 4 it is shown that check box 411 and " production at " base unit "
The example that the check box 413 of number " is chosen.Then, setting input block 22 is received passes through the pin of input unit 11 by user
To among the number of devices column 420 of menu display part 41 in the step S100 data class received by setting input block 22
Number of devices and the number of devices (step S101) inputted.In fig. 4 it is shown that respectively to being hooked in data selectionbar 410
Choosing " base unit " input " 1 ", to the example for " production number " input " 2 " chosen in data selectionbar 410.
Then, picture species input block 23 receive by user the picture and selecting column 430 of menu display part 41 final election
The species (step S102) for the picture chosen in frame 431 to 433.As the species of picture, having prepared in advance can be
In the structure of information system 200 effectively by the use of equipment picture, tendency chart, searching picture etc diversified picture as
Template.
Then, judge whether user has pressed preview button 43 (step S103) by picture preview display unit 24.That is, draw
Face preview display unit 24 receives user's pressing to preview button 43.Picture preview display unit 24 be judged as having pressed it is pre-
Look at (step S103 in the case of button 43:Yes), will be with setting input block 22 and picture in picture preview display part 42
The suitable sample picture of data that face species input block 23 is received from user is shown in display device 12 (step S104).
From being judged as having pressed (the step S103 of preview button 43 by picture preview display unit 24:Yes) rise to sample and draw
Face be shown in picture preview display part 42 (step S104) untill actual act concrete example it is as follows.In step S100 extremely
The data received in S102 by setting input block 22 and picture species input block 23 from user are stored in storage dress
Put 14.In addition, picture preview display unit 24 is in the case where being judged as that preview button 43 is pressed, creates such as equipment and draw
The sample picture of face, tendency chart and searching picture etc and be temporarily stored in storage device 14.Then, picture preview display is single
Member 24 obtains the data of the setting value that is received from user etc from storage device 14, and temporarily storage will be stored in based on the data
The sample picture of device 14 is shown in picture preview display part 42.Fig. 6 is the figure for the sample picture for representing equipment picture.Fig. 7 is
Represent the figure of the sample picture of tendency chart.Fig. 8 is the figure for the sample picture for representing searching picture.
Picture preview display part 42 as shown in Figure 4 only to user in the picture species that menu display part 41 is selected 1
The picture of individual species carries out preview and shown, the picture species that user selects have it is multiple in the case of, preview is not carried out and is shown
Other pictures shown by label (tab) 401,402,403, user can by label 401,402,403 carry out
Select and preview is shown and switched over.In addition, in the case where number of devices is multiple, as shown in fig. 6, equipment picture is at 1
Configure, show and the part of set number of devices corresponding amount as production line A and production line B on picture.Tendency chart with
And searching picture is directed to each data class selected in the step s 100 and generated, shows with being directed to each number in step S101
According to the picture of the suitable quantity of the number of devices inputted.It is right alternatively, it is also possible to picture split etc. in the preview display
Multiple pictures should be shown in the picture and multiple equipment number of multiple species simultaneously.
(the step S103 in the case where not receiving the pressing of preview button 43:No) and after step S104, enter
Step S105, determines whether it has received user by database setup unit 25 and presses (step to database setting button 44
S105).(the step S105 in the case where being determined as that user has pressed database setting button 44 by database setup unit 25:
Yes), the database setting screen 50 shown in Fig. 9 is made to be shown in display device 12 (step S106) by database setup unit 25.
As shown in figure 9, database setting screen 50 has:Database name designating frame 51, it is specified to database name;
Table name designating frame 52, it is specified to the table in the database 31 specified by database name designating frame 51;And link setting
Column 53.Link setting column 53 is shown as " link of database-label is set " in fig .9.Also, database sets picture
Face 50 has:OK button 54, it makes database setup unit 25 perform the setting that user is inputted;And cancel button 55, its
Setting for user to be inputted is cancelled.
If database setup unit 25 receives pressing for database setting button 44, with SQL (Structured
Query Language) sentence specified to database name, by being emitted to database setting means 102, so as to obtain
Take the table name of the database of specified database name.Thus, in fig .9 so that with input to database name designating frame 51
The corresponding table name of database name is shown in table name designating frame 52 in the way of drop-down menu, is enabled a user to
Selected.
User respectively inputs specified database name to database name designating frame 51, and the table name of the database is inputted
To table name designating frame 52.Also, user inputs the field name in the table specified by table name designating frame 52 in link setting column 53
With set the label after PLC device value.User can carry out the data of selection to field name input in menu display part 41
Species, although or inputting and user can not be selected to want storage to the data kind of database 31 in the progress of menu display part 41
Class.Then, in step s 107, judge whether database setup unit 25 receives pressing to OK button 54.
(the step S107 in the case where being judged as that database setup unit 25 is received to the pressing of OK button 54:Yes),
Based on the input of above-mentioned user, database setup unit 25 can be by database name, table name, field name and field name and mark
Link setting between label is created as setting data, is temporarily preserved to storage device 14 (step S108).Here, exist
In the case that non-input field name is set with linking between label, database name, the table of the setting data as database 31
Name and field name are created as transient data, are stored in storage device 14.Be pressed in cancel button 55 and not
It is judged as that database setup unit 25 is received to (step S107 in the case of the pressing of OK button 54:No), into step
S109。
After step S108, or (step in the case that user sets the pressing of button 44 to database is not being received
Rapid S105:No), as the state pressed of the user to be received such as data generating unit 26 to generation button 45.Data generation is single
If member 26 receives user's pressing to generation button 45, based on the setting received by setting input block 22 from user
Value, temporarily the sample picture of storage device 14 is stored in by picture preview display unit 24 and is created by database setup unit 25
The data built, collectively generate picture data and setting data (step S109).The picture generated by data generating unit 26
Data and setting data are exported i.e. non-easy to such as HDD of storage device 14 (Hard Disk Drive) as file
The property lost memory (step S109).In addition, not being pressed in generation button 45 and finishing design of information system aid 100
In the case of, the sample picture and setting data of being temporarily stored in storage device 14 are deleted.
Figure 10 is the structure chart for representing following states, i.e. based on the setting received by setting input block 22 from user
Value, the species of the picture received by picture species input block 23 from user and the chain performed by database setup unit 25
The picture data and setting data for connecing setting and being generated in step S109, the state of preservation is concentrated as template 60.
Template 60 is to set data by picture data 62, database in units of the selected data class of user i.e. data type 61
66 and database attachment means setting data 67 constitute.In design of information system aid 100, prepare in advance out every
The template 60 for the structure that each data of individual data type 61 can be handled in association, when generating picture in step S109
Face data and setting data when, from data generating unit 26 storage device 14 with to template 60 set picture data and
The data file of setting data is stored.
Picture data 62 is made up of equipment picture part 63, tendency chart 64 and searching picture 65.Equipment picture portion
Part 63 is the parts data of constitution equipment picture, and equipment as indicated with 6 is created by configuring the parts data in equipment picture
Picture.Parts data corresponds to 1 equipment, and in the case where number of devices is multiple, many numbers of individual equipment are charged in 1 row
According to.The situation that number of devices is 1 is exemplified in Figure 10.Tendency chart 64 is the trend diagram data that picture shows edit tool 101.Retrieval
Picture 65 is the searching picture data that picture shows edit tool 101.Tendency chart and searching picture collectively show, no
Dependent on number of devices, therefore, 1 data is charged to respectively in 1 row in tendency chart 64 and searching picture 65.
Database setting data 66 are setting numbers used in the database setting means 102 set to database 31
According to including database name, table name and field name.Database attachment means setting data 67 are that database attachment means 32 are entered
Setting data used in the database attachment means setting means 103 of row setting, the device value comprising field name and PLC is mark
Link setting between label.Database sets data 66 and database attachment means setting data 67 are setting data, but such as
It is upper described, when in the picture in Fig. 9 not from user's input field name between label linking setting in the case of, set number
Database attachment means setting data 67 in are blank.
That is, generate picture data and setting data when, by will design of information system aid picture 40 by
The information of user's setting and the input value for being set to be directed to template 60 in the information that database setting screen 50 is set by the user, so that
It is equipment picture part 63, tendency chart 64, searching picture 65, database to the various data of template 60 according to data type 61
Setting data 66 and database attachment means setting data 67 are set in association.Specifically, for example Figure 10's
Data type 61 for " base unit " row in arrange " EquipmentData (a) ", " TrendGraphData (a) ",
" SearchData (a) ", " DBData (a) " and " DBConnectionUnitData (a) " is identified by being endowed identical
Symbol is " (a) ", and is associated as the data related to " base unit ".Row under " base unit " similarly, respectively
Equipment picture part 63, tendency chart 64, searching picture 65, database are set into number from by identifier " (b) " or " (c) "
It is associated according to 66 and database attachment means setting data 67 as the data related to " power consumption " or " production number ".
The generation of data generating unit 26 equipment picture part 63, tendency chart 64, searching picture 65, database setting data 66 and
Database attachment means set data 67, as by above-mentioned identifier come the picture data associated with identical data class
And setting data.
As shown in figure 3, the picture data exported by data generating unit 26 to storage device 14 can be shown by picture and compile
Volume instrument 101 is utilized, and the setting data exported by data generating unit 26 to storage device 14 can be by database setting means
102 and database attachment means setting means 103 utilize.
Therefore, based on the picture data 62 exported in step S109, picture shows that edit tool 101 can show picture
It is shown in display device 12.Then, user can show that configuration of the edit tool 101 to equipment picture is changed via picture,
Or enter to be about to the editor that the data supplementing that oneself is created is shown in the picture of picture etc.
In addition, setting data 66 based on the database exported in step S109, database setting means 102 is able to carry out
The setting of the database name of database 31, table name and field name.
In addition, setting data 67 based on the database attachment means exported in step S109, database attachment means are set
Determine to link setting between the field name and PLC device value i.e. label that instrument 103 is able to carry out in database attachment means 32.
In the past, when building information system, it is necessary to show that edit tool 101, database are set using picture respectively by user
Determine instrument 102 and database attachment means setting means 103 and independently perform picture and show shown by edit tool 101
The setting of the various data of the setting of the species of picture, database 31 and database attachment means 32.
, can be by Fig. 4 information system however, according to design of information system aid 100 of the present embodiment
System build the user in aid picture 40 and Fig. 9 database setting screen 50 be simply input and selection operation and
There is provided show edit tool 101, data to picture for the generation picture data corresponding with information system 200 and setting data
Storehouse setting means 102 and database attachment means setting means 103.Thereby, it is possible to cut down the workload of user.In addition, by
Picture data and various setting data are provided in complete, therefore, it is possible to prevent because the mismatch between various setting data causes
The problem of.
More than embodiment shown by representation be present disclosure an example, also can be with other
Known technology is combined, additionally it is possible to a part for structure is omitted, changed in the scope for not departing from the purport of the present invention.
The explanation of label
10 personal computers, 11 input units, 12 display devices, 13 central operation devices, 14 storage devices, 21 menus are drawn
Face display unit, 22 setting input blocks, 23 picture species input blocks, 24 picture preview display units, the setting of 25 databases
Unit, 26 data generating units, 31 databases, 32 database attachment means, 40 design of information system aid pictures, 41 dishes
Single display part, 42 picture preview display parts, 43 preview buttons, 44 databases setting button, 45 generation buttons, the setting of 50 databases
Picture, 51 database name designating frames, 52 table name designating frames, 53 link setting columns, 54OK buttons, 55 cancel buttons, 60 templates, 61
Data type, 62 picture datas, 63 equipment picture parts, 64 tendency charts, 65 searching pictures, 66 databases setting data, 67
Database attachment means set data, 71,72 ..., 7n PLC, 100 design of information system aids, 101 pictures display compile
The instrument of collecting, 102 database setting means, 103 database attachment means setting means, 200 information systems, 401,402,403 marks
Label, 410 data selectionbars, 411~413,431~433 check boxes, 420 number of devices columns, 421~423 number of devices, the choosing of 430 pictures
Select column.
Claims (6)
1. a kind of design of information system aid, its generate for by PLC data display in the picture data of display unit
And the setting data for the database that the data of the PLC are stored,
The design of information system aid is characterised by having:
Memory cell, it can be shown that the setting means of edit tool and the database is read by picture, and the picture is shown
Edit tool is shown and edited to picture using the picture data;
Input block is set, it receives the data class of the data of the PLC;
Picture species input block, it receives the species of the picture of the picture data;
Database setup unit, it receives the setting data of the database;And
Data generating unit, it is directed to each data class, in memory cell generation by according to the kind of the picture
The data that the picture data of class classification and the setting data of the database are associated.
2. design of information system aid according to claim 1, it is characterised in that
The setting means for the database attachment means that the memory cell can also be collected by the data to the PLC is read
Take,
The device value that the database setup unit receives the PLC corresponding with the data class is used as the database
The setting data of attachment means,
The data generating unit is directed to each data class, in memory cell generation by according to the kind of the picture
The setting data of the picture data, the setting data of the database and the database attachment means that class is classified are carried out
The data of association.
3. design of information system aid according to claim 1 or 2, it is characterised in that
Also there is picture preview display unit, kind of the picture preview display unit based on the data class and the picture
Class and be shown in the display unit above or equal to 1 preview screen.
4. a kind of design of information system auxiliary program, its generate for by PLC data display in the picture data of display unit
And the setting data for the database that the data of the PLC are stored, the design of information system auxiliary program can be by counting
Calculation machine is performed,
The design of information system auxiliary program is characterised by having:
Input step is set, the data class of the data of the PLC is received;
Picture species input step, receives the species of the picture of the picture data;
Database setting procedure, receives the setting data of the database;And
Data generation step, for each data class, in memory cell generation by according to the type classification of the picture
The picture data and the database the data that are associated of setting data, the memory cell can show by picture
Show that the setting means of edit tool and the database is read, the picture shows edit tool using the picture data to drawing
Face is shown and edited.
5. design of information system auxiliary program according to claim 4, it is characterised in that
The setting means for the database attachment means that the memory cell can also be collected by the data to the PLC is read
Take,
In the database setting procedure, the PLC corresponding with data class device value is received as described
The setting data of database attachment means,
In the data generation step, for each data class, it will be drawn in memory cell generation according to described
The setting number of the picture data of the type classification in face, the setting data of the database and the database attachment means
According to the data associated.
6. the design of information system auxiliary program according to claim 4 or 5, it is characterised in that
Also there is picture preview step display, in the picture preview step display, based on the data class and the picture
The species in face, the display unit is shown in above or equal to 1 preview screen.
Applications Claiming Priority (1)
Application Number | Priority Date | Filing Date | Title |
---|---|---|---|
PCT/JP2014/083177 WO2016098168A1 (en) | 2014-12-15 | 2014-12-15 | Information system construction support tool and information system construction support program |
Publications (2)
Publication Number | Publication Date |
---|---|
CN107003664A true CN107003664A (en) | 2017-08-01 |
CN107003664B CN107003664B (en) | 2019-04-19 |
Family
ID=56126092
Family Applications (1)
Application Number | Title | Priority Date | Filing Date |
---|---|---|---|
CN201480084091.XA Active CN107003664B (en) | 2014-12-15 | 2014-12-15 | Design of information system auxiliary tool and design of information system auxiliary program |
Country Status (6)
Country | Link |
---|---|
US (1) | US9922030B2 (en) |
JP (1) | JP6121068B2 (en) |
KR (1) | KR101886985B1 (en) |
CN (1) | CN107003664B (en) |
DE (1) | DE112014007254T5 (en) |
WO (1) | WO2016098168A1 (en) |
Cited By (2)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
CN110573976A (en) * | 2018-04-06 | 2019-12-13 | 三菱电机株式会社 | System construction assistance device, system construction assistance method, and system construction assistance program |
CN115917459A (en) * | 2020-11-04 | 2023-04-04 | 三菱电机株式会社 | System construction assistance program, system construction assistance method, and system construction assistance device |
Families Citing this family (6)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
JP6837747B2 (en) * | 2016-02-18 | 2021-03-03 | コニカミノルタ株式会社 | Radiation imaging system |
JP6409985B1 (en) * | 2017-04-13 | 2018-10-24 | 三菱電機株式会社 | Display screen generating apparatus, factory automation system, and display screen generating method |
EP3413147B1 (en) | 2017-06-07 | 2022-03-23 | Brooks Automation (Germany) GmbH | Method for controlling a plc using a pc program |
US10248385B1 (en) * | 2017-11-30 | 2019-04-02 | International Business Machines Corporation | Extracting mobile application workflow from design files |
JP2020057332A (en) * | 2018-10-04 | 2020-04-09 | オムロン株式会社 | Program generation device, control method for program generation device, control program, and recording medium |
CN115087951A (en) * | 2020-02-12 | 2022-09-20 | 三菱电机株式会社 | Screen data creation program, screen data creation device, and screen data creation method |
Citations (5)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
JP2006277734A (en) * | 2005-03-01 | 2006-10-12 | Omron Corp | Network diagram display device |
CN101681157A (en) * | 2007-05-31 | 2010-03-24 | 三菱电机株式会社 | Control system engineering apparatus |
CN202141924U (en) * | 2011-03-31 | 2012-02-08 | 广东冠粤路桥有限公司 | Monitoring system for asphalt mixing equipment |
CN102622165A (en) * | 2011-02-01 | 2012-08-01 | 三菱电机株式会社 | Programmable display |
CN102819231A (en) * | 2007-05-31 | 2012-12-12 | 三菱电机株式会社 | Control system design device |
Family Cites Families (25)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
JPH07160311A (en) * | 1993-12-08 | 1995-06-23 | Fuji Electric Co Ltd | Superimposing display device for operation display unit |
US6850808B2 (en) * | 1999-09-24 | 2005-02-01 | Rockwell Software Inc. | Method and system for developing a software program using compound templates |
JP4000841B2 (en) | 2001-12-07 | 2007-10-31 | 松下電工株式会社 | Connection setting support tool in distributed control system |
JP4175041B2 (en) | 2002-06-26 | 2008-11-05 | オムロン株式会社 | Screen creation device and program |
JP2004178157A (en) | 2002-11-26 | 2004-06-24 | Yokogawa Electric Corp | Programmable logic controller supporting device |
US7493310B2 (en) * | 2002-12-30 | 2009-02-17 | Fisher-Rosemount Systems, Inc. | Data visualization within an integrated asset data system for a process plant |
JP4197466B2 (en) * | 2003-06-20 | 2008-12-17 | 株式会社山武 | How to display process event occurrence history |
US8751616B2 (en) * | 2004-06-08 | 2014-06-10 | Siemens Industry, Inc. | System for accessing and browsing a PLC provided within a network |
US20060069689A1 (en) * | 2004-06-08 | 2006-03-30 | Gregory Karklins | Method for accessing and browsing a PLC provided within a network |
JP4485326B2 (en) * | 2004-11-05 | 2010-06-23 | 株式会社デジタル | PROGRAMMABLE DISPLAY, DISPLAY CONTROL PROGRAM, AND RECORDING MEDIUM CONTAINING THE PROGRAM |
US7827494B1 (en) * | 2005-04-08 | 2010-11-02 | Adobe Systems Incorporated | Layout management using data-descriptive meta language documents |
US20070067458A1 (en) * | 2005-09-20 | 2007-03-22 | Rockwell Software, Inc. | Proxy server for integration of industrial automation data over multiple networks |
US8392845B2 (en) * | 2007-09-04 | 2013-03-05 | Fisher-Rosemount Systems, Inc. | Methods and apparatus to control information presented to process plant operators |
US20090089226A1 (en) * | 2007-09-28 | 2009-04-02 | Rockwell Automation Technologies, Inc. | Visualization of non-time series events |
US7809458B2 (en) * | 2008-03-31 | 2010-10-05 | Honda Motor Co., Ltd. | Process control system with ability to exchange data with production line machine controllers |
JP5091308B2 (en) * | 2008-04-09 | 2012-12-05 | 三菱電機株式会社 | Graphic user interface device |
EP2309358B1 (en) * | 2008-08-06 | 2016-09-21 | Mitsubishi Electric Corporation | Plant monitoring control system |
GB2476011B (en) * | 2008-09-29 | 2013-05-15 | Fisher Rosemount Systems Inc | Efficient design and configuration of elements in a process control system |
US8438192B2 (en) * | 2008-09-30 | 2013-05-07 | Rockwell Automation Technologies, Inc. | System and method for retrieving and storing industrial data |
US8825183B2 (en) * | 2010-03-22 | 2014-09-02 | Fisher-Rosemount Systems, Inc. | Methods for a data driven interface based on relationships between process control tags |
JP5486378B2 (en) * | 2010-03-31 | 2014-05-07 | 株式会社キーエンス | External device characteristic display system, display device, and external device characteristic display method |
US9372835B2 (en) * | 2010-09-01 | 2016-06-21 | Pilot.Is Llc | System and method for presentation creation |
KR20130105692A (en) * | 2010-12-24 | 2013-09-25 | 미쓰비시덴키 가부시키가이샤 | Screen creation system for programmable indicator |
FR2976379B1 (en) * | 2011-06-08 | 2019-04-26 | Schneider Electric Industries Sas | SYSTEM AND METHOD FOR SHARING DATA STORED IN A DATABASE |
JP6051682B2 (en) * | 2011-09-14 | 2016-12-27 | 株式会社リコー | Display processing apparatus, image forming system, and program |
-
2014
- 2014-12-15 US US15/528,553 patent/US9922030B2/en not_active Expired - Fee Related
- 2014-12-15 WO PCT/JP2014/083177 patent/WO2016098168A1/en active Application Filing
- 2014-12-15 KR KR1020177016127A patent/KR101886985B1/en active IP Right Grant
- 2014-12-15 CN CN201480084091.XA patent/CN107003664B/en active Active
- 2014-12-15 JP JP2016554295A patent/JP6121068B2/en active Active
- 2014-12-15 DE DE112014007254.0T patent/DE112014007254T5/en not_active Withdrawn
Patent Citations (5)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
JP2006277734A (en) * | 2005-03-01 | 2006-10-12 | Omron Corp | Network diagram display device |
CN101681157A (en) * | 2007-05-31 | 2010-03-24 | 三菱电机株式会社 | Control system engineering apparatus |
CN102819231A (en) * | 2007-05-31 | 2012-12-12 | 三菱电机株式会社 | Control system design device |
CN102622165A (en) * | 2011-02-01 | 2012-08-01 | 三菱电机株式会社 | Programmable display |
CN202141924U (en) * | 2011-03-31 | 2012-02-08 | 广东冠粤路桥有限公司 | Monitoring system for asphalt mixing equipment |
Cited By (3)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
CN110573976A (en) * | 2018-04-06 | 2019-12-13 | 三菱电机株式会社 | System construction assistance device, system construction assistance method, and system construction assistance program |
CN110573976B (en) * | 2018-04-06 | 2020-12-18 | 三菱电机株式会社 | System construction assistance device and system construction assistance method |
CN115917459A (en) * | 2020-11-04 | 2023-04-04 | 三菱电机株式会社 | System construction assistance program, system construction assistance method, and system construction assistance device |
Also Published As
Publication number | Publication date |
---|---|
JP6121068B2 (en) | 2017-04-26 |
KR101886985B1 (en) | 2018-08-08 |
JPWO2016098168A1 (en) | 2017-04-27 |
WO2016098168A1 (en) | 2016-06-23 |
CN107003664B (en) | 2019-04-19 |
US20170262436A1 (en) | 2017-09-14 |
DE112014007254T5 (en) | 2017-09-07 |
US9922030B2 (en) | 2018-03-20 |
KR20170077254A (en) | 2017-07-05 |
Similar Documents
Publication | Publication Date | Title |
---|---|---|
CN107003664A (en) | Design of information system aid and design of information system auxiliary program | |
JP5850033B2 (en) | Field device management apparatus, device information display method, computer program, and recording medium | |
JP5157282B2 (en) | Equipment information collection management system | |
CN102902767A (en) | Method and system for rapidly creating forms | |
CN107480380B (en) | A kind of engineering drawing generation method based on template | |
JPH10335193A (en) | Manufacturing process specification generation/operation system, process data generation system, and method for manufacturing semiconductor device | |
CN107957713B (en) | System and method for generating multiple work table exports | |
CN105320504A (en) | Visual software modeling method for constructing software view on basis of software meta view | |
TWI304950B (en) | Fault detection and classification (fdc) specification management apparatus and method thereof | |
US20210182101A1 (en) | Program generating device, program generating method, and information storage medium | |
CN105144004B (en) | Program map display device and programme diagram display methods | |
CN109033729B (en) | Product design information management method and system | |
CN104156199B (en) | A kind of automatic continuous integrated approach of software and system | |
CN106325833A (en) | Code generation method for enterprise information management | |
JP6761004B2 (en) | Tool management system, tool management device and tool management method | |
CN107430475A (en) | Object adjusts instrument and object adjustment programme | |
KR101431995B1 (en) | Facility management device, screen display method, and recording medium | |
US20030090526A1 (en) | Analysis work support system | |
CN104679499A (en) | IC equipment human-computer interaction interface customizable data displaying method | |
CN105241011B (en) | Air-conditioning group control system development device and method | |
CN105122157B (en) | Program editing device and program editing method | |
CN103809973B (en) | Graphic control interface design system and graphic control interface design operation method thereof | |
US8839124B2 (en) | Apparatus for configuring a diagnostics module for an industrial plant | |
CN115545401A (en) | City physical examination evaluation method and system based on visual index model configuration and computer equipment | |
KR20160014786A (en) | System construction assist device, method, and recording medium |
Legal Events
Date | Code | Title | Description |
---|---|---|---|
PB01 | Publication | ||
PB01 | Publication | ||
SE01 | Entry into force of request for substantive examination | ||
SE01 | Entry into force of request for substantive examination | ||
GR01 | Patent grant | ||
GR01 | Patent grant |