Clip: a Visual Language for Explicit Schema Mappings

  • Authors:
  • Alessandro Raffio;Daniele Braga;Stefano Ceri;Paolo Papotti;Mauricio A. Hernandez

  • Affiliations:
  • Dipartimento di Elettronica e Informazione, Politecnico di Milano, Piazza Leonardo da Vinci 32, Milano, Italy. raffio@elet.polimi.it;Dipartimento di Elettronica e Informazione, Politecnico di Milano, Piazza Leonardo da Vinci 32, Milano, Italy. braga@elet.polimi.it;Dipartimento di Elettronica e Informazione, Politecnico di Milano, Piazza Leonardo da Vinci 32, Milano, Italy. ceri@elet.polimi.it;Dipartimento di Informatica e Automazione, Universitá di Roma Tre, Via della Vasca Navale 79, Roma, Italy. papotti@dia.uniroma3.it;IBM Almaden Research Center, San Jose, CA, US. mauricio@almaden.ibm.com

  • Venue:
  • ICDE '08 Proceedings of the 2008 IEEE 24th International Conference on Data Engineering
  • Year:
  • 2008

Quantified Score

Hi-index 0.00

Visualization

Abstract

Many data integration solutions in the market today include tools for schema mapping, to help users visually relate elements of different schemas. Schema elements are connected with lines, which are interpreted as mappings, i.e. high-level logical expressions capturing the relationship between source and target data-sets; these are compiled into queries and programs that convert source-side data instances into target-side instances. This paper describes Clip, an XML Schema mapping tool distinguished from existing tools in that mappings explicitly specify structural transformations in addition to value couplings. Since Clip maps hierarchical XML schemas, lines appear naturally nested. We describe the transformation semantics associated with our "lines" and how they combine to form mappings that are more expressive than those generated by Clio, a well-known mapping tool. Further, we extend Clio's mapping generation algorithms to generate Clip's mappings.