JP3580348B2 - Data download control method, data download control device, and their recording media - Google Patents

Description

[0001]
TECHNICAL FIELD OF THE INVENTION
BACKGROUND OF THE INVENTION 1. Field of the Invention The present invention relates to a data download control method, a data download control device, and a recording medium thereof, and more particularly, to a device to be downloaded such as a PLC (programmable logic controller) in response to generation of a predetermined trigger for data stored in a database The present invention relates to a data download control method, a data download control device, and a recording medium for automatically downloading data to a data download control device.
[0002]
[Prior art]
In recent FA (factory automation) applications, when "something necessary timing" occurs, it is often constructed in such a way that "processing corresponding to it" is executed.
[0003]
For example,
1) Every time a predetermined time elapses, PLC data is collected in a form specified by the user and stored in a database.
2) When production by the PLC is started, necessary data such as recipe data, master data, and work instructions are searched and downloaded to the PLC.
The application is built in the form.
[0004]
[Problems to be solved by the invention]
However, the programming of the above-mentioned application is performed such that when "a necessary timing" occurs, that is, when a trigger occurs, a "corresponding process" is executed, that is, an action is executed. Programming is performed separately for each trigger type and each action type, and in this type of programming, it is often required to cooperate with other user applications. There has been a problem that the development cost is high and that it takes time to deal with the processing change.
[0005]
Therefore, the present invention provides a data download control method and a data download control which can realize, at a low development cost, a function of automatically downloading data stored in a database to a download target device in response to occurrence of a predetermined trigger. It is an object to provide devices and their recording media.
[0007]
In order to achieve the above object, the present invention provides In a data download control device for downloading data stored in a database to a download target device, a trigger indicating a timing of downloading data from the database to the download target device. The trigger ID, the trigger name, and the trigger type ID indicating the type of trigger are set in association with each other, and the trigger type execution program for generating the trigger is set in association with the trigger type ID. Set , Trigger setting means and an action for downloading data from the database to the download target device The action ID, the action name, and the action type ID indicating the action type are set in association with each other, and the action type execution program for executing the download action is set in association with the action type ID. Conditions for searching the target data from the database Set , Action setting means, job setting means for setting a job by associating the action ID set by the action setting means with the trigger ID set by the trigger setting means, and setting by the trigger setting means Trigger is generated by activating and executing a trigger type execution program corresponding to the trigger type ID of the trigger, and an event notification in which a trigger ID corresponding to the trigger type ID of the trigger type execution program is added by the occurrence of the trigger And during this event notification Trigger ID associated with the job setting means Action ID Corresponding to the action type ID of Action type execution program Automatically execute Thereby, an SQL sentence is created based on the stored search condition, the database is searched using the created SQL sentence, and data of a search result is downloaded from the database to the download target device. And a control means.
[0009]
BEST MODE FOR CARRYING OUT THE INVENTION
Hereinafter, an embodiment of a data download control method, a data download control device, and a recording medium thereof according to the present invention will be described in detail with reference to the accompanying drawings.
[0010]
FIG. 1 is a system configuration diagram showing an embodiment of a data download control method, a data download control device, and a data download control system configured by applying a recording medium thereof according to the present invention.
[0011]
In FIG. 1, this data download control system connects a data download control device 10 to a download target device 20 via a network or the like, and associates a data in a database 40 of the data download control device 10 with a predetermined trigger. An action to be downloaded is set in the memory 22 of the device 20, and the action corresponding to the trigger is automatically executed in response to the generation of the trigger, so that the data is downloaded from the database 40 of the data download control device 10 to the memory 22 of the device 20 to be downloaded. Is configured to download data.
[0012]
Here, the data download control device 10 includes an FA personal computer (personal computer) 100, and the trigger and action are set by the FA personal computer 100.
[0013]
The download target device 20 is configured by, for example, a PLC 21, and the memory 22 is configured as a memory that stores various data related to control of the PLC 21.
[0014]
The memory 22 has a variable area name DM, an offset of 10 ch, and a maximum number of records set to, for example, 20 records 1 to 20.
[0015]
Downloading of data from the database 40 of the data download control device 10 to the memory 22 of the download target device 20 is performed using an offset tag described in detail below.
[0016]
FIG. 2 is a diagram showing a specific operation example of the data download system shown in FIG.
[0017]
In FIG. 2, the database 40 of the data download control device 10 includes a recipe database that stores recipe data of the download target device 20.
[0018]
Here, the database 40 including the recipe database stores a product type table, and the product type table stores the materials and processes corresponding to the product types produced by the download target device 20.
[0019]
For example, for the type “1”, the material “A”, the process “1”, the material “B”, and the process “2” are stored in association with each other, and for the type “2”, the material “A” is stored. A, process "2", material "C", process "3", material "F", process "2" are stored in association with each other, and for product type "3", material "X", The process “1” is stored in association with the process.
[0020]
The head tag name “head material” (DM0010) of the target device area of the memory 22 of the download target device 20 includes the DB (material) A downloaded from the database 12 of the data download control device 10 and the tag “current value”. , DB (process): 1, constant: 0, DB (material) B, tag “current value”, DB (process): 2, constant: 0,.
[0021]
That is, the data downloaded from the database 40 of the data download control device 10 is allocated to the target device area of the memory 22 of the download target device 20 under the following conditions.
[0022]
Record sequence 1: DB field (material)
Record sequence 2: Tag "current value"
Record arrangement 3: DB field (processing)
Record arrangement 4: Constant (0)
MAX records: 20
If there is more than MAX: Download up to MAX
[0023]
FIG. 3 is a block diagram showing a detailed configuration of the data download control device shown in FIG.
[0024]
3, the data download control device 10 includes a device setting tool 11 for performing various settings for the data download control device 10, a setting table 12 for storing setting contents set by the device setting tool 11, and a data download control device 10. A tag setting tool 13 for setting a tag for data transfer by a tag, a tag database 14 for storing tags set by the tag setting tool 13, and a service processing unit 15 for executing a data flow control service by the data download control device 10. It is configured with.
[0025]
Here, the service processing unit 15 includes a control module 16 for executing data flow control by the data download control device 10, a trigger module 17 for generating various triggers, and an action module 18 for executing various actions. .
[0026]
Further, a command such as data collection start and stop is notified from the user application 50 to the control module 16 of the service processing unit 15, and a command such as generation of a trigger is notified from the user application 50 to the trigger module 17. The action module 18 notifies the user application 50 of the application (application notification).
[0027]
The action module 18 sends and receives data to and from the user data file 40.
[0028]
The service processing unit 15 transmits and receives data to and from the plurality of PLCs 20-1 and 20-2 via the gateway 60.
[0029]
Here, the service by the service processing unit 15 realizes a data logging process, a download process, and the like. That is, when a certain trigger occurs, the service processing unit 15 executes an action corresponding to the trigger. This
1) Store the data of the PLCs 20-1 and 20-2 in the user data file 40
2) Search the database created by the user under specified conditions, and write the results to the PLCs 20-1 and 20-2.
3) Notify the user application 50 as an action when a trigger occurs
And so on.
[0030]
In addition, the device setting tool 11
1) Registration of setting data required for service of service processing unit 15
2) Starting and stopping the service of the service processing unit 15
3) Registration, start, and end of a job, which is a unit of a trigger and an action (work) to be logged at that time
And other functions.
[0031]
In addition, the tag setting tool 13
1) Setting tags for the variable area of the target device
2) Setting of event memory mapping with target device
And other functions.
[0032]
The tag database 14 is a database that stores tag information set by the tag setting tool 13.
[0033]
The setting table 12 is a database that stores a collection of data necessary for executing the service of the service processing unit 15.
[0034]
The user data file 40 is a database in which data for actually logging data is stored or a database in which data to be downloaded is stored. The table configuration (schema) of this database can be designed and created by the user.
[0035]
FIG. 4 is a functional block diagram showing a detailed operation of the data download control device shown in FIG.
[0036]
4, the trigger setting unit 111 executes a trigger type setting program, that is, a trigger type 1 setting program 151-1, a trigger type 2 setting program 151-2, and a trigger type 3 setting program 151-3. Is set in the trigger setting database (trigger setting DB) 121.
[0037]
The job setting unit 112 sets a job in which a trigger and an action are associated with each other in a job setting database (job setting DB) 122.
[0038]
The action setting unit 113 executes an action type setting program, that is, an area download action setting program 152-1, an action type 2 setting program 152-2, and an action type 3 setting program 152-3, and stores the results in an action setting database. (Action setting DB) 123 is set.
[0039]
The trigger starting unit 151 reads the trigger set in the trigger setting database (trigger setting DB) 121 and the job set in the job setting database (job setting DB) 122, and executes an execution program of the trigger type, that is, execution of the trigger type 1 The start / stop command is notified to the program 153-1, the trigger type 2 execution program 153-2, the trigger type 3 execution program 153-3, and the trigger type 3 execution program 153-4.
[0040]
When an event occurs due to execution of the trigger type 1 execution program 153-1, the trigger type 2 execution program 153-2, the trigger type 3 execution program 153-3, and the trigger type 3 execution program 153-4, the event is transmitted to the flow control unit. 152 is notified.
[0041]
The flow control unit 152 that executes the event reads the action set in the action setting database (action setting DB) 123 and the job set in the job setting database (job setting DB) 122, and executes the execution program of the action type, that is, The execution instruction is notified to the area download execution program 154-1, the action type 2 execution program 154-2, the action type 3 execution program 154-3, and the action type 4 execution program 154-4.
[0042]
FIG. 5 is a diagram showing an example of the job setting database (job setting DB) shown in FIG.
[0043]
In FIG. 5, a job setting database (job setting DB) 122 includes a job table 122-1.
[0044]
The job table 122-1 shown in FIG. 5 is a table in which an action ID is stored in correspondence with a trigger ID.
[0045]
That is, in the job table 122-1 shown in FIG. 5, the action ID "200" is set for the trigger ID "100", the action ID "210" is set for the trigger ID "100", and the trigger ID This indicates that the action ID “230” is set for “110”.
[0046]
FIG. 6 is a diagram showing an example of the trigger setting database (trigger setting DB) shown in FIG.
[0047]
6, the trigger setting database (trigger setting DB) 121 includes a trigger table 121-1, a trigger program information table 121-2, and a table 121-3 for each trigger type.
[0048]
The trigger table 121-1 shown in FIG. 6 is a table in which a trigger name and a trigger type ID are stored in association with a trigger ID.
[0049]
That is, in the trigger table 121-1 shown in FIG. 6, the trigger name “every 30 seconds” and the trigger type ID “1” are set for the trigger ID “100”, and the trigger name “110” is set for the trigger ID “110”. This indicates that “production start” and the trigger type ID “3” are set.
[0050]
The trigger program information table 121-2 shown in FIG. 6 is a table in which a trigger type name, a setting program, and an execution program are stored in correspondence with a trigger type ID.
[0051]
That is, in the trigger program information table 121-2 shown in FIG. 6, for the trigger type ID "1", the trigger type name "fixed period", the setting program "SetCyclic", and the execution program "CyclicExec" are set. The trigger type name “specified time”, the setting program “SetTime”, and the execution program “TimeExe” are set for the ID “2”, and the trigger type name “condition match” and the setting program “ SetTag ”and the execution program“ TagExe ”are set.
[0052]
Further, a table 121-3 for each trigger type shown in FIG. 6 is a table for a fixed period trigger, and is a table in which a fixed period is stored in correspondence with a trigger ID.
[0053]
That is, in the table 121-3 for each trigger type shown in FIG. 6, the fixed period “0: 0: 30” is set for the trigger ID “100”, and the fixed period “0” is set for the trigger ID “101”. : 1: 0 "is set.
[0054]
FIG. 7 is a diagram showing an example of the action setting database (action setting DB) shown in FIG.
[0055]
7, the action setting database (action setting DB) 123 includes an action table 123-1, an action program information table 123-2, and a table 123-3 for each action type.
[0056]
The action table 123-1 shown in FIG. 7 is a table in which an action name and an action type ID are stored in association with the action ID.
[0057]
That is, in the action table 123-1 shown in FIG. 7, the action name “Result data collection” and the action type ID “1” are set for the action ID “200”, and the action name “210” is set for the action ID “210”. "Facility abnormality", action type ID "1" are set, and action name "instruction download" and action type ID "3" are set for action ID "230".
[0058]
The trigger program information table 123-2 illustrated in FIG. 7 is a table in which an action type name, a setting program, and an execution program are stored in association with an action type ID.
[0059]
That is, in the action program information table 123-2 shown in FIG. 7, an action type name "data collection (file)", a setting program "SetCollectFile", and an execution program "CollectFileExec" are set for the action type ID "1". For the action type ID "2", the action type name "Data collection (DB)", the setting program "SetCollectDB", and the execution program "CollectDBExe" are set, and for the action type ID "3", the action type name "Data". "Download", a setting program "SetDownLoadFile", and an execution program "DownLoadFileExe" are set.
[0060]
Further, a table 123-3 for each action type shown in FIG. 7 shows a table for data collection, and is a table in which a data collection file and a collection content are stored in correspondence with an action ID.
[0061]
That is, the table 123-3 for each action type shown in FIG. 7 indicates that the data collection file "Collect1.log" is set for the action ID "200".
[0062]
This data download control device has a table for a data download function for realizing the data download function, in addition to the tables shown in FIGS.
[0063]
FIG. 8 is a diagram showing a data download function table for implementing the data download function in the configuration shown in FIG.
[0064]
8, a table 124 for the data download function includes a tag table 124-1, an area download table (table for each action type) 124-2, a search table 124-3, a sort table 124-4, and a download allocation table 124-. 5 is provided.
[0065]
Here, the tag table 124-1 is a table in which a network number, a node number, a remote area, an offset, the number of channels, and a data type are stored in association with a tag name.
[0066]
That is, in the tag table 124-1 shown in FIG. 8, the network number "2", the node number "3", the remote area "DM", the offset "700", the number of channels "10" for the tag name "tag 1". "Indicates that the data type" BCD "has been set.
[0067]
The area download table (table for each action type) 124-2 is a table in which a database name, a table name, a download head tag, a record size, and a result notification tag are stored in correspondence with the action ID.
[0068]
That is, in the area download table (table for each action type) 124-2 shown in FIG. 8, a database name "DB1", a table name "TB1", a download head tag "AreaDown1", a record for an action ID "300" This indicates that the size “10” and the result notification tag “AnsTag” are set.
[0069]
The search table 124-3 is a table in which a search order, a field name, a symbol, a type, a value, and a connection condition are stored in correspondence with an action ID.
[0070]
That is, in the search table 124-3 shown in FIG. 8, for the action ID "300", the search order "1", the field name "Field1", the symbol ">", the type "constant", the value "10", the connection The condition “AND” is set, and the search order “2”, the field name “Field2”, the symbol “=”, the type “tag name”, the value “Tag1”, and the connection condition “END” are set for the action ID “300”. Indicates that it has been set.
[0071]
The sort table 124-4 is a table in which a search order, a field name, and a symbol are stored in association with an action ID.
[0072]
That is, in the sort table 124-4 shown in FIG. 8, a search order "1", a field name "Field1", and a symbol "descending order" are set for the action ID "300", and the action ID "300" is set for the action ID "300". This indicates that the search order “2”, the field name “Field2”, and the symbol “ascending order” are set.
[0073]
In addition, the download assignment table 124-5 is a table in which the assignment order, type, size, and value are stored in association with the action ID.
[0074]
That is, in the download allocation table 124-5 shown in FIG. 8, the allocation order "1", type "DB", size "2", and value "DB (Field3)" are set for the action ID "300". Assignment order “2”, type “constant”, size “1”, value “1” are set for action ID “300”, and assignment order “3”, type “DB” for action ID “300”. , Size “1”, and value “DB (Field 1)” are set.
[0075]
In the data download control system of this embodiment, the following SQL statement is created from the data download function table 124 shown in FIG.
[0076]
SELECT Field3, Field1 FROM DB1. TB1
WHERE Field1> 10 AND Field2 = Tag (Tag1)
ORDER BY Field1, Field2 DESC;
[0077]
In the area download execution program,
1) Open the database DB1 and execute the above SQL
2) However, immediately before the execution, the tag value of the WHERE sentence is read from the PLC and reflected in the SQL sentence.
3) Write the following values from the beginning of writing to the area based on the search result. The value of Field3, the value of constant 1, and the value of Field1 are downloaded for the records.
[0078]
Here, the SQL (Structured Query Language) sentence is a standard language for operating a relational database, and the standard is set by ISO / TC97 / SC5 / WG15, JIS, and the like. By using an SQL statement, operations such as addition, change, and deletion of data can be performed in the same manner for different database management systems.
[0079]
For a database search,
SELECT field 1, field 2, field 3 FROM table name
WHERE field a = (or other symbol) value 1, field b = value 2, ...
ORDER BY field x, field y;
Thus, data matching the WHERE condition can be retrieved from the FROM table, and the data in the field after SELECT as a result can be sorted and obtained by ORDER BY.
[0080]
The structure of the SQL statement in the case of addition to the database is as follows.
[0081]
INSERT INTO [table name] (field 1, field 2, ...)
VALUES (value1, value2, ...)
[0082]
Here, [table name] represents a table name to which data is to be added, and field 1, field 2,... Represent field names to which data is added in the table. Also, the values 1, 2,... After VALUES indicate the values of the data to be actually stored corresponding to the previous field names.
[0083]
The structure of the SQL statement in the case of updating to the database is as follows.
[0084]
UPDATE [table name] SET (field A = value a, field B = value b ...)
WHERE (field X = value x AND field Y = value y ...)
[0085]
Here, [table name] represents a table name for which data is to be updated, and field A, field B... Represent field names for updating data in the table. The values a and b indicate the values to be updated. The field X = value x AND field Y = value y... After the WHERE describes a condition for specifying which record in the table is to be updated.
[0086]
FIG. 9 is a flowchart showing the processing of the trigger setting unit shown in FIG.
[0087]
In FIG. 9, when the processing of the trigger setting unit 111 shown in FIG. 4 is started, first, the user selects one of the trigger type names registered in the trigger program information table 121-2 shown in FIG. (Step 201).
[0088]
Then, a setting program corresponding to the registered trigger type name is executed (Step 202). Then, the process of the job setting unit 111 ends.
[0089]
FIG. 10 is a flowchart showing an example of a process executed by the trigger setting program for each type selected in the process shown in FIG.
[0090]
The process shown in FIG. 10 indicates a process executed by the setting program when the trigger type is “fixed period”.
[0091]
In FIG. 10, when this processing is started, first, a trigger name is input (step 211). Next, an interval to be generated at a fixed period is input (step 212).
[0092]
Then, the trigger table 121-1 shown in FIG. 6 is set (step 213). Here, the trigger name is set to the name of the trigger input in this program, that is, the trigger name input in step 211, the trigger ID is generated by generating a unique ID, and the trigger type is set to a fixed period. It is set to the type ID that represents.
[0093]
Next, a table (periodic trigger table) 121-3 for each trigger type shown in FIG. 6 is set (step 214). Here, the trigger ID is set to the same ID as the trigger ID set in the trigger table 121-1, that is, the same ID as the ID set in step 213, and the fixed cycle is the value of the fixed cycle input in step 212. Is set. After that, this processing ends.
[0094]
FIG. 11 is a flowchart showing the processing of the action setting unit shown in FIG.
[0095]
11, when the process of the action setting unit 113 shown in FIG. 4 is started, first, the user selects one of the action type names registered in the action program information table 123-2 shown in FIG. (Step 221).
[0096]
Then, a setting program corresponding to the registered action type name is executed (step 202). Then, the process of the action setting unit 113 ends.
[0097]
FIG. 12 is a flowchart illustrating an example of a process executed by the action setting program for each type selected in the process illustrated in FIG.
[0098]
Note that the processing illustrated in FIG. 12 indicates processing executed by the setting program when the action type is “collect”.
[0099]
In FIG. 12, when this processing is started, first, an action name is input (step 231). Next, information necessary for data collection is input (step 232).
[0100]
Then, the action table 123-1 shown in FIG. 7 is set (step 233). Here, the action name is set to the name of the action input in this program, that is, the action name input in step 231, the action ID is set by generating a unique ID, and the action type represents collection. Set to the type ID.
[0101]
Next, a table (data collection table) 123-3 for each action type shown in FIG. 7 is set (step 234). Here, the action ID is set to the same ID as the trigger ID set in the action table 123-1, that is, the same ID as the ID set in step 233. The file name is set to the file name for data collection. The collection format sets which data is collected and how. After that, this processing ends.
[0102]
FIG. 13 is a flowchart showing the processing of the job setting unit shown in FIG. 13, when the process of the job setting unit 112 shown in FIG. 4 is started, first, a list of triggers registered in the trigger table 121-1 shown in FIG. 6 is displayed and generated therein. A trigger is selected (step 241).
[0103]
Next, a list of actions registered in the action table 123-1 shown in FIG. 7 is displayed, and an action to be executed when the previously selected trigger occurs is selected from the list (step 242).
[0104]
Then, each ID of the selected combination of the trigger and the action is registered in the job table 122-1 shown in FIG. 5 (step 243), and the processing of the job setting unit 112 is ended.
[0105]
FIG. 14 is a flowchart illustrating the activation process by the trigger activation unit illustrated in FIG.
[0106]
In the activation process shown in FIG. 14, first, the trigger ID of the job registered in the job table 122-1 shown in FIG. 5 is obtained (step 251).
[0107]
Next, the trigger ID is searched from the job table 122-1 shown in FIG. 5, and the trigger type is known (step 252).
[0108]
Then, an execution program corresponding to the trigger type is searched from the trigger program information table 121-2 shown in FIG. 6, and the corresponding execution program is started. At this time, a trigger ID is passed as a start parameter of the execution program (step 253).
[0109]
Next, it is checked whether or not all jobs have been completed (step 254). If not all jobs have been completed (NO in step 254), the process returns to step 251. If it is determined that all jobs have been completed, (YES in step 254), and proceeds to step 255.
[0110]
In step 255, a job action ID registered in the job table 122-1 shown in FIG. 5 is obtained.
[0111]
Then, the action ID is retrieved from the action table 123-1 shown in FIG. 7 to know the action type (step 256).
[0112]
Next, an execution program corresponding to the action type is searched from the action program information table 123-2 shown in FIG. 7, and the corresponding execution program is started. At this time, an action ID is passed as a start parameter of the execution program (step 257).
[0113]
Then, it is checked whether or not all the jobs have been completed (step 258). If not all the jobs have been completed (NO in step 258), the process returns to step 255, but if it is determined that all the jobs have been completed, (YES in step 258), and ends this process.
[0114]
FIG. 15 is a flowchart showing the processing by the execution program for each trigger activated by the processing shown in FIG.
[0115]
In FIG. 15, when this processing is started, the trigger ID passed at the time of activation is first increased, and the table 121-3 for each trigger type shown in FIG. A setting table is searched (step 261).
[0116]
Then, the setting contents for each type corresponding to the searched trigger ID are acquired (step 261). Here, the setting content for each type corresponding to the acquired trigger ID is, for example, an interval at which a trigger is generated at a fixed cycle in the fixed cycle trigger table.
[0117]
Next, preparations are made for generating a trigger based on the acquired information (step 263). Here, the preparation for generating a trigger based on the acquired information means that, for example, when the trigger type is a fixed period, a timer for generating a trigger is started for each period.
[0118]
Then, upon recognizing that the trigger has occurred, for example, when a timer interrupt occurs at a fixed period with a fixed period trigger, an event notification is performed to the flow control unit 152 shown in FIG. In this event notification, a trigger ID is added and notified (step 264).
[0119]
Next, it is determined whether or not to end the processing (step 265). If not (NO in step 264), the process returns to step 263. If it is determined that the processing is ended (YES in step 265), the processing ends. .
[0120]
FIG. 16 is a flowchart showing the processing of the flow control unit shown in FIG.
[0121]
In FIG. 16, when the process of the flow control unit 152 shown in FIG. 4 is started, first, it waits for event reception (step 271).
[0122]
Then, it is checked whether an event has been received (step 272). Here, if it is determined that the event is not received (NO in step 272), the process returns to step 271. If it is determined that the event is received (YES in step 272), the process returns to FIG. 5 based on the passed trigger ID. The job table 122-1 is searched to obtain a corresponding job ID (step 274).
[0123]
Then, the occurrence of the trigger is notified to the action execution program for each action ID activated in the activation process shown in FIG. 14 (step 275).
[0124]
Next, it is determined whether or not to end the processing (step 276). If it is determined that the processing is not to be ended (NO in step 276), the process returns to step 271. If it is determined that the processing is to be ended (YES in step 276), The process ends.
[0125]
FIG. 17 is a flowchart showing the execution program initialization process for each action type started by the process of FIG.
[0126]
In FIG. 17, when this process is started, first, the action ID passed at the time of activation is used to set the table 123-3 for each action shown in FIG. 7, that is, for example, the setting for each action consisting of a data collection action table. The table is searched (step 281).
[0127]
Next, the setting contents for each type corresponding to the searched action ID, for example, the information of the collection file name and the collection format are acquired from the data collection action table (step 282).
[0128]
Then, processing for each type is performed (step 283). For example, in data collection, processing such as opening a specified data collection file is performed.
[0129]
In this state, when the occurrence of a trigger is notified from the flow control unit 152 shown in FIG. 4, execution processing specific to the action type such as data collection is performed according to the set contents (step 284).
[0130]
Next, it is determined whether or not to end the processing (step 285). If it is determined that the processing is not to be ended (NO in step 285), the process returns to step 284. If it is determined that the processing is to be ended (YES in step 285), The process ends.
[0131]
FIG. 18 is a flowchart showing processing by the area download action setting program shown in FIG.
[0132]
In FIG. 18, when the processing by the area download action setting program is started, first, an action name related to the area download action setting program is input (step 301).
[0133]
Next, database information of the download source is input (step 302). Enter the database information of this download source,
1) Database name
2) Table name
Is performed by inputting.
[0134]
Then, feed information, that is, feed name, type, size, and the like are obtained from the input database table (step 303).
[0135]
Next, search conditions are input (step 304). This search condition is input by inputting the following information from the above fields.
[0136]
1) Feed name used for search
2) Symbol to compare feed and value
3) Value type
4) Value
5) Symbols connecting search expressions
[0137]
Next, a sort condition is input (step 305). The input of this sort condition is performed by inputting the following information from the above fields.
[0138]
1) Field name used for sorting
2) Select descending or ascending order
[0139]
Next, the download destination common condition is input (step 306). The input of the download destination common condition is performed by inputting the following information.
[0140]
1) Download destination tag name
2) Maximum record size
3) Result notification destination tag
[0141]
Next, a download destination record format is input (step 307). The input of the download destination record format is performed by inputting information of a field or less in one record of the download destination.
[0142]
1) Area field number
2) Area field type
3) Value
[0143]
Next, the following information is set in the download table (step 308).
[0144]
1) Action name: Name entered in this program
2) Action ID: Generate unique ID
3) Action type ID: Type ID indicating area download
[0145]
Next, database information of the download source is input (step 309). The database information of the download source is input by setting the following information in the area download table 124-2 shown in FIG. 8 based on the input of the download destination common condition in step 307.
[0146]
1) Action ID: The same ID as the ID in the action table 123-1 shown in FIG.
[0147]
Next, the search table 104-3 shown in FIG. 8 is set based on the search condition input in step 304 (step 310), and the sort table 124-4 shown in FIG. 8 is set based on the sort condition input in step 305. (Step 311) Based on the input of the download destination record format in Step 307, the download allocation table 124-5 shown in FIG. 8 is set (Step 312), and then this processing ends.
[0148]
FIG. 19 is a flowchart showing the download action execution program initialization processing shown in FIG.
[0149]
In FIG. 19, when the initialization processing of the area download execution program 154-1 shown in FIG. 4 is started, first, the area download table 124-2 shown in FIG. The data is obtained by searching the table 124-3, the sort table 124-4, and the download allocation table 124-5 (step 321).
[0150]
Next, the database is opened from the data source name (step 322).
[0151]
Then, an SQL statement is created from the acquired data (step 323), and a trigger is awaited (step 324).
[0152]
Next, a data download process is executed (step 325). Then, it is checked whether the data download processing has been completed (step 325). If it is determined that the data download processing has not been completed (NO in step 325), the process returns to step 325 and the data download processing is continued. If it is determined that the download processing has been completed (YES in step 326), the download action execution program initialization processing ends.
[0153]
FIG. 20 is a flowchart showing details of the data download processing shown in FIG.
[0154]
In FIG. 20, when the data download processing is started, first, if there is a tag name item in the WHERE statement in the SQL statement, the data of the variable area of the PLC corresponding to the tag name is acquired ( Step 332).
[0155]
Then, an SQL statement is completed based on the acquired data (step 332), and the SQL statement is executed on the database opened in the initialization process of FIG. 19 (step 333).
[0156]
Next, it is checked whether or not there is search data (step 334). If there is search data (YES in step 334), it is next checked whether the number is equal to or less than the maximum number (step 335). Here, if it is determined that the number is equal to or less than the maximum number (YES in step 335), the data is written from the download head tag according to the contents of the download allocation table shown in FIG. 8 based on the data obtained by executing the SQL statement. (Step 336).
[0157]
Next, the code of "normal download completed" is written into the result notification tag (step 337), and the data download process ends.
[0158]
If it is determined in step 334 that there is no search data (NO in step 334), a code of “no data” is written in the result notification tag, and the data download process ends.
[0159]
If it is determined in step 335 that the maximum number is exceeded (NO in step 335), a code of “data over” is written in the result notification tag (step 339), and the data download process ends. In this case, as the processing in this case, there are options such as whether to end with an error measure or to download up to MAX.
[0160]
FIG. 21 is a diagram illustrating an example of a table used for tag download.
[0161]
In the case of tag download, a tag download table (table for each action type) 124-6 and a tag download assignment table 124-7 are used in addition to the data download function table shown in FIG.
[0162]
Here, the tag download table (table for each action type) 124-6 is a table in which a database name, a table name, and a result notification tag are stored in association with the action ID.
[0163]
That is, in the tag download table (table for each action type) 124-6 shown in FIG. 21, the database name "DB1", the table name "TB1", and the result notification tag "AnsTag" are set for the action ID "300". It is shown that it is.
[0164]
The tag download assignment table 124-7 is a table in which an assignment tag, a type, a size, and a value are stored in association with an action ID.
[0165]
That is, in the tag download assignment table 124-7 in FIG. 21, the assignment tag “tag 1”, type “DB”, size “2”, and value are set to “DB (Field 3)” for the action ID “300”. The assigned tag “tag 2”, type “constant”, size “1” and value “1” are set for the action ID “300”, and assigned tag “tag 3” for the action ID “300”. , The type “DB”, the size “1”, and the value are set to “DB (Field 1)”.
[0166]
As described above, in this embodiment, the data download control device 10 is connected to the PLC which is the download target device 20 via a network or the like, and the data in the database 40 of the data download control device 10 is associated with a predetermined trigger. Is set in the memory 22 of the download target device 20, and the above action corresponding to the trigger is automatically executed in response to the occurrence of the trigger, whereby the download target device 20 is downloaded from the database 40 of the data download control device 10. Since the configuration described above is used to download the data to the memory 22, the following is possible.
[0167]
1) The function of downloading data to the PLC can be performed by setting parameters from the user.
[0168]
2) Search from the database can be performed based on the value on the PLC.
[0169]
3) As a result of downloading, for example, there is no data to be downloaded from the PLC.
[0170]
【The invention's effect】
As described above, according to the first aspect of the present invention, in a data download control method for downloading data stored in a database to a download target device, a timing of downloading data from the database to the download target device is indicated. An action for performing the download is set in association with a trigger, and data is downloaded from the database to the download target device by automatically executing an action corresponding to the trigger in response to the occurrence of the trigger. Therefore, a function of automatically downloading data stored in the database to the download target device in response to the occurrence of a predetermined trigger can be realized at low development cost.
[0171]
In the data download control device for downloading data stored in a database to a download target device, a trigger indicating a timing of downloading data from the database to the download target device is set. Trigger setting means, action setting means for setting an action for downloading data from the database to the download target device, and associating the action set by the action setting means in response to the trigger set by the trigger setting means And a control unit for executing an action associated with the job setting unit in response to occurrence of the trigger set by the trigger setting unit. Automatically it is possible to provide a data download control apparatus makes it possible to be realized at a low development cost the ability to download the stored data to the download target device in response to occurrence of a predetermined trigger.
[0172]
According to the third aspect of the present invention, in a recording medium storing a program for downloading data stored in a database to a download target device, a trigger indicating a timing of downloading data from the database to the download target device. Trigger setting means for setting, an action setting means for setting an action of downloading data from the database to the download target device, and an action set by the action setting means corresponding to the trigger set by the trigger setting means. And a control means for executing an action associated with the job setting means in response to occurrence of a trigger set by the trigger setting means. , Also It is possible to provide a data download control apparatus makes it possible to be realized at a low development cost function to automatically download to the download target device and data stored in the database in response to occurrence of a predetermined trigger.
[Brief description of the drawings]
FIG. 1 is a system configuration diagram showing an embodiment of a data download control method, a data download control device, and a data download control system configured by applying a recording medium thereof according to the present invention.
FIG. 2 is a view showing a specific operation example of the data download system shown in FIG. 1;
FIG. 3 is a block diagram showing a detailed configuration of a data download control device shown in FIG. 2;
FIG. 4 is a functional block diagram showing a detailed operation of the data download control device shown in FIG. 2;
FIG. 5 is a view showing an example of a job setting database (job setting DB) shown in FIG. 4;
FIG. 6 is a view showing an example of a trigger setting database (trigger setting DB) shown in FIG. 4;
FIG. 7 is a view showing an example of an action setting database (action setting DB) shown in FIG. 4;
FIG. 8 is a diagram showing a table for a data download function for realizing the data download function in the configuration shown in FIG. 4;
FIG. 9 is a flowchart showing processing of a trigger setting unit shown in FIG. 4;
10 is a flowchart illustrating an example of a process executed by a trigger setting program for each type selected in the process illustrated in FIG. 9;
FIG. 11 is a flowchart showing processing of an action setting unit shown in FIG. 4;
FIG. 12 is a flowchart showing an example of a process executed by an action setting program for each type selected in the process shown in FIG. 11;
FIG. 13 is a flowchart illustrating processing of a job setting unit illustrated in FIG. 4;
FIG. 14 is a flowchart showing activation processing by a trigger activation unit shown in FIG. 4;
FIG. 15 is a flowchart showing processing by an execution program for each trigger activated by the processing shown in FIG. 14;
FIG. 16 is a flowchart showing the processing of the flow control unit shown in FIG. 4;
FIG. 17 is a flowchart showing an execution program initialization process for each action type started by the process of FIG. 14;
FIG. 18 is a flowchart showing processing by an area download action setting program shown in FIG. 4;
FIG. 19 is a flowchart showing a download action execution program initialization process shown in FIG. 4;
FIG. 20 is a flowchart showing details of the data download processing shown in FIG. 19;
FIG. 21 is a diagram showing an example of a table used for tag download.
[Explanation of symbols]
10 Data download control device
11 Device setting tool
12 Setting table
13 Tag setting tool
14 Tag database
15 Service processing unit
16 Control module
17 Trigger module
18 Action Module
20 Download target devices
20-1, 20-2 PLC (Programmable Logic Controller)
40 database
50 User Application
60 Gateway
111 Trigger setting section
112 Job setting section
113 Action setting section
121 Trigger setting database (Trigger setting DB)
121-1 Trigger table
121-2 Trigger program information table
121-3 Table for Each Trigger Type
122 Job Setting Database (Job Setting DB)
122-1 Job table
123 Action Setting Database (Action Setting DB)
123-1 Action table
123-2 Action program information table
123-3 Table for each action type
124 Table for data download function
124-1 Tag table
124-2 Area download table (table for each action type)
124-3 Search Table
124-4 Sort Table
124-5 Download Allocation Table
142-6 Tag Download Table (Table for Each Action Type)
124-7 Tag Download Allocation Table
151 Trigger activation unit
151-1 Trigger type 1 setting program
151-2 Trigger type 2 setting program
151-3 Trigger type 3 setting program
152 Flow control unit
152-1 Area download action setting program
152-2 Action type 2 setting program
152-3 Action type 3 setting program
153-1 Trigger type 1 execution program
153-2 Trigger Type 2 Execution Program
153-3 Trigger Type 3 Execution Program
153-4 Trigger Type 4 Execution Program
154-1 Area download execution program
154-2 Action type 2 execution program
154-3 Action type 3 execution program
154-4 Action type 4 execution program

Claims (1)

In a data download control device that downloads data stored in a database to a download target device,
For a trigger indicating the timing of downloading data from the database to the download target device , a trigger ID, a trigger name, and a trigger type ID indicating the type of trigger are set in association with each other, and a trigger type for generating the trigger is executed. the program set corresponding to the trigger type ID, a trigger setting means,
An action type execution program for executing an action of downloading by setting an action ID, an action name, and an action type ID indicating an action type in association with an action of downloading data from the database to the download target device. Corresponding to the action type ID, and setting a condition for searching data to be downloaded from a database , action setting means,
Job setting means for setting a job by associating the action ID set by the action setting means with the trigger ID set by the trigger setting means;
A trigger is generated by activating and executing a trigger type execution program corresponding to the trigger type ID of the trigger set by the trigger setting means, and the generation of the trigger corresponds to the trigger type ID of the trigger type execution program. An event notification to which a trigger ID is added is performed, and the action type execution program corresponding to the action type ID of the action ID associated with the job setting means is automatically executed with respect to the trigger ID in the event notification , whereby the storage is performed. Control means for creating an SQL sentence based on the searched search condition, searching the database using the created SQL sentence, and downloading search result data from the database to the download target device ;
A data download control device comprising:

Images