Holistic Schema Matching for Web Query Interfaces

  • Weifeng Su
  • Jiying Wang
  • Frederick Lochovsky
Part of the Lecture Notes in Computer Science book series (LNCS, volume 3896)


One significant part of today’s Web is Web databases, which can dynamically provide information in response to user queries. To help users submit queries to different Web databases, the query interface matching problem needs to be addressed. To solve this problem, we propose a new complex schema matching approach, Holistic Schema Matching (HSM). By examining the query interfaces of real Web databases, we observe that attribute matchings can be discovered from attribute-occurrence patterns. For example, First Name often appears together with Last Name while it is rarely co-present with Author in the Books domain. Thus, we design a count-based greedy algorithm to identify which attributes are more likely to be matched in the query interfaces. In particular, HSM can identify both simple matching i.e., 1:1 matching, and complex matching, i.e., 1:n or m:n matching, between attributes. Our experiments show that HSM can discover both simple and complex matchings accurately and efficiently on real data sets.


Schema Match Parallel Schema Query Interface Input Schema Holistic Schema 
These keywords were added by machine and not by the authors. This process is experimental and the keywords may be updated as the learning algorithm improves.


Unable to display preview. Download preview PDF.

Unable to display preview. Download preview PDF.


  1. 1.
    Bergman, M.K.: Surfacing hidden value (December 2000),
  2. 2.
    Bilke, A., Naumann, F.: Schema matching using duplicates. In: 21st Int. Conf. on Data Engineering, pp. 69–80 (2005)Google Scholar
  3. 3.
    Chang, K.C.-C., He, B., Li, C., Zhang, Z.: Structured databases on the Web: Observations and implications. Technical Report UIUCDCS-R-2003-2321, CS Department, University of Illinois at Urbana-Champaign (February 2003)Google Scholar
  4. 4.
    Chang, K.C.-C., He, B., Li, C., Zhang, Z.: The UIUC Web integration repository. Computer Science Department, University of Illinois at Urbana-Champaign (2003),
  5. 5.
    Dhamankar, R., Lee, Y., Doan, A., Halevy, A., Domingos, P.: imap: Discovering complex semantic matches between database schemas. In: ACM SIGMOD Conference, pp. 383–394 (2004)Google Scholar
  6. 6.
    Doan, A., Domingos, P., Halevy, A.Y.: Reconciling schemas of disparate data sources: A machine-learning approach. In: ACM SIGMOD Conference, pp. 509–520 (2001)Google Scholar
  7. 7.
    He, B., Chang, K.C.-C.: Discovering complex matchings across Web query interfaces: A correlation mining approach. In: ACM SIGKDD Conference, pp. 147–158 (2004)Google Scholar
  8. 8.
    He, B., Chang, K.C.-C., Han, J.: Statistical schema matching acrossWeb query interfaces. In: ACM SIGMOD Conference, pp. 217–228 (2003)Google Scholar
  9. 9.
    Li, W., Clifton, C., Liu, S.: Database Integration using Neural Networks: Implementation and Experience. Knowledge and Information Systems 2(1), 73–96 (2000)zbMATHCrossRefGoogle Scholar
  10. 10.
    Madhavan, J., Bernstein, P., Doan, A., Halevy, A.: Corpus-based schema matching. In: 21st Int. Conf. on Data Engineering, pp. 57–68 (2005)Google Scholar
  11. 11.
    Manning, C., Schutze, H.: Foundations of Statistical Natural Language Processing, May. MIT Press, Cambridge (1999)zbMATHGoogle Scholar
  12. 12.
    Melnik, S., Garcia-Molina, H., Rahm, E.: Similarity flooding: A versatile graph matching algorithm. In: 18th Int. Conf. on Data Engineering, pp. 117–128 (2002)Google Scholar
  13. 13.
    Miller, G.: WordNet: An on-line lexical database. International Journal of Lexicography (1990)Google Scholar
  14. 14.
    Rahm, E., Bernstein, P.A.: A survey of approaches to automatic schema matching. The VLDB Journal 10, 334–350 (2001)zbMATHCrossRefGoogle Scholar
  15. 15.
    Tan, P., Kumar, V., Srivastava, J.: Selecting the right interestingness measure for association patterns. In: ACM SIGKDD Conference, pp. 32–41 (2002)Google Scholar
  16. 16.
    Wang, J., Wen, J., Lochovsky, F., Ma, W.: Instance-based schema matching for Web databases by domain-specific query probing. In: 30th Int. Conf. Very Large Data Bases, pp. 408–419 (2004)Google Scholar
  17. 17.
    Wu, W., Yu, C., Doan, A., Meng, W.: An interactive clustering-based approach to integrating source query interfaces on the deep Web. In: ACM SIGMOD Conference, pp. 95–106 (2004)Google Scholar

Copyright information

© Springer-Verlag Berlin Heidelberg 2006

Authors and Affiliations

  • Weifeng Su
    • 1
  • Jiying Wang
    • 2
  • Frederick Lochovsky
    • 1
  1. 1.Hong Kong University of Science & TechnologyHong Kong
  2. 2.City UniversityHong Kong

Personalised recommendations