On Modern Text-to-SQL Semantic Parsing Methodologies for Natural Language Interface to Databases: A Comparative Study
NLIDB research has gained popularity recently, mainly as a means of enhancing outcomes and performance. This study makes an effort to give readers background information on how the subject has evolved recently using different text-to-SQL procedures and approaches, as well as an appraisal of the adva...
Uloženo v:
| Vydáno v: | International Conference on Artificial Intelligence in Information and Communication (ICAIIC) (Online) s. 390 - 396 |
|---|---|
| Hlavní autoři: | , , , , , |
| Médium: | Konferenční příspěvek |
| Jazyk: | angličtina |
| Vydáno: |
IEEE
20.02.2023
|
| Témata: | |
| ISSN: | 2831-6983 |
| On-line přístup: | Získat plný text |
| Tagy: |
Přidat tag
Žádné tagy, Buďte první, kdo vytvoří štítek k tomuto záznamu!
|
| Abstract | NLIDB research has gained popularity recently, mainly as a means of enhancing outcomes and performance. This study makes an effort to give readers background information on how the subject has evolved recently using different text-to-SQL procedures and approaches, as well as an appraisal of the advantages and disadvantages of each methodology. In contrast with past studies, this paper describes the search and selection processes and provide an overview of the complete process for each approach under review before making comparisons. The authors also evaluated the performance of each methodology against a widely recognized benchmark dataset. Along with model performance, each model was compared and assessed based on its overall structure and associated processes, such as using pre-trained language models and intermediate representations. The results of this study show that the field of text-to-SQL semantic parsing has advanced significantly in recent years, as seen by the improved performance of the models under consideration. It was clear that most recent developments concentrated on the encoder side, even if each technique follows an encoder-decoder design. The imbalance opens up much room for decoder advancement in subsequent studies. Using pre-trained language models was also noteworthy for improving the models' performances; the authors will consider this for future efforts. The selection of intermediate representations, on the other hand, is wholly arbitrary. |
|---|---|
| AbstractList | NLIDB research has gained popularity recently, mainly as a means of enhancing outcomes and performance. This study makes an effort to give readers background information on how the subject has evolved recently using different text-to-SQL procedures and approaches, as well as an appraisal of the advantages and disadvantages of each methodology. In contrast with past studies, this paper describes the search and selection processes and provide an overview of the complete process for each approach under review before making comparisons. The authors also evaluated the performance of each methodology against a widely recognized benchmark dataset. Along with model performance, each model was compared and assessed based on its overall structure and associated processes, such as using pre-trained language models and intermediate representations. The results of this study show that the field of text-to-SQL semantic parsing has advanced significantly in recent years, as seen by the improved performance of the models under consideration. It was clear that most recent developments concentrated on the encoder side, even if each technique follows an encoder-decoder design. The imbalance opens up much room for decoder advancement in subsequent studies. Using pre-trained language models was also noteworthy for improving the models' performances; the authors will consider this for future efforts. The selection of intermediate representations, on the other hand, is wholly arbitrary. |
| Author | Visperas, Moses Borjal, Christalline Joie Catapang, Jasper Kyle Peramo, Elmer Adoptante, Aunhel John Abia, Ma. Teresita |
| Author_xml | – sequence: 1 givenname: Moses surname: Visperas fullname: Visperas, Moses organization: Advanced Science and Technology Institute,Computer Software Division,Department of Science and Technology,Diliman,Quezon City,Philippines – sequence: 2 givenname: Aunhel John surname: Adoptante fullname: Adoptante, Aunhel John organization: Advanced Science and Technology Institute,Computer Software Division,Department of Science and Technology,Diliman,Quezon City,Philippines – sequence: 3 givenname: Christalline Joie surname: Borjal fullname: Borjal, Christalline Joie organization: Advanced Science and Technology Institute,Computer Software Division,Department of Science and Technology,Diliman,Quezon City,Philippines – sequence: 4 givenname: Ma. Teresita surname: Abia fullname: Abia, Ma. Teresita organization: Advanced Science and Technology Institute,Computer Software Division,Department of Science and Technology,Diliman,Quezon City,Philippines – sequence: 5 givenname: Jasper Kyle surname: Catapang fullname: Catapang, Jasper Kyle organization: University of Birmingham,Department of English Language and Linguistics,United Kingdom – sequence: 6 givenname: Elmer surname: Peramo fullname: Peramo, Elmer email: elmer@asti.dost.gov.ph organization: Advanced Science and Technology Institute,Computer Software Division,Department of Science and Technology,Diliman,Quezon City,Philippines |
| BookMark | eNo1kM1OwzAQhA0CiVL6BhzMA6TYceLG3KrwFymloJRztYnXIai1K8dB9O2JBEgzWs1ltN9ckjPrLBJyw9mcc6Zui3xZFHm64ELMYxaLOWdMjik5ITO1yLiUaZLKUadkEmeCR1Jl4oLM-v6TMSZilrBETciwtnTlNHpLN_gdouCi6q2kFe7Bhq6hr-D7zrZ0heHDabdzbYc9Nc7TFwiDhx0twbYDtEgLG9AbaJAGR-8hQA099nd0SXO3P4CH0H0hrcKgj1fk3MCux9nfnZL3x4dN_hyV66cRrIy68b8QNSg1rxU0I1cTM0iMHJ2xGlmTaKibTBlZjzTKgBGoVbrQynAmtDGSCyam5Pq3t0PE7cF3e_DH7f9S4gfqZmFG |
| ContentType | Conference Proceeding |
| DBID | 6IE 6IL CBEJK RIE RIL |
| DOI | 10.1109/ICAIIC57133.2023.10067134 |
| DatabaseName | IEEE Electronic Library (IEL) Conference Proceedings IEEE Xplore POP ALL IEEE Xplore All Conference Proceedings IEEE/IET Electronic Library (IEL) (UW System Shared) IEEE Proceedings Order Plans (POP All) 1998-Present |
| DatabaseTitleList | |
| Database_xml | – sequence: 1 dbid: RIE name: IEEE/IET Electronic Library (IEL) (UW System Shared) url: https://ieeexplore.ieee.org/ sourceTypes: Publisher |
| DeliveryMethod | fulltext_linktorsrc |
| EISBN | 9781665456456 1665456450 |
| EISSN | 2831-6983 |
| EndPage | 396 |
| ExternalDocumentID | 10067134 |
| Genre | orig-research |
| GroupedDBID | 6IE 6IF 6IL 6IN AAWTH ABLEC ADZIZ ALMA_UNASSIGNED_HOLDINGS BEFXN BFFAM BGNUA BKEBE BPEOZ CBEJK CHZPO IEGSK OCL RIE RIL |
| ID | FETCH-LOGICAL-i204t-ce6d1b9ac713c20a4f6a4f80be0c4dabc89f6b0039faf3ed957d9f103dff61303 |
| IEDL.DBID | RIE |
| ISICitedReferencesCount | 0 |
| ISICitedReferencesURI | http://www.webofscience.com/api/gateway?GWVersion=2&SrcApp=Summon&SrcAuth=ProQuest&DestLinkType=CitingArticles&DestApp=WOS_CPL&KeyUT=001012997600072&url=https%3A%2F%2Fcvtisr.summon.serialssolutions.com%2F%23%21%2Fsearch%3Fho%3Df%26include.ft.matches%3Dt%26l%3Dnull%26q%3D |
| IngestDate | Wed Aug 27 02:22:26 EDT 2025 |
| IsPeerReviewed | false |
| IsScholarly | false |
| Language | English |
| LinkModel | DirectLink |
| MergedId | FETCHMERGED-LOGICAL-i204t-ce6d1b9ac713c20a4f6a4f80be0c4dabc89f6b0039faf3ed957d9f103dff61303 |
| PageCount | 7 |
| ParticipantIDs | ieee_primary_10067134 |
| PublicationCentury | 2000 |
| PublicationDate | 2023-Feb.-20 |
| PublicationDateYYYYMMDD | 2023-02-20 |
| PublicationDate_xml | – month: 02 year: 2023 text: 2023-Feb.-20 day: 20 |
| PublicationDecade | 2020 |
| PublicationTitle | International Conference on Artificial Intelligence in Information and Communication (ICAIIC) (Online) |
| PublicationTitleAbbrev | ICAIIC |
| PublicationYear | 2023 |
| Publisher | IEEE |
| Publisher_xml | – name: IEEE |
| SSID | ssj0003204049 |
| Score | 1.838285 |
| Snippet | NLIDB research has gained popularity recently, mainly as a means of enhancing outcomes and performance. This study makes an effort to give readers background... |
| SourceID | ieee |
| SourceType | Publisher |
| StartPage | 390 |
| SubjectTerms | Benchmark testing Decoding natural language processing natural language query Natural languages NLIDB semantic parsing Semantics Structured Query Language Syntactics text-to-SQL |
| Title | On Modern Text-to-SQL Semantic Parsing Methodologies for Natural Language Interface to Databases: A Comparative Study |
| URI | https://ieeexplore.ieee.org/document/10067134 |
| WOSCitedRecordID | wos001012997600072&url=https%3A%2F%2Fcvtisr.summon.serialssolutions.com%2F%23%21%2Fsearch%3Fho%3Df%26include.ft.matches%3Dt%26l%3Dnull%26q%3D |
| hasFullText | 1 |
| inHoldings | 1 |
| isFullTextHit | |
| isPrint | |
| link | http://cvtisr.summon.serialssolutions.com/2.0.0/link/0/eLvHCXMwlV1NS8NAEF1sEfGkYsVvRvC6NdtNk6y3Ei0Waq20Qm9lsx_Qg0lpU8F_7842bfHgwUMgBIYsM9mdnZd98wi5D5NAaqsTqhlCN9IyKiOVURd-GQaSR0ZZLzYRDwbJZCKGFVndc2GMMf7wmWnirf-Xrwu1QqjMzXC3tjIe1kgtjuM1WWsLqPCW-x5DcUDuqj6aD7200-ulbSzDmqgS3tzY_1JS8Ymke_TPIRyTxo6SB8NtsjkheyY_Jau3HNZiZjDGCrYs6Oi9DyPz6fw1UzCUHgqAVy8T7Zc5swS3TYWB9P02oF_BleCRQSvdW8oCnmQpMb0tH6ED6a4_OOCpw-8G-eg-j9MXWuko0JnzSUmViTTLhFRu4KrlYmAjdyVBZgIVapmpRNgIp7ew0nKjRTvWwrKAa2uxvOBnpJ4XuTkn4LYTFrm0seHKlTpoxUKmMrSMrLIXpIE-m87XrTKmG3dd_vH8ihxiZDxHPLgm9XKxMjdkX32Vs-Xi1gf4B3owqE4 |
| linkProvider | IEEE |
| linkToHtml | http://cvtisr.summon.serialssolutions.com/2.0.0/link/0/eLvHCXMwlV3PS8MwFH7oFPWk4sTfPsFrZ7NmXettVMeKXZ1swm4jzQ_YwVa2TvC_N8m6DQ8ePBRKIW14r8nL-5LvfQD3NHCZUCJwBDHQDVPEYT7PHO1-Rl3m-ZIrKzbRTtNgPA4HFVndcmGklPbwmWyYW7uXLwq-MFCZHuF6biUe3YadFqVNsqRrrSEVr6n_SBruwV1VSfMhjjpxHLVMItYwOuGN1Rt-aanYUNI9_GcnjqC-IeXhYB1ujmFL5ieweM1xKWeGI5PDloUzfEtwKD-0xaYcB8yCAdi3QtF2opNz1AtVTJmtuIFJBViixQYV018pC3xiJTMBbv6IHYw2FcLRnDv8rsN793kU9ZxKScGZapuUDpe-IFnIuO44b2ovKF9fgZtJl1PBMh6EyjcDPFRMeVKErbYIFXE9oZRJMLxTqOVFLs8A9YJCGTZtW3pcJzumFaGEZ6alr7g6h7qx2eRzWSxjsjLXxR_Pb2G_N-onkyROXy7hwHjJMsbdK6iVs4W8hl3-VU7nsxvr7B9ouquV |
| openUrl | ctx_ver=Z39.88-2004&ctx_enc=info%3Aofi%2Fenc%3AUTF-8&rfr_id=info%3Asid%2Fsummon.serialssolutions.com&rft_val_fmt=info%3Aofi%2Ffmt%3Akev%3Amtx%3Abook&rft.genre=proceeding&rft.title=International+Conference+on+Artificial+Intelligence+in+Information+and+Communication+%28ICAIIC%29+%28Online%29&rft.atitle=On+Modern+Text-to-SQL+Semantic+Parsing+Methodologies+for+Natural+Language+Interface+to+Databases%3A+A+Comparative+Study&rft.au=Visperas%2C+Moses&rft.au=Adoptante%2C+Aunhel+John&rft.au=Borjal%2C+Christalline+Joie&rft.au=Abia%2C+Ma.+Teresita&rft.date=2023-02-20&rft.pub=IEEE&rft.eissn=2831-6983&rft.spage=390&rft.epage=396&rft_id=info:doi/10.1109%2FICAIIC57133.2023.10067134&rft.externalDocID=10067134 |