• The KIPS Transactions:PartD
• /
• v.11D no.3
• /
• pp.553-562
• /
• 2004

This paper constructs ERD thesaurus that is storing information about Entity Relationship Diagram(ERD), and proposes an ERD thesaurus-based methodology for view integration in an important conceptual design step in designing databases. To show the usefulness of proposed methodology, the prototype for view integration support system is implemented for the applied case. As a result, ERD thesaurus-based methodology is more effective than the existing methodologies for view Integration in the aspects of affinity analysis, semantic conflicts resolution, and view Integration processes. Therefore, our methodology is expected to be utilized in integrating the existing fragmented schema or designing a large database integration.

• Journal of Korean Library and Information Science Society
• /
• v.41 no.3
• /
• pp.269-290
• /
• 2010

Applying one specific thesaurus might cause several problems because each thesaurus has its own characteristics inherited from its construction process. Therefore, integration of thesauri can be an appropriate approach to overcome the difficulties. This current research selected physics as a domain and two thesauri in the domain: PACS and PIRA. By integrating these two heterogeneous thesauri, this research could construct a conceptual structure that covers the whole concepts related to physics. By constructing the conceptual structure with the use of facet analysis from integrated thesaurus, it provides knowledge base with hierarchical structure and clear relationships between concepts. It can be an alternate approach to effective and efficient information retrieval and knowledge discovery.

• Proceedings of the Korean Information Science Society Conference
• /
• 2003.04a
• /
• pp.668-670
• /
• 2003

최근 정보기술의 급속한 발달로 기존 정보시스템의 확장을 위한 데이터베이스 재설계에 대한 사용자들의 요구에 직면해 있다. 그러나 기존 데이터베이스 시스템은 다중 서버에 분산되어 있거나, 규모가 방대하여 확장을 위한 재설계에 많은 비용을 지불하고 있다. 따라서 기존 데이터베이스에서 서브스키마들의 정보를 추출하고, 이들간의 유사성 분석을 통하여 의미충돌을 해결하는 통합 방법을 적용하고 있는데, 본 연구에서는 이를 지원하기 위한 서브스키마의 유사성 분석을 위한 시소러스의 활용 방안을 제시한다.

• Journal of Navigation and Port Research
• /
• v.29 no.10 s.106
• /
• pp.883-890
• /
• 2005

Database Integration problems has been recognized as a critical issue for effective logistics service in logistics environment. However, researches related to effective methodology for this have been studied theoretically in the DB schema integration, are insufficient in the side of the system realization. The aim of this paper is to present a schema integration technique to integrate DB using XML( eXtensible Markup Language) in the part of practical DB integration, a quantitative methodology for the identification of conflict that is a representative problem on database integration. To achieve this aim, we extracted the entity name and attribute name from DB schema and suggested a quantitative methodology to easily fine name conflict that frequently give raise to a trouble when schema integration, based on the level of semantic similarity between attributes and entities.

• Proceedings of the Korean Institute of Navigation and Port Research Conference
• /
• 2005.10a
• /
• pp.353-360
• /
• 2005

Database Integration problems has been recognized as a critical issue for effective logistics service in logistics environment. However, researches related to effective methodology for this have been studied theoretically in the DB schema integration, are insufficient in the side of the system realization. The aim of this paper is to present a schema integration technique to integrate DB using XML(eXtensible Markup Language) in the part of practical DB integration, a quantitative methodology for the identification of conflict that is a representative problem on database integration. To achieve this aim, we extracted the entity name and attribute name from DB schema and suggested a quantitative methodology to easily fine name conflict that frequently give raise to a trouble when schema integration, based on the level of semantic similarity between attributes and entities.

• Journal of Information Management
• /
• v.32 no.2
• /
• pp.26-39
• /
• 2001

Various controlled vocabularies such as thesaurus and classification used for effective information retrieval contain different terms in expressing the same concept or meaning. National Library of Medicine has developed the Unified Medical Language System(UMLS) to solve the problems of information retrieval and integration resulted from the difference of concepts between different sources. The UMLS development was initiated in 1982 as a long-term project, and the 2001 edition of the UMLS consists of three parts : Metathesaurus, Semantic Network, and SPECIALIST Lexicon. This paper reviews background and structure of the UMLS including applications in PubMed, NLM Gateway.

• Journal of Navigation and Port Research
• /
• v.29 no.5 s.101
• /
• pp.457-464
• /
• 2005

Database integration has been recognized as a critical issue for effective logistics service in logistics environment. However, research related to effective methodology for this have been little studied, and also, prominent achievements have yet to be suggested. The aim of this paper is to present a quantitative methodology for the identification of conflict that is a representative problem on database integration. To achieve this aim, we suggested a quantitative methodology that can efficiently fine troubles such as name conflicts when schema integration, based on the level of semantic similarity between attributes and entities. And, in order to measure these semantic similarities, we used a thesaurus dictionary that proposed previous research. Finally, we presented effectiveness of the proposed methodology through some typical examples.

• Proceedings of the Korean Information Science Society Conference
• /
• 2001.10a
• /
• pp.331-333
• /
• 2001

분산되고 이질적인 환경에서의 정보 소스들을 통합하려는 노력은 끊임 없이 계속되어 왔다. 이질적인 다중 정보소스로부터 추출된 정보를 통합하는 도구를 개발하는 것은 인터넷 기반에서 다양한 정보들을 실시간으로 사용할 수 있다는 측면에서 아주 흥미로운 일이다. 이러한 도구를 개발하는데 있어서의 주된 문제점은 서로 다른 정보소스에 존재하지만 실제적으로는 같은 실세계의 개념을 가지고 있는 정보를 어떻게 효과적으로 표현할 것인가 하는 것이다. 이러한 의미적 이질성을 해결하기 위해서 WordNet이나 Common Thesaurus 등을 이용한 개념 기반의 접근방법이 많이 제안되었다. 하지만 이들은 스키마 이질성을 해결하는 방법을 제시 할 뿐, 데이터의 이질성을 해결 하는 방법은 보여주지 않는다. 본 논문에서는 GSN(Global Semantic Network)을 이용해서 스키마 이질성을 해결해야 데이터베이스 시스템에서 발생하는 데이터 이질성의 예를 제시하고 이러한 데이터 이질성을 해결할 수 있는 기법을 제안한다.