Exploring schema repositories with schemr

ABSTRACT

Schemr is a schema search engine, and provides users the ability to search for and visualize schemas stored in a metadata repository. Users may search by keywords and by example -- using schema fragments as query terms. Schemr uses a novel search algorithm, based on a combination of text search and schema matching techniques, as well as a structurally-aware scoring metric. Schemr presents search results in a GUI that allows users to explore which elements match and how well they do. The GUI supports interactions, including panning, zooming, layout and drilling-in. We demonstrate schema search and visualization, introduce Schemr as a new component of the information integration toolbox, and discuss its benefits in several applications.

REFERENCES

• 1: Anhai Doan , Pedro Domingos , Alon Halevy, Learning to Match the Schemas of Data Sources: A Multistrategy Approach, Machine Learning, v.50 n.3, p.279-301, March 2003 [doi>10.1023/A:1021765902788]
• 2: Peter Mork , Len Seligman , Arnon Rosenthal , Michael Morse , Chris Wolf , Jeff Hoyt , Ken Smith, Galaxy: Encouraging Data Sharing among Sources with Schema Variants, Proceedings of the 2009 IEEE International Conference on Data Engineering, p.1551-1554, March 29-April 02, 2009 [doi>10.1109/ICDE.2009.78]
• 3: Erhard Rahm , Philip A. Bernstein, A survey of approaches to automatic schema matching, The VLDB Journal — The International Journal on Very Large Data Bases, v.10 n.4, p.334-350, December 2001 [doi>10.1007/s007780100057]
• 4: George G. Robertson , Mary P. Czerwinski , John E. Churchill, Visualization of mappings between schemas, Proceedings of the SIGCHI conference on Human factors in computing systems, April 02-07, 2005, Portland, Oregon, USA [doi>10.1145/1054972.1055032]
• 5: Cong Yu , H. V. Jagadish, Schema summarization, Proceedings of the 32nd international conference on Very large data bases, September 12-15, 2006, Seoul, Korea
• 6: Lucene. http://lucene.apache.org.
• 7: Eclipse data tools platform (dtp) project. http://www.eclipse.org/datatools.
• 8: OpenII Google Code Project. http://code.google.com/p/openii.
• 9: OpenII Project. http://sites.google.com/site/ openinformationintegration.

INDEX TERMS

Primary Classification:
  H. Information Systems
  H.3 INFORMATION STORAGE AND RETRIEVAL
      H.3.3 Information Search and Retrieval
          Subjects: Retrieval models

General Terms:
Algorithms, Design

Keywords:
schema search