• 한국컴퓨터정보학회논문지
• /
• 제24권3호
• /
• pp.105-112
• /
• 2019

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.

• 대한한의학원전학회지
• /
• 제27권4호
• /
• pp.121-131
• /
• 2014

Objectives : The objectives of this study is to compare the differences in medical herbs combination of Taepyeonghyeminhwajegukbang, Somunsunmyungronbang and Nansilbijang. Methods : This study was proceeded by using Access 2007 and SQL Server and prescriptions of which herbal configuration could be indicated by weight unit were analysed from 765 prescriptions of Taepyeonghyeminhwajegukbang, 350 prescriptions of Somunsunmyungronbang and 277 prescriptions of Nansilbijang. Results : If more than 80% similarity, it is considered similar prescription. Only 6 Prescriptions of Nansilbijang similar to Prescriptions of Taepyeonghyeminhwajegukbang. And 20 Prescriptions of Somunsunmyungronbang similar to Prescriptions of Taepyeonghyeminhwajegukbang. Conclusions : Configuration patterns of Somunsunmyungronbang and Nansilbijang are different from Taepyeonghyeminhwajegukbang. So We can prove that theory of Somunsunmyungronbang and Nansilbijang are different from Taepyeonghyeminhwajegukbang.