Title
The nautilus analyzer: understanding and debugging data transformations
Abstract
When developing data transformations - a task omnipresent in applications like data integration, data migration, data cleaning, or scientific data processing -developers quickly face the need to verify the semantic correctness of the transformation. Declarative specifications of data transformations, e.g., SQL or ETL tools, increase developer productivity but usually provide limited or no means for inspection or debugging. In this situation, developers today have no choice but to manually analyze the transformation and, in case of an error, to (repeatedly) fix and test the transformation. The goal of the Nautilus project is to semi-automatically support this analysis-fix-test cycle. This demonstration focuses on one main component of Nautilus, namely the Nautilus Analyzer that helps developers in understanding and debugging their data transformations. The demonstration will show the capabilities of this component for data transformations specified in SQL on scenarios from different domains that are based on real-world data. We provide an overview the Nautilus Analyzer, discuss components and implementation techniques, and outline our demonstration plan. The Nautilus website (http://nautilus-system.org) features a video, screenshots, and further details.
Year
DOI
Venue
2012
10.1145/2396761.2398743
CIKM
Keywords
Field
DocType
scientific data processing,data migration,main component,demonstration plan,real-world data,nautilus project,data transformation,debugging data transformation,nautilus analyzer,data integration,nautilus website
SQL,Data integration,Nautilus,Data mining,Data processing,Data transformation (statistics),Computer science,Correctness,Debugging,Data migration
Conference
Citations 
PageRank 
References 
6
0.45
7
Authors
2
Name
Order
Citations
PageRank
Melanie Herschel124223.52
Hanno Eichelberger282.89