{"id":"W2070598375","doi":"10.1007/s10844-006-0368-2","title":"Holes in joins","year":2006,"lang":"en","type":"article","venue":"Journal of Intelligent Information Systems","topic":"Advanced Database Systems and Queries","field":"Computer Science","cited_by":1,"is_retracted":false,"has_abstract":false,"ca_institutions":"York University","funders":"","keywords":"Joins; Computer science; Join (topology); Sketch; Tuple; Query optimization; Cartesian product; Product (mathematics); Materialized view; Data warehouse; Data mining; Information retrieval; Theoretical computer science; Database; Algorithm; View; Programming language; Database design; Mathematics","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.002093046,0.0007840983,0.001965994,0.003066629,0.004200002,0.006827016,0.001423453,0.001790385,0.01900527],"category_scores_gemma":[0.01082317,0.00125439,0.001168874,0.003917478,0.004521073,0.01878226,0.005242018,0.003951509,0.002086416],"about_ca_system_candidate":false,"about_ca_system_consensus":false,"about_ca_system_score_codex":0.001501801,"about_ca_system_score_gemma":0.00083281,"about_ca_topic_candidate":false,"about_ca_topic_consensus":false,"about_ca_topic_score_codex":0.00123432,"about_ca_topic_score_gemma":0.001019099,"domain_scores_codex":[0.9977404,0.0004797308,0.0001682246,0.0006056179,0.0007018532,0.0003041867],"domain_scores_gemma":[0.9943515,0.003280886,0.0004399287,0.0008892375,0.0005830597,0.0004554452],"domain_codex":null,"domain_gemma":null,"domain_candidate":null,"domain_consensus":null,"study_design_codex":"theoretical_or_conceptual","study_design_gemma":"theoretical_or_conceptual","study_design_scores_codex":[0.0000689029,0.00001334119,0.0002428125,0.000030491,0.000007716939,0.00004728132,0.0002992006,0.0002327168,0.0002095487,0.9896193,0.002844983,0.006383727],"study_design_scores_gemma":[0.00001712192,0.000009405153,0.00009775937,0.00001288983,0.00001197142,0.00008492687,0.0001387948,0.001108641,0.0002171184,0.9894193,0.008874883,0.000007150547],"study_design_candidate":"theoretical_or_conceptual","study_design_consensus":"theoretical_or_conceptual","genre_codex":"methods","genre_gemma":"empirical","genre_scores_codex":[0.2500614,0.007894242,0.4577724,0.01402348,0.002168076,0.0002146578,0.001939545,0.002122662,0.2638035],"genre_scores_gemma":[0.8623587,0.002572897,0.07146817,0.001431771,0.001326379,0.0001542796,0.001372836,0.0008784882,0.05843647],"genre_candidate":"empirical","genre_consensus":null,"teacher_disagreement_score":0.01900527,"threshold_uncertainty_score":0.06357896,"prediction_status":"machine_predicted_unvalidated"},"machine_scores":{"provisional":true,"baseline":true,"maturity_gate_passed":false,"score_opus":0.01195421222928267,"score_gpt":0.2346485700349911,"score_spread":0.2226943578057085,"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."}}