{"id":"W2505195002","doi":"10.4018/978-1-60960-475-2.ch012","title":"Making Query Coding in SQL Easier by Implementing the SQL Divide Keyword","year":2011,"lang":"en","type":"book-chapter","venue":"Advances in data mining and database management book series","topic":"Advanced Database Systems and Queries","field":"Computer Science","cited_by":1,"is_retracted":false,"has_abstract":true,"ca_institutions":"University of Calgary","funders":"","keywords":"Query by Example; Computer science; SQL; Sargable; Query optimization; Data definition language; Relational algebra; SQL/PSM; Stored procedure; Null (SQL); Programming language; Codd's theorem; Relational database; Theoretical computer science; Database; Relational model; Information retrieval; Web search query; Relational calculus","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","open_science"],"consensus_categories":[],"category_scores_codex":[0.001558749,0.0007033775,0.0006764171,0.0003804213,0.0004572253,0.0002663397,0.002333,0.000102011,0.00007893398],"category_scores_gemma":[0.00007926049,0.0006036502,0.00005153955,0.0001821411,0.0003444962,0.0114664,0.01051593,0.0004468368,0.00001155532],"about_ca_system_candidate":false,"about_ca_system_consensus":false,"about_ca_system_score_codex":0.00007673346,"about_ca_system_score_gemma":0.00004212884,"about_ca_topic_candidate":false,"about_ca_topic_consensus":false,"about_ca_topic_score_codex":0.00009121741,"about_ca_topic_score_gemma":0.002583624,"domain_scores_codex":[0.9957252,0.00009676216,0.001055924,0.001749997,0.00051547,0.0008566789],"domain_scores_gemma":[0.9954645,0.0002927221,0.000641059,0.003482313,0.00003333108,0.00008607998],"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.0000557275,0.00002607267,0.0005273815,0.0007837932,0.00008954804,0.0004349353,0.00069938,0.000007204274,0.00000464733,0.7949815,0.01505404,0.1873358],"study_design_scores_gemma":[0.0003751407,0.00003148789,0.00002378939,0.002666022,0.00004258147,0.00002876613,0.000547361,0.0002540375,0.00001247682,0.002454156,0.9928467,0.0007174424],"study_design_candidate":"not_applicable","study_design_consensus":null,"genre_codex":"methods","genre_gemma":"methods","genre_scores_codex":[0.00003752194,0.09816639,0.4490646,0.0007489382,0.00139529,0.001979351,0.007036413,0.0003792384,0.4411923],"genre_scores_gemma":[0.001689982,0.2931343,0.4032259,0.003032894,0.0007445051,0.0005889687,0.01641195,0.0004032105,0.2807683],"genre_candidate":"methods","genre_consensus":"methods","teacher_disagreement_score":0.9777927,"threshold_uncertainty_score":0.9996415,"prediction_status":"machine_predicted_unvalidated"},"machine_scores":{"provisional":true,"baseline":true,"maturity_gate_passed":false,"score_opus":0.05640107424140321,"score_gpt":0.2973257292373583,"score_spread":0.2409246549959551,"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."}}