A sign language to SQL query translation system for enhancing database accessibility

IF 3.1 2区 计算机科学 Q3 COMPUTER SCIENCE, SOFTWARE ENGINEERING
Guocang Yang, Dawei Yuan, Tao Zhang, Zhenghan Chen
{"title":"A sign language to SQL query translation system for enhancing database accessibility","authors":"Guocang Yang,&nbsp;Dawei Yuan,&nbsp;Tao Zhang,&nbsp;Zhenghan Chen","doi":"10.1007/s10515-025-00558-w","DOIUrl":null,"url":null,"abstract":"<div><p>Structured Query Language (SQL) is a standard language for interacting with relational databases and is widely used across various information systems, either through direct query execution or via object-relational mapping (ORM) frameworks. Recent approaches have focused on converting natural language into SQL to simplify database development for users without programming expertise. However, these methods overlook direct translation from sign language—an essential modality for users such as the deaf community who may lack experience with SQL syntax. In this paper, we present <i>SIGN2SQL</i>, an innovative end-to-end framework that generates SQL queries from signed input. The system first employs a dedicated gesture recognition module to interpret the visual signals, followed by a convolutional neural network (CNN)-based model that produces the corresponding SQL statements. Trained on a well-annotated dataset, SIGN2SQL is evaluated against multiple pipeline-based baselines. Experimental results demonstrate that SIGN2SQL outperforms existing methods in both effectiveness and efficiency, particularly for SELECT statements with WHERE clauses. It achieves an execution accuracy of 89.8%, highlighting its potential as an accessible and inclusive database interaction interface.</p></div>","PeriodicalId":55414,"journal":{"name":"Automated Software Engineering","volume":"33 1","pages":""},"PeriodicalIF":3.1000,"publicationDate":"2025-10-07","publicationTypes":"Journal Article","fieldsOfStudy":null,"isOpenAccess":false,"openAccessPdf":"https://link.springer.com/content/pdf/10.1007/s10515-025-00558-w.pdf","citationCount":"0","resultStr":null,"platform":"Semanticscholar","paperid":null,"PeriodicalName":"Automated Software Engineering","FirstCategoryId":"94","ListUrlMain":"https://link.springer.com/article/10.1007/s10515-025-00558-w","RegionNum":2,"RegionCategory":"计算机科学","ArticlePicture":[],"TitleCN":null,"AbstractTextCN":null,"PMCID":null,"EPubDate":"","PubModel":"","JCR":"Q3","JCRName":"COMPUTER SCIENCE, SOFTWARE ENGINEERING","Score":null,"Total":0}
引用次数: 0

Abstract

Structured Query Language (SQL) is a standard language for interacting with relational databases and is widely used across various information systems, either through direct query execution or via object-relational mapping (ORM) frameworks. Recent approaches have focused on converting natural language into SQL to simplify database development for users without programming expertise. However, these methods overlook direct translation from sign language—an essential modality for users such as the deaf community who may lack experience with SQL syntax. In this paper, we present SIGN2SQL, an innovative end-to-end framework that generates SQL queries from signed input. The system first employs a dedicated gesture recognition module to interpret the visual signals, followed by a convolutional neural network (CNN)-based model that produces the corresponding SQL statements. Trained on a well-annotated dataset, SIGN2SQL is evaluated against multiple pipeline-based baselines. Experimental results demonstrate that SIGN2SQL outperforms existing methods in both effectiveness and efficiency, particularly for SELECT statements with WHERE clauses. It achieves an execution accuracy of 89.8%, highlighting its potential as an accessible and inclusive database interaction interface.

一个用于增强数据库可访问性的手语到SQL查询的翻译系统
结构化查询语言(SQL)是与关系数据库交互的标准语言,通过直接查询执行或通过对象关系映射(ORM)框架,在各种信息系统中广泛使用。最近的方法侧重于将自然语言转换为SQL,以简化没有编程专业知识的用户的数据库开发。然而,这些方法忽略了直接从手语进行翻译,而手语对于可能缺乏SQL语法经验的聋哑人社区等用户来说是一种必要的方式。在本文中,我们介绍了SIGN2SQL,这是一个创新的端到端框架,可以从签名输入生成SQL查询。该系统首先使用专用的手势识别模块来解释视觉信号,然后使用基于卷积神经网络(CNN)的模型生成相应的SQL语句。SIGN2SQL在一个注释良好的数据集上进行训练,根据多个基于管道的基线进行评估。实验结果表明,SIGN2SQL在有效性和效率方面都优于现有方法,特别是对于带有WHERE子句的SELECT语句。它实现了89.8%的执行精度,突出了其作为可访问和包容性数据库交互界面的潜力。
本文章由计算机程序翻译,如有差异,请以英文原文为准。
求助全文
约1分钟内获得全文 求助全文
来源期刊
Automated Software Engineering
Automated Software Engineering 工程技术-计算机:软件工程
CiteScore
4.80
自引率
11.80%
发文量
51
审稿时长
>12 weeks
期刊介绍: This journal details research, tutorial papers, survey and accounts of significant industrial experience in the foundations, techniques, tools and applications of automated software engineering technology. This includes the study of techniques for constructing, understanding, adapting, and modeling software artifacts and processes. Coverage in Automated Software Engineering examines both automatic systems and collaborative systems as well as computational models of human software engineering activities. In addition, it presents knowledge representations and artificial intelligence techniques applicable to automated software engineering, and formal techniques that support or provide theoretical foundations. The journal also includes reviews of books, software, conferences and workshops.
×
引用
GB/T 7714-2015
复制
MLA
复制
APA
复制
导出至
BibTeX EndNote RefMan NoteFirst NoteExpress
×
提示
您的信息不完整,为了账户安全,请先补充。
现在去补充
×
提示
您因"违规操作"
具体请查看互助需知
我知道了
×
提示
确定
请完成安全验证×
copy
已复制链接
快去分享给好友吧!
我知道了
右上角分享
点击右上角分享
0
联系我们:info@booksci.cn Book学术提供免费学术资源搜索服务,方便国内外学者检索中英文文献。致力于提供最便捷和优质的服务体验。 Copyright © 2023 布克学术 All rights reserved.
京ICP备2023020795号-1
ghs 京公网安备 11010802042870号
Book学术文献互助
Book学术文献互助群
群 号:604180095
Book学术官方微信