Semantic Correspondence of Database Schema from Heterogeneous Databases using Self-Organizing Map
0
조회
0
다운로드
0
인용
0
참고문헌
키워드
초록
This paper provides a framework for semantic correspondence of heterogeneous databases using self- organizing map. It solves the problem of overlapping between different databases due to their different schemas. Clustering technique using self-organizing maps (SOM) is tested and evaluated to assess its performance when using different kinds of data. Preprocessing of database is performed prior to clustering using edit distance algorithm, principal component analysis (PCA), and normalization function to identify the features necessary for clustering.
Abstract
This paper provides a framework for semantic correspondence of heterogeneous databases using self- organizing map. It solves the problem of overlapping between different databases due to their different schemas. Clustering technique using self-organizing maps (SOM) is tested and evaluated to assess its performance when using different kinds of data. Preprocessing of database is performed prior to clustering using edit distance algorithm, principal component analysis (PCA), and normalization function to identify the features necessary for clustering.
참고문헌 (16)
- C. Batini, "A comparative analysis of methodologies for database schema integration", pp.323~364 (1986), ACM Computing Surveys
- S. Ram, "Detecting both schema- level and instance- level correspondences for integration of E-catalogs", Proceedings of the Eleventh Annual Workshop on Information Technology and Systems (WITS’01), New Orleans, Louisiana, USA, pp.193~198 (2001)
- T.W. Ryu, "A database clustering methodology and tool", Information Sciences, 171, pp.29~59 (2005)
- D. Heimbigner, "A federated architecture for information management", ACM Transactions on Office Information Systems, 3(3), pp.253~278 (1985)
- H. Zhao, "Combining Sschema and Instance Information for Integrating Hererogeneous Data Sources", Data and Knowledge Engineering Science Direct, 61, pp.281~303 (2007)
- S. Theodoridis, "Pattern Recognition, 3rd edition", pp.102~ (2006), Elsevier USA
- H. Zhao, "Clustering Schema Elements for Semantic Integration of Heterogeneous Data Sources", Journal of Database Management, 15, pp.88~106 (2004)
- Learning String Edit Distance, "E.S. Ristad", Department of Computer Science, Princeton University, ~, pp.Research Report CS-TR-532-96 (1997)
- P. Hall, "Approximate String Matching", Computing Surveys, 12(4), pp.381~402 (1980)
- E. Ellmer, "Automatic Classification of semantic concepts in view specifications , in Database and Expert Systems Applications", Proceedings of 7th International Conference, DEXA, pp.824~833 (1996)
- W.S. Li, "SEMINT: A tool for identifying attributer correspondence in heterogeneous databases using neural networks, vol. 33", pp.49~84 (2000), Elsevier
- U. Srinivasan, "Managing heterogeneous information systems through discovery and retrieval of generic concepts", Journal of American Society for Information Science, 51(8), pp.707~723 (2000)
- J. Shlens, "A Tutorial on Principal Component Analysis ,March", March, ~ (2003)
- L. I. Smith, "Tutorial on Principal Component Analysis", ~ (2002)
- A.A. Afifi, "Computer Aided Multivariate Analysis (3rd)" (1996), Chapman & Hall
- Clementine Reference Manual Version 5, "Integral Solutions Limited", ~ (1995)