{"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":"metacan-v3-hybrid-931329e0061c","candidate_categories":[],"consensus_categories":[],"category_scores_codex":[0.002879216,0.001042787,0.0006527832,0.0007869667,0.0004611271,0.003536881,0.001745725,0.0007877583,0.009729238],"category_scores_gemma":[0.00611162,0.0008041882,0.001488063,0.0009611702,0.00123888,0.004373258,0.002664524,0.003457095,0.005658854],"about_ca_system_candidate":false,"about_ca_system_consensus":false,"about_ca_system_score_codex":0.0007281649,"about_ca_system_score_gemma":0.001598739,"about_ca_topic_candidate":false,"about_ca_topic_consensus":false,"about_ca_topic_score_codex":0.00183888,"about_ca_topic_score_gemma":0.001896462,"domain_scores_codex":[0.9965216,0.0007134448,0.000528887,0.0007335275,0.001248582,0.0002540718],"domain_scores_gemma":[0.9964035,0.001330676,0.000180629,0.001084494,0.0008878958,0.0001128399],"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.0007375072,0.0004598764,0.003575193,0.002057313,0.0001824405,0.001183936,0.004830535,0.01455584,0.1459062,0.3892378,0.07293635,0.3643371],"study_design_scores_gemma":[0.0001928642,0.0003550612,0.001521136,0.0004483586,0.0002044621,0.001779206,0.0008843059,0.1245154,0.1888567,0.09554929,0.5854622,0.0002310959],"study_design_candidate":"not_applicable","study_design_consensus":null,"genre_codex":"methods","genre_gemma":"methods","genre_scores_codex":[0.004279618,0.0001565711,0.9677211,0.0002906588,0.0001420011,0.000219245,0.0005097222,0.02058921,0.006091971],"genre_scores_gemma":[0.08416232,0.0007471786,0.8891094,0.00152604,0.0001782423,0.0003932995,0.00335225,0.01053825,0.009993088],"genre_candidate":"methods","genre_consensus":"methods","teacher_disagreement_score":0.009729238,"threshold_uncertainty_score":0.03254753,"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."}}