ADVDB23 07 - Выполнения запросов
Выполнения запросов Слайды https://15721.courses.cs.cmu.edu/spring2023/slides/07-scheduling.pdf V. Leis, et al., Morsel-Driven Parallelism: A NUMA-Aware Query Evaluation Framework for the Many-Core Age, in SIGMOD, 2014 https://15721.courses.cs.cmu.edu/spring2023/papers/07-scheduling/p743-leis.pdf I. Psaroudakis, et al., Scaling Up Concurrent Main-Memory Column-Store Scans: Towards Adaptive NUMA-aware Data and Task Placement, in VLDB, 2015 (Optional) https://15721.courses.cs.cmu.edu/spring2023/papers/07-scheduling/p1442-psaroudakis.pdf I. Psaroudakis, et al., Task Scheduling for Highly Concurrent Analytical and Transactional Main-Memory Workloads, in ADMS, 2013 (Optional) https://15721.courses.cs.cmu.edu/spring2023/papers/07-scheduling/psaroudakis_adms13.pdf B. Wagner, et al., Self-Tuning Query Scheduling for Analytical Workloads, in SIGMOD, 2021 (Optional) https://15721.courses.cs.cmu.edu/spring2023/papers/07-scheduling/wagner-sigmod21.pdf 00:00 Intro 01:12 Query Plan 04:05 Operating System 05:26 Responsiveness 06:50 Agenda 07:49 Process Model 10:11 Worker Allocation 12:22 Push vs Pool 13:37 Data Location 14:36 Uniform Memory Access 16:16 NonUniform Memory Access 19:34 Partitioning Memory 21:16 Virtual Memory 22:38 Interleaving 23:23 Move 23:49 Experiment 29:40 Partition Scheme 30:27 Test Assignment Model 31:21 Static Scheduling 35:42 Global Data Structure 37:27 Data Table 38:38 Exiting Query 43:02 WorkStealing 43:41 Speculative Execution 47:50 Umbra Schedule 55:42 SAP Hana
Выполнения запросов Слайды https://15721.courses.cs.cmu.edu/spring2023/slides/07-scheduling.pdf V. Leis, et al., Morsel-Driven Parallelism: A NUMA-Aware Query Evaluation Framework for the Many-Core Age, in SIGMOD, 2014 https://15721.courses.cs.cmu.edu/spring2023/papers/07-scheduling/p743-leis.pdf I. Psaroudakis, et al., Scaling Up Concurrent Main-Memory Column-Store Scans: Towards Adaptive NUMA-aware Data and Task Placement, in VLDB, 2015 (Optional) https://15721.courses.cs.cmu.edu/spring2023/papers/07-scheduling/p1442-psaroudakis.pdf I. Psaroudakis, et al., Task Scheduling for Highly Concurrent Analytical and Transactional Main-Memory Workloads, in ADMS, 2013 (Optional) https://15721.courses.cs.cmu.edu/spring2023/papers/07-scheduling/psaroudakis_adms13.pdf B. Wagner, et al., Self-Tuning Query Scheduling for Analytical Workloads, in SIGMOD, 2021 (Optional) https://15721.courses.cs.cmu.edu/spring2023/papers/07-scheduling/wagner-sigmod21.pdf 00:00 Intro 01:12 Query Plan 04:05 Operating System 05:26 Responsiveness 06:50 Agenda 07:49 Process Model 10:11 Worker Allocation 12:22 Push vs Pool 13:37 Data Location 14:36 Uniform Memory Access 16:16 NonUniform Memory Access 19:34 Partitioning Memory 21:16 Virtual Memory 22:38 Interleaving 23:23 Move 23:49 Experiment 29:40 Partition Scheme 30:27 Test Assignment Model 31:21 Static Scheduling 35:42 Global Data Structure 37:27 Data Table 38:38 Exiting Query 43:02 WorkStealing 43:41 Speculative Execution 47:50 Umbra Schedule 55:42 SAP Hana