{"id":"W2117538598","doi":"10.14778/1687627.1687659","title":"A scalable, predictable join operator for highly concurrent data warehouses","year":2009,"lang":"en","type":"article","venue":"Proceedings of the VLDB Endowment","topic":"Advanced Database Systems and Queries","field":"Computer Science","cited_by":87,"is_retracted":false,"has_abstract":true,"ca_institutions":"ASTER","funders":"","keywords":"Computer science; Query plan; Scalability; Query optimization; Online aggregation; Data warehouse; Tuple; Throughput; Computation; Query language; Pipeline (software); Sargable; Database; Data mining; Distributed computing; Web search query; Search engine; Information retrieval; Algorithm; 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.0003959076,0.0001819849,0.0002677018,0.0000504057,0.0001995488,0.00009984412,0.001850974,0.00003440421,0.000003282994],"category_scores_gemma":[0.0001708253,0.0001175924,0.00006435016,0.0002723839,0.00005536885,0.001347595,0.0009288502,0.00008439428,0.000003663929],"about_ca_system_candidate":false,"about_ca_system_consensus":false,"about_ca_system_score_codex":0.00005417534,"about_ca_system_score_gemma":0.00007836897,"about_ca_topic_candidate":false,"about_ca_topic_consensus":false,"about_ca_topic_score_codex":0.00002476934,"about_ca_topic_score_gemma":0.00000262906,"domain_scores_codex":[0.9983907,0.000005878874,0.0003824239,0.000503904,0.0003734522,0.0003436598],"domain_scores_gemma":[0.9987925,0.00003854173,0.000247841,0.0005955508,0.0002375486,0.00008802211],"domain_codex":null,"domain_gemma":null,"domain_candidate":null,"domain_consensus":null,"study_design_codex":"theoretical_or_conceptual","study_design_gemma":"not_applicable","study_design_scores_codex":[0.00004315786,0.0003880826,0.0007086476,0.0003567533,0.00007406635,7.166397e-7,0.000771516,0.00005682437,0.05403279,0.8165987,0.09806886,0.02889993],"study_design_scores_gemma":[0.002102712,0.0007009821,0.0007723845,0.0006475923,0.00005786953,0.00003170143,0.0002628415,0.01667202,0.2977001,0.003721097,0.6767837,0.0005469534],"study_design_candidate":"theoretical_or_conceptual","study_design_consensus":null,"genre_codex":"methods","genre_gemma":"empirical","genre_scores_codex":[0.0615283,0.006449354,0.8841202,0.02279972,0.005077234,0.009464697,0.002710243,0.001341702,0.006508498],"genre_scores_gemma":[0.8585214,0.0001373116,0.1392959,0.0007249049,0.0002885907,0.0001828645,0.00002720194,0.0000230341,0.000798738],"genre_candidate":"methods","genre_consensus":null,"teacher_disagreement_score":0.8128775,"threshold_uncertainty_score":0.4795278,"prediction_status":"machine_predicted_unvalidated"},"machine_scores":{"provisional":true,"baseline":true,"maturity_gate_passed":false,"score_opus":0.03523027418104299,"score_gpt":0.2718733476399827,"score_spread":0.2366430734589397,"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."}}