A tool for mapping discovery over revealing schemas

ABSTRACT

In a world of wide-scale information sharing, the decentralized coordination has to consolidate a variety of heterogeneity. Shared data are described in different formats, i.e. data structures, values and schemas. Querying manifold such sources entails techniques that can bridge the data formats. Some of these techniques deal with producing mappings for the schemas of data. The existing techniques view complementary aspects of the schema mapping problem. Important ones, consider producing all the possible mappings for a pair of schemas, insinuating any accompanying semantics in the mappings and adapting correct mappings as schemas evolve. Towards this end we have developed a solution that is fine-tuned for the discovery of mappings as schemas of autonomous sources are gradually revealed. In this demonstration we exhibit a new prototype tool that implements this solution. The tool provides a mechanism that realizes discovery of correct mappings as schemas are revealed. Mapping discovery is schema-centric and incorporates new semantics as they are unveiled. Mapping experience is reused and possible mappings are ranked so that the best choice is presented. The core mechanism collaborates with an automatic schema matching tool and the user that lightly guides the mapping process. The demonstration presents two application scenarios that prove the suitability of this prototype tool and the effectiveness of the implemented mapping solution in realistic situations of of data integration and exchange between heterogeneous autonomous sources.

REFERENCES

• 1: http://dbs.uni-leipzig.de/Research/coma.html.
• 2: http://www.dbnet.ece.ntua.gr/~vkante/mapping/schemas.
• 3: Bogdan Alexe , Laura Chiticariu , Renée J. Miller , Daniel Pepper , Wang-Chiew Tan, Muse: a system for understanding and designing mappings, Proceedings of the 2008 ACM SIGMOD international conference on Management of data, June 09-12, 2008, Vancouver, Canada [doi>10.1145/1376616.1376755]
• 4: Yuan An, Alexander Borgida, Renée J. Miller, and John Mylopoulos. A semantic approach to discovering schema mapping expressions. In ICDE, pages 206--215, 2007.
• 5: Marcelo Arenas , Vasiliki Kantere , Anastasios Kementsietsidis , Iluju Kiringa , Renée J. Miller , John Mylopoulos, The hyperion project: from data integration to data coordination, ACM SIGMOD Record, v.32 n.3, September 2003 [doi>10.1145/945721.945733]
• 6: A. Halevy, Z. Ives, J. Madhavan, P. Mork, D. Suciu, and I. Tatarinov. The Piazza Peer Data Management System. In IEEE TKDE, 2003.
• 7: Mauricio A. Hernández , Renée J. Miller , Laura M. Haas, Clio: a semi-automatic tool for schema mapping, Proceedings of the 2001 ACM SIGMOD international conference on Management of data, p.607, May 21-24, 2001, Santa Barbara, California, United States
• 8: V. Kantere, D. Bousounis, and T. Sellis. Mapping Discovery over Revealing Peer Schemas. Submitted for publication. http://www.dbnet.ece.ntua.gr/~vkante/mapping.
• 9: Verena Kantere , Dimitrios Tsoumakos , Timos Sellis , Nick Roussopoulos, GrouPeer: Dynamic clustering of P2P databases, Information Systems, v.34 n.1, p.62-86, March, 2009 [doi>10.1016/j.is.2008.04.002]
• 10: Maurizio Lenzerini, Data integration: a theoretical perspective, Proceedings of the twenty-first ACM SIGMOD-SIGACT-SIGART symposium on Principles of database systems, June 03-05, 2002, Madison, Wisconsin [doi>10.1145/543613.543644]
• 11: Yannis Velegrakis , Renée J. Miller , Lucian Popa , John Mylopoulos, ToMAS: A System for Adapting Mappings while Schemas Evolve, Proceedings of the 20th International Conference on Data Engineering, p.862, March 30-April 02, 2004