{"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":"metacan-v3-hybrid-931329e0061c","candidate_categories":[],"consensus_categories":[],"category_scores_codex":[0.00506111,0.001353608,0.001362476,0.003132954,0.002005772,0.008830975,0.002350362,0.002427464,0.03832301],"category_scores_gemma":[0.02267131,0.001420138,0.001832301,0.003650693,0.002595038,0.01827001,0.005647872,0.003127883,0.01189243],"about_ca_system_candidate":false,"about_ca_system_consensus":false,"about_ca_system_score_codex":0.001711533,"about_ca_system_score_gemma":0.001431255,"about_ca_topic_candidate":false,"about_ca_topic_consensus":false,"about_ca_topic_score_codex":0.002366354,"about_ca_topic_score_gemma":0.001663526,"domain_scores_codex":[0.9876057,0.003231396,0.001513386,0.001766205,0.004940663,0.0009427056],"domain_scores_gemma":[0.9914185,0.004421268,0.0003837256,0.002118052,0.001394754,0.000263737],"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.0005578013,0.0001763762,0.00199807,0.0004228594,0.00009083209,0.001391763,0.001615159,0.002637933,0.00563488,0.7731026,0.07760647,0.1347654],"study_design_scores_gemma":[0.00010555,0.00005424003,0.0004524809,0.0001677473,0.0001599933,0.001977305,0.0007826188,0.03248085,0.01424219,0.5918359,0.3576426,0.00009856393],"study_design_candidate":"not_applicable","study_design_consensus":null,"genre_codex":"methods","genre_gemma":"methods","genre_scores_codex":[0.02303825,0.002097911,0.7850337,0.008074305,0.001057859,0.0006833853,0.006843672,0.0137219,0.159449],"genre_scores_gemma":[0.4320307,0.002914647,0.4307539,0.003359373,0.00154062,0.0005674443,0.0199601,0.005545006,0.1033281],"genre_candidate":"methods","genre_consensus":"methods","teacher_disagreement_score":0.03832301,"threshold_uncertainty_score":0.1282033,"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."}}