Journal of Information Technology Services (한국IT서비스학회지)

Korea Society of IT Services (한국IT서비스학회)
권호 표지

A Study on the Method for Solving Data Heterogeneity in the Integrated Information System

통합 정보시스템에서의 데이터 이질성 해결 방안에 관한 연구

  • 박성진 (한신대학교 컴퓨터공학부) ;
  • 박성공 (고려대학교 대학원 컴퓨터학과) ;
  • 박화규 (순천향대학교 보건행정학과)
  • Published : 2008.12.31
Download PDF
⟨ Previous Next ⟩

Abstract

As the technologies for telecommunication have been evolving, more enhanced information services and integrated information systems have been introduced, which can manage a variety of information from the heterogeneous systems. The major obstacle for the integrated information systems is the integrating heterogeneous databases in the systems and the heterogeneity problems can be classified into the structural and data heterogeneities. However, the previous researches have mainly highlighted into the solving structural heterogeneity problems. This paper identifies the data heterogeneity problems for multi-database schema integrations and proposes a new solving method. We analyze the semantics equivalence in data values based on the functional dependency, primary and candidate keys, and present a procedural solution of data heterogeneity in the perspective of the concept of attribute equivalence, integration key and conceptual integration table.

Keywords

References

  1. Won Kim and Jungyun Seo, "Classifying Schematic and Data Heterogeneity in Multidatabase Systems", IEEE Computer, Vol. 24, No.2(1991), pp.12-18
  2. Litwin, W., "MSQL：A Multidatabase Language", Information Science, 1989
  3. Lifer Michael, Kim Won and Sagiv Yehoshua, "Querying Object-Oriented Databases", ACM SIGMOD, Vol.21, No.2(1992), pp.393-402
  4. Frederic Gingras and Laks V. S. Lakshmanan, "nD-SQL：A Multi-dimensional Language for Interoperability and OLAP", Proceedings of the 21th VLDB Conference, 1998, pp.134-145
  5. Soon M. Chung and Pyeong S. Mah, "Schema Integration for Multidatabases Using the Unified Relational and Object-Oriented Model", Proceedings of the 23rd ACM Annual Conference, 1995, pp.208-215
  6. Cheng Hian Goh, Stephane Bressan, Stuart Madnick, and Michael Siegel, "Context Interchange： New Features and Formalism for the Intelligent Integration of Information", ACM Transactions on Information Systems, Vol.17, No.3(1999), pp.270-293 https://doi.org/10.1145/314516.314520
  7. Adam Farquhar, Richard Fikes, Wnada Pratt, and James Rice, "Collaborative Ontology Construction for Information Integration", Technical Report, Dept. of Computer Science, Stanford University, Knowledge Systems Laboratory, 1995
  8. Ramez Elamsri and Shamkant B. Navathe, Fundamentals of Database Systems, Benjaming/ Cummings, 1994
  9. Vipul Kashyap and Amit Sheth, "Semantic and Schematic Similarities between Database Objects：A Context-based approach", VLDB Journals, Vol.5, No.4(1996), pp.276-304 https://doi.org/10.1007/s007780050029
  10. Silvana Castano, Valeria De Antonellis, and Sabrina De Capitani di Vimercati, "Global Viewing of Heterogeneous Data Sources", IEEE Transactions on Knowledge and Data Engineering, Vol.13, No.2(2001), pp.277-297 https://doi.org/10.1109/69.917566
  11. Marek Rusunkiewicz, Amit Sheth, and George Karabatis, "Specifying Interdatabase Dependencies in a Multidatabase Environment", IEEE Computer, Vol.24, No.12(1991), pp.46-53 https://doi.org/10.1109/2.116888
  12. Laks V. S. Lakshmanan, Feredoon Sadri, and Iyer N. Subramanian, "Logic and Algebraic Language for Interoperability in Multidatabase Systems", Journal of Logic Programming, Vol.33, No.2(1997), pp.101-149 https://doi.org/10.1016/S0743-1066(96)00146-X