期刊文献+

基于自然语言处理技术的政务智能搜索引擎应用探索

Research on the Application of Government Affairs Intelligent Search Engine based on NL2SQL Technology
下载PDF
导出
摘要 为适应问答系统智能化程度越来越高的特点,提出基于自然语言处理转化为SQL(Structured Query Language,结构化查询语言)语言技术的政务智能搜索引擎系统。用户通过输入自然语言问题直接获得相关数据,数据可以表格、图形等方式直观地显示。建立了融合SQL语法和增强列信息的算法模型SQL Model,利用NL2SQL(Natural Language Processing to Structured Query Language,自然语言转化为结构化查询语言)技术设计政务智能搜索引擎系统,并以某市的人口数据进行实验。实验结果表明,该技术可有效降低数据应用的复杂度,实现多维度复杂查询,降低业务部门数据搜索应用难度,提高政务数据搜索效率。 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.
作者 姚俊华 汤代佳 YAO Junhua;TANG Daijia(Shenzhen Nanshan District Government Affairs Service Data Management Bureau,Shenzhen 518000,China;Shenzhen United Information Technology Company,Shenzhen 518000,China)
出处 《软件工程》 2023年第2期59-62,58,共5页 Software Engineering
基金 深圳市基础研究重点项目(20200829114939001) 深圳市科技计划项目(GJHZ20180929154602092) 深圳市技术攻关面上项目(JCYJ20190809145407809).
关键词 问答系统 NL2SQL 政务智能搜索引擎系统 SQL Model question answering system NL2SQL government affairs intelligent search engine system SQL model
  • 相关文献

参考文献4

二级参考文献25

  • 1龚汉明,周长胜.汉语分词技术综述[J].北京机械工业学院学报,2004,19(3):52-55. 被引量:26
  • 2孟小峰,王珊.嵌套查询的非嵌套化处理研究[J].计算机学报,1995,18(4):241-251. 被引量:2
  • 3李明琴,李涓子,王作英,陆大.语义分析和结构化语言模型[J].软件学报,2005,16(9):1523-1533. 被引量:7
  • 4翟伟斌,周振柳,蒋卓明,许榕生.汉语分词词典设计[J].计算机工程与应用,2007,43(1):1-2. 被引量:11
  • 5Androutsopoulos L.Natural langage interfaces to database-An introduction[J].Journal of Natural Language Engineering,1995,1(1):29-81.
  • 6Meng Xiaofeng,Liu Shuang,Wang Shan.Word Segmentation Based on Database Semantics in NChiql[J].J.Comput.Sci.& Technoi.,2000,15(4):346-354.
  • 7Cheng Yuchang.Machine Learning-based Dependency Ana-lyzer for Chinese[C] //Proceedings of the International Con-ference on Chinese Computing.Singapore:[s.n.].2005:66-73.
  • 8Nivre J,Scholz M.Deterministic Dependency Parsing of Eng-lish Text[C] //Proceedings of COLING'04.Geneva,Switzer-land:[s.n.].2004:64-70.
  • 9Androutsopoulos I. Interfacing a Natural Language Front-end to a Relational Database in Department of Artificial Intelligence[D]. Edinburgh, UK: University of Edinburgh, 1993.
  • 10Kaplan S J. Designing a Portable Natural Language Database Query System[J]. ACM Transactions on Database Systems, 1984, 9(1): 1-19.

共引文献21

相关作者

内容加载中请稍等...

相关机构

内容加载中请稍等...

相关主题

内容加载中请稍等...

浏览历史

内容加载中请稍等...
;
使用帮助 返回顶部