{"id":"W2096077069","doi":"10.1109/hicss.1991.184165","title":"Semantic query optimization using inter-relational functional dependencies","year":2002,"lang":"en","type":"article","venue":"","topic":"Advanced Database Systems and Queries","field":"Computer Science","cited_by":2,"is_retracted":false,"has_abstract":true,"ca_institutions":"Université du Québec à Montréal","funders":"","keywords":"Functional dependency; Computer science; Dependency (UML); Query optimization; Relational database; Dependency theory (database theory); Relational model; Sargable; Extension (predicate logic); Codd's theorem; Process (computing); Relational calculus; Information retrieval; Theoretical computer science; Data mining; Artificial intelligence; Programming language; Web search query; Search engine","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.00008612088,0.00008680341,0.00008059795,0.0000825536,0.0001587812,0.00004329955,0.0001052482,0.00003232451,0.0007079752],"category_scores_gemma":[0.00003076831,0.00007572189,0.00003490138,0.0001916447,0.00002839673,0.001432553,0.0001174905,0.00005877896,0.00008251322],"about_ca_system_candidate":false,"about_ca_system_consensus":false,"about_ca_system_score_codex":0.00004388603,"about_ca_system_score_gemma":0.00001813575,"about_ca_topic_candidate":false,"about_ca_topic_consensus":false,"about_ca_topic_score_codex":0.00003586942,"about_ca_topic_score_gemma":0.00001605797,"domain_scores_codex":[0.9992195,0.00002682433,0.0001821057,0.000221361,0.0002157564,0.0001343869],"domain_scores_gemma":[0.9995382,0.00004899429,0.0000610493,0.0002257195,0.00008452657,0.00004153143],"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.000002000469,0.00004094658,0.001257998,0.00001459985,0.00001633943,0.00000810672,0.000181156,0.4342069,0.0002995998,0.5601087,0.001555968,0.002307686],"study_design_scores_gemma":[0.0001013181,0.000009907308,0.0002923711,0.00002107659,0.000002177609,0.00006768118,0.00003251197,0.995755,0.0001050595,0.0002156741,0.003288226,0.0001090516],"study_design_candidate":"simulation_or_modeling","study_design_consensus":null,"genre_codex":"methods","genre_gemma":"methods","genre_scores_codex":[0.0006296916,0.00009318019,0.9952818,0.000212051,0.0004380052,0.00005971249,0.00000314149,0.0001341673,0.003148206],"genre_scores_gemma":[0.2038694,0.00000773549,0.7932259,0.0001882897,0.0001150997,0.000005159163,0.0000126082,0.000006740006,0.002569076],"genre_candidate":"methods","genre_consensus":"methods","teacher_disagreement_score":0.561548,"threshold_uncertainty_score":0.7751833,"prediction_status":"machine_predicted_unvalidated"},"machine_scores":{"provisional":true,"baseline":true,"maturity_gate_passed":false,"score_opus":0.06303274988772185,"score_gpt":0.2349874531493314,"score_spread":0.1719547032616096,"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."}}