{"id":"W2168503413","doi":"10.1109/icde.2000.839397","title":"DB2 advisor: an optimizer smart enough to recommend its own indexes","year":2002,"lang":"en","type":"article","venue":"","topic":"Data Management and Algorithms","field":"Computer Science","cited_by":290,"is_retracted":false,"has_abstract":true,"ca_institutions":"University of Toronto; IBM (Canada)","funders":"","keywords":"Knapsack problem; Computer science; Index (typography); Selection (genetic algorithm); Quality (philosophy); Relational database management system; Interface (matter); Data mining; World Wide Web; Algorithm; Artificial intelligence; Relational database; Operating system","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":["insufficient_payload"],"consensus_categories":["insufficient_payload"],"category_scores_codex":[0.0002138799,0.0001513321,0.0001363713,0.0001405607,0.0001157895,0.0004683013,0.001415039,0.00003616901,0.001665899],"category_scores_gemma":[0.00001697482,0.0001282067,0.00003792553,0.0004132712,0.00001082562,0.001986221,0.0006889788,0.00008397025,0.001902443],"about_ca_system_candidate":false,"about_ca_system_consensus":false,"about_ca_system_score_codex":0.00001810227,"about_ca_system_score_gemma":0.000004241367,"about_ca_topic_candidate":false,"about_ca_topic_consensus":false,"about_ca_topic_score_codex":0.00003056044,"about_ca_topic_score_gemma":0.00001866378,"domain_scores_codex":[0.9986973,0.00004042665,0.0001855295,0.000485622,0.0002368848,0.0003542748],"domain_scores_gemma":[0.9989279,0.00002755999,0.00003584665,0.0007898107,0.00003488719,0.0001840304],"domain_codex":null,"domain_gemma":null,"domain_candidate":null,"domain_consensus":null,"study_design_codex":"design_other","study_design_gemma":"not_applicable","study_design_scores_codex":[0.00000346319,0.0003197302,0.0001172497,0.000008363098,0.00002903732,0.00002631025,0.0007964229,0.0001548528,0.00005064817,0.04821375,0.3957033,0.5545768],"study_design_scores_gemma":[0.0003722578,0.0002069396,0.0003441851,0.000008810971,0.000005269779,0.000003939368,0.00003697878,0.1478977,0.0005442376,0.0003534729,0.849864,0.0003622395],"study_design_candidate":"not_applicable","study_design_consensus":null,"genre_codex":"methods","genre_gemma":"methods","genre_scores_codex":[0.002972534,0.0001204838,0.6672298,0.04779606,0.00152489,0.0006573445,0.00001907266,0.001033188,0.2786466],"genre_scores_gemma":[0.1260354,0.0001393521,0.7338761,0.01429244,0.0003352802,0.0000572551,0.00003105546,0.0000335324,0.1251996],"genre_candidate":"methods","genre_consensus":"methods","teacher_disagreement_score":0.5542146,"threshold_uncertainty_score":0.9992467,"prediction_status":"machine_predicted_unvalidated"},"machine_scores":{"provisional":true,"baseline":true,"maturity_gate_passed":false,"score_opus":0.04929654506499023,"score_gpt":0.2521579843231119,"score_spread":0.2028614392581217,"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."}}