{"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":"codex-gemma-dda1882f352a","candidate_categories":[],"consensus_categories":[],"category_scores_codex":[0.0006479508,0.00008685383,0.0002068265,0.0004088203,0.00003492221,0.0001356489,0.0002769362,0.00003798886,0.000002359304],"category_scores_gemma":[0.0000408541,0.0000655335,0.00006392039,0.0002940164,0.00001842617,0.004282061,0.00004552204,0.000118622,0.00007069098],"about_ca_system_candidate":false,"about_ca_system_consensus":false,"about_ca_system_score_codex":0.0001130107,"about_ca_system_score_gemma":0.00006804586,"about_ca_topic_candidate":false,"about_ca_topic_consensus":false,"about_ca_topic_score_codex":0.0001219076,"about_ca_topic_score_gemma":0.000010419,"domain_scores_codex":[0.9981607,0.00004433135,0.00124481,0.00004650019,0.0003675154,0.0001361957],"domain_scores_gemma":[0.9986171,0.00004399688,0.0008096124,0.0001889397,0.0002969166,0.00004347206],"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.00001497279,0.00004951471,0.001818057,0.0001192004,0.0000130931,0.00002369876,0.001627195,0.0418941,0.0001759787,0.9405644,0.005045922,0.008653865],"study_design_scores_gemma":[0.0004473222,0.0001207042,0.001452363,0.0004701086,0.000002753608,0.0006722028,0.00197948,0.01695232,0.002522654,0.0006248201,0.9745385,0.0002167626],"study_design_candidate":"not_applicable","study_design_consensus":null,"genre_codex":"methods","genre_gemma":"empirical","genre_scores_codex":[0.007611985,0.0004343417,0.9873579,0.00009184516,0.001121065,0.0001101214,0.000005122583,0.00001864055,0.003248973],"genre_scores_gemma":[0.9873182,0.0000632575,0.01218928,0.00007433932,0.0002161462,0.000004993757,0.000006000967,0.000003565561,0.000124272],"genre_candidate":"methods","genre_consensus":null,"teacher_disagreement_score":0.9797062,"threshold_uncertainty_score":0.3104391,"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."}}