{"id":"W3090668201","doi":"10.1145/3379597.3387467","title":"On the Prevalence, Impact, and Evolution of SQL Code Smells in Data-Intensive Systems","year":2020,"lang":"en","type":"article","venue":"","topic":"Software Engineering Research","field":"Computer Science","cited_by":43,"is_retracted":false,"has_abstract":true,"ca_institutions":"Polytechnique Montréal","funders":"","keywords":"Code smell; Computer science; Code refactoring; SQL; Software quality; Code review; Code (set theory); Software engineering; Software; Database; Programming language; Software development","routes":{"ca_aff":true,"ca_fund":false,"ca_venue":false,"about_ca":false,"invisible_to_affiliation_only":false},"retraction":null,"screen":null,"direct_labels":[],"prediction":{"model_version":"metacan-v3-hybrid-931329e0061c","candidate_categories":[],"consensus_categories":[],"category_scores_codex":[0.006588046,0.000331667,0.0002537078,0.004328548,0.0005177855,0.001449144,0.000539079,0.0007441608,0.0009571398],"category_scores_gemma":[0.06238409,0.000351782,0.0005058472,0.002727734,0.001046168,0.002892679,0.001557893,0.0009470698,0.0002774907],"about_ca_system_candidate":false,"about_ca_system_consensus":false,"about_ca_system_score_codex":0.0007334656,"about_ca_system_score_gemma":0.000808439,"about_ca_topic_candidate":false,"about_ca_topic_consensus":false,"about_ca_topic_score_codex":0.003768304,"about_ca_topic_score_gemma":0.006491357,"domain_scores_codex":[0.992713,0.001740556,0.001035262,0.001286439,0.00268025,0.000544359],"domain_scores_gemma":[0.8066956,0.09905407,0.06871926,0.005762901,0.0162962,0.003471854],"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.0000555359,0.00006189961,0.9862125,0.00006189312,0.00004000673,0.0001244608,0.001663569,0.0003018066,0.0007668695,0.0000904485,0.00009934165,0.01052161],"study_design_scores_gemma":[0.000001824909,0.00009480779,0.9962852,0.00003459856,0.00002158496,0.0001969744,0.001157854,0.00142598,0.0004100345,0.0001061147,0.0002529387,0.00001192478],"study_design_candidate":"observational","study_design_consensus":"observational","genre_codex":"empirical","genre_gemma":"empirical","genre_scores_codex":[0.9981589,0.0002435183,0.0008365737,0.0001116474,0.000003618618,0.00001345798,0.0001204025,0.00002616543,0.0004857259],"genre_scores_gemma":[0.9984661,0.0001393023,0.0009084778,0.0000299431,0.000007109423,0.00001245915,0.000234786,0.00001217672,0.0001896601],"genre_candidate":"empirical","genre_consensus":"empirical","teacher_disagreement_score":0.006588046,"threshold_uncertainty_score":0.0348413,"prediction_status":"machine_predicted_unvalidated"},"machine_scores":{"provisional":true,"baseline":true,"maturity_gate_passed":false,"score_opus":0.0499365641812848,"score_gpt":0.2952276787439877,"score_spread":0.2452911145627029,"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."}}