{"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":"metacan-v3-hybrid-931329e0061c","candidate_categories":[],"consensus_categories":[],"category_scores_codex":[0.009998214,0.00116183,0.001430381,0.001553943,0.00195174,0.004261234,0.002026065,0.00208248,0.001353013],"category_scores_gemma":[0.07844724,0.001119243,0.0006886346,0.00232029,0.001494381,0.005031743,0.002352052,0.002655707,0.000573588],"about_ca_system_candidate":false,"about_ca_system_consensus":false,"about_ca_system_score_codex":0.001704918,"about_ca_system_score_gemma":0.001539407,"about_ca_topic_candidate":false,"about_ca_topic_consensus":false,"about_ca_topic_score_codex":0.001862948,"about_ca_topic_score_gemma":0.001401179,"domain_scores_codex":[0.9592558,0.01459096,0.003214713,0.004660734,0.01575417,0.002523686],"domain_scores_gemma":[0.8785884,0.09219353,0.008980515,0.008959116,0.008255989,0.0030225],"domain_codex":null,"domain_gemma":null,"domain_candidate":null,"domain_consensus":null,"study_design_codex":"observational","study_design_gemma":"simulation_or_modeling","study_design_scores_codex":[0.006841467,0.004369599,0.3644418,0.0009504466,0.0008716824,0.003125159,0.003908219,0.2530121,0.2176815,0.02301986,0.00676694,0.1150113],"study_design_scores_gemma":[0.0002005281,0.001959906,0.06264839,0.00005557858,0.0002247916,0.002430995,0.001456723,0.8595367,0.04952451,0.01767473,0.004089924,0.0001971751],"study_design_candidate":"simulation_or_modeling","study_design_consensus":null,"genre_codex":"empirical","genre_gemma":"empirical","genre_scores_codex":[0.9540651,0.0005649713,0.04072771,0.0006963387,0.00007539577,0.0002689459,0.000415562,0.0008489907,0.002336908],"genre_scores_gemma":[0.991252,0.00007439967,0.007438296,0.0001729955,0.00004041928,0.0001477222,0.0004594292,0.00009262474,0.0003219599],"genre_candidate":"empirical","genre_consensus":"empirical","teacher_disagreement_score":0.009998214,"threshold_uncertainty_score":0.05287623,"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."}}