• Journal of the Korea Society of Computer and Information
• /
• v.24 no.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.

• Journal of Information Processing Systems
• /
• v.15 no.5
• /
• pp.1055-1067
• /
• 2019

In view of the deficiencies of existing weighted similarity indexes, a hierarchical clustering method initialize-expand-merge (IEM) is proposed based on the similarity of common neighbors for community discovery in weighted networks. Firstly, the similarity of the node pair is defined based on the attributes of their common neighbors. Secondly, the most closely related nodes are fast clustered according to their similarity to form initial communities and expand the communities. Finally, communities are merged through maximizing the modularity so as to optimize division results. Experiments are carried out on many weighted networks, which have verified the effectiveness of the proposed algorithm. And results show that IEM is superior to weighted common neighbor (CN), weighted Adamic-Adar (AA) and weighted resources allocation (RA) when using the weighted modularity as evaluation index. Moreover, the proposed algorithm can achieve more reasonable community division for weighted networks compared with cluster-recluster-merge-algorithm (CRMA) algorithm.

• Journal of Agricultural Extension & Community Development
• /
• v.30 no.2
• /
• pp.103-118
• /
• 2023

This study aims to develop the living SOC function index and classified classes using the GIS-based spatial analysis method by applying the "Central Place Theory" as basic data for classifying living areas necessary for establishing rural spatial strategies in Boryeong. Boryeong-si is classified as a southern living area in the northern living area, centering on Daecheon-dong, the first class, and it is analyzed that living services such as used car service procurement and education are needed, and the southern living area needs a mid- and high-vehicle service delivery system in Ungcheon-eup. It is believed that this study can provide important clues to the classification of central functional facilities suitable for rural centers, reinforcement of vulnerable functional facilities by living area, and provision of living services.

• Journal of the Korea Academia-Industrial cooperation Society
• /
• v.18 no.12
• /
• pp.744-754
• /
• 2017

In this study, an analytic hierarchy process (AHP) was conducted with the aim of developing a post-disaster refugee housing performance index system (PPS) to improve the post-disaster refugee housing (PRH) performance criteria for the foundation of quality-based development. The PRH was defined as a mid-term temporary housing facility that is used for a certain period before the permanent housing is established. The safety, rapidity, reusability, habitability, and economy were derived from major performance factors through prior research. A hierarchical PPS was organized by linking the major performance factors with the whole life cycle process of PRH. The priority of each performance index of PPS was determined quantitatively using the analytic hierarchy process through an expert survey. Based on AHP analysis, the performance criterion of the total weight 1-10 ranking and the performance criterion of the first rank in each category were classified into the essential performance criterion (must be achieved) and the others were classified into the recommended performance criterion (optional achieved) and the performance index was constructed considering all stages of PRH development. With the completion of the PRH performance index, it is expected that victims will be able to secure stable residence and return to their daily lives quickly.

• Journal of Korean Academy of Fundamentals of Nursing
• /
• v.19 no.1
• /
• pp.6-15
• /
• 2012

Purpose: The purposes of this study were to identify the level of health literacy and to determine its impact on disease-related knowledge and adherence to self-care in adults with hypertension. Methods: This was a cross-sectional, descriptive study in which patients with hypertension were recruited from outpatient hypertension clinics in Seoul, Korea from December, 2009 to February, 2010. A total 186 patients completed series of questionnaires to assess health literacy, disease-related knowledge, and adherence to self-care. Hierarchical linear regression was used to determine whether health literacy was associated with disease-related knowledge and adherence to self-care. Results: Seventy-one (38.2%) and seventy-two (38.7%) patients had inadequate and marginal health literacy, respectively. In hierarchical linear regression, health literacy independently predicted disease-related knowledge (${\beta}$= .43, p < .001) and adherence to self-care (${\beta}$= .37, p < .001) after controlling for age, education level, having a job or not, and body mass index. Conclusion: These findings show that health care providers need to pay attention to patients with hypertension who have inadequate health literacy. Further, it is recommended to develop and implement new strategies for assessing health literacy in clinical practices. Interventions to improve health literacy could promote disease-related knowledge and adherence to self-care in patients with hypertension.

• The Journal of the Korea Contents Association
• /
• v.11 no.4
• /
• pp.440-447
• /
• 2011

Selecting a suitable place is to determine the attributive conditions and qualified areas for the aim as factors and is to be fulfilled systematically for selecting the area which satisfies all these. This research tries to achieve a rational suitability analysis of residential development using the GIS modeling method and the hierarchical analysis process. A spatial and attributive analysis has been systematized for selecting a suitable place for the study and GIS analysis model has been used for the effective conclusion drawing for different levels. As a next step, a quantitative and qualitative evaluation index was created through complex consideration of the criteria and decision factors of the location selection, and weights were added depending on the relative importance of these factors. In particular, 3D terrain model simulation method has been used in order to reflect the aesthetic factors of the scenery which is an element of the subjective evaluation factors and considered qualitative and subjective evaluation factors which were not considered for the existing AHP technique. After the research, a location that satisfies complex requirements was found rapidly and accurately through the GIS model and hierarchical analysis.

• Journal of the Korean Society for information Management
• /
• v.32 no.3
• /
• pp.221-236
• /
• 2015

The purpose of this study is to analyze the research fields constituting the knowledge structure of the Korean Studies by applying hierarchical clustering method to domestic journal papers in Korean Studies. We analyzed 3,800 papers containing Korean author keyword that were listed in 14 kinds of Korean Studies journals published in 2004-2013, which have average impact factor more than 0.5 in 2011-2013. The results of the analysis show that the central research fields are the subjects related to political & social problems based on Confucian ideas focusing on Neo-Confucianism (Seonglihak) and Realist School of Confucianism (Silhak), to the political situation associated with territorial division of the Korean peninsula, and to the history from the period of japanese colonialism to modern and contemporary. It has been also found that the temporal backgrounds of researches in domestic Korean Studies were related to the modern times and the Joseon Dynasty periods, rather than the time of the ancient and contemporary.

• Journal of Korea Multimedia Society
• /
• v.1 no.1
• /
• pp.1-17
• /
• 1998

Video information is an important component of multimedia systems such as Digital Library, World-Wide Web (WWW), and Video-On-Demand (VOD) service system. Video information has hierarchical document structure inherently, so it is named "structure video document" in this paper. This paper proposes a data model, a query language, and an indexing scheme for structured video documents in order to store, retrieve, and share video documents efficiently. In representing structured video documents, the object-oriented data modeling technique is used since the hierarchical structure information can be modeled as complex objects. We also define object types for the structure information. Our query language supports not only content-based retrieval, which means the queries based on the structure of video documents, and spatial/temporal relation for video documents. In order to perform structure queries efficiently, as well as to reduce the storage overhead of indices, an optimized inverted index structure is proposed.

• Journal of The Korean Digital Architecture Interior Association
• /
• v.12 no.4
• /
• pp.49-57
• /
• 2012

With regard to the culture in cities this study aims to essential understanding and systematic approach to the culture. The "2011 Seoul Survey"report has been used to find out causality among the related variables. In the first place 'satisfaction of cultural condition' was operationally selected as a dependent variable for regression. For the purpose of controlling confounding factors for ceteris paribus effect correlation analysis was done between the dependent variable and all other variables respectively, which resulted in two groups of variables: group (1) - 6 variables of very significant correlations(p-value<0.01) and (2) - the other 6 variables of significant correlations(p-value<0.05). Then hierarchical regression was adopted to these 2 groups to analyse $R^2$ increment, statistical significance of independent variables, and multicollinearity(VIF; variance inflation factor). At last a regression model specified by group (1) as independent variables(they are 'social trust', 'satisfaction of walking condition', 'happiness index', 'preparation against old age', 'satisfaction of traffic condition' and 'hours for internet') shows that only 'social trust' variable has statistically significant and substantially strong effect on 'satisfaction of cultural condition.' This finding should be accepted on the following understanding; (1) urban culture has a collective attribute formed between people and society, (2) culture is somewhat telling and hearing stories and the confidence between tellers and hearers is essential in the mutual response and (3) stimulus is received by relationship in company with sense, emotion, thinking and action. In spite of restrictive external validity this finding can be used as a direction for promoting culture and a basis for related policy choice in cities.

• Journal of Korean Academy of Nursing
• /
• v.38 no.6
• /
• pp.866-873
• /
• 2008

Purpose: The study was done to compare quality of life by gender, and to identify factors which explain quality of life in individuals with coronary artery disease. Methods: For the survey, 91 individuals (53 men and 38 women) agreed to participate in the study. Cardiovascular risk factors, systolic blood pressure, body mass index, total cholesterol, triglyceride, high density lipoprotein-cholesterol, and low density lipoprotein-cholesterol, health behavior as well as quality of life, were measured. Descriptive statistics, t-test, correlation and hierarchical multiple regression with SPSS WIN 12.0 were used to analyze the data. Results: Significant gender differences were found for education, smoking status, chronic disease, perceived health status, and quality of life within sub-dimensions. Hierarchical regression analysis showed gender (men), age, perceived health status, cardiovascular risk scores, and health behaviors together explained 40.2% (adjusted $R^2$) of variance in quality of life. Conclusion: As the factors explaining quality of me in individuals with coronary artery disease have been identified as gender (men), age, perceived health status, and health behaviors, health promotion programs designed for this population should focus on these factors for effective behavioral modification, and consequent improvement in quality of life.