Programmable logic controller, data collection apparatus, database access method, and database access program
AssigneeOMRON Corporation
InventorKotaro OKAMURA
Life of this patent
Estimating the term…
Abstract
A plurality of records are collectively manipulated with a simple structure, in a technology for manipulating a database without having to formulate SQL statements. A database access unit of a programmable logic controller generates an SQL statement for manipulating a plurality of records, with reference to a plurality of structure data included in a data group generated by an execution unit and definition data representing a definition of the structure data, and executes the SQL statement.
Claims9
A programmable logic controller configured to access a database, the controller comprising:
- a generation unit configured to generate structure data defining a single record, and to generate a data group including a plurality of the generated structure data;
- a storage unit configured to store definition data representing a definition of the structure data;
- and
- a database access unit configured to generate an SQL statement for manipulating a plurality of records, with reference to the plurality of structure data included in the data group generated by the generation unit and the definition data stored in the storage unit, and to execute the SQL statement.
A data collection apparatus configured to be connected to a programmable logic controller and to access a database, the apparatus comprising:
- an acquisition unit configured to acquire data from the programmable logic controller;
- a generation unit configured to generate structure data defining a single record from the data acquired by the acquisition unit, and to generate a data group including a plurality of the generated structure data;
- a storage unit configured to store definition data representing a definition of the structure data;
- and
- a database access unit configured to generate an SQL statement for manipulating a plurality of records, with reference to the plurality of structure data included in the data group generated by the generation unit and the definition data stored in the storage unit, and to execute the SQL statement.
A database access method of a programmable logic controller configured to access a database, the method comprising:
- a generation step of the programmable logic controller generating structure data defining a single record, and generating a data group including a plurality of the generated structure data;
- and
- a database access step of the programmable logic controller generating an SQL statement for manipulating a plurality of records, with reference to the plurality of structure data included in the data group generated in the generation step and definition data that represents a definition of the structure data, and executing the SQL statement.
A database access program for causing a programmable logic controller configured to access a database to execute:
- a generation step of generating structure data defining a single record, and generating a data group including a plurality of the generated structure data;
- and
- a database access step of generating an SQL statement for manipulating a plurality of records, with reference to the plurality of structure data included in the data group generated in the generation step and definition data that represents a definition of the structure data, and executing the SQL statement.
A database access method of a data collection apparatus configured to be connected to a programmable logic controller and to access a database, the method comprising:
- an acquisition step of the data collection apparatus acquiring data from the programmable logic controller;
- a generation step of the data collection apparatus generating structure data defining a single record from the data acquired in the acquisition step, and generating a data group including a plurality of the generated structure data;
- and
- a database access step of the data collection apparatus generating an SQL statement for manipulating a plurality of records, with reference to the plurality of structure data included in the data group generated in the generation step and definition data that represents a definition of the structure data, and executing the SQL statement.
A database access program for causing a computer connected to a programmable logic controller and configured to access a database to execute:
- an acquisition step of acquiring data from the programmable logic controller;
- a generation step of generating structure data defining a single record from the data acquired in the acquisition step, and generating a data group including a plurality of the generated structure data;
- and
- a database access step of generating an SQL statement for manipulating a plurality of records, with reference to the plurality of structure data included in the data group generated in the generation step and definition data that represents a definition of the structure data, and executing the SQL statement.
Dependencies are inferred from the claim text.