{"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":"codex-gemma-dda1882f352a","candidate_categories":["metaepi_narrow"],"consensus_categories":[],"category_scores_codex":[0.0005946432,0.0005051781,0.0004232565,0.0009346881,0.0002666257,0.0009949724,0.004063989,0.0002372033,0.0001161722],"category_scores_gemma":[0.00003742955,0.0004754777,0.0001194656,0.0007475346,0.000394206,0.001626422,0.002114428,0.0005697109,0.0001600621],"about_ca_system_candidate":false,"about_ca_system_consensus":false,"about_ca_system_score_codex":0.0002127191,"about_ca_system_score_gemma":0.0001255975,"about_ca_topic_candidate":false,"about_ca_topic_consensus":false,"about_ca_topic_score_codex":0.00001549997,"about_ca_topic_score_gemma":0.00001502567,"domain_scores_codex":[0.9962556,0.0000264697,0.0004755287,0.001586329,0.001021907,0.0006341354],"domain_scores_gemma":[0.9975554,0.0001444355,0.0002684366,0.001721365,0.0001546856,0.000155614],"domain_codex":null,"domain_gemma":null,"domain_candidate":null,"domain_consensus":null,"study_design_codex":"design_other","study_design_gemma":"simulation_or_modeling","study_design_scores_codex":[0.00000110252,0.00003258864,0.00001248872,0.00002409733,0.0000108823,0.00009928626,0.0001784511,0.1934244,0.000007154079,0.01205373,0.0002272635,0.7939285],"study_design_scores_gemma":[0.0001663331,0.00007835323,0.00002382034,0.000131542,0.000007132369,0.00002630385,3.063642e-8,0.9637977,0.00009938381,0.03050152,0.004598973,0.000568884],"study_design_candidate":"simulation_or_modeling","study_design_consensus":null,"genre_codex":"methods","genre_gemma":"methods","genre_scores_codex":[0.000001402569,0.000204281,0.9842117,0.0007945154,0.002178719,0.0003343216,0.000006124219,0.0002659796,0.01200292],"genre_scores_gemma":[0.002736788,0.0001586894,0.9918127,0.001928307,0.0006609031,0.000008315756,0.0000278038,0.00004026219,0.002626254],"genre_candidate":"methods","genre_consensus":"methods","teacher_disagreement_score":0.7933596,"threshold_uncertainty_score":0.9997697,"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."}}