{"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":"metacan-v3-hybrid-931329e0061c","candidate_categories":[],"consensus_categories":[],"category_scores_codex":[0.00193602,0.0005087471,0.0005529565,0.0004267008,0.000803351,0.001328261,0.002724681,0.0005036845,0.001295996],"category_scores_gemma":[0.002925025,0.0006188284,0.0004519189,0.0005804467,0.0006813659,0.001915141,0.001917113,0.001245945,0.0004127836],"about_ca_system_candidate":false,"about_ca_system_consensus":false,"about_ca_system_score_codex":0.0005839977,"about_ca_system_score_gemma":0.001972151,"about_ca_topic_candidate":false,"about_ca_topic_consensus":false,"about_ca_topic_score_codex":0.004068205,"about_ca_topic_score_gemma":0.003987083,"domain_scores_codex":[0.9986507,0.0001320218,0.00009276383,0.0002576839,0.0007286532,0.0001380972],"domain_scores_gemma":[0.9984194,0.000455697,0.000132193,0.0005293275,0.0002719664,0.0001913276],"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.003163591,0.001125969,0.01084168,0.0003360139,0.0001540688,0.0006994168,0.001229196,0.06636148,0.3675981,0.02747726,0.02575014,0.495263],"study_design_scores_gemma":[0.0003769119,0.0006037064,0.001713707,0.00001416711,0.00008142966,0.0003449043,0.0001574762,0.9210724,0.05316964,0.008804369,0.01359203,0.0000691705],"study_design_candidate":"not_applicable","study_design_consensus":null,"genre_codex":"methods","genre_gemma":"empirical","genre_scores_codex":[0.08592767,0.0002727742,0.8904182,0.0002680905,0.00008081797,0.0002800603,0.0001818396,0.02066255,0.001908057],"genre_scores_gemma":[0.5524328,0.0001816807,0.4438276,0.0001751203,0.0001025169,0.0001987426,0.0004490788,0.0005956781,0.002036862],"genre_candidate":"empirical","genre_consensus":null,"teacher_disagreement_score":0.004068205,"threshold_uncertainty_score":0.01023877,"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."}}