Parallel Query Scheduling and Optimization with Time- and Space-Shared Resources

Scheduling query execution plans is a particularly complex problem in hierarchical parallel systems, where each site consists of a collection of local time-shared (e.g., CPU(s) or disk(s)) and space-shared (e.g., memory) resources and communicates with remote sites by messagepassing. We develop a general approach to the problem, capturing the full complexity of schedulingdistributed multi-dimensional resource units for all kinds of parallelism within and across queries and operators. We present heuristic algorithms for various forms of the problem, some of which are provably near-optimal. Preliminary experimental results confirm the effectiveness of our approach.

• Type: Conference
• Year: 1997
• Where: VLDB
• Authors: Minos N. Garofalakis, Yannis E. Ioannidis
• Keywords: Complex Problem, Database, Hierarchical Parallel Systems, Query Execution Plans, VLDB 1997