KJCKorea
Journal Central

@article{ART002448751},
author={Go-Bong Choi and Yong-Tae Woo},
title={A Table Integration Technique Using Query Similarity Analysis},
journal={Journal of The Korea Society of Computer and Information},
issn={1598-849X},
year={2019},
volume={24},
number={3},
pages={105-112},
doi={10.9708/jksci.2019.24.03.105}

TY - JOUR
AU - Go-Bong Choi
AU - Yong-Tae Woo
TI - A Table Integration Technique Using Query Similarity Analysis
JO - Journal of The Korea Society of Computer and Information
PY - 2019
VL - 24
IS - 3
PB - The Korean Society Of Computer And Information
SP - 105
EP - 112
SN - 1598-849X
AB - In this paper, we propose a technique to analyze similarity between SQL queries and to assist integrating similar tables. First, the table information was extracted from the SQL queries through the query structure analyzer, and the similarity between the tables was measured using the Jacquard index technique. Then, similar table clusters are generated through hierarchical cluster analysis method and the co-occurence probability of the table used in the query is calculated. The possibility of integrating similar tables is classified by using the possibility of co-occurence of similarity table and table, and classifying them into an integrable cluster, a cluster requiring expert review, and a cluster with low integration possibility. This technique analyzes the SQL query in practice and analyse the possibility of table integration independent of the existing business, so that the existing schema can be effectively reconstructed without interruption of work or additional cost.
KW - SQL similarity analysis;Table integration;Data Architecture;Data Modeling Schema Reconstruction
DO - 10.9708/jksci.2019.24.03.105
ER -

Go-Bong Choi and Yong-Tae Woo. (2019). A Table Integration Technique Using Query Similarity Analysis. Journal of The Korea Society of Computer and Information, 24(3), 105-112.

Go-Bong Choi and Yong-Tae Woo. 2019, "A Table Integration Technique Using Query Similarity Analysis", Journal of The Korea Society of Computer and Information, vol.24, no.3 pp.105-112. Available from: doi:10.9708/jksci.2019.24.03.105

Go-Bong Choi, Yong-Tae Woo "A Table Integration Technique Using Query Similarity Analysis" Journal of The Korea Society of Computer and Information 24.3 pp.105-112 (2019) : 105.

Go-Bong Choi, Yong-Tae Woo. A Table Integration Technique Using Query Similarity Analysis. 2019; 24(3), 105-112. Available from: doi:10.9708/jksci.2019.24.03.105

Go-Bong Choi and Yong-Tae Woo. "A Table Integration Technique Using Query Similarity Analysis" Journal of The Korea Society of Computer and Information 24, no.3 (2019) : 105-112.doi: 10.9708/jksci.2019.24.03.105

Go-Bong Choi; Yong-Tae Woo. A Table Integration Technique Using Query Similarity Analysis. Journal of The Korea Society of Computer and Information, 24(3), 105-112. doi: 10.9708/jksci.2019.24.03.105

Go-Bong Choi; Yong-Tae Woo. A Table Integration Technique Using Query Similarity Analysis. Journal of The Korea Society of Computer and Information. 2019; 24(3) 105-112. doi: 10.9708/jksci.2019.24.03.105

Go-Bong Choi, Yong-Tae Woo. A Table Integration Technique Using Query Similarity Analysis. 2019; 24(3), 105-112. Available from: doi:10.9708/jksci.2019.24.03.105

Go-Bong Choi and Yong-Tae Woo. "A Table Integration Technique Using Query Similarity Analysis" Journal of The Korea Society of Computer and Information 24, no.3 (2019) : 105-112.doi: 10.9708/jksci.2019.24.03.105