{"id":"W1997533292","doi":"10.1145/503099.503102","title":"SchemaSQL","year":2001,"lang":"en","type":"article","venue":"ACM Transactions on Database Systems","topic":"Advanced Database Systems and Queries","field":"Computer Science","cited_by":94,"is_retracted":false,"has_abstract":true,"ca_institutions":"University of British Columbia","funders":"","keywords":"Computer science; SQL; Data definition language; Relational database; Schema (genetic algorithms); Database schema; Programming language; Database; Conceptual schema; Semi-structured model; Database model; Information retrieval; Database design","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.0003310457,0.0002501868,0.0002709028,0.0002135614,0.0003621707,0.0001043427,0.0009507589,0.00006789153,0.00006069724],"category_scores_gemma":[0.00005162579,0.000222833,0.00009445187,0.0006810019,0.0000516508,0.001463424,0.0000443481,0.0002432903,0.0006899209],"about_ca_system_candidate":false,"about_ca_system_consensus":false,"about_ca_system_score_codex":0.00007634498,"about_ca_system_score_gemma":0.00006403653,"about_ca_topic_candidate":false,"about_ca_topic_consensus":false,"about_ca_topic_score_codex":0.000345515,"about_ca_topic_score_gemma":0.00005030319,"domain_scores_codex":[0.9980167,0.0001068262,0.0004036733,0.000625429,0.0004335359,0.0004138702],"domain_scores_gemma":[0.9962888,0.0001694003,0.0001083085,0.003151397,0.00008124168,0.0002008827],"domain_codex":null,"domain_gemma":null,"domain_candidate":null,"domain_consensus":null,"study_design_codex":"theoretical_or_conceptual","study_design_gemma":"not_applicable","study_design_scores_codex":[0.0001674145,0.001293159,0.0003282958,0.0005400669,0.0003855712,0.001108257,0.001057095,0.01169125,0.01455998,0.7860388,0.01203114,0.170799],"study_design_scores_gemma":[0.0006591884,0.0001132787,0.00003555637,0.0002532297,0.00001523682,0.0005862983,0.000295655,0.009710787,0.003014636,0.0001300703,0.9846652,0.0005208767],"study_design_candidate":"not_applicable","study_design_consensus":null,"genre_codex":"methods","genre_gemma":"empirical","genre_scores_codex":[0.0008409894,0.0003615586,0.9938166,0.0004602707,0.001539845,0.0003441481,0.0003190918,0.000519447,0.001798008],"genre_scores_gemma":[0.6717315,0.0006202548,0.317955,0.0005660715,0.0004834745,0.0005370624,0.0002257368,0.00008302446,0.007797854],"genre_candidate":"methods","genre_consensus":null,"teacher_disagreement_score":0.972634,"threshold_uncertainty_score":0.9086864,"prediction_status":"machine_predicted_unvalidated"},"machine_scores":{"provisional":true,"baseline":true,"maturity_gate_passed":false,"score_opus":0.03070971332297829,"score_gpt":0.2692929818947709,"score_spread":0.2385832685717926,"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."}}