{"id":"W1538798823","doi":"10.1007/11901181_49","title":"Auto-completion of Underspecified SQL Queries","year":2006,"lang":"en","type":"book-chapter","venue":"Lecture notes in computer science","topic":"Advanced Database Systems and Queries","field":"Computer Science","cited_by":1,"is_retracted":false,"has_abstract":false,"ca_institutions":"Okanagan University College; University of British Columbia, Okanagan Campus; University of British Columbia","funders":"","keywords":"Computer science; Stored procedure; SQL; SQL/PSM; PL/SQL; Query by Example; Joins; SQL injection; Language Integrated Query; Programming language; Data definition language; Database; Data Transformation Services; Information retrieval; 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":"codex-gemma-dda1882f352a","candidate_categories":["metaepi_narrow"],"consensus_categories":[],"category_scores_codex":[0.0005556911,0.0004872949,0.0007023436,0.0006756852,0.0002067373,0.0001258451,0.001575091,0.0001942144,0.00002101508],"category_scores_gemma":[0.00005329852,0.0004431806,0.0001433168,0.0005367023,0.001118799,0.0008651852,0.0009895095,0.0004608495,0.00002140248],"about_ca_system_candidate":false,"about_ca_system_consensus":false,"about_ca_system_score_codex":0.0002554503,"about_ca_system_score_gemma":0.0004229707,"about_ca_topic_candidate":false,"about_ca_topic_consensus":false,"about_ca_topic_score_codex":0.0001696225,"about_ca_topic_score_gemma":0.0002404296,"domain_scores_codex":[0.9964684,0.0000343579,0.0007293141,0.001250829,0.0009928623,0.000524301],"domain_scores_gemma":[0.9971902,0.000303748,0.0005177385,0.001577633,0.0003111951,0.00009953381],"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.000007956321,0.00003052831,0.00003940204,0.0001063749,0.00001068833,0.0000508498,0.0004353649,0.02116227,0.0006545158,0.859546,0.0001680559,0.117788],"study_design_scores_gemma":[0.001146006,0.0005932046,0.001168088,0.002339625,0.00002645882,0.0002466608,0.000002517159,0.3457831,0.01241901,0.4848977,0.1483283,0.003049391],"study_design_candidate":"theoretical_or_conceptual","study_design_consensus":"theoretical_or_conceptual","genre_codex":"methods","genre_gemma":"methods","genre_scores_codex":[0.00003174688,0.0005513924,0.9892607,0.0003375833,0.001397276,0.000311803,0.00002895265,0.0001645689,0.007916025],"genre_scores_gemma":[0.05972812,0.00005022118,0.9382369,0.0003463456,0.0005269339,0.00001021813,0.00003389102,0.0000436011,0.001023793],"genre_candidate":"methods","genre_consensus":"methods","teacher_disagreement_score":0.3746483,"threshold_uncertainty_score":0.999802,"prediction_status":"machine_predicted_unvalidated"},"machine_scores":{"provisional":true,"baseline":true,"maturity_gate_passed":false,"score_opus":0.02050467328655909,"score_gpt":0.2431744688143798,"score_spread":0.2226697955278207,"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."}}