{"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":"metacan-v3-hybrid-931329e0061c","candidate_categories":[],"consensus_categories":[],"category_scores_codex":[0.002830487,0.001285026,0.001251535,0.0008257031,0.0006588312,0.002493311,0.001761827,0.0009409102,0.00740171],"category_scores_gemma":[0.00743965,0.0008649078,0.0004740217,0.0008920179,0.0004259506,0.003024205,0.001407542,0.001743936,0.004662519],"about_ca_system_candidate":false,"about_ca_system_consensus":false,"about_ca_system_score_codex":0.0005674073,"about_ca_system_score_gemma":0.001148201,"about_ca_topic_candidate":false,"about_ca_topic_consensus":false,"about_ca_topic_score_codex":0.003907838,"about_ca_topic_score_gemma":0.004130316,"domain_scores_codex":[0.9982677,0.0003706584,0.0001257781,0.0003285493,0.0007798277,0.0001275259],"domain_scores_gemma":[0.9976661,0.0005203184,0.0001186417,0.001049918,0.0004623129,0.000182665],"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.002615956,0.0005118069,0.00907537,0.0005091297,0.000329591,0.0001743991,0.0004331743,0.06496795,0.05827973,0.01139518,0.1185203,0.7331874],"study_design_scores_gemma":[0.0003632887,0.0003197925,0.003547252,0.00004924128,0.00009919635,0.0002091239,0.00008950812,0.808321,0.07623388,0.006489524,0.1041486,0.0001295933],"study_design_candidate":"simulation_or_modeling","study_design_consensus":null,"genre_codex":"methods","genre_gemma":"methods","genre_scores_codex":[0.05129114,0.001204766,0.7751737,0.0009773376,0.0002724154,0.000391812,0.001891077,0.1481565,0.02064126],"genre_scores_gemma":[0.2428253,0.0005945556,0.724879,0.0007106547,0.0001919327,0.000268248,0.003462426,0.01435067,0.01271726],"genre_candidate":"methods","genre_consensus":"methods","teacher_disagreement_score":0.00740171,"threshold_uncertainty_score":0.02476114,"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."}}