• 首页
  • 期刊简介
  • 编委会
  • 投稿指南
  • 收录情况
  • 杂志订阅
  • 联系我们
引用本文:姚俊华,汤代佳.基于自然语言处理技术的政务智能搜索引擎应用探索[J].软件工程,2023,26(2):59-62.【点击复制】
【打印本页】   【下载PDF全文】   【查看/发表评论】  【下载PDF阅读器】  
←前一篇|后一篇→ 过刊浏览
分享到: 微信 更多
基于自然语言处理技术的政务智能搜索引擎应用探索
姚俊华1,汤代佳2
(1.深圳市南山区政务服务数据管理局,广东 深圳 518000;
2.深圳市联合信息技术有限公司,广东 深圳 518000)
yaojunhuasz@163.com; tangdaijiasz@163.com
摘 要: 为适应问答系统智能化程度越来越高的特点,提出基于自然语言处理转化为SQL(Structured Query Language,结构化查询语言)语言技术的政务智能搜索引擎系统。用户通过输入自然语言问题直接获得相关数据,数据可以表格、图形等方式直观地显示。建立了融合SQL语法和增强列信息的算法模型SQL Model,利用NL2SQL(Natural Language Processing to Structured Query Language,自然语言转化为结构化查询语言)技术设计政务智能搜索引擎系统,并以某市的人口数据进行实验。实验结果表明,该技术可有效降低数据应用的复杂度,实现多维度复杂查询,降低业务部门数据搜索应用难度,提高政务数据搜索效率。
关键词: 问答系统;NL2SQL;政务智能搜索引擎系统;SQL Model
中图分类号: TP31    文献标识码: A
基金项目: 深圳市基础研究重点项目(20200829114939001);深圳市科技计划项目(GJHZ20180929154602092);深圳市技术攻关面上项目(JCYJ20190809145407809).
Research on the Application of Government Affairs Intelligent Search Engine based on NL2SQL Technology
YAO Junhua1, TANG Daijia2
( 1.Shenzhen Nanshan District Government Affairs Service Data Management Bureau, Shenzhen 518000, China ;
2.Shenzhen United Information Technology Company, Shenzhen 518000, China)
yaojunhuasz@163.com; tangdaijiasz@163.com
Abstract: In order to accommodate the increasingly intelligent characteristics of the question answering system, this paper proposes an intelligent search engine system for government affairs based on the technology of transforming natural language processing into SQL (Structured Query Language) language. Users can directly obtain relevant data by inputting natural language questions, and the data can be displayed intuitively in tables, graphs, and so on. An algorithm model of SQL Model is established that incorporates SQL syntax and enhances column information. NL2SQL (Natural Language Processing to Structured Query Language) technology is used to design the intelligent search engine system for government affairs, and an experiment is carried out with the population data of a city. The experimental results show that this technology can effectively reduce the complexity of data application, realize multi-dimensional complex query, reduce the application difficulty of data search in departments, and improve the data search efficiency of government affairs.
Keywords: question answering system; NL2SQL; government affairs intelligent search engine system; SQL model


版权所有:软件工程杂志社
地址:辽宁省沈阳市浑南区新秀街2号 邮政编码:110179
电话:0411-84767887 传真:0411-84835089 Email:semagazine@neusoft.edu.cn
备案号:辽ICP备17007376号-1
技术支持:北京勤云科技发展有限公司

用微信扫一扫

用微信扫一扫