{"id":"W2121324617","doi":"10.1145/1594156.1594170","title":"Query interactions in database workloads","year":2009,"lang":"en","type":"article","venue":"","topic":"Advanced Database Systems and Queries","field":"Computer Science","cited_by":28,"is_retracted":false,"has_abstract":true,"ca_institutions":"University of Waterloo","funders":"","keywords":"Computer science; Database; View; Database tuning; Query optimization; Database testing; Data mining; Database theory; Online aggregation; Database design; Sargable; 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":"codex-gemma-dda1882f352a","candidate_categories":[],"consensus_categories":[],"category_scores_codex":[0.0001052713,0.00007018167,0.00008576215,0.0000993311,0.00004086086,0.00003033225,0.0002069487,0.0000097232,0.00003900634],"category_scores_gemma":[0.00002582116,0.00005908199,0.00002033472,0.0003195112,0.00001017309,0.001532262,0.0000860065,0.00009637604,0.00008726893],"about_ca_system_candidate":false,"about_ca_system_consensus":false,"about_ca_system_score_codex":0.00002478993,"about_ca_system_score_gemma":0.00002330424,"about_ca_topic_candidate":false,"about_ca_topic_consensus":false,"about_ca_topic_score_codex":0.0001182863,"about_ca_topic_score_gemma":0.000380318,"domain_scores_codex":[0.9993564,0.00002336425,0.0001600133,0.0002149964,0.00008712637,0.0001580738],"domain_scores_gemma":[0.9993706,0.0000389093,0.00002844396,0.0004958119,0.00001757772,0.00004868772],"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.000003679175,0.00007638116,0.0004031938,0.000002875854,0.000001624979,0.00004708685,0.0001624485,0.0000611945,0.001774563,0.9291676,0.004328088,0.06397133],"study_design_scores_gemma":[0.0008564445,0.0001190609,0.0192859,0.0003339646,0.000002876284,0.0001567113,0.0004061226,0.02991524,0.007252852,0.008402386,0.9324726,0.000795825],"study_design_candidate":"theoretical_or_conceptual","study_design_consensus":null,"genre_codex":"methods","genre_gemma":"empirical","genre_scores_codex":[0.002617501,0.00008018753,0.9792377,0.001247168,0.0002480547,0.00006549485,0.000004126667,0.000133521,0.01636625],"genre_scores_gemma":[0.5947496,0.00002727169,0.4012764,0.001424027,0.00008345729,0.00001069107,0.00001454378,0.00000363673,0.002410461],"genre_candidate":"methods","genre_consensus":null,"teacher_disagreement_score":0.9281445,"threshold_uncertainty_score":0.2409294,"prediction_status":"machine_predicted_unvalidated"},"machine_scores":{"provisional":true,"baseline":true,"maturity_gate_passed":false,"score_opus":0.02252401156989909,"score_gpt":0.2980112363743665,"score_spread":0.2754872248044674,"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."}}