테이블 유사도 분석을 통한 테이블 통합 기법

• Published in: 한국컴퓨터정보학회논문지, 24(3) pp. 105 - 112
• Main Authors: 최고봉(코아정보기술, 우용태
• Format: Journal Article
• Language: Korean
• Published: 한국컴퓨터정보학회 01.03.2019
• Subjects: 컴퓨터학
• ISSN: 1598-849X; 2383-9945
• DOI: 10.9708/jksci.2019.24.03.105

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. KCI Citation Count: 0