Please wait a minute...
吉林化工学院学报, 2023, 40(7): 65-70     https://doi.org/10.16039/j.cnki.cn22-1249.2023.07.012
  本期目录 | 过刊浏览 | 高级检索 |
基于NL2SQL的智能搜索系统研究
展昭1**,李双远2 *
1.吉林化工学院 信息与控制工程学院,吉林 吉林 132022; 2.吉林化工学院 信息化建设办公室,吉林 吉林 132022
Research on Intelligent Search System based on NL2SQL
ZHAN Zhao1**, LI Shuangyuan2 *
1. School of Information and Control Engineering, Jilin Institute of Chemical Technology, Jilin City 132022, China; 2. Information Construction Office, Jilin Institute of Chemical Technology, Jilin City 132022, China
下载:  PDF (1002KB) 
输出:  BibTeX | EndNote (RIS)      
摘要 

在当今大数据时代,信息繁多,但是真正对自己有价值的数据很少,如何从冗杂的数据里面检索出自己真正需要的数据至关重要。传统的搜索系统只能够对已经出现的数据进行展示,不能够对数据进行整合、计算等处理。本文使用NL2SQL技术来实现搜索系统,首先构建异构图结构对数据进行预处理,然后通过相对位置的自注意力机制将异构图编码成高维隐层向量,最后通过树型解码器将高维隐层向量解码成SQL语句。这样能够更好的满足用户真实需求,用户能够更加自由地和数据库进行交互,充分挖掘出数据的价值。

服务
把本文推荐给朋友
加入引用管理器
E-mail Alert
RSS
作者相关文章
展昭
李双远
关键词:  NL2SQL  搜索系统  异构图  数据库     
Abstract: 

In the era of big data, there is a lot of information, but there is very little data that is really valuable to you. It is crucial to retrieve the data you really need from the redundant data. The traditional search system is only able to display the data that has appeared, not able to integrate, calculate and other processing of the data. This paper uses NL2SQL technology to implement the search system. First, we construct the heterogeneous graph structure to preprocess the data, then encode the heterogeneous graph into a high-dimensional hidden layer vector by the self-attention mechanism of relative position, and finally decode the high-dimensional hidden layer vector into SQL statements by the tree decoder. This can better meet the real needs of users, who can interact with the database more freely and fully exploit the value of the data.

Key words:  NL2SQL    search system    heterogeneous graph    database
               出版日期:  2023-07-25      发布日期:  2023-07-25      整期出版日期:  2023-07-25
ZTFLH:  TP311  
引用本文:    
展昭, 李双远 . 基于NL2SQL的智能搜索系统研究 [J]. 吉林化工学院学报, 2023, 40(7): 65-70.
ZHAN Zhao, LI Shuangyuan . Research on Intelligent Search System based on NL2SQL . Journal of Jilin Institute of Chemical Technology, 2023, 40(7): 65-70.
链接本文:  
http://xuebao.jlict.edu.cn/CN/10.16039/j.cnki.cn22-1249.2023.07.012  或          http://xuebao.jlict.edu.cn/CN/Y2023/V40/I7/65
[1] 李双远, 张明齐. 浅谈区块链技术及应用价值 [J]. 吉林化工学院学报, 2019, 36(3): 54-58.
[2] 张 鹏. 橡皮囊成形工艺参数数据库的开发[J]. 吉林化工学院学报, 2018, 35(3): 78-82.
[1] . [J]. Journal of Jilin Institute of Chemical Technology, 2018, 35(9): 0 .
[2] . [J]. Journal of Jilin Institute of Chemical Technology, 2018, 35(9): 0 .
[3] SHAO Bao-li, LU Da, ZHAO Dong-hui. The Application of Dimensional Analysis in the Physical Quantity Conversion between Physical System and Numerical System [J]. Journal of Jilin Institute of Chemical Technology, 2018, 35(9): 1 -3 .
[4] ZHANG Jian, ZHAO Xiang, QU Bo, WU Qi, LIU Yu-tong, LI Yu-shi, LIU Qun. Application of Phosphorus-sulfur-nitrogen Composite Flame Retardant in Cotton Fabric [J]. Journal of Jilin Institute of Chemical Technology, 2018, 35(9): 4 -7 .
[5] WU Ping, REN Hong, LU Fei, WEI Qingling. A Functional Material on Recognition of Zn(II) ions based on the New Azo Compound [J]. Journal of Jilin Institute of Chemical Technology, 2018, 35(9): 8 -10 .
[6] YANG Yan-jun, WANG Ya-hong, Yang Xiu-dong. Process Aptimization of Surfactant Assisted Extraction of Total Polyphenols from Kyllinga Brevifolia Rottb [J]. Journal of Jilin Institute of Chemical Technology, 2018, 35(9): 11 -15 .
[7] LIU Jin-lu, LEI Yong-ping, WANG xiao-lin, ZHONG fang-li. Study on the  Purification Method of Total Saponins fromFruit of Rosa Davuvrica Pall. and its  Purification Method [J]. Journal of Jilin Institute of Chemical Technology, 2018, 35(9): 16 -23 .
[8] SONG Jian-gang, ZHONG Fang-li, WANG Xiao-lin, LIN Yu. Study on Extraction of Anthocyanin from Aronia melanocarpa Fruit by Ionic liquid Ultrasound Assisted [J]. Journal of Jilin Institute of Chemical Technology, 2018, 35(9): 24 -31 .
[9] TAN Li-hui, TAN Hong-wu. The Crashworthiness Analysis of different Cross-Section Thin-Walled Components [J]. Journal of Jilin Institute of Chemical Technology, 2018, 35(9): 32 -35 .
[10] YU Wen-xin, ZHENG Kai, WANG Li-hui, LIU Hai-bo, Wang Jian-xin. The Influence of Magnetostrictive Transducer Radiation Plate material on Radiation Sound Field Distribution [J]. Journal of Jilin Institute of Chemical Technology, 2018, 35(9): 36 -40 .
Viewed
Full text


Abstract

Cited

  Shared   
  Discussed