{"id":"W2145832235","doi":"10.1007/s10844-009-0091-x","title":"Queries with CASE expressions","year":2009,"lang":"en","type":"article","venue":"Journal of Intelligent Information Systems","topic":"Advanced Database Systems and Queries","field":"Computer Science","cited_by":1,"is_retracted":false,"has_abstract":false,"ca_institutions":"IBM (Canada); York University","funders":"","keywords":"Computer science; Query optimization; Expression (computer science); Information retrieval; Query language; Programming language","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":[],"consensus_categories":[],"category_scores_codex":[0.0004028288,0.0001154482,0.0002237899,0.0002328098,0.000126423,0.0001923894,0.000244723,0.00003663778,0.000004235988],"category_scores_gemma":[0.00005424024,0.0000708713,0.00005792884,0.0002399759,0.00002033224,0.006141637,0.00002999978,0.0001357159,0.0000287374],"about_ca_system_candidate":false,"about_ca_system_consensus":false,"about_ca_system_score_codex":0.00006119571,"about_ca_system_score_gemma":0.00009227129,"about_ca_topic_candidate":false,"about_ca_topic_consensus":false,"about_ca_topic_score_codex":0.00001927857,"about_ca_topic_score_gemma":0.000001678513,"domain_scores_codex":[0.9984806,0.0000461624,0.0008784468,0.00005645371,0.0003942219,0.0001441403],"domain_scores_gemma":[0.9980421,0.0000500659,0.0009075333,0.0002907512,0.0005868322,0.0001227172],"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.0001444809,0.0001058069,0.0001347196,0.0001653641,0.00009513829,0.001496424,0.01888107,0.0251613,0.0004030269,0.8787397,0.008647426,0.0660256],"study_design_scores_gemma":[0.0005089924,0.001004056,0.00006451026,0.0008351305,0.00001249122,0.06495138,0.01222444,0.006368062,0.004173597,0.000150464,0.9093759,0.0003309814],"study_design_candidate":"not_applicable","study_design_consensus":null,"genre_codex":"methods","genre_gemma":"empirical","genre_scores_codex":[0.005118411,0.0002898508,0.9917213,0.0001826487,0.0006011018,0.000135532,0.000007045,0.00003724272,0.001906829],"genre_scores_gemma":[0.9561767,0.00006087959,0.04327807,0.0002178181,0.0001453798,0.000004325534,0.000003203681,0.000003298338,0.0001103108],"genre_candidate":"methods","genre_consensus":null,"teacher_disagreement_score":0.9510583,"threshold_uncertainty_score":0.4452538,"prediction_status":"machine_predicted_unvalidated"},"machine_scores":{"provisional":true,"baseline":true,"maturity_gate_passed":false,"score_opus":0.01360373531177958,"score_gpt":0.2505480904407343,"score_spread":0.2369443551289548,"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."}}