{"id":"W2118265701","doi":"10.1145/1189769.1189772","title":"Adaptive rank-aware query optimization in relational databases","year":2006,"lang":"en","type":"article","venue":"ACM Transactions on Database Systems","topic":"Data Management and Algorithms","field":"Computer Science","cited_by":56,"is_retracted":false,"has_abstract":true,"ca_institutions":"University of Waterloo","funders":"","keywords":"Computer science; Query optimization; Query plan; Ranking (information retrieval); Rank (graph theory); Cardinality (data modeling); Key (lock); Query language; Relational database; Join (topology); Operator (biology); Sargable; Theoretical computer science; Database; Data mining; Information retrieval; Web search query; Search engine","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.002333811,0.001004599,0.001002168,0.0007864573,0.0008179749,0.001642685,0.002125149,0.0007602485,0.0007830902],"category_scores_gemma":[0.004435072,0.0004756686,0.000742527,0.001447423,0.0009257116,0.002723709,0.001579061,0.001227966,0.0003223787],"about_ca_system_candidate":false,"about_ca_system_consensus":false,"about_ca_system_score_codex":0.001117957,"about_ca_system_score_gemma":0.001790185,"about_ca_topic_candidate":false,"about_ca_topic_consensus":false,"about_ca_topic_score_codex":0.009449322,"about_ca_topic_score_gemma":0.01002792,"domain_scores_codex":[0.9965239,0.0008742684,0.0002433738,0.0006374824,0.001373598,0.0003472264],"domain_scores_gemma":[0.9973817,0.001226128,0.0002494766,0.0006344712,0.0003996836,0.0001084938],"domain_codex":null,"domain_gemma":null,"domain_candidate":null,"domain_consensus":null,"study_design_codex":"simulation_or_modeling","study_design_gemma":"simulation_or_modeling","study_design_scores_codex":[0.0007820624,0.0004634802,0.004880896,0.0003034742,0.0001340101,0.0002367611,0.0004714799,0.6879132,0.05093918,0.02222398,0.005960777,0.2256907],"study_design_scores_gemma":[0.00002664925,0.00009804669,0.0004630563,0.000005059003,0.00002669086,0.00006972445,0.00006931829,0.981397,0.009056041,0.007243744,0.001522963,0.00002161896],"study_design_candidate":"simulation_or_modeling","study_design_consensus":"simulation_or_modeling","genre_codex":"methods","genre_gemma":"empirical","genre_scores_codex":[0.09871926,0.001551674,0.8900695,0.0003835795,0.00003305569,0.0001632943,0.0002899571,0.006524642,0.002264976],"genre_scores_gemma":[0.5875003,0.0004896038,0.4096378,0.0001639084,0.00004255056,0.00008522291,0.0004544175,0.0004109014,0.001215206],"genre_candidate":"empirical","genre_consensus":null,"teacher_disagreement_score":0.009449322,"threshold_uncertainty_score":0.01878864,"prediction_status":"machine_predicted_unvalidated"},"machine_scores":{"provisional":true,"baseline":true,"maturity_gate_passed":false,"score_opus":0.03803229702306821,"score_gpt":0.2493029119004517,"score_spread":0.2112706148773835,"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."}}