Automated data mapping specification via schema heuristics and user interaction

Data transformation problems are very common and are challenging to implement for large and complex datasets. We describe a new approach for specifying data mapping transformations between XML schemas using a combination of automated schema analysis agents and selective user interaction. A graphical tool visualizes parts of the two schemas to be mapped and a variety of agents analyze all or parts of the schema, voting on the likelihood of matching subsets. The user can confirm or reject suggestions, or even allow schema matches to be automatically determined, incrementally building up to a fully-mapped schema. An implementation of the mapping specification can then be generated.

[1]  John C. Grundy,et al.  An Architecture for Efficient, Flexible Enterprise System Integration , 2003, International Conference on Internet Computing.

[2]  Elke A. Rundensteiner,et al.  Automating the transformation of XML documents , 2001, WIDM '01.

[3]  Erhard Rahm,et al.  A survey of approaches to automatic schema matching , 2001, The VLDB Journal.

[4]  John C. Grundy,et al.  Inconsistency Management for Multiple-View Software Development Environments , 1998, IEEE Trans. Software Eng..

[5]  Yongqiang Li,et al.  A data mapping specification environment using a concrete business form-based metaphor , 2002, Proceedings IEEE 2002 Symposia on Human Centric Computing Languages and Environments.

[6]  Yongqiang Li,et al.  Domain-specific visual languages for specifying and generating data mapping systems , 2004, J. Vis. Lang. Comput..

[7]  John C. Grundy,et al.  Approaches to supporting software visual notation exchange , 2003, IEEE Symposium on Human Centric Computing Languages and Environments, 2003. Proceedings. 2003.

[8]  John C. Grundy,et al.  Generating EDI message translations from visual specifications , 2001, Proceedings 16th Annual International Conference on Automated Software Engineering (ASE 2001).