{"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":"metacan-v3-hybrid-931329e0061c","candidate_categories":[],"consensus_categories":[],"category_scores_codex":[0.001951975,0.001083698,0.0006511069,0.002364335,0.0007999079,0.001845975,0.002154617,0.001391611,0.0009508083],"category_scores_gemma":[0.01797654,0.0005365719,0.0004689968,0.0009643445,0.001316576,0.002475921,0.00110233,0.001355632,0.000333058],"about_ca_system_candidate":false,"about_ca_system_consensus":false,"about_ca_system_score_codex":0.001537539,"about_ca_system_score_gemma":0.001621514,"about_ca_topic_candidate":false,"about_ca_topic_consensus":false,"about_ca_topic_score_codex":0.005873647,"about_ca_topic_score_gemma":0.003805132,"domain_scores_codex":[0.996712,0.0008802572,0.0002419393,0.0005358604,0.001334331,0.0002956572],"domain_scores_gemma":[0.9865759,0.009021353,0.001540892,0.0009245735,0.001678915,0.0002584381],"domain_codex":null,"domain_gemma":null,"domain_candidate":null,"domain_consensus":null,"study_design_codex":"simulation_or_modeling","study_design_gemma":"not_applicable","study_design_scores_codex":[0.0007946771,0.0006330944,0.03662773,0.0005617543,0.0001607883,0.001034316,0.001050503,0.4974019,0.05917457,0.01720456,0.006542159,0.378814],"study_design_scores_gemma":[0.00001786064,0.00005526688,0.001982652,0.00001237544,0.00001690342,0.0001375209,0.0001068924,0.9743235,0.01391507,0.008791565,0.0006250455,0.00001543831],"study_design_candidate":"not_applicable","study_design_consensus":null,"genre_codex":"methods","genre_gemma":"methods","genre_scores_codex":[0.270404,0.0007691731,0.7100768,0.001141359,0.00006256146,0.0002477191,0.0003542378,0.014137,0.002807195],"genre_scores_gemma":[0.8664924,0.0001606283,0.1321183,0.0001030339,0.00003498382,0.00006625163,0.0003768693,0.0001142021,0.0005332608],"genre_candidate":"methods","genre_consensus":"methods","teacher_disagreement_score":0.005873647,"threshold_uncertainty_score":0.01167893,"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."}}