English  |  正體中文  |  简体中文  |  全文筆數/總筆數 : 63190/95884 (66%)
造訪人次 : 4628229      線上人數 : 390
RC Version 7.0 © Powered By DSPACE, MIT. Enhanced by NTU Library & TKU Library IR team.
搜尋範圍 查詢小技巧:
  • 您可在西文檢索詞彙前後加上"雙引號",以獲取較精準的檢索結果
  • 若欲以作者姓名搜尋,建議至進階搜尋限定作者欄位,可獲得較完整資料
  • 進階搜尋
    請使用永久網址來引用或連結此文件: https://tkuir.lib.tku.edu.tw/dspace/handle/987654321/125171

    題名: SV2-SQL: A Text-to-SQL Transformation Mechanism Based on BERT Models for Slot Filling, Value Extraction and Verification
    作者: Chang, C. Y.;Liang, Yuan-Lin;Wu, Shih-Jung;Roy, Diptendu Sinha
    關鍵詞: NL2SQL;Slot filling;BERT;SV2-SQL;Information retrieval;Semantic parsing
    日期: 2024-01-16
    上傳時間: 2024-03-07 12:06:04 (UTC+8)
    出版者: Springer
    摘要: Information retrieval from databases is challenging for a non-SQL-domain expert. Some previous studies have provided solutions for translating the natural language to SQL instruction, aiming to access the information in the database directly. However, most solutions are in English Natural Language. In addition, the accuracies of the existing works still need to be improved. This work presents a mechanism called SV2-SQL, based on the pre-trained BERT. The proposed SV2-SQL mainly consists of multiple deep-learning models, including select-where slot filling model (SWSF-model), value extraction model (VE-model), and verification (V-model). The SWSF-model handles the classification tasks for those fields that appear in the “Select” and “Where” clauses, and the VE-model extracts the values for the “Where” clause from the input. The V-model sorts out the unwanted candidates from two previous models and leaves only the ones with the highest possibility. The proposed SV2-SQL also includes an algorithm for the inference process and allows the three models to be cooperative. Experimental results show that the proposed SV2-SQL outperforms the existing studies in terms of precision, accuracy, and recall.
    關聯: Multimedia Systems 30(16), p. 5-17
    DOI: 10.1007/s00530-023-01201-y
    顯示於類別:[資訊工程學系暨研究所] 期刊論文


    檔案 描述 大小格式瀏覽次數



    DSpace Software Copyright © 2002-2004  MIT &  Hewlett-Packard  /   Enhanced by   NTU Library & TKU Library IR teams. Copyright ©   - 回饋