{"id":"W4225630774","doi":"10.48550/arxiv.2201.02215","title":"On the Prevalence, Impact, and Evolution of SQL Code Smells in Data-Intensive Systems","year":2022,"lang":"en","type":"preprint","venue":"arXiv (Cornell University)","topic":"Software Engineering Research","field":"Computer Science","cited_by":1,"is_retracted":false,"has_abstract":true,"ca_institutions":"","funders":"Natural Sciences and Engineering Research Council of Canada; Fonds Wetenschappelijk Onderzoek; Fonds De La Recherche Scientifique - FNRS","keywords":"Code smell; Computer science; Code refactoring; SQL; Code (set theory); Code review; Software quality; Software; Software engineering; Database; Programming language; Software development","routes":{"ca_aff":false,"ca_fund":true,"ca_venue":false,"about_ca":false,"invisible_to_affiliation_only":true},"retraction":null,"screen":null,"direct_labels":[],"prediction":{"model_version":"metacan-v3-hybrid-931329e0061c","candidate_categories":[],"consensus_categories":[],"category_scores_codex":[0.00735599,0.0003729272,0.00029295,0.004875284,0.0005799668,0.001615864,0.0005962055,0.0008251478,0.00101254],"category_scores_gemma":[0.07364759,0.0003927943,0.0005056349,0.003397334,0.001168161,0.003279968,0.001706618,0.001042291,0.0003156123],"about_ca_system_candidate":false,"about_ca_system_consensus":false,"about_ca_system_score_codex":0.0007418073,"about_ca_system_score_gemma":0.0007642399,"about_ca_topic_candidate":false,"about_ca_topic_consensus":false,"about_ca_topic_score_codex":0.003812052,"about_ca_topic_score_gemma":0.005778937,"domain_scores_codex":[0.9919648,0.001935899,0.001076206,0.001597619,0.002867129,0.0005583232],"domain_scores_gemma":[0.7737853,0.1239348,0.07305929,0.007135313,0.01829522,0.003790085],"domain_codex":null,"domain_gemma":null,"domain_candidate":null,"domain_consensus":null,"study_design_codex":"observational","study_design_gemma":"observational","study_design_scores_codex":[0.0000594829,0.00006687052,0.9843487,0.00007416136,0.00004732988,0.000128046,0.001699921,0.0003922436,0.0008029136,0.0001223782,0.0001285963,0.01212931],"study_design_scores_gemma":[0.000002401707,0.00009728775,0.9955385,0.00003906474,0.00002650485,0.0002134402,0.001145621,0.001942193,0.0004914722,0.000181789,0.0003070213,0.00001461481],"study_design_candidate":"observational","study_design_consensus":"observational","genre_codex":"empirical","genre_gemma":"empirical","genre_scores_codex":[0.9976627,0.0003036856,0.001152155,0.0001398699,0.000004041141,0.00001396297,0.0001621675,0.00003604098,0.0005254044],"genre_scores_gemma":[0.9979493,0.0001800447,0.001245203,0.00003680272,0.00000888356,0.0000148501,0.0003425438,0.00001826387,0.0002041279],"genre_candidate":"empirical","genre_consensus":"empirical","teacher_disagreement_score":0.00735599,"threshold_uncertainty_score":0.03890264,"prediction_status":"machine_predicted_unvalidated"},"machine_scores":{"provisional":true,"baseline":true,"maturity_gate_passed":false,"score_opus":0.09521332136890527,"score_gpt":0.2315162346778636,"score_spread":0.1363029133089583,"validation_status":"score_only:v0-immature-baseline","note":"Baseline scores from an immature model (maturity gate not passed). Scores rank; they never assert a category."}}