Visualization and Integration of Databases using Self-Organizing Map

被引:2
|
作者
Bourennani, Farid [1 ]
Pu, Ken Q. [1 ]
Zhu, Ying [1 ]
机构
[1] Univ Ontario, Inst Technol, Toronto, ON, Canada
来源
2009 FIRST INTERNATIONAL CONFERENCE ON ADVANCES IN DATABASES, KNOWLEDGE, AND DATA APPLICATIONS | 2009年
关键词
SOM; Common Item Based Classifier (CIBC); Data Integration; Information Retrieval (IR);
D O I
10.1109/DBKDA.2009.30
中图分类号
TP [自动化技术、计算机技术];
学科分类号
0812 ;
摘要
With the growing computer networks, accessible data is becoming increasingly distributed. Understanding and integrating remote and unfamiliar data sources are important data management issues. In this paper, we propose to utilize self-organizing maps (SOM) clustering to aid with the visualization of similar columns, and integration of relational database tables and attributes based on the content. In order to accommodate heterogeneous data types found in relational databases, we extended the TFIDF measure to handle, in addition to text, numerical attribute types for coincident meaning extraction. We present a SOM clustering based visualization algorithm allowing the user to browse the heterogeneously typed database attributes and discover semantically similar clusters. Additionally, we propose a new algorithm Common Item Based Classifier (CIBC) to smoothen the homogeneity of the clusters obtained by SOM. The discovered semantic clusters can significantly aid in manual or automated constructions of data integrity constraints in data cleaning or schema mappings in data integration.
引用
收藏
页码:155 / 160
页数:6
相关论文
共 50 条
  • [21] The Forbidden Region Self-Organizing Map Neural Network
    Diaz Ramos, Antonio
    Lopez-Rubio, Ezequiel
    Palomo, Esteban J.
    IEEE TRANSACTIONS ON NEURAL NETWORKS AND LEARNING SYSTEMS, 2020, 31 (01) : 201 - 211
  • [22] Learning a Self-organizing Map Model on a Riemannian Manifold
    Yu, D. J.
    Hancock, E. R.
    Smith, W. A. P.
    MATHEMATICS OF SURFACES XIII, 2009, 5654 : 375 - +
  • [23] Pruning a classifier based on a self-organizing map using Boolean function formalization
    Lobo, VJ
    Swiniarski, R
    Moura-Pires, F
    IEEE WORLD CONGRESS ON COMPUTATIONAL INTELLIGENCE, 1998, : 1910 - 1915
  • [24] Strategy Analysis of Multi-Agent Games Using Self-Organizing Map
    Tominaga, Moeko
    Takemura, Yasunori
    Ishii, Kazuo
    ICAROB 2018: PROCEEDINGS OF THE 2018 INTERNATIONAL CONFERENCE ON ARTIFICIAL LIFE AND ROBOTICS, 2018, : 757 - 760
  • [25] Analysis of Team Relationship using Self-Organizing Map for University Volleyball Players
    Takemura, Yasunori
    Oda, Kazuya
    Ono, Michiyoshi
    JOURNAL OF ROBOTICS NETWORKING AND ARTIFICIAL LIFE, 2018, 5 (03): : 199 - 203
  • [26] Analysis of Seismic Activity Using Self-Organizing Map: Implications for Earthquake Prediction
    Ida, Yoshiaki
    Ishida, Mizuho
    PURE AND APPLIED GEOPHYSICS, 2022, 179 (01) : 1 - 9
  • [27] IDENTIFICATION OF ATTRACTING ATTENTION IN THAI HANDICRAFT PRODUCTS USING SELF-ORGANIZING MAP
    Jinsakul, Natinai
    Tsai, Cheng-Fa
    PROCEEDINGS OF 2018 INTERNATIONAL CONFERENCE ON MACHINE LEARNING AND CYBERNETICS (ICMLC), VOL 2, 2018, : 444 - 449
  • [28] Efficient Self-Organizing Map Learning Scheme Using Data Reduction Preprocessing
    Xu, Yang
    Chow, Tommy W. S.
    WORLD CONGRESS ON ENGINEERING, WCE 2010, VOL I, 2010, : 273 - 276
  • [29] Clustering Hierarchical Data Using Self-Organizing Map: A Graph-Theoretical Approach
    Argyrou, Argyris
    ADVANCES IN SELF-ORGANIZING MAPS, PROCEEDINGS, 2009, 5629 : 19 - 27
  • [30] Hardware Self-Organizing Map With Dithered Step Neighborhood Function
    Hikawa, Hiroomi
    IEEE TRANSACTIONS ON CIRCUITS AND SYSTEMS I-REGULAR PAPERS, 2025,