Matches in SemOpenAlex for { <https://semopenalex.org/work/W1578814752> ?p ?o ?g. }
- W1578814752 abstract "Scheduling query execution plans is a particularly complex problem in shared-nothing 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 message-passing. Earlier work on parallel query scheduling employs either (a) one-dimensional models of parallel task scheduling, effectively ignoring the potential benefits of resource sharing, or (b) models of globally accessible resource units, which are appropriate only for shared-memory architectures, since they cannot capture the affinity of system resources to sites. In this paper, we develop a general approach capturing the full complexity of scheduling distributed, multi-dimensional resource units for all forms of parallelism within and across queries and operators. We present a level-based list scheduling heuristic algorithm for independent query tasks (i.e., physical operator pipelines) that is provably near-optimal for given degrees of partitioned parallelism (with a worst-case performance ratio that depends on the number of time-shared and space-shared resources per site and the granularity of the clones). We also propose extensions to handle blocking constraints in logical operator (e.g., hash-join) pipelines and bushy query plans as well as on-line task arrivals (e.g., in a dynamic or multi-query execution environment). Experiments with our scheduling algorithms implemented on top of a detailed simulation model verify their effectiveness compared to existing approaches in a realistic setting. Based on our analytical and experimental results, we revisit the open problem of designing efficient cost models for parallel query optimization and propose a solution that captures all the important parameters of parallel execution." @default.
- W1578814752 created "2016-06-24" @default.
- W1578814752 creator A5023079617 @default.
- W1578814752 creator A5084870386 @default.
- W1578814752 date "2014-03-30" @default.
- W1578814752 modified "2023-09-27" @default.
- W1578814752 title "Multi-Resource Parallel Query Scheduling and Optimization" @default.
- W1578814752 cites W1487093789 @default.
- W1578814752 cites W1488422606 @default.
- W1578814752 cites W1508957747 @default.
- W1578814752 cites W1519941054 @default.
- W1578814752 cites W1535462869 @default.
- W1578814752 cites W1539798503 @default.
- W1578814752 cites W1549426500 @default.
- W1578814752 cites W1557956086 @default.
- W1578814752 cites W1566966599 @default.
- W1578814752 cites W1578006587 @default.
- W1578814752 cites W1581203859 @default.
- W1578814752 cites W1590291442 @default.
- W1578814752 cites W1593000629 @default.
- W1578814752 cites W1604793072 @default.
- W1578814752 cites W1684916801 @default.
- W1578814752 cites W1895735149 @default.
- W1578814752 cites W1966080685 @default.
- W1578814752 cites W1975278491 @default.
- W1578814752 cites W1986843683 @default.
- W1578814752 cites W1989152133 @default.
- W1578814752 cites W1997020216 @default.
- W1578814752 cites W1998406251 @default.
- W1578814752 cites W1999119023 @default.
- W1578814752 cites W2000637380 @default.
- W1578814752 cites W2004861737 @default.
- W1578814752 cites W2008750849 @default.
- W1578814752 cites W2011039300 @default.
- W1578814752 cites W2028801713 @default.
- W1578814752 cites W2037394610 @default.
- W1578814752 cites W2040823248 @default.
- W1578814752 cites W2046269252 @default.
- W1578814752 cites W2049263029 @default.
- W1578814752 cites W2049305549 @default.
- W1578814752 cites W2055782916 @default.
- W1578814752 cites W2057913648 @default.
- W1578814752 cites W2068088848 @default.
- W1578814752 cites W2075284083 @default.
- W1578814752 cites W2078678742 @default.
- W1578814752 cites W2080427212 @default.
- W1578814752 cites W2081987145 @default.
- W1578814752 cites W2086190489 @default.
- W1578814752 cites W2089269509 @default.
- W1578814752 cites W2099055602 @default.
- W1578814752 cites W2104680817 @default.
- W1578814752 cites W2104777670 @default.
- W1578814752 cites W2105574638 @default.
- W1578814752 cites W2108127784 @default.
- W1578814752 cites W2112668678 @default.
- W1578814752 cites W2128871859 @default.
- W1578814752 cites W2128912667 @default.
- W1578814752 cites W2139444324 @default.
- W1578814752 cites W2142860409 @default.
- W1578814752 cites W2151197771 @default.
- W1578814752 cites W2151826520 @default.
- W1578814752 cites W2151834759 @default.
- W1578814752 cites W2153329411 @default.
- W1578814752 cites W2153446144 @default.
- W1578814752 cites W2154305205 @default.
- W1578814752 cites W2157760211 @default.
- W1578814752 cites W2169486917 @default.
- W1578814752 cites W2479567345 @default.
- W1578814752 cites W2614663664 @default.
- W1578814752 cites W2751601659 @default.
- W1578814752 hasPublicationYear "2014" @default.
- W1578814752 type Work @default.
- W1578814752 sameAs 1578814752 @default.
- W1578814752 citedByCount "0" @default.
- W1578814752 crossrefType "posted-content" @default.
- W1578814752 hasAuthorship W1578814752A5023079617 @default.
- W1578814752 hasAuthorship W1578814752A5084870386 @default.
- W1578814752 hasConcept C107568181 @default.
- W1578814752 hasConcept C111919701 @default.
- W1578814752 hasConcept C120314980 @default.
- W1578814752 hasConcept C126255220 @default.
- W1578814752 hasConcept C173608175 @default.
- W1578814752 hasConcept C177774035 @default.
- W1578814752 hasConcept C206729178 @default.
- W1578814752 hasConcept C31258907 @default.
- W1578814752 hasConcept C33923547 @default.
- W1578814752 hasConcept C41008148 @default.
- W1578814752 hasConcept C5119721 @default.
- W1578814752 hasConcept C51332947 @default.
- W1578814752 hasConcept C80444323 @default.
- W1578814752 hasConceptScore W1578814752C107568181 @default.
- W1578814752 hasConceptScore W1578814752C111919701 @default.
- W1578814752 hasConceptScore W1578814752C120314980 @default.
- W1578814752 hasConceptScore W1578814752C126255220 @default.
- W1578814752 hasConceptScore W1578814752C173608175 @default.
- W1578814752 hasConceptScore W1578814752C177774035 @default.
- W1578814752 hasConceptScore W1578814752C206729178 @default.
- W1578814752 hasConceptScore W1578814752C31258907 @default.
- W1578814752 hasConceptScore W1578814752C33923547 @default.
- W1578814752 hasConceptScore W1578814752C41008148 @default.