{"id":"W4399619591","doi":"10.1145/3672449","title":"An Empirical Study on the Characteristics of Database Access Bugs in Java Applications","year":2024,"lang":"en","type":"article","venue":"ACM Transactions on Software Engineering and Methodology","topic":"Software Testing and Debugging Techniques","field":"Computer Science","cited_by":0,"is_retracted":false,"has_abstract":true,"ca_institutions":"Concordia University","funders":"","keywords":"Computer science; Database; SQL; Java; Database schema; Stored procedure; Query by Example; View; Commit; Database model; Database design; World Wide Web; Programming language; Web search query","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":"codex-gemma-dda1882f352a","candidate_categories":[],"consensus_categories":[],"category_scores_codex":[0.001142119,0.0001420467,0.0002091479,0.000324684,0.00007228038,0.00007610254,0.0007359617,0.00007136938,0.00000352754],"category_scores_gemma":[0.000812518,0.0001100368,0.00003540812,0.0005771951,0.00003834155,0.0001616197,0.00003325683,0.0003874495,0.000002133665],"about_ca_system_candidate":false,"about_ca_system_consensus":false,"about_ca_system_score_codex":0.00002159674,"about_ca_system_score_gemma":0.00004091522,"about_ca_topic_candidate":false,"about_ca_topic_consensus":false,"about_ca_topic_score_codex":0.00004652383,"about_ca_topic_score_gemma":0.00000250682,"domain_scores_codex":[0.9988403,0.000254499,0.0002390079,0.0003830997,0.0001175206,0.0001655569],"domain_scores_gemma":[0.9929481,0.006023638,0.00002932284,0.0009097428,0.00003340043,0.00005584432],"domain_codex":null,"domain_gemma":null,"domain_candidate":null,"domain_consensus":null,"study_design_codex":"design_other","study_design_gemma":"observational","study_design_scores_codex":[0.00005040151,0.001398449,0.01793093,0.0002972522,0.0001468436,0.00007815703,0.005931817,0.0047509,0.0009242333,0.004573623,0.0002764047,0.963641],"study_design_scores_gemma":[0.002064476,0.007250251,0.4665651,0.00193771,0.0004695942,0.0006046954,0.0005873355,0.436741,0.01837249,0.05287882,0.009243886,0.003284624],"study_design_candidate":"design_other","study_design_consensus":null,"genre_codex":"methods","genre_gemma":"empirical","genre_scores_codex":[0.05203502,0.00005990022,0.944827,0.0003085587,0.0001919388,0.0002545418,0.00001877224,0.002302598,0.000001724073],"genre_scores_gemma":[0.6100526,0.00001902173,0.3896095,0.00009780752,0.00001998352,0.0001810969,0.000002480497,0.00001302845,0.000004466948],"genre_candidate":"methods","genre_consensus":null,"teacher_disagreement_score":0.9603564,"threshold_uncertainty_score":0.4487171,"prediction_status":"machine_predicted_unvalidated"},"machine_scores":{"provisional":true,"baseline":true,"maturity_gate_passed":false,"score_opus":0.1622306835150713,"score_gpt":0.4138237030113616,"score_spread":0.2515930194962903,"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."}}