{"id":"W2069307110","doi":"10.1145/1529282.1529629","title":"Exploiting join cardinality for faster hash joins","year":2009,"lang":"en","type":"article","venue":"","topic":"Caching and Content Delivery","field":"Computer Science","cited_by":2,"is_retracted":false,"has_abstract":true,"ca_institutions":"University of British Columbia, Okanagan Campus; University of British Columbia","funders":"","keywords":"Joins; Join (topology); Computer science; Cardinality (data modeling); Hash join; Hash function; Theoretical computer science; Parallel computing; Database; Mathematics; Programming language","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.0002520127,0.00008076998,0.0001166399,0.00003858863,0.0001146217,0.0001729824,0.0003132081,0.00002623958,0.00000519727],"category_scores_gemma":[0.00002709838,0.00006924927,0.0001228315,0.00007864609,0.000007189029,0.0003232231,0.00005607008,0.00005812465,0.00002353169],"about_ca_system_candidate":false,"about_ca_system_consensus":false,"about_ca_system_score_codex":0.00002055884,"about_ca_system_score_gemma":0.00001839391,"about_ca_topic_candidate":false,"about_ca_topic_consensus":false,"about_ca_topic_score_codex":0.00003712688,"about_ca_topic_score_gemma":0.000006184746,"domain_scores_codex":[0.9992418,0.00002334911,0.0001413743,0.0002498228,0.000128931,0.0002147089],"domain_scores_gemma":[0.9994893,0.0000467129,0.00003186853,0.0003185532,0.00005601731,0.00005753727],"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.00002770519,0.0002035884,0.002149585,0.00002863809,0.000049914,0.00002577609,0.00136893,0.0001493014,0.02742979,0.3564314,0.03524034,0.5768951],"study_design_scores_gemma":[0.005624947,0.00184973,0.04548714,0.0002583991,0.00008179861,0.0001886568,0.001256089,0.7490155,0.03136767,0.09302665,0.0690785,0.002764931],"study_design_candidate":"simulation_or_modeling","study_design_consensus":null,"genre_codex":"methods","genre_gemma":"empirical","genre_scores_codex":[0.09169643,0.00003646205,0.8927444,0.002715511,0.0002106999,0.0001145073,0.0000014314,0.0002361833,0.0122444],"genre_scores_gemma":[0.9819483,0.000001435945,0.013445,0.002404097,0.0001082702,0.000006892923,0.000001124316,0.000002897764,0.002081992],"genre_candidate":"empirical","genre_consensus":null,"teacher_disagreement_score":0.8902519,"threshold_uncertainty_score":0.2823903,"prediction_status":"machine_predicted_unvalidated"},"machine_scores":{"provisional":true,"baseline":true,"maturity_gate_passed":false,"score_opus":0.04712684653484023,"score_gpt":0.2610858423320991,"score_spread":0.2139589957972589,"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."}}