@article{ART001578919},
author={오병중 and 안수민 and 김경창},
title={Performance Comparison of Column-Oriented and Row-Oriented Database Systems for Star Schema Join Processing},
journal={Journal of The Korea Society of Computer and Information},
issn={1598-849X},
year={2011},
volume={16},
number={8},
pages={29-38}
TY - JOUR
AU - 오병중
AU - 안수민
AU - 김경창
TI - Performance Comparison of Column-Oriented and Row-Oriented Database Systems for Star Schema Join Processing
JO - Journal of The Korea Society of Computer and Information
PY - 2011
VL - 16
IS - 8
PB - The Korean Society Of Computer And Information
SP - 29
EP - 38
SN - 1598-849X
AB - Unlike in traditional row-oriented database systems, a column-oriented database system stores data in column-oriented and not row-oriented order. Recently, research results revealed the effectiveness of column-oriented databases for applications such as data warehouse and decision support systems that access large volumes of data in a read only manner. In this paper, we investigate the join strategies for column-oriented databases and prove the effectiveness of column-oriented databases in data warehouse systems. For unbiased comparison, the two database systems are analyzed using the star schema benchmark and the performance analysis of a star schema join query is carried out. We experimented with well-known join algorithms and considered early materialization and late materialization join strategies for column-oriented databases. The performance results confirm that star schema join queries perform better in terms of disk I/O cost in column-oriented databases than in row-oriented databases. In addition, the late materialization strategy showed more performance gain than the early materialization strategy in column-oriented databases.
KW - column-oriented database system;row-oriented database system;data warehouse;early materialization;late materialization;star schema benchmark;star schema join
DO -
UR -
ER -
오병중, 안수민 and 김경창. (2011). Performance Comparison of Column-Oriented and Row-Oriented Database Systems for Star Schema Join Processing. Journal of The Korea Society of Computer and Information, 16(8), 29-38.
오병중, 안수민 and 김경창. 2011, "Performance Comparison of Column-Oriented and Row-Oriented Database Systems for Star Schema Join Processing", Journal of The Korea Society of Computer and Information, vol.16, no.8 pp.29-38.
오병중, 안수민, 김경창 "Performance Comparison of Column-Oriented and Row-Oriented Database Systems for Star Schema Join Processing" Journal of The Korea Society of Computer and Information 16.8 pp.29-38 (2011) : 29.
오병중, 안수민, 김경창. Performance Comparison of Column-Oriented and Row-Oriented Database Systems for Star Schema Join Processing. 2011; 16(8), 29-38.
오병중, 안수민 and 김경창. "Performance Comparison of Column-Oriented and Row-Oriented Database Systems for Star Schema Join Processing" Journal of The Korea Society of Computer and Information 16, no.8 (2011) : 29-38.
오병중; 안수민; 김경창. Performance Comparison of Column-Oriented and Row-Oriented Database Systems for Star Schema Join Processing. Journal of The Korea Society of Computer and Information, 16(8), 29-38.
오병중; 안수민; 김경창. Performance Comparison of Column-Oriented and Row-Oriented Database Systems for Star Schema Join Processing. Journal of The Korea Society of Computer and Information. 2011; 16(8) 29-38.
오병중, 안수민, 김경창. Performance Comparison of Column-Oriented and Row-Oriented Database Systems for Star Schema Join Processing. 2011; 16(8), 29-38.
오병중, 안수민 and 김경창. "Performance Comparison of Column-Oriented and Row-Oriented Database Systems for Star Schema Join Processing" Journal of The Korea Society of Computer and Information 16, no.8 (2011) : 29-38.
