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

Last update: 09 Sep 2011

• Binary distribution (working on all platforms) - 21.4 MB
• Windows installer - 11.7 MB
• Linux installer - 11.3 MB
• MacOSX installer - 11.2 MB
• Source code - 1.8 MB
• Examples - 0.4 MB

Publications

• [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)

Technical Reports

• [WR11] G. Mecca, P. Papotti, S. Raunich - Core Schema Mappings: Scalable Core Computations in Data Exchange. Spicy Working Report 01-2011 (.pdf)

People

• Gianni Mecca
• Paolo Papotti - Università Roma Tre - Italy
• Salvatore Raunich
• Donatello Santoro
• Marcello Buoncristiano
• Gianvito Summa

Past Collaborators

• Angela Bonifati
• Bruno Marnette
• Alessandro Pappalardo

Comments, Bugs, Requests

• spicysystem[-at-]gmail.com