{"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":"metacan-v3-hybrid-931329e0061c","candidate_categories":[],"consensus_categories":[],"category_scores_codex":[0.007928503,0.00163732,0.00136773,0.002863258,0.001608906,0.008521542,0.007712069,0.00263522,0.05195415],"category_scores_gemma":[0.0167231,0.002017213,0.003671398,0.003119037,0.001317966,0.01076673,0.007945903,0.004416022,0.03368536],"about_ca_system_candidate":false,"about_ca_system_consensus":false,"about_ca_system_score_codex":0.001806025,"about_ca_system_score_gemma":0.005147182,"about_ca_topic_candidate":false,"about_ca_topic_consensus":false,"about_ca_topic_score_codex":0.007528958,"about_ca_topic_score_gemma":0.005942179,"domain_scores_codex":[0.9920931,0.001793813,0.001389997,0.001025869,0.003011018,0.0006861448],"domain_scores_gemma":[0.9928777,0.001856938,0.0004363914,0.002218464,0.002177951,0.0004325286],"domain_codex":null,"domain_gemma":null,"domain_candidate":null,"domain_consensus":null,"study_design_codex":"not_applicable","study_design_gemma":"theoretical_or_conceptual","study_design_scores_codex":[0.0005714045,0.0002210554,0.002278758,0.001959796,0.000319364,0.0005276238,0.0008744594,0.005345454,0.004737686,0.2642291,0.5624763,0.1564591],"study_design_scores_gemma":[0.0001045692,0.00003734294,0.0002464096,0.000170302,0.00005001328,0.0003946023,0.0001601677,0.01058917,0.003969657,0.05993186,0.9242697,0.00007622639],"study_design_candidate":"theoretical_or_conceptual","study_design_consensus":null,"genre_codex":"methods","genre_gemma":"methods","genre_scores_codex":[0.002752317,0.002143795,0.6742128,0.00398384,0.001196718,0.001673391,0.06256807,0.1747596,0.07670942],"genre_scores_gemma":[0.04623395,0.004812209,0.5766754,0.008545077,0.000719474,0.002589094,0.2721344,0.03560749,0.05268292],"genre_candidate":"methods","genre_consensus":"methods","teacher_disagreement_score":0.05195415,"threshold_uncertainty_score":0,"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."}}