Browse > Article
http://dx.doi.org/10.3745/KIPSTD.2003.10D.2.233

Design and Implementation of A Distributed Information Integration System based on Metadata Registry  

Kim, Jong-Hwan (고려대학교 대학원 컴퓨터학과)
Park, Hea-Sook (고려대학교 대학원 컴퓨터학과)
Moon, Chang-Joo (고려대학교 대학원 컴퓨터학과)
Baik, Doo-Kwon (고려대학교 컴퓨터학과)
Publication Information
The KIPS Transactions:PartD / v.10D, no.2, 2003 , pp. 233-246 More about this Journal
Abstract
The mediator-based system integrates heterogeneous information systems with the flexible manner. But it does not give much attention on the query optimization issues, especially for the query reusing. The other thing is that it does not use standardized metadata for schema matching. To improve this two issues, we propose mediator-based Distributed Information Integration System (DIIS) which uses query caching regarding performance and uses ISO/IEC 11179 metadata registry in terms of standardization. The DIIS is designed to provide decision-making support, which logically integrates the distributed heterogeneous business information systems based on the Web environment. We designed the system in the aspect of three-layer expression formula architecture using the layered pattern to improve the system reusability and to facilitate the system maintenance. The functionality and flow of core components of three-layer architecture are expressed in terms of process line diagrams and assembly line diagrams of Eriksson Penker Extension Model (EPEM), a methodology of an extension of UML. For the implementation, Supply Chain Management (SCM) domain is used. And we used the Web-based environment for user interface. The DIIS supports functions of query caching and query reusability through Query Function Manager (QFM) and Query Function Repository (QFR) such that it enhances the query processing speed and query reusability by caching the frequently used queries and optimizing the query cost. The DIIS solves the diverse heterogeneity problems by mapping MetaData Registry (MDR) based on ISO/IEC 11179 and Schema Repository (SCR).
Keywords
Database; Distributed Information Integration System; Meta-data Registry; Schema Repository; Heterogeneity; Query Function Repository; EPEM; SCM; Query Caching; Query Reusability;
Citations & Related Records
Times Cited By KSCI : 1  (Citation Analysis)
연도 인용수 순위
1 이정욱, '멀티데이터베이스 시스템의 정보공유를 위한 개념 기반 의미망', 고려대학교 대학원 컴퓨터학과 박사학위논문, 2001
2 ISO, Metadata Registry, ISO-11179, 2000
3 송치양, 임성빈, 백두권, 김철홍, '컴포넌트 유통환경을 위한 컴포넌트 메타데이타 레지스트리 구축 : C_MDR', 정보과학회지, 제7권 제6호, 한국정보과학회, pp.614-629, 2001   과학기술학회마을
4 Gamma, Erich, Richard, Helm, Ralph Johnson, John Vlisicles, 'Design Patterns,' Addison-Wesley, 1995
5 F. Buschmann, R. Meunier, H. Rohnert, P. Sommerlad, M. Stal, 'Pattern-Oriented Software Architecture - A System of Patterns,' John Wiley & Sons, Inc., 1996
6 Hans-Erik Eriksson and Magnus Penker, 'Enterprise Java with UML,' John Wiley & Sons, Inc., 2000
7 후쿠시마 요시아키, 'SCM 경영혁명', 21세기 북스, 1998
8 ECR Korea, available online at : http://scm.eankorea.or. kr/, 2002
9 황종선, 윤영식, 'C 언어로 설명한 알고리즘', 정익사, 1996
10 S. Busse, R. D. Kutsche, U. Leser, H. Weber, 'Federated Information Systems : concepts, terminology and architectures,' Technical Report Nr.99-9, TU Berlin, 1999
11 C. Batini, M. Lenzerini, S. B. Navathe, 'A Comparative Analysis of Methodologies for Database Schema Integration,' ACM Computing Surveys, Vol.18, No.4, pp.323-364, 1986   DOI   ScienceOn
12 G. Wiederhold, 'Intelligent Integration of Information,' ACM SIGMOD Record, Vol.22, No.2, pp.434-437, Jun., 1993   DOI   ScienceOn
13 A. P. Sheth and J. A. Larson, 'Federated Database Systems for managing Distributed Heterogeneous and Autonomous Database,' ACM Computing Surveys, Vol.22, No. 3, pp.183-236, 1990   DOI
14 Hans-Erik Eriksson and Magnus Penker, 'Business Modeling with UML,' OMG Press, 2000
15 Hea-Sook Park, Jong Hwan Kim, Doo-Kwon Baik, 'Componet-based Modeling and Verification of an Information Retrieval System using EPEM,' Proceedings of The 4th ICACT, pp.821-826, Feb., 2002
16 류근호, '생물다양성 정보의 투명한 접근을 위한 데이터베이스 분산 통합 방안', 한림 심포지움, 한국과학기술한림원, 2002
17 Uified Modeling Language Resoure Center, available online at : http://www.rational.com/uml/, 2002
18 E. Kilic, G. et al, 'Experiences in using CORBA for a Multidatabase Implementation,' 6th International Conference in Database, 1995
19 W. Litwin and A. Abdellatif, 'Multidatabase Interoperability,' 1986
20 A. P. Sheth, J A. Larson, 'Federated Database System for Managing Distributed, Heterogeneous, and Autonomous Databases,' ACM Computing Surveys, Vol.22, No.3, pp.183-236, Sept., 1990   DOI