{"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":"metacan-v3-hybrid-931329e0061c","candidate_categories":[],"consensus_categories":[],"category_scores_codex":[0.006161626,0.0003742577,0.0003194572,0.004793358,0.0006228217,0.001571673,0.0009658005,0.0009133967,0.0009433235],"category_scores_gemma":[0.1064345,0.0004452152,0.0003747347,0.004506713,0.001026626,0.003011043,0.001001181,0.001158047,0.0002466711],"about_ca_system_candidate":false,"about_ca_system_consensus":false,"about_ca_system_score_codex":0.0008276212,"about_ca_system_score_gemma":0.000984937,"about_ca_topic_candidate":false,"about_ca_topic_consensus":false,"about_ca_topic_score_codex":0.003696687,"about_ca_topic_score_gemma":0.006940226,"domain_scores_codex":[0.9889244,0.002648141,0.002157786,0.001454051,0.004128757,0.0006868587],"domain_scores_gemma":[0.669917,0.1965958,0.09217562,0.008647342,0.02942845,0.00323586],"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.0000609809,0.0002050265,0.9826988,0.0001602005,0.00003600805,0.0002460087,0.002434854,0.0002401861,0.000844613,0.0001196798,0.0003097282,0.01264388],"study_design_scores_gemma":[0.000005861335,0.0001850874,0.9918172,0.00007709398,0.0000296032,0.0007058546,0.003457327,0.001976007,0.0007418168,0.0001245283,0.0008618966,0.00001778538],"study_design_candidate":"observational","study_design_consensus":"observational","genre_codex":"empirical","genre_gemma":"empirical","genre_scores_codex":[0.9978023,0.0002369537,0.0008453349,0.0001172536,0.000006153577,0.00004329601,0.0003257887,0.00003678317,0.0005860087],"genre_scores_gemma":[0.9977277,0.0001810204,0.001110982,0.00004753262,0.000009224236,0.00004319618,0.0006441125,0.00001897605,0.0002172491],"genre_candidate":"empirical","genre_consensus":"empirical","teacher_disagreement_score":0.006161626,"threshold_uncertainty_score":0.03258622,"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."}}