{"id":"W7132937022","doi":"","title":"Dynamic, Hardware-Conscious Tuning of Concurrent Multithreaded Analytical Database Queries","year":2024,"lang":"","type":"dissertation","venue":"TSpace","topic":"Advanced Database Systems and Queries","field":"Computer Science","cited_by":0,"is_retracted":false,"has_abstract":true,"ca_institutions":"University of Toronto","funders":"","keywords":"Query optimization; Hash function; Online aggregation; Execution time; Sargable; Profiling (computer programming); Query language; Query plan; Hash table","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.002006229,0.0006856799,0.0005813049,0.0004144026,0.0005487229,0.001681808,0.002270482,0.0004479034,0.0009239796],"category_scores_gemma":[0.006276561,0.0004896757,0.0003318584,0.0004411152,0.0007387956,0.001716668,0.001518125,0.001101679,0.0002133214],"about_ca_system_candidate":false,"about_ca_system_consensus":false,"about_ca_system_score_codex":0.0008402218,"about_ca_system_score_gemma":0.001446781,"about_ca_topic_candidate":false,"about_ca_topic_consensus":false,"about_ca_topic_score_codex":0.002415945,"about_ca_topic_score_gemma":0.002262378,"domain_scores_codex":[0.9979253,0.0003427229,0.0001116102,0.0004993834,0.0008455791,0.0002754106],"domain_scores_gemma":[0.9972505,0.001148182,0.0002359403,0.0008513383,0.0003270026,0.0001868962],"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.002356219,0.0009238871,0.02858205,0.0003647182,0.0001643602,0.0003855526,0.001155041,0.3207405,0.2840734,0.02128551,0.005686193,0.3342825],"study_design_scores_gemma":[0.00007482848,0.0001601877,0.002677711,0.000009706014,0.00002939646,0.00007295356,0.0001099261,0.9396415,0.04968261,0.003993371,0.003518032,0.0000298901],"study_design_candidate":"simulation_or_modeling","study_design_consensus":null,"genre_codex":"empirical","genre_gemma":"empirical","genre_scores_codex":[0.5827561,0.0009124448,0.3974293,0.0004193271,0.000156973,0.000197296,0.0001459256,0.01166,0.006322626],"genre_scores_gemma":[0.9449408,0.0001065307,0.05354884,0.00009766364,0.00003080209,0.00005695594,0.00009316695,0.0003969579,0.0007283529],"genre_candidate":"empirical","genre_consensus":"empirical","teacher_disagreement_score":0.002415945,"threshold_uncertainty_score":0.0106101,"prediction_status":"machine_predicted_unvalidated"},"machine_scores":{"provisional":true,"baseline":true,"maturity_gate_passed":false,"score_opus":0.03107446379668898,"score_gpt":0.3672445027240642,"score_spread":0.3361700389273752,"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."}}