Granted Patent B2

US 12,298,731 · App. 17/434,836 · Granted May 13, 2025

Inventors: Tomonari Inui (Kusatsu, JP); Kotaro Okamura (Kusatsu, JP)

Assignee: OMRON CORPORATION

G05B19/056G06F16/22

Abstract

Claims (37)

1. A control system for controlling a control target, the control system comprising:

a database configured to hold one or more tables;

a control apparatus comprising control circuitry configured to execute a control program and access the database via a network; and

processing circuitry communicatively coupled to the database and the control apparatus via the network and configured to implement at least:

an acquisition module configured to acquire a number of columns of a table and a data type of each column, the table being selected from among the one or more tables;

a setting module configured to define a structure including a number of members corresponding to the acquired number of columns, the structure being available in the control program; and

a determination module configured to determine a data type of each member of the structure in correspondence with the acquired data type of each column by referring to a data-type correspondence table that defines a correspondence between a data type of a column and a data type of a member,

wherein the determination module is configured to determine the data type of each member of the structure from among data types available in the control program, and

wherein the control program includes a first function block for executing an instruction to control access to the database, and in the first function block, each of a table name of the table and a variable for referring to entirety of the structure is set as an argument, and

wherein the control program includes a second function block for storing, in the control apparatus, data of a data type brought into correspondence with the data type of each column.

2. The control system according to claim 1 , wherein the determination module is configured to determine the data type of each member of the structure in accordance with selection by a user from among one or more candidates of a data type.

3. The control system according to claim 1 , wherein the determination module is configured to bring a table name of the selected table into correspondence as attribute information of a variable, the variable being used for referring to entirety of the structure.

4. The control system according to claim 1 , wherein the determination module is configured to bring a member name of each member of the structure into correspondence with a column name of each column.

5. The control system according to claim 1 , wherein the processing circuitry is further configured to implement a generation module configured to generate a program template for performing processing of adding, to a corresponding table, a record including values set for the respective members.

6. The control system according to claim 1 , further comprising an information processing apparatus configured to support development of the control program executed in the control apparatus,

wherein the information processing apparatus comprises the processing circuitry that is configured to implement the acquisition module, the setting module, and the determination module.

7. An information processing apparatus configured to support development of a control program executed in a control apparatus, the information processing apparatus comprising processing circuitry configured to implement at least:

acquisition module configured to acquire a number of columns of a table and a data type of each column, the table being selected from among one or more tables held by a database, the database being accessible to the control apparatus;

setting module configured to define a structure including a number of members corresponding to the acquired number of columns, the structure being available in the control program; and

determination module configured to determine a data type of each member of the structure in correspondence with the acquired data type of each column by referring to a data-type correspondence table that defines a correspondence between a data type of a column and a data type of a member,

wherein the determination module is configured to determine the data type of each member of the structure from among data types available in the control program,

wherein the control program includes a first function block for executing an instruction to control access to the database, and in the first function block, each of a table name of the table and a variable for referring to entirety of the structure is set as an argument, and

wherein the control program includes a second function block for storing, in the control apparatus, data of a data type brought into correspondence with the data type of each column.

8. The information processing apparatus according to claim 7 , wherein the determination module is configured to determine the data type of each member of the structure in accordance with selection by a user from among one or more candidates of a data type.

9. The information processing apparatus according to claim 7 , wherein the determination module is configured to bring a table name of the selected table into correspondence as attribute information of a variable, the variable being used for referring to entirety of the structure.

10. The information processing apparatus according to claim 7 , wherein the determination module is configured to bring a member name of each member of the structure into correspondence with a column name of each column.

11. A non-transitory computer-readable storage medium having stored thereon an executable information processing program for an information processing apparatus configured to support development of a control program executed in a control apparatus,

the information processing program, when executed by the information processing apparatus, causing the information processing apparatus to at least:

acquire a number of columns of a table and a data type of each column, the table being selected from among one or more tables held by a database, the database being accessible to the control apparatus;

define a structure including a number of members corresponding to the acquired number of columns, the structure being available in the control program; and

determine a data type of each member of the structure in correspondence with the acquired data type of each column by referring to a data-type correspondence table that defines a correspondence between a data type of a column and a data type of a member,

wherein the determining includes determining the data type of each member of the structure from among data types available in the control program,

wherein the control program includes a first function block for executing an instruction to control access to the database, and in the first function block, each of a table name of the table and a variable for referring to entirety of the structure is set as an argument, and

wherein the control program includes a second function block for storing, in the control apparatus, data of a data type brought into correspondence with the data type of each column.

12. The non-transitory computer-readable storage medium according to claim 11 , wherein the determining incudes determining the data type of each member of the structure in accordance with selection by a user from among one or more candidates of a data type.

13. The non-transitory computer-readable storage medium according to claim 11 , wherein the determining incudes bringing a table name of the selected table into correspondence as attribute information of a variable, the variable being used for referring to entirety of the structure.

14. The non-transitory computer-readable storage medium according to claim 11 , wherein determining incudes bringing a member name of each member of the structure into correspondence with a column name of each column.

Assignments (1)

Priority Claims (1)

Continuity (1)

References Cited (37)