Browse > Article
http://dx.doi.org/10.3745/KIPSTD.2004.11D.4.775

A Conceptual Schema Integration through Extraction of Common Similar Subschemas : An Case Study of Multidatabase System  

Koh, Jae-jin (울산대학교 컴퓨터정보통신공학부)
Lee, Won-Jo (울산과학대학 컴퓨터정보학부)
Publication Information
The KIPS Transactions:PartD / v.11D, no.4, 2004 , pp. 775-782 More about this Journal
Abstract
Recently, most of global enterprises have geographically distributed organization, thus have distributed information systems which have distributed database systems. So, it is difficult for these systems to provide common views for the application programs of end users. One of solutions to solve these difficulties is an MDBS(Multidatabase System) A method to effectively implement MDBS is a schema integration. This paper proposes a methodology for a schema integration through extraction of common similar subschemas Our methodology is consisted of 5 phases : affinity analysis, extraction of similar subschemas, decision of imtegration order, resolution of semantic conflict, and schema integration. To verify the usability of our methodology, a case study is implemented with an object of MDBS. At a result, our approach can effectively be applied to the extraction of common similar subschemas and schema integration.
Keywords
Similar Subschemas; Multidatabase System; View; Affinity Analysis; Schema Integration;
Citations & Related Records
Times Cited By KSCI : 3  (Citation Analysis)
연도 인용수 순위
1 S. B. Navathe, R. Elmasri, J. Larson, 'Integrating User Views in Database Design,' IEEE Computer, Jan., 1986   DOI   ScienceOn
2 S. Castano, V. D. Antonellis, 'Semantic Dictionary Design for Database Interoperability,' ACM SIGSOFT, pp.43-54, 1996   DOI
3 S. B. Nabathe, R. Elmasri, J. Larson, 'Integration User Views in Database Design,' IEEE Computer, Jan., 1986
4 P. Martin, W. Powley, 'Database Integration using Multidatabase Views,' CASCON'93, pp.1-14, 1993
5 M. W. Bright, A. R. Hurson and S. Pakzad, 'Automated Resolution of Semantic Heterogeneity in Multidatabases,' ACM Transactions on Database System, Vol.19, No.2, pp.212-253, June, 1994   DOI   ScienceOn
6 S. B. Navathe, S. G. Gadqil, 'A Methodology for View Integration in Logical Database Design,' Proceedings of the International Conference on Very Large Data Bases, Mexico City, pp.142-164, September, 1982
7 I. Mirbel, 'Semantic integration of conceptual schemas,' Proceedings of the First International Workshop on Applications of Natural Language to Databases(NLDB'95)
8 R. Jakobovits, 'Integrating Autonomous Heterogeneous Information Sources,' University of Washington, July, 1997
9 이희석 외 3명, '의미객체 모델을 이용한 뷰통합 지원시스템 개발', 한국경영종보학회 학술대회논문집, pp.52-70, 1996
10 임병학, '의미객체 모델을 이용한 뷰통합 지원시스템 개발', 한국과학기술원 석사학위논문, 1996
11 신기태 외 3명, '제조 데이터베이스 설계에서의 뷰 통합 방안', 한국경영과학회논문지, 제11권 제3호, pp.668-670, 1994
12 이상태 외 1명, '객체-관계 데이터 모델을 토대로 한 다중 데이터베이스 시스템의 스키마 통합에 관한 연구', 한국멀티미디어학회 춘계학술대회논문집, pp.256-261, 1998   과학기술학회마을
13 김기중, '통합 데이터베이스를 위한 스키마 통합 방법', 정보통신학회논문지, 제6권 제2호, pp.1 13, 1998
14 김홍수, '참조 스키마 생성을 위한 개념적 스키마 분석', 한국OA학회논문지, 제7권 제4호, pp.83-88, 2002   과학기술학회마을
15 최태광 외 5명, '데이터 유사성 척도를 이용한 생산정보 데이터베이스의 분산 구조 설계', 대한산업공학회논문지, 제8권 제3호, pp.269-278, 1995
16 이원조 외 3명, '스키마 통합을 위한 시소러스의 활용 방안', 한국정보과학회 춘계학술대회, 제30권 제1호, pp.668-670   과학기술학회마을
17 이원조, '유사 서브스키마 추출을 통한 스키마 통합 방법론', 정보과학회전문대학논문지, 제11권 제2호, pp.151-160, 2003
18 S. Castano, V. D. Antonellis, M. G. Fugini and B. Pernici, 'Conceptual Schema Analysis : Techniques and Applications,' ACM Transactions on Database System, Vol.23, No.3, pp.286-333, September, 1998   DOI   ScienceOn
19 C. Batini, M. Lenzerini, S. B. Navathe, 'A Comparative Analysis of Methodologies for Database Schema Integration,' ACM Computing Surveys, Vol.18, No.4, December, 1986   DOI   ScienceOn
20 C. Batini, M. Lenzerini, 'A Methodology for Data Schema Integration in the Entity Relationship Model,' ACM Transactions on software engineering, Vol.SE-10, No.6, Nov., 1984