{"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":"codex-gemma-dda1882f352a","candidate_categories":[],"consensus_categories":[],"category_scores_codex":[0.0001516456,0.0001400501,0.0001973829,0.00005210831,0.00009039453,0.0003618472,0.0015187,0.00006254551,0.0001009269],"category_scores_gemma":[0.00007471314,0.0001230126,0.00007566722,0.0004705204,0.00001173448,0.0004183958,0.000161907,0.0001001382,0.0006938732],"about_ca_system_candidate":false,"about_ca_system_consensus":false,"about_ca_system_score_codex":0.00002975607,"about_ca_system_score_gemma":0.00003018982,"about_ca_topic_candidate":false,"about_ca_topic_consensus":false,"about_ca_topic_score_codex":0.0001031541,"about_ca_topic_score_gemma":0.00004684655,"domain_scores_codex":[0.9987774,0.00004283398,0.000173991,0.0004376023,0.0002224975,0.0003456468],"domain_scores_gemma":[0.9984578,0.0000487023,0.00004015068,0.001228197,0.00004923548,0.0001759142],"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.0000100028,0.00003944375,0.0003652778,0.000006566218,0.00001084023,0.00002805899,0.0002431258,0.00004703343,0.0003956968,0.001834035,0.05185544,0.9451645],"study_design_scores_gemma":[0.0003205385,0.0001467255,0.001759814,0.00003440782,0.000002413137,0.00002120596,0.00001406456,0.005285594,0.0004175111,0.002520302,0.9892058,0.0002715771],"study_design_candidate":"not_applicable","study_design_consensus":null,"genre_codex":"methods","genre_gemma":"empirical","genre_scores_codex":[0.3143614,0.000359503,0.6019365,0.03938935,0.002156476,0.0008525256,0.0000388073,0.0008793681,0.04002608],"genre_scores_gemma":[0.9336844,0.00001704862,0.03818214,0.001356589,0.0002670923,0.00005324936,0.000003567182,0.0000140034,0.0264219],"genre_candidate":"empirical","genre_consensus":null,"teacher_disagreement_score":0.9448929,"threshold_uncertainty_score":0.8918567,"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."}}