一种交互式SQL生成方案  

InterConfig2SQL:Interactive Configuration to SQL

作　　者：万朔 陈佳 潘玉春[1] 

机构地区：[1]南京南瑞继保电气有限公司,江苏南京211102

出　　处：《工业控制计算机》2023年第3期19-21,共3页Industrial Control Computer

摘　　要：随着数字经济的蓬勃发展,电力、金融、教育等各行各业都在使用数据库进行数据存储和分析。提出一套交互式的SQL生成方案(InterConfig2SQL),只需要进行交互式的配置,就可以自动生成SQL进行OLAP查询。该方案前后端分离,前端引导用户进行交互式配置,后端将配置转换成SQL,兼容主流的关系型数据库,已被应用于电力自动化领域的多种场景。With the development of the digital economy,various industries such as electricity,finance,and education are using database for data storage and analysis.This paper proposes a set of interactive SQL generation scheme(InterConfig2SQL),which can automatically generate SQL for OLAP query only by interactive configuration.The front-end and back-end of the solution are separated.The front-end guides users to perform interactive configuration,and the back-end converts the configuration into SQL.It is also compatible with mainstream relational databases and has been applied to various scenarios in the field of power automation.

关 键 词：SQL解析 低代码 人机交互 

分 类 号：TP311.52[自动化与计算机技术—计算机软件与理论]