{"id":"W3007378362","doi":"10.1145/3377555.3377892","title":"Improving database query performance with automatic fusion","year":2020,"lang":"en","type":"article","venue":"","topic":"Advanced Database Systems and Queries","field":"Computer Science","cited_by":3,"is_retracted":false,"has_abstract":true,"ca_institutions":"McGill University","funders":"","keywords":"Computer science; Compiler; Loop fusion; Query optimization; SQL; Sargable; Database; Fuse (electrical); Query language; Programming language; View; Loop unrolling; Search engine; Web search query; Information retrieval; Database design","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.00009013615,0.0001134795,0.0001240629,0.00002584893,0.0001224177,0.00004550484,0.0002879989,0.00001562123,0.00003497763],"category_scores_gemma":[0.00002392142,0.0000758259,0.00001557718,0.0002615886,0.0000253064,0.001737159,0.0003420055,0.00008246781,0.00009313176],"about_ca_system_candidate":false,"about_ca_system_consensus":false,"about_ca_system_score_codex":0.00001200765,"about_ca_system_score_gemma":0.00006289614,"about_ca_topic_candidate":false,"about_ca_topic_consensus":false,"about_ca_topic_score_codex":0.00005708485,"about_ca_topic_score_gemma":0.00001328629,"domain_scores_codex":[0.9991105,0.00001811784,0.0001564441,0.0003168053,0.0002068662,0.0001912685],"domain_scores_gemma":[0.9992844,0.00002518394,0.00007069978,0.0004602788,0.00003493555,0.0001244683],"domain_codex":null,"domain_gemma":null,"domain_candidate":null,"domain_consensus":null,"study_design_codex":"design_other","study_design_gemma":"simulation_or_modeling","study_design_scores_codex":[0.00006156964,0.0001063041,0.004439233,0.001765168,0.00004010869,0.0002355819,0.003268809,0.0007530833,0.05053138,0.2464658,0.004822568,0.6875104],"study_design_scores_gemma":[0.0003130542,0.0002125595,0.000475243,0.00008521046,0.000003639838,0.00003676389,0.0001236731,0.9749048,0.008968893,0.000005363302,0.01461369,0.0002570717],"study_design_candidate":"simulation_or_modeling","study_design_consensus":null,"genre_codex":"methods","genre_gemma":"methods","genre_scores_codex":[0.05206808,0.00004019269,0.9456186,0.0006222554,0.00006734898,0.0001244663,0.000005869527,0.0004255372,0.001027604],"genre_scores_gemma":[0.3945301,0.000009929729,0.6041183,0.001088334,0.00007231102,0.00001389531,0.00001244185,0.000009537314,0.0001451187],"genre_candidate":"methods","genre_consensus":"methods","teacher_disagreement_score":0.9741517,"threshold_uncertainty_score":0.3092091,"prediction_status":"machine_predicted_unvalidated"},"machine_scores":{"provisional":true,"baseline":true,"maturity_gate_passed":false,"score_opus":0.01440875879431176,"score_gpt":0.208022100579784,"score_spread":0.1936133417854723,"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."}}