Interactive data repairing

The FALCON dive

Enzo Veltri, Donatello Santoro, Giansalvatore Mecca, Paolo Papotti, Jian He, Gouliang Li, Nan Tang

Research output: Chapter in Book/Report/Conference proceedingConference contribution

Abstract

In this paper we discuss Falcon, an interactive, deterministic, and declarative data cleaning system. Unlike traditional rule-based system, Falcon does not rely on the existence of a set of pre-defined data quality rules, but it encourages users to explore the data, identify possible problems, and make updates to fix them. The main technical challenge consists in finding a set of rules, expressed as sql update queries, that are semantically correct and that fixes the largest number of errors in the data. Falcon navigates the lattice by interacting with users to gradually checking the correctness of a set of rules. We have conducted extensive experiments using both real-world and synthetic datasets to show that Falcon can effectively communicate with users in data repairing.

Original languageEnglish (US)
Title of host publication25th Italian Symposium on Advanced Database Systems, SEBD 2017
PublisherSistemi Evoluti per Basi di Dati (SEBD)
Pages267-274
Number of pages8
StatePublished - Jan 1 2017
Event25th Italian Symposium on Advanced Database Systems, SEBD 2017 - Squillace Lido, Catanzaro, Italy
Duration: Jun 25 2017Jun 29 2017

Other

Other25th Italian Symposium on Advanced Database Systems, SEBD 2017
CountryItaly
CitySquillace Lido, Catanzaro
Period6/25/176/29/17

Fingerprint

Knowledge based systems
Cleaning
Experiments

ASJC Scopus subject areas

  • Software
  • Information Systems

Cite this

Veltri, E., Santoro, D., Mecca, G., Papotti, P., He, J., Li, G., & Tang, N. (2017). Interactive data repairing: The FALCON dive. In 25th Italian Symposium on Advanced Database Systems, SEBD 2017 (pp. 267-274). Sistemi Evoluti per Basi di Dati (SEBD).

Interactive data repairing : The FALCON dive. / Veltri, Enzo; Santoro, Donatello; Mecca, Giansalvatore; Papotti, Paolo; He, Jian; Li, Gouliang; Tang, Nan.

25th Italian Symposium on Advanced Database Systems, SEBD 2017. Sistemi Evoluti per Basi di Dati (SEBD), 2017. p. 267-274.

Research output: Chapter in Book/Report/Conference proceedingConference contribution

Veltri, E, Santoro, D, Mecca, G, Papotti, P, He, J, Li, G & Tang, N 2017, Interactive data repairing: The FALCON dive. in 25th Italian Symposium on Advanced Database Systems, SEBD 2017. Sistemi Evoluti per Basi di Dati (SEBD), pp. 267-274, 25th Italian Symposium on Advanced Database Systems, SEBD 2017, Squillace Lido, Catanzaro, Italy, 6/25/17.
Veltri E, Santoro D, Mecca G, Papotti P, He J, Li G et al. Interactive data repairing: The FALCON dive. In 25th Italian Symposium on Advanced Database Systems, SEBD 2017. Sistemi Evoluti per Basi di Dati (SEBD). 2017. p. 267-274
Veltri, Enzo ; Santoro, Donatello ; Mecca, Giansalvatore ; Papotti, Paolo ; He, Jian ; Li, Gouliang ; Tang, Nan. / Interactive data repairing : The FALCON dive. 25th Italian Symposium on Advanced Database Systems, SEBD 2017. Sistemi Evoluti per Basi di Dati (SEBD), 2017. pp. 267-274
@inproceedings{af588fa8f2d5495ba322e0636b92acc7,
title = "Interactive data repairing: The FALCON dive",
abstract = "In this paper we discuss Falcon, an interactive, deterministic, and declarative data cleaning system. Unlike traditional rule-based system, Falcon does not rely on the existence of a set of pre-defined data quality rules, but it encourages users to explore the data, identify possible problems, and make updates to fix them. The main technical challenge consists in finding a set of rules, expressed as sql update queries, that are semantically correct and that fixes the largest number of errors in the data. Falcon navigates the lattice by interacting with users to gradually checking the correctness of a set of rules. We have conducted extensive experiments using both real-world and synthetic datasets to show that Falcon can effectively communicate with users in data repairing.",
author = "Enzo Veltri and Donatello Santoro and Giansalvatore Mecca and Paolo Papotti and Jian He and Gouliang Li and Nan Tang",
year = "2017",
month = "1",
day = "1",
language = "English (US)",
pages = "267--274",
booktitle = "25th Italian Symposium on Advanced Database Systems, SEBD 2017",
publisher = "Sistemi Evoluti per Basi di Dati (SEBD)",

}

TY - GEN

T1 - Interactive data repairing

T2 - The FALCON dive

AU - Veltri, Enzo

AU - Santoro, Donatello

AU - Mecca, Giansalvatore

AU - Papotti, Paolo

AU - He, Jian

AU - Li, Gouliang

AU - Tang, Nan

PY - 2017/1/1

Y1 - 2017/1/1

N2 - In this paper we discuss Falcon, an interactive, deterministic, and declarative data cleaning system. Unlike traditional rule-based system, Falcon does not rely on the existence of a set of pre-defined data quality rules, but it encourages users to explore the data, identify possible problems, and make updates to fix them. The main technical challenge consists in finding a set of rules, expressed as sql update queries, that are semantically correct and that fixes the largest number of errors in the data. Falcon navigates the lattice by interacting with users to gradually checking the correctness of a set of rules. We have conducted extensive experiments using both real-world and synthetic datasets to show that Falcon can effectively communicate with users in data repairing.

AB - In this paper we discuss Falcon, an interactive, deterministic, and declarative data cleaning system. Unlike traditional rule-based system, Falcon does not rely on the existence of a set of pre-defined data quality rules, but it encourages users to explore the data, identify possible problems, and make updates to fix them. The main technical challenge consists in finding a set of rules, expressed as sql update queries, that are semantically correct and that fixes the largest number of errors in the data. Falcon navigates the lattice by interacting with users to gradually checking the correctness of a set of rules. We have conducted extensive experiments using both real-world and synthetic datasets to show that Falcon can effectively communicate with users in data repairing.

UR - http://www.scopus.com/inward/record.url?scp=85035050920&partnerID=8YFLogxK

UR - http://www.scopus.com/inward/citedby.url?scp=85035050920&partnerID=8YFLogxK

M3 - Conference contribution

SP - 267

EP - 274

BT - 25th Italian Symposium on Advanced Database Systems, SEBD 2017

PB - Sistemi Evoluti per Basi di Dati (SEBD)

ER -