#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.

For a new and improved chase engine for data cleaning and schema mappings altogether please check the LLunatic project

How to import project in NetBeans

1. In NetBeans, File -> Open projects... and select the project folder
2. Execute ant target task gfp, either using command-line ant gfp, or using NetBeans (in the projects windows, right click on build.xml -> Run Target -> Other Targets -> gfp)

#Screenshots

#Download

• Version 1.1 (July 2015)

#Pubblications

• [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 (link)
• [VLDB10] B. Marnette, G. Mecca, P. Papotti - Scalable Data Exchange with Functional Dependencies. In VLDB Conference, 2010 (link)
• [SIGMOD09] G. Mecca, P. Papotti, S. Raunich - Core Schema Mappings. In SIGMOD Conference, 2009 (link)
• [VLDB09] G. Mecca, P. Papotti, S. Raunich, M. Buoncristiano - Concise and Expressive Mappings with the +Spicy System. In VLDB Conference, 2009(link)
• [EDBT08] A. Bonifati, G. Mecca, A. Pappalardo, S. Raunich, G. Summa - Schema Mapping Verification: the Spicy way. In EDBT Conference, 2008:85-96 (link)
• [SIGMOD08] A. Bonifati, G. Mecca, A. Pappalardo, S. Raunich, G. Summa - The Spicy System: Towards a Notion of Mapping Quality. In SIGMOD Conference, 2008 (link)

#People

• Gianni Mecca
• Paolo Papotti
• Salvatore Raunich
• Donatello Santoro
• Marcello Buoncristiano
• Gianvito Summa
• Bruno Marnette