{"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":"codex-gemma-dda1882f352a","candidate_categories":["metaepi_narrow"],"consensus_categories":[],"category_scores_codex":[0.0006404603,0.001094286,0.001643051,0.0006026416,0.0003475639,0.0002627583,0.001070656,0.0004005243,0.0002683767],"category_scores_gemma":[0.0004996721,0.001060426,0.0004616692,0.001146802,0.0006573792,0.001077136,0.0008352859,0.001164554,0.0003127143],"about_ca_system_candidate":false,"about_ca_system_consensus":false,"about_ca_system_score_codex":0.0002307472,"about_ca_system_score_gemma":0.001084336,"about_ca_topic_candidate":false,"about_ca_topic_consensus":false,"about_ca_topic_score_codex":0.002134289,"about_ca_topic_score_gemma":0.002712486,"domain_scores_codex":[0.9940875,0.0002533119,0.001582309,0.001947502,0.001170764,0.0009586189],"domain_scores_gemma":[0.9954014,0.0004440135,0.0009956774,0.002040703,0.0006771077,0.0004410592],"domain_codex":null,"domain_gemma":null,"domain_candidate":null,"domain_consensus":null,"study_design_codex":"theoretical_or_conceptual","study_design_gemma":"simulation_or_modeling","study_design_scores_codex":[0.0005838829,0.0009406575,0.0004218575,0.02238647,0.002032015,0.001679272,0.1879752,0.001142628,0.03294179,0.6771202,0.00664711,0.06612888],"study_design_scores_gemma":[0.001884276,0.0007367503,0.000506053,0.01563846,0.001067078,0.0001951399,0.05162954,0.8024799,0.01208296,0.0002737803,0.109956,0.003549979],"study_design_candidate":"simulation_or_modeling","study_design_consensus":null,"genre_codex":"methods","genre_gemma":"empirical","genre_scores_codex":[0.05085034,0.02580883,0.9033086,0.0006241823,0.01229891,0.001675978,0.001854121,0.0005154306,0.003063548],"genre_scores_gemma":[0.8305935,0.003614389,0.08763841,0.0001335379,0.0005313403,0.0003009567,0.01038389,0.0003983836,0.06640561],"genre_candidate":"methods","genre_consensus":null,"teacher_disagreement_score":0.8156703,"threshold_uncertainty_score":0.9991846,"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."}}