{"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":"metacan-v3-hybrid-931329e0061c","candidate_categories":[],"consensus_categories":[],"category_scores_codex":[0.003849976,0.0008171728,0.0007639974,0.001477671,0.001118798,0.0021163,0.001998703,0.00102417,0.003960182],"category_scores_gemma":[0.00943571,0.0005639134,0.001559588,0.001746215,0.002593654,0.005392935,0.002599247,0.002394137,0.001142284],"about_ca_system_candidate":false,"about_ca_system_consensus":false,"about_ca_system_score_codex":0.001483808,"about_ca_system_score_gemma":0.001744668,"about_ca_topic_candidate":false,"about_ca_topic_consensus":false,"about_ca_topic_score_codex":0.00289699,"about_ca_topic_score_gemma":0.005131321,"domain_scores_codex":[0.9942183,0.001993907,0.0004469702,0.0007176354,0.002312477,0.0003106764],"domain_scores_gemma":[0.9944371,0.003219933,0.0003367396,0.001066808,0.0008757716,0.0000635076],"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.0001284677,0.0001136357,0.0007459262,0.0003460078,0.00008658918,0.0006792708,0.0006317525,0.07082769,0.01545356,0.7054511,0.01050146,0.1950346],"study_design_scores_gemma":[0.00004065615,0.00007478159,0.0005044637,0.00006840233,0.00009335583,0.0006631404,0.0002091046,0.5440021,0.02982101,0.3687862,0.05565833,0.00007840087],"study_design_candidate":"theoretical_or_conceptual","study_design_consensus":"theoretical_or_conceptual","genre_codex":"methods","genre_gemma":"methods","genre_scores_codex":[0.003681041,0.00008337906,0.9903758,0.0004901047,0.00002547432,0.00008766346,0.0001155095,0.0005297518,0.004611294],"genre_scores_gemma":[0.1761981,0.0004598432,0.8148491,0.0004916577,0.0001139589,0.0002478168,0.001060525,0.0003748455,0.006204201],"genre_candidate":"methods","genre_consensus":"methods","teacher_disagreement_score":0.003960182,"threshold_uncertainty_score":0.02036089,"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."}}