Factory Automation SQL Table Generation from Control Variables
Find Innovative SolutionsGenerate Solutions
Solution Overview
Problem
Users without SQL expertise face difficulties in creating tables on databases for uploading data in factory automation systems, as they need to define column attributes and associate data items with column names, requiring complex preliminary settings.
Innovation Solution
A controller with a generation module that outputs an SQL statement for creating a table, determining identification names and data types based on correspondence, allowing users to create tables without formulating SQL statements, and enabling easy management of structural bodies and primary keys.
Engineering Contradictions & Design Principles
Engineering Contradiction Analysis
1Manufacturing precision
If a user manually defines column attributes and associates data items with column names to create a database table, then the table structure can be precisely controlled, but the operation complexity and time required increase significantly for users without SQL expertise
Solution Approach 1:
The system performs automatic table creation by having the controller generate SQL statements based on its own internal variable definitions and data structure information, eliminating the need for manual user configuration and association work
Solution Approach 2:
The controller acts as an intermediary between the user's data upload needs and the database, automatically translating user variables into proper SQL table creation statements without requiring the user to directly interact with SQL or database structure definitions
2Manufacturing precision
If a user manually formulates SQL statements to create database tables, then precise control over column attributes and data types is achieved, but the time and expertise required increase
Solution Approach 1:
The controller performs preliminary actions by automatically defining column attributes, data types, and associations based on its internal variable definitions before the actual table creation, eliminating the need for users to perform these time-consuming manual configuration steps
Solution Approach 2:
The system generates the SQL statements automatically based on the controller's own internal data structure definitions, performing the table creation task autonomously without requiring user time or expertise in SQL formulation
3Reliability
If complex preliminary settings are required for database table creation, then the table structure can be optimized for data upload, but the ease of use deteriorates for users without SQL knowledge
Solution Approach 1:
The controller serves as an intermediary that handles the complex preliminary settings automatically, translating user variables and data structures into optimized database table structures without requiring users to understand or configure these complex parameters manually
Solution Approach 2:
The system performs the complex preliminary configuration work autonomously by having the controller generate appropriate SQL statements based on its internal variable definitions, ensuring reliable data upload structure without user intervention in the complex setup process
Data Source
AI summary
There has been desired a technique for creating a table on a database without formulating an SQL statement. A control program for a controller includes a generation module configured to output an SQL statement for creating, on a database, a table in which collection target variables included in the control program are stored. The generation module determines an identification name, on the database, of each collection target variable, identifies, based on a correspondence between a data type usable in the control program and a data type usable in the database, a data type on the database corresponding to the data type of the collection target variable in the control program, and generates the SQL statement based on the determined identification name and the identified data type.