Overview
The ability of modern information systems to exchange, transform and integrate data is nowadays considered a crucial requirement. A fundamental requirement for such data integration applications is that of manipulating mappings among data sources. Mappings, also called schema mappings, are executable transformations – say, SQL queries for relational data or XQuery scripts for XML – that specify how an instance of the source repository should be translated into an instance of the target repository.
++Spicy is a mapping system developed at the Università della Basilicata - Department of Mathematics and Computer Science for the generation and manipulation of schema mappings.
It is the first mapping system that brings together:
- sophisticated matchers for the inference of correspondences between different schemas [SEBD06, SIGMOD08, EDBT08];
- a set of expressive mapping generation primitives, which includes selection conditions, costants, etc;
- a mapping generation algorithm that generates both canonical and core solutions; [SIGMOD09, VLDB09]
- and a mapping verification module for scenarios where target instances are already available. [EDBT08, SIGMOD08]
++Spicy contributes towards the goal of integrating scalable solutions based on schema mapping concepts into practical data integration tasks.
Screenshots
Download
Source code and binary distribution are hosted on github https://github.com/dbunibas/spicy
Publications
-
[CIKM12] G. Mecca, P. Papotti, S. Raunich, D. Santoro -
What is the IQ of your Data Transformation System? In CIKM 2012
(link)
-
[IS12] G. Mecca, P. Papotti, S. Raunich -
Core schema mappings: Scalable core computations in data exchange In Information Systems 2012, Vol. 37, Iss. 7
(link)
-
[IT12] G. Mecca, P. Papotti -
Schema Mapping and Data Exchange Tools: Time for the Golden Age In Information Technology 2012, Vol. 54, No. 3
(link)
-
[VLDB11] B. Marnette, G. Mecca, P. Papotti, S. Raunich, D. Santoro -
++Spicy: an OpenSource Tool for Second-Generation Schema Mapping and Data Exchange In VLDB Conference, 2011
(.pdf)
-
[VLDB10] B. Marnette, G. Mecca, P. Papotti - Scalable Data Exchange with Functional Dependencies. In VLDB Conference, 2010 (.pdf)
-
[SIGMOD09] G. Mecca, P. Papotti, S. Raunich - Core Schema Mappings. In SIGMOD Conference, 2009 (.pdf)
-
[VLDB09] G. Mecca, P. Papotti, S. Raunich, M. Buoncristiano - Concise and Expressive Mappings with the +Spicy System. In VLDB Conference, 2009(.pdf)
-
[EDBT08] A. Bonifati, G. Mecca, A. Pappalardo, S. Raunich, G. Summa - Schema Mapping Verification: the Spicy way. In EDBT Conference, 2008:85-96 (.pdf)
-
[SIGMOD08] A. Bonifati, G. Mecca, A. Pappalardo, S. Raunich, G. Summa - The Spicy System: Towards a Notion of Mapping Quality. In SIGMOD Conference, 2008 (.pdf)
People
Comments, Bugs, Requests
