{"id":"W2019940097","doi":"10.1016/s0304-3975(02)00736-3","title":"Expressive power of SQL","year":2003,"lang":"en","type":"article","venue":"Theoretical Computer Science","topic":"Advanced Database Systems and Queries","field":"Computer Science","cited_by":68,"is_retracted":false,"has_abstract":false,"ca_institutions":"University of Toronto; University of New Brunswick","funders":"Institut national de recherche en informatique et en automatique (INRIA)","keywords":"SQL; Computer science; Relational algebra; Mathematical proof; Programming language; Theoretical computer science; Reachability; Relational database; Database; 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.0008808304,0.0001318937,0.0002005153,0.000111239,0.0001889607,0.00006405891,0.00113355,0.00002889433,0.0000611098],"category_scores_gemma":[0.0001744196,0.0001006324,0.00005085397,0.0007960445,0.002265371,0.0008611154,0.0005218216,0.00009783157,0.0000345543],"about_ca_system_candidate":false,"about_ca_system_consensus":false,"about_ca_system_score_codex":0.00002023304,"about_ca_system_score_gemma":0.0001205535,"about_ca_topic_candidate":false,"about_ca_topic_consensus":false,"about_ca_topic_score_codex":0.000001368125,"about_ca_topic_score_gemma":1.07229e-7,"domain_scores_codex":[0.9981936,0.0001003405,0.0002659301,0.0005024655,0.0005428572,0.0003947635],"domain_scores_gemma":[0.9983731,0.0001617596,0.00009521444,0.0009819169,0.0002089911,0.000179054],"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.000001777701,0.00002783039,0.00002629991,0.000004598951,0.000001628449,0.000006637738,0.0004054681,0.00004647889,0.00237896,0.9950693,0.00003493668,0.001996109],"study_design_scores_gemma":[0.0008497728,0.0007948082,0.0009733277,0.0001915571,0.000006964273,0.0002448214,0.0001229973,0.06131437,0.3823276,0.5376315,0.01458768,0.0009546042],"study_design_candidate":"theoretical_or_conceptual","study_design_consensus":"theoretical_or_conceptual","genre_codex":"methods","genre_gemma":"empirical","genre_scores_codex":[0.01368097,0.0000495483,0.9748068,0.00008317313,0.0005342085,0.00009803237,0.000002826428,0.00007657985,0.0106678],"genre_scores_gemma":[0.6485745,0.000001309039,0.3512957,0.0001014844,0.00001334576,0.000002728391,1.408163e-7,0.000003035447,0.000007710351],"genre_candidate":"methods","genre_consensus":null,"teacher_disagreement_score":0.6348935,"threshold_uncertainty_score":0.8346855,"prediction_status":"machine_predicted_unvalidated"},"machine_scores":{"provisional":true,"baseline":true,"maturity_gate_passed":false,"score_opus":0.007096860504463824,"score_gpt":0.2419075946911204,"score_spread":0.2348107341866565,"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."}}