一种交互式SQL生成方案

InterConfig2SQL:Interactive Configuration to SQL

随着数字经济的蓬勃发展,电力、金融、教育等各行各业都在使用数据库进行数据存储和分析。提出一套交互式的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.