Clustering similar schema elements across heterogeneous databases: A first step in database integration

Advanced Topics in Database Research

Volumn 5, Issue , 2006, Pages 227-248

  Zhao, Huimin ^a   Ram, Sudha ^b  

^a UNIVERSITY OF WISCONSIN MILWAUKEE   (United States)

^b UNIVERSITY OF ARIZONA   (United States)

Author keywords

[No Author keywords available]

Indexed keywords

EID: 33947183147     PISSN: None     EISSN: None     Source Type: Book    
DOI: 10.4018/978-1-59140-935-9.ch013     Document Type: Chapter

References (42)

1. rd ed.). New York: Chapman & Hall.
2. Ambrosio, A. P., Métais, E., & Meunier, J. (1997). The linguistic level: Contribution for conceptual design, view integration, reuse and documentation. Data & Knowledge Engineering, 21(2), 111-129.
3. Benkley, S. S., Fandozzi, J. F., Housman, E. M., & Woodhouse, G. M. (1995). Data Element Tool-based Analysis (DELTA) (Tech. Rep. No. MTR 95B0000147). Bedford, MA: The MITRE Corporation.
4. Berlin, J., & Motro, A. (2002, May 27-31). Database schema matching using machine learning with feature selection. In Proceedings of the 14th International Conference on Advanced Information Systems Engineering, Toronto, Canada (LNCS 2348, pp. 452-466). Berlin; Heidelberg, Germany: Springer.
5. Bright, M. W., Hurson, A. R., & Pakzad, S. H. (1994). Automated resolution of semantic heterogeneity in multidatabases. ACM Transactions on Database Systems, 19(2), 212-253.
6. Clifton, C., Housman, E., & Rosenthal, A. (1997, October 7-10). Experience with a combined approach to attribute-matching across heterogeneous databases. In Proceedings of the 7th IFIP 2.6 Working Conference on Data Semantics (DS-7), Leysin, Switzerland (pp. 429-451). London: Chapmann and Hall.
7. Costa, J. A. F., & de Andrade Netto, M. L. (1999). Estimating the number of clusters in multivariate data by self-organizing maps. International Journal of Neural Systems, 9(3), 195-202.
8. Do, H., Melnik, S., & Rahm, E. (2002, October 7-10). Comparison of schema matching evaluations. In Proceedings of the 2nd International Workshop on Web Databases (German Informatics Society), Erfurt, Germany (LNCS 2593, pp. 221-237). London: Springer.
9. Doan, A., Domingos, P., & Halevy, A. (2003). Learning to match the schemas of databases: A multistrategy approach. Machine Learning, 50(3), 279-301.
10. Duwairi, R. M. (2004). Clustering semantically related classes in a heterogeneous multidatabase system. Information Sciences, 162(3-4), 193-210.
11. Ellmer, E., Huemer, C., Merkl, D., & Pernul, G. (1996, September 9-13). Automatic classification of semantic concepts in view specifications. In Proceedings of the 7th International Conference on Database and Expert Systems Applications, Zurich, Switzerland (LNCS 1134, pp. 824-833). New York: Springer-Verlag.
12. th ed.). Arnold; London: Oxford University Press.
13. Fan, W., Lu, H., Madnick, S. E. & Cheung, D. W. (2001). Discovering and reconciling value conflicts for numerical data integration. Information Systems, 26(8), 635-656.
14. Fan, W., Lu, H., Madnick, S. E., & Cheung, D. W. (2002). DIRECT: A system for mining data value conversion rules from disparate sources. Decision Support Systems, 34(1), 19-39.
15. Giunchiglia, F., & Yatskevich, M. (2004, November 8). Element level semantic matching. In Proceedings of Meaning Coordination and Negotiation Workshop at ISWC, Hiroshima, Japan (pp. 37-48).
16. Hansen, M., Madnick, S., & Siegel, M. (2002, May 28). Data integration using web services. In Proceedings of International Workshop on Data Integration over the Web, Toronto, Canada (pp. 3-16). Toronto, Canada: University of Toronto Press.
17. Hayne, S., & Ram, S. (1990, February 5-9). Multi-user view integration system (MUVIS): An expert system for view integration. In Proceedings of the Sixth International Conference on Data Engineering, Los Angeles, CA (pp. 402-410). Los Alamitos, CA: IEEE Computer Society Press.
18. Johannesson, P. (1997). Supporting schema integration by linguistic instruments. Data & Knowledge Engineering, 21(2), 165-182.
19. Kang, J., & Naughton, J. F. (2003, June 9-12). On schema matching with opaque column names and data values. In Proceedings of the ACM SIGMOD International Conference on Management of Data (SIGMOD), San Diego, CA (p. 205-216). New York: ACM Press.
20. rd ed.). Berlin: Springer.
21. Li, W. S., & Clifton, C. (2000). SEMINT: A tool for identifying attribute correspondences in heterogeneous databases using neural networks. Data & Knowledge Engineering, 33(1), 49-84.
22. Lu, H., Fan, W., Goh, C. H., Madnick, S. E., & Cheng, D. W. (1997, October 7-10). Discovering and reconciling semantic conflicts: A data mining perspective. In Proceedings of the 7th IFIP 2.6 Working Conference on Data Semantics (DS-7), Leysin, Switzerland (pp. 410-427). London: Chapmann and Hall.
23. Madhavan, J., Bernstein, P. A., & Rahm, E. (2001, September 11-14). Generic schema matching with Cupid. In Proceedings of the 27th International Conferences on Very Large Databases, Roma, Italy (pp. 49-58). San Francisco: Morgan Kaufmann.
24. Mangiameli, P., Chen, S. K., & West, D. (1996). A comparison of SOM neural network and hierarchical clustering methods. European Journal of Operational Research, 93(2), 402-417.
25. Masood, N. & Eaglestone, B. (1998, August 24-28). Semantics based schema analysis. In Proceedings of the 9th International Conference on Database and Expert Systems Applications, Vienna, Austria (pp. 80-89). London: Springer-Verlag.
26. Mirbel, I. (1997). Semantic integration of conceptual schemas. Data & Knowledge Engineering, 21(2), 183-195.
27. Navathe, S., Thomas, H., Satitsamitpong, M., & Datta, A. (2001, April 25-28). A model to support e-catalog integration. In Proceedings of the 9th IFIP 2.6 Working Conference on Database Semantics (DS-9), Hong Kong (pp. 247-261). Deventer, The Netherlands: Kluwer Academic Publisher.
28. Palopoli, L., Pontieri, L., Terracina, G., & Ursino, D. (2000). Intentional and extensional integration and abstraction of heterogeneous databases. Data & Knowledge Engineering, 35(3), 201-237.
29. Palopoli, L., Sacca, D., Terracina, G., & Ursino, D. (2003). Uniform techniques for deriving similarities of objects and subschemes in heterogeneous databases. IEEE Transactions on Knowledge and Data Engineering, 15(2), 271-294.
30. Petersohn, H. (1998). Assessment of cluster analysis and self-organizing maps. International Journal of Uncertainty, Fuzziness and Knowledge-Based Systems, 6(2), 136-149.
31. Rahm, E., & Bernstein, P. A. (2001). A survey of approaches to automatic schema matching. The VLDB Journal, 10, 334-350.
32. Ram, S., Park, J., Kim, K., & Hwang, Y. (1999, December 11-12). A comprehensive framework for classifying data- and schema-level semantic conflicts in geographic and non-geographic databases. In Proceedings of the 9th Annual Workshop on Information Technologies and Systems, Charlotte, NC (pp. 185-190).
33. Ram, S., & Venkataraman, R. (1999). Schema integration: past, present and future. In: A. Elmagarmid, M. Rusinkiewicz, & A. Sheth (Eds.), Management of heterogeneous and autonomous database system (pp. 119-156). San Francisco: Morgan Kaufmann.
34. Ram, S., & Zhao, H. (2001, December 15-16). Detecting both schema-level and instance-level correspondences for the integration of e-catalogs. In Proceedings of the 11th Annual Workshop on Information Technology and Systems, New Orleans, LA (pp. 193-198).
35. Rodríguez, M. A., Egenhofer, M. J., & Rugg, R. D. (1999, March 10-12). Assessing semantic similarities among geospatial feature class definitions. In Proceedings of the 2nd International Conference on Interoperating Geographic Information Systems, Zürich, Switzerland (pp. 189-202). New York: Springer-Verlag.
36. Seligman, L., Rosenthal, A., Lehner, P., & Smith, A. (2002). Data integration: Where does the time go? IEEE Data Engineering Bulletin, 25(3), 3-10.
37. Song, W. W., Johannesson, P., & Bubenko, J. A. (1996). Semantic similarity relations and computation in schema integration. Data & Knowledge Engineering, 19(1), 65-97.
38. Srinivasan, U., Ngu, A. H. H., & Gedeon, T. (2000). Managing heterogeneous information systems through discovery and retrieval of generic concepts. Journal of the American Society for Information Science, 51(8), 707-723.
39. Stephen, G. A. (1994). String searching algorithms. Singapore: World Scientific Publishing Co. Pte. Ltd.
40. Zhao, H. (2005). Semantic matching across heterogeneous data sources. Communications of the ACM, forthcoming.
41. Zhao, H., & Ram, S. (2004). Clustering schema elements for semantic integration of heterogeneous data sources. Journal of Database Management, 15(4), 88-106.
42. Zhao, H., & Ram, S. (2005). Entity identification for heterogeneous database integration - A multiple classifier system approach and empirical evaluation. Information Systems, 30(2), 119-132.