{"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":"codex-gemma-dda1882f352a","candidate_categories":[],"consensus_categories":[],"category_scores_codex":[0.0004005503,0.0002005901,0.0001899484,0.0004532937,0.0001930692,0.0001488692,0.0008048548,0.0000437803,0.00005168119],"category_scores_gemma":[0.00002117737,0.0002017094,0.0000532522,0.0008227048,0.00003540338,0.002598456,0.00005280482,0.0001984426,0.0001104],"about_ca_system_candidate":false,"about_ca_system_consensus":false,"about_ca_system_score_codex":0.00009749365,"about_ca_system_score_gemma":0.00005691511,"about_ca_topic_candidate":false,"about_ca_topic_consensus":false,"about_ca_topic_score_codex":0.002186456,"about_ca_topic_score_gemma":0.000300732,"domain_scores_codex":[0.9981118,0.0001484953,0.0004282731,0.0005855631,0.0004467619,0.0002790712],"domain_scores_gemma":[0.9981123,0.0002149879,0.0001114411,0.001446099,0.00005759816,0.00005758848],"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.00003330093,0.0004385584,0.0001853345,0.00005436694,0.00003695118,0.00007391315,0.00004323764,0.9410409,0.00002530454,0.04748416,0.004152541,0.006431443],"study_design_scores_gemma":[0.0009108643,0.00004338362,0.000403984,0.000197957,0.00001876389,0.00001648086,0.0001152852,0.9884306,0.00009600836,0.0001169516,0.009310028,0.0003397274],"study_design_candidate":"simulation_or_modeling","study_design_consensus":"simulation_or_modeling","genre_codex":"methods","genre_gemma":"empirical","genre_scores_codex":[0.0001044263,0.0001143791,0.9960285,0.0003234512,0.0007311543,0.0004320179,0.001235761,0.0002102179,0.0008200286],"genre_scores_gemma":[0.520306,0.0001571016,0.4695767,0.0002039517,0.0003474657,0.0003705197,0.006279065,0.00005494582,0.002704282],"genre_candidate":"methods","genre_consensus":null,"teacher_disagreement_score":0.5264519,"threshold_uncertainty_score":0.8225468,"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."}}