Code Recommendation for Schema Evolution of Mimic Storage Systems

Xianglong Kong 1
Zhuo Lv 2
Cen Chen 2
Hao Chang 2
Nuannuan Li 2
Fan Zhang 3
1
 
Purple Mountain Laboratories, Nanjing 211111, P. R. China
2
 
State Grid Henan Electric Power Research Institute, Zhengzhou 450000, P. R. China
3
 
National Digital Switching System and Engineering Technological Research Center, Zhengzhou 450002, P. R. China
Publication typeJournal Article
Publication date2024-10-28
scimago Q3
wos Q4
SJR0.206
CiteScore1.8
Impact factor0.6
ISSN02181940, 17936403
Abstract

Schema evolution of mimic storage systems is a time-consuming and error-prone task due to the redundant development of heterogeneous executors. The ORM-based proxy requires an entire class to represent the structure of a data table. There lacks domain-specific code recommendation techniques to boost storage development. To address this issue, we design a novel type of code context, i.e. schema context, that combines features of code text, syntax and structure. Regarding the requirements of class-level granularity, we focus on behavior and attribute in code syntax, and use element position and structural metrics to mine the hidden relationships. Based on schema context and an existing inference mode, we propose SchemaRec to recommend ORM-related class for the database executors once one of them has been changed. We conduct experiments with 110 open-source projects, and the results show that SchemaRec obtains more accurate results than Lucene, DeepCS, QobCS and SEA in terms of Top-1, Top-10 and MRR accuracy due to the better ability of context representation. We also find that code syntax is the most important information because it involves behavior and attribute information of ORM-related classes.

Found 

Are you a researcher?

Create a profile to get free access to personal recommendations for colleagues and new articles.
Metrics
0
Share
Cite this
GOST |
Cite this
GOST Copy
Kong X. et al. Code Recommendation for Schema Evolution of Mimic Storage Systems // International Journal of Software Engineering and Knowledge Engineering. 2024. Vol. 35. No. 01. pp. 89-110.
GOST all authors (up to 50) Copy
Kong X., Lv Z., Chen C., Chang H., Li N., Zhang F. Code Recommendation for Schema Evolution of Mimic Storage Systems // International Journal of Software Engineering and Knowledge Engineering. 2024. Vol. 35. No. 01. pp. 89-110.
RIS |
Cite this
RIS Copy
TY - JOUR
DO - 10.1142/s0218194024500499
UR - https://www.worldscientific.com/doi/10.1142/S0218194024500499
TI - Code Recommendation for Schema Evolution of Mimic Storage Systems
T2 - International Journal of Software Engineering and Knowledge Engineering
AU - Kong, Xianglong
AU - Lv, Zhuo
AU - Chen, Cen
AU - Chang, Hao
AU - Li, Nuannuan
AU - Zhang, Fan
PY - 2024
DA - 2024/10/28
PB - World Scientific
SP - 89-110
IS - 01
VL - 35
SN - 0218-1940
SN - 1793-6403
ER -
BibTex |
Cite this
BibTex (up to 50 authors) Copy
@article{2024_Kong,
author = {Xianglong Kong and Zhuo Lv and Cen Chen and Hao Chang and Nuannuan Li and Fan Zhang},
title = {Code Recommendation for Schema Evolution of Mimic Storage Systems},
journal = {International Journal of Software Engineering and Knowledge Engineering},
year = {2024},
volume = {35},
publisher = {World Scientific},
month = {oct},
url = {https://www.worldscientific.com/doi/10.1142/S0218194024500499},
number = {01},
pages = {89--110},
doi = {10.1142/s0218194024500499}
}
MLA
Cite this
MLA Copy
Kong, Xianglong, et al. “Code Recommendation for Schema Evolution of Mimic Storage Systems.” International Journal of Software Engineering and Knowledge Engineering, vol. 35, no. 01, Oct. 2024, pp. 89-110. https://www.worldscientific.com/doi/10.1142/S0218194024500499.