Controller-Based SQL Table Generation for Factory Data Upload
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 columns, requiring complex preliminary settings.
Innovation Solution
A development tool that communicates with a controller to generate SQL statements for creating tables based on user-designated variables, data types, and identification names, allowing users to set primary keys and manage structural body members without formulating SQL statements.
Engineering Contradictions & Design Principles
Engineering Contradiction Analysis
1Reliability
If a user manually defines column attributes and associates data items with columns to create a database table, then the database structure becomes properly organized and reliable, but the complexity of the operation increases significantly and requires SQL expertise
Solution Approach 1:
The patent introduces a development tool as an intermediary between the user and the database system. This tool automatically generates SQL statements based on user-friendly settings, mediating the complex SQL formulation process and presenting a simplified interface to users without SQL expertise.
Solution Approach 2:
The system enables self-service by allowing users to configure table creation through simple settings in the development tool without needing to manually write or understand SQL statements. The tool automatically handles the complex tasks of generating proper SQL syntax and formatting based on user selections.
2Manufacturing precision
If a user manually formulates SQL statements to create database tables, then precise control over table structure is achieved, but the time and expertise required for the process increases
Solution Approach 1:
The patent applies preliminary action by having the development tool pre-generate and prepare SQL statements based on user settings before actual table creation. The tool performs the complex SQL formulation work in advance, allowing users to simply review and confirm the generated statements without manually writing them.
Solution Approach 2:
The system uses copying by generating SQL statements as templates based on predefined patterns and user selections. Instead of requiring users to create unique SQL statements from scratch, the tool copies and adapts standard SQL structures to match the specific table requirements, significantly reducing the time and expertise needed.
3Ease of operation
If automatic generation of SQL statements is implemented, then ease of operation improves and SQL expertise is not required, but the device complexity increases due to the development tool
Solution Approach 1:
The development tool is designed with multi-functionality, serving not only for table creation but also for variable designation, data type specification, and other database development tasks. This universal approach consolidates multiple functions into a single tool, making the added complexity worthwhile by providing comprehensive database development capabilities through one integrated system.
Data Source
AI summary
There has been desired a technique for creating a table on a database without formulating an SQL statement. A control system includes a development support device and a controller. The development support device includes a development tool configured to accept, as setting information, a setting that designates collection target variables from among variables included in a control program, and a setting that designates an identification name, on a database, of each collection target variable. The controller includes a generation module-configured to output an SQL statement for creating a table on the database, based on a data type and an identification name on the database, the identification name being specified in the setting information.