Matches in SemOpenAlex for { <https://semopenalex.org/work/W2397506800> ?p ?o ?g. }
Showing items 1 to 79 of
79
with 100 items per page.
- W2397506800 endingPage "192" @default.
- W2397506800 startingPage "180" @default.
- W2397506800 abstract "We investigate the effect of the data skew of join attributes on the performance of a pipelined multi-way hash join method, and propose two new harsh join methods in the shared-nothing multiprocessor environment. The first proposed method allocates buckets statically by round-robin fashion, and the second one allocates buckets dynamically via a frequency distribution. Using harsh-based joins, multiple joins can be pipelined to that the early results from a join, before the whole join is completed, are sent to the next join processing without staying in disks. Shared nothing multiprocessor architecture is known to be more scalable to support very large databases. However, this hardware structure is very sensitive to the data skew. Unless the pipelining execution of multiple hash joins includes some dynamic load balancing mechanism, the skew effect can severely deteriorate the system performance. In this parer, we derive an execution model of the pipeline segment and a cost model, and develop a simulator for the study. As shown by our simulation with a wide range of parameters, join selectivities and sizes of relations deteriorate the system performance as the degree of data skew is larger. But the proposed method using a large number of buckets and a tuning technique can offer substantial robustness against a wide range of skew conditions." @default.
- W2397506800 created "2016-06-24" @default.
- W2397506800 creator A5016541805 @default.
- W2397506800 creator A5023490157 @default.
- W2397506800 creator A5052688831 @default.
- W2397506800 date "2002-01-01" @default.
- W2397506800 modified "2023-09-23" @default.
- W2397506800 title "A Load Balancing Method using Partition Tuning for Pipelined Multi-way Hash Join" @default.
- W2397506800 hasPublicationYear "2002" @default.
- W2397506800 type Work @default.
- W2397506800 sameAs 2397506800 @default.
- W2397506800 citedByCount "0" @default.
- W2397506800 crossrefType "journal-article" @default.
- W2397506800 hasAuthorship W2397506800A5016541805 @default.
- W2397506800 hasAuthorship W2397506800A5023490157 @default.
- W2397506800 hasAuthorship W2397506800A5052688831 @default.
- W2397506800 hasConcept C114614502 @default.
- W2397506800 hasConcept C120314980 @default.
- W2397506800 hasConcept C173608175 @default.
- W2397506800 hasConcept C188805328 @default.
- W2397506800 hasConcept C199360897 @default.
- W2397506800 hasConcept C2776124973 @default.
- W2397506800 hasConcept C2778692605 @default.
- W2397506800 hasConcept C33923547 @default.
- W2397506800 hasConcept C41008148 @default.
- W2397506800 hasConcept C42812 @default.
- W2397506800 hasConcept C43711488 @default.
- W2397506800 hasConcept C48044578 @default.
- W2397506800 hasConcept C4822641 @default.
- W2397506800 hasConcept C76155785 @default.
- W2397506800 hasConcept C77088390 @default.
- W2397506800 hasConcept C99138194 @default.
- W2397506800 hasConceptScore W2397506800C114614502 @default.
- W2397506800 hasConceptScore W2397506800C120314980 @default.
- W2397506800 hasConceptScore W2397506800C173608175 @default.
- W2397506800 hasConceptScore W2397506800C188805328 @default.
- W2397506800 hasConceptScore W2397506800C199360897 @default.
- W2397506800 hasConceptScore W2397506800C2776124973 @default.
- W2397506800 hasConceptScore W2397506800C2778692605 @default.
- W2397506800 hasConceptScore W2397506800C33923547 @default.
- W2397506800 hasConceptScore W2397506800C41008148 @default.
- W2397506800 hasConceptScore W2397506800C42812 @default.
- W2397506800 hasConceptScore W2397506800C43711488 @default.
- W2397506800 hasConceptScore W2397506800C48044578 @default.
- W2397506800 hasConceptScore W2397506800C4822641 @default.
- W2397506800 hasConceptScore W2397506800C76155785 @default.
- W2397506800 hasConceptScore W2397506800C77088390 @default.
- W2397506800 hasConceptScore W2397506800C99138194 @default.
- W2397506800 hasIssue "3" @default.
- W2397506800 hasLocation W23975068001 @default.
- W2397506800 hasOpenAccess W2397506800 @default.
- W2397506800 hasPrimaryLocation W23975068001 @default.
- W2397506800 hasRelatedWork W1515038756 @default.
- W2397506800 hasRelatedWork W2069944651 @default.
- W2397506800 hasRelatedWork W2077933549 @default.
- W2397506800 hasRelatedWork W2131055986 @default.
- W2397506800 hasRelatedWork W2132727211 @default.
- W2397506800 hasRelatedWork W2140869148 @default.
- W2397506800 hasRelatedWork W2184400310 @default.
- W2397506800 hasRelatedWork W2226599271 @default.
- W2397506800 hasRelatedWork W2378725315 @default.
- W2397506800 hasRelatedWork W2435648513 @default.
- W2397506800 hasRelatedWork W2529787296 @default.
- W2397506800 hasRelatedWork W2602770141 @default.
- W2397506800 hasRelatedWork W2889095650 @default.
- W2397506800 hasRelatedWork W2889219672 @default.
- W2397506800 hasRelatedWork W2949751527 @default.
- W2397506800 hasRelatedWork W2972203418 @default.
- W2397506800 hasRelatedWork W2992819018 @default.
- W2397506800 hasRelatedWork W3135618461 @default.
- W2397506800 hasRelatedWork W336172238 @default.
- W2397506800 hasRelatedWork W50914958 @default.
- W2397506800 hasVolume "29" @default.
- W2397506800 isParatext "false" @default.
- W2397506800 isRetracted "false" @default.
- W2397506800 magId "2397506800" @default.
- W2397506800 workType "article" @default.