{"id":"W4386719007","doi":"10.1145/3568812.3603471","title":"MSMI1: Towards a Validated SQL Misconceptions Instrument","year":2023,"lang":"en","type":"article","venue":"","topic":"Advanced Database Systems and Queries","field":"Computer Science","cited_by":2,"is_retracted":false,"has_abstract":false,"ca_institutions":"University of Toronto","funders":"","keywords":"Computer science; SQL; SQL/PSM; Database; World Wide Web; Query by Example","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":["insufficient_payload"],"consensus_categories":[],"category_scores_codex":[0.0001398483,0.00009280344,0.00010557,0.00008463486,0.0001270572,0.00005460497,0.000289409,0.00002554333,0.0001110781],"category_scores_gemma":[0.00002166387,0.00007399719,0.00004148277,0.0006725483,0.00003257179,0.0005574309,0.0003265739,0.00005298337,0.0009837168],"about_ca_system_candidate":false,"about_ca_system_consensus":false,"about_ca_system_score_codex":0.00002414067,"about_ca_system_score_gemma":0.00005748621,"about_ca_topic_candidate":false,"about_ca_topic_consensus":false,"about_ca_topic_score_codex":0.0001478538,"about_ca_topic_score_gemma":0.00002713965,"domain_scores_codex":[0.9991007,0.00002916779,0.0001693484,0.0002699424,0.0001928578,0.0002379758],"domain_scores_gemma":[0.9993155,0.00001942587,0.00003475497,0.0005087279,0.00004073641,0.00008087406],"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.000001802513,0.00002821063,0.0001566068,0.00001654504,0.00001674134,0.00003369492,0.0008051609,0.0001912309,0.00290285,0.8971785,0.02698299,0.07168564],"study_design_scores_gemma":[0.0004704736,0.00008064212,0.003258685,0.00004131985,0.000003934938,0.00002827409,0.0005405999,0.02150455,0.01010827,0.002976797,0.9606025,0.0003839837],"study_design_candidate":"not_applicable","study_design_consensus":null,"genre_codex":"methods","genre_gemma":"empirical","genre_scores_codex":[0.01633708,0.00001606555,0.9669333,0.001890928,0.0005182277,0.0001411247,0.00002633625,0.001072043,0.01306492],"genre_scores_gemma":[0.6034646,0.00008750853,0.3678008,0.000935953,0.0002095418,0.0001544618,0.0001439784,0.00002477304,0.02717838],"genre_candidate":"methods","genre_consensus":null,"teacher_disagreement_score":0.9336195,"threshold_uncertainty_score":0.9997941,"prediction_status":"machine_predicted_unvalidated"},"machine_scores":{"provisional":true,"baseline":true,"maturity_gate_passed":false,"score_opus":0.04383012856794518,"score_gpt":0.2846854110350373,"score_spread":0.2408552824670921,"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."}}