@article{ART001083363},
author={박영규},
title={Join Operation of Parallel Database Sysem with Large Main Memory},
journal={Journal of The Korea Society of Computer and Information},
issn={1598-849X},
year={2007},
volume={12},
number={3},
pages={51-58}
TY - JOUR
AU - 박영규
TI - Join Operation of Parallel Database Sysem with Large Main Memory
JO - Journal of The Korea Society of Computer and Information
PY - 2007
VL - 12
IS - 3
PB - The Korean Society Of Computer And Information
SP - 51
EP - 58
SN - 1598-849X
AB - The shared-nothing multiprocessor architecture has advantages in scalability, this architecture has been adopted in many multiprocessor database systems. But, if the data are not uniformly distributed across the processors, load will be unbalanced. Therefore, the whole system performance will deteriorate. This is the data skew problem, which usually occurs in processing parallel hash join. Balancing the load before performing join will resolve this problem efficiently and the whole system performance can be improved. In this paper, we will present an algorithm using merit of very large memory to reduce disk access overhead in performing load balancing and to efficiently solve the data skew problem. Also, we will present analytical model of our new algorithm and present the result of some performance study we made comparing our algorithm with the other algorithms in handling data skew.
KW -
DO -
UR -
ER -
박영규. (2007). Join Operation of Parallel Database Sysem with Large Main Memory. Journal of The Korea Society of Computer and Information, 12(3), 51-58.
박영규. 2007, "Join Operation of Parallel Database Sysem with Large Main Memory", Journal of The Korea Society of Computer and Information, vol.12, no.3 pp.51-58.
박영규 "Join Operation of Parallel Database Sysem with Large Main Memory" Journal of The Korea Society of Computer and Information 12.3 pp.51-58 (2007) : 51.
박영규. Join Operation of Parallel Database Sysem with Large Main Memory. 2007; 12(3), 51-58.
박영규. "Join Operation of Parallel Database Sysem with Large Main Memory" Journal of The Korea Society of Computer and Information 12, no.3 (2007) : 51-58.
박영규. Join Operation of Parallel Database Sysem with Large Main Memory. Journal of The Korea Society of Computer and Information, 12(3), 51-58.
박영규. Join Operation of Parallel Database Sysem with Large Main Memory. Journal of The Korea Society of Computer and Information. 2007; 12(3) 51-58.
박영규. Join Operation of Parallel Database Sysem with Large Main Memory. 2007; 12(3), 51-58.
박영규. "Join Operation of Parallel Database Sysem with Large Main Memory" Journal of The Korea Society of Computer and Information 12, no.3 (2007) : 51-58.
