I3DE: An IDE for Inspecting Inconsistencies in PL/SQL Code

ArXiv Pub Date : 2024-03-06 DOI:10.1145/3643796.3648461
Jiangshan Liu, Shuang Liu, Junjie Chen
{"title":"I3DE: An IDE for Inspecting Inconsistencies in PL/SQL Code","authors":"Jiangshan Liu, Shuang Liu, Junjie Chen","doi":"10.1145/3643796.3648461","DOIUrl":null,"url":null,"abstract":"In this paper, we introduce I3DE (Inconsistency Inspecting IDE) - an IDE plugin to inspect inconsistencies in PL/SQL code. We first observed the potential issues, e.g., misuses or bugs, that are introduced by the inconsistent understanding of PL/SQL semantics by PL/SQL programmers and DBMS developers, and propose a metamorphic testing-based approach for inspecting such inconsistencies in PL/SQL code. We design and implement our approach in I3DE, a widely usable plugin for the IntelliJ Platform. We conducted a comparative user study involving 16 participants, and the findings indicate that I3DE is consistently effective and efficient in helping programmers identify and avoid inconsistencies across different programming difficulties","PeriodicalId":513202,"journal":{"name":"ArXiv","volume":"4 5","pages":""},"PeriodicalIF":0.0000,"publicationDate":"2024-03-06","publicationTypes":"Journal Article","fieldsOfStudy":null,"isOpenAccess":false,"openAccessPdf":"","citationCount":"0","resultStr":null,"platform":"Semanticscholar","paperid":null,"PeriodicalName":"ArXiv","FirstCategoryId":"1085","ListUrlMain":"https://doi.org/10.1145/3643796.3648461","RegionNum":0,"RegionCategory":null,"ArticlePicture":[],"TitleCN":null,"AbstractTextCN":null,"PMCID":null,"EPubDate":"","PubModel":"","JCR":"","JCRName":"","Score":null,"Total":0}
引用次数: 0

Abstract

In this paper, we introduce I3DE (Inconsistency Inspecting IDE) - an IDE plugin to inspect inconsistencies in PL/SQL code. We first observed the potential issues, e.g., misuses or bugs, that are introduced by the inconsistent understanding of PL/SQL semantics by PL/SQL programmers and DBMS developers, and propose a metamorphic testing-based approach for inspecting such inconsistencies in PL/SQL code. We design and implement our approach in I3DE, a widely usable plugin for the IntelliJ Platform. We conducted a comparative user study involving 16 participants, and the findings indicate that I3DE is consistently effective and efficient in helping programmers identify and avoid inconsistencies across different programming difficulties
I3DE:用于检查 PL/SQL 代码中不一致之处的集成开发环境
本文介绍了 I3DE(不一致性检查集成开发环境)--一种用于检查 PL/SQL 代码中不一致性的集成开发环境插件。我们首先观察了由于 PL/SQL 程序员和 DBMS 开发人员对 PL/SQL 语义的理解不一致而导致的潜在问题(如误用或错误),并提出了一种基于元测试的方法来检查 PL/SQL 代码中的不一致之处。我们在 IntelliJ 平台的一个广泛使用的插件 I3DE 中设计并实现了我们的方法。我们进行了一项有 16 人参与的用户对比研究,研究结果表明,I3DE 在帮助程序员识别和避免不同编程困难中的不一致性方面始终是有效和高效的。
本文章由计算机程序翻译,如有差异,请以英文原文为准。
求助全文
约1分钟内获得全文 求助全文
来源期刊
自引率
0.00%
发文量
0
×
引用
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学术文献互助群
群 号:481959085
Book学术官方微信