{"id":"W2126321570","doi":"10.1145/335191.335393","title":"How to roll a join","year":2000,"lang":"en","type":"article","venue":"ACM SIGMOD Record","topic":"Distributed systems and fault tolerance","field":"Computer Science","cited_by":91,"is_retracted":false,"has_abstract":true,"ca_institutions":"University of Waterloo","funders":"","keywords":"Computer science; Materialized view; Asynchronous communication; Process (computing); Join (topology); Point (geometry); Refresh rate; Distributed computing; Database; Operating system; Computer hardware; Computer network; View","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.0009820093,0.000683248,0.0005416619,0.00063633,0.001299941,0.003170004,0.001005694,0.001138298,0.02587328],"category_scores_gemma":[0.0044496,0.0005543829,0.0008280737,0.0004450353,0.0007907309,0.003345745,0.001491314,0.001591917,0.00986842],"about_ca_system_candidate":false,"about_ca_system_consensus":false,"about_ca_system_score_codex":0.0003648243,"about_ca_system_score_gemma":0.0008720218,"about_ca_topic_candidate":false,"about_ca_topic_consensus":false,"about_ca_topic_score_codex":0.004000856,"about_ca_topic_score_gemma":0.003881691,"domain_scores_codex":[0.9986048,0.0001880487,0.00008811134,0.0002767307,0.0006453299,0.0001969579],"domain_scores_gemma":[0.9985393,0.0003316136,0.00007168487,0.000598072,0.0002765788,0.0001826424],"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.001002206,0.0003335309,0.002928576,0.0003664983,0.00009890034,0.000743416,0.0007332409,0.01993184,0.03127182,0.0749215,0.1216368,0.7460316],"study_design_scores_gemma":[0.0006258319,0.0006066851,0.004181185,0.0002866685,0.0002253237,0.0013958,0.001726461,0.283461,0.057276,0.1865055,0.4633837,0.0003258177],"study_design_candidate":"not_applicable","study_design_consensus":null,"genre_codex":"methods","genre_gemma":"other","genre_scores_codex":[0.0345868,0.001361913,0.8325056,0.004628137,0.002278219,0.0009410121,0.001669659,0.03463146,0.0873972],"genre_scores_gemma":[0.3640887,0.001181577,0.5752281,0.001227578,0.0006115616,0.0003539118,0.002771781,0.003544201,0.0509925],"genre_candidate":"other","genre_consensus":null,"teacher_disagreement_score":0.02587328,"threshold_uncertainty_score":0.08655471,"prediction_status":"machine_predicted_unvalidated"},"machine_scores":{"provisional":true,"baseline":true,"maturity_gate_passed":false,"score_opus":0.01619001446389559,"score_gpt":0.2327563099770128,"score_spread":0.2165662955131172,"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."}}