{"id":"W2142687459","doi":"10.1109/icac.2005.12","title":"Automatic Diagnosis of Performance Problems in Database Management Systems","year":2005,"lang":"en","type":"article","venue":"","topic":"AI-based Problem Solving and Planning","field":"Computer Science","cited_by":25,"is_retracted":false,"has_abstract":true,"ca_institutions":"Acadia University","funders":"","keywords":"Computer science; Workload; Database; Transaction processing; Database transaction; Database tuning; Database testing; Resource (disambiguation); Resource allocation; Online transaction processing; Process (computing); Resource management (computing); Database administrator; Database server; Online analytical processing; Database design; Distributed computing; Database schema; Data warehouse; View","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.00055102,0.00009634124,0.000142668,0.0001678799,0.00003902012,0.00005197055,0.0005351933,0.00002559588,0.00002864532],"category_scores_gemma":[0.000005893517,0.00008255537,0.00001992147,0.0003644161,0.00001316592,0.0005033499,0.0001646157,0.00007513177,0.00005847446],"about_ca_system_candidate":false,"about_ca_system_consensus":false,"about_ca_system_score_codex":0.00003741091,"about_ca_system_score_gemma":0.00001775679,"about_ca_topic_candidate":false,"about_ca_topic_consensus":false,"about_ca_topic_score_codex":0.00009022489,"about_ca_topic_score_gemma":0.00001589547,"domain_scores_codex":[0.9989694,0.00004200877,0.0003243311,0.0002234054,0.0002167111,0.000224181],"domain_scores_gemma":[0.9993212,0.00008151851,0.00008626496,0.0004475983,0.00002018187,0.00004320512],"domain_codex":null,"domain_gemma":null,"domain_candidate":null,"domain_consensus":null,"study_design_codex":"design_other","study_design_gemma":"simulation_or_modeling","study_design_scores_codex":[0.000003285674,0.0004757147,0.26862,0.003499791,0.00005792392,0.00002681917,0.002556303,0.2612466,0.00005375269,0.04824249,0.006670211,0.408547],"study_design_scores_gemma":[0.0002444696,0.00004357738,0.004298293,0.0006628431,0.000003793877,0.0000042372,0.00002824699,0.989624,0.0003457748,0.00002240806,0.004595878,0.0001265109],"study_design_candidate":"simulation_or_modeling","study_design_consensus":null,"genre_codex":"empirical","genre_gemma":"empirical","genre_scores_codex":[0.5151776,0.001583406,0.4528214,0.0009991354,0.0003779858,0.001064224,0.000007400499,0.0005414117,0.02742742],"genre_scores_gemma":[0.9391597,0.00007944142,0.06021149,0.00006758713,0.00001483895,0.00009134398,0.000003634408,0.00000466005,0.0003673025],"genre_candidate":"empirical","genre_consensus":"empirical","teacher_disagreement_score":0.7283773,"threshold_uncertainty_score":0.3366511,"prediction_status":"machine_predicted_unvalidated"},"machine_scores":{"provisional":true,"baseline":true,"maturity_gate_passed":false,"score_opus":0.01800011011679083,"score_gpt":0.2272112398363537,"score_spread":0.2092111297195629,"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."}}