{"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":"metacan-v3-hybrid-931329e0061c","candidate_categories":[],"consensus_categories":[],"category_scores_codex":[0.003550528,0.0009437293,0.001442555,0.001073955,0.0006547771,0.001999827,0.00167647,0.0006325563,0.004395634],"category_scores_gemma":[0.008760332,0.00109571,0.001673109,0.001098435,0.001331491,0.00390746,0.002660224,0.002202717,0.00222844],"about_ca_system_candidate":false,"about_ca_system_consensus":false,"about_ca_system_score_codex":0.0006244117,"about_ca_system_score_gemma":0.001252837,"about_ca_topic_candidate":false,"about_ca_topic_consensus":false,"about_ca_topic_score_codex":0.002013911,"about_ca_topic_score_gemma":0.002346469,"domain_scores_codex":[0.9941773,0.001042108,0.0004936885,0.0009413403,0.002851584,0.0004938987],"domain_scores_gemma":[0.9873438,0.004216203,0.000580578,0.004902,0.002684386,0.000273065],"domain_codex":null,"domain_gemma":null,"domain_candidate":null,"domain_consensus":null,"study_design_codex":"design_other","study_design_gemma":"simulation_or_modeling","study_design_scores_codex":[0.001431032,0.0006141457,0.004867593,0.00110574,0.000195884,0.001321364,0.002250127,0.06295007,0.06699618,0.2035524,0.0347571,0.6199583],"study_design_scores_gemma":[0.0001233044,0.0003506617,0.002253169,0.0001525507,0.0001826561,0.0014395,0.0004554904,0.4847691,0.1521106,0.2955401,0.06245286,0.0001700652],"study_design_candidate":"simulation_or_modeling","study_design_consensus":null,"genre_codex":"methods","genre_gemma":"empirical","genre_scores_codex":[0.07705099,0.0005479701,0.894507,0.0001895001,0.0001531653,0.000127839,0.0005648461,0.01899024,0.007868358],"genre_scores_gemma":[0.4614347,0.0005578534,0.5088756,0.000332052,0.000299029,0.0001455669,0.004488655,0.005197428,0.01866905],"genre_candidate":"empirical","genre_consensus":null,"teacher_disagreement_score":0.004395634,"threshold_uncertainty_score":0.01877719,"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."}}