{"id":"W1760549314","doi":"10.1007/3-540-46146-9_70","title":"Query Optimization via Empty Joins","year":2002,"lang":"en","type":"book-chapter","venue":"Lecture notes in computer science","topic":"Data Management and Algorithms","field":"Computer Science","cited_by":0,"is_retracted":false,"has_abstract":false,"ca_institutions":"York University","funders":"","keywords":"Joins; Computer science; Query optimization; Tuple; Cartesian product; Join (topology); Relational database; Materialized view; Sargable; Data mining; Information retrieval; Theoretical computer science; Product (mathematics); Database; Web search query; View; Programming language; Search engine; Database design; Mathematics; Discrete 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.002724773,0.001022513,0.002487728,0.001365732,0.001267354,0.00359088,0.002483783,0.0009829673,0.007988773],"category_scores_gemma":[0.008215519,0.0009183909,0.001214683,0.002917131,0.002127647,0.00810405,0.004518752,0.002969965,0.002258077],"about_ca_system_candidate":false,"about_ca_system_consensus":false,"about_ca_system_score_codex":0.0008646981,"about_ca_system_score_gemma":0.0007791533,"about_ca_topic_candidate":false,"about_ca_topic_consensus":false,"about_ca_topic_score_codex":0.0007312911,"about_ca_topic_score_gemma":0.0008183109,"domain_scores_codex":[0.9951558,0.001239488,0.0003485745,0.0006912698,0.002032699,0.0005322094],"domain_scores_gemma":[0.9956683,0.001822671,0.000190979,0.001751428,0.0004347933,0.0001318819],"domain_codex":null,"domain_gemma":null,"domain_candidate":null,"domain_consensus":null,"study_design_codex":"theoretical_or_conceptual","study_design_gemma":"simulation_or_modeling","study_design_scores_codex":[0.001646455,0.0002350791,0.0008215863,0.0006494419,0.0001718886,0.0001949166,0.0004583212,0.03135021,0.01618284,0.4722469,0.03485975,0.4411826],"study_design_scores_gemma":[0.00009027483,0.0001513319,0.0003159582,0.00004834497,0.0001074845,0.0003615028,0.0001096747,0.2276982,0.02367438,0.7239855,0.02340445,0.0000528594],"study_design_candidate":"simulation_or_modeling","study_design_consensus":null,"genre_codex":"methods","genre_gemma":"methods","genre_scores_codex":[0.01813362,0.001982485,0.9570702,0.0006986115,0.0001870552,0.00007213548,0.0003090562,0.003895624,0.01765128],"genre_scores_gemma":[0.3724657,0.001425093,0.5917705,0.0005608626,0.0005601704,0.0001518818,0.001788572,0.002698734,0.02857832],"genre_candidate":"methods","genre_consensus":"methods","teacher_disagreement_score":0.007988773,"threshold_uncertainty_score":0.02672511,"prediction_status":"machine_predicted_unvalidated"},"machine_scores":{"provisional":true,"baseline":true,"maturity_gate_passed":false,"score_opus":0.0174380794443442,"score_gpt":0.2230660569652224,"score_spread":0.2056279775208782,"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."}}