That's all folks! LLUNATIC goes open source

Floris Geerts, Giansalvatore Mecca, Paolo Papotti, Donatello Santoro

Research output: Chapter in Book/Report/Conference proceedingChapter

25 Citations (Scopus)

Abstract

It is widely recognized that whenever different data sources need to be integrated into a single target database errors and inconsistencies may arise, so that there is a strong need to apply data-cleaning techniques to repair the data. Despite this need, database research has so far investigated mappings and data repairing essentially in isolation. Unfortunately, schema-mappings and data quality rules interact with each other, so that applying existing algorithms in a pipelined way - i.e., first exchange then data, then repair the result - does not lead to solutions even in simple settings. We present the LLUNATIC mapping and cleaning system, the first comprehensive proposal to handle schema mappings and data repairing in a uniform way. LLUNATIC is based on the intuition that transforming and cleaning data are different facets of the same problem, unified by their declarative nature. This holistic approach allows us to incorporate unique features into the system, such as configurable user interaction and a tunable trade-off between efficiency and quality of the solutions.

Original languageEnglish
Title of host publicationProceedings of the VLDB Endowment
PublisherAssociation for Computing Machinery
Pages1565-1568
Number of pages4
Volume7
Edition13
Publication statusPublished - 2014

Fingerprint

Cleaning
Repair
Electronic data interchange

ASJC Scopus subject areas

  • Computer Science (miscellaneous)
  • Computer Science(all)

Cite this

Geerts, F., Mecca, G., Papotti, P., & Santoro, D. (2014). That's all folks! LLUNATIC goes open source. In Proceedings of the VLDB Endowment (13 ed., Vol. 7, pp. 1565-1568). Association for Computing Machinery.

That's all folks! LLUNATIC goes open source. / Geerts, Floris; Mecca, Giansalvatore; Papotti, Paolo; Santoro, Donatello.

Proceedings of the VLDB Endowment. Vol. 7 13. ed. Association for Computing Machinery, 2014. p. 1565-1568.

Research output: Chapter in Book/Report/Conference proceedingChapter

Geerts, F, Mecca, G, Papotti, P & Santoro, D 2014, That's all folks! LLUNATIC goes open source. in Proceedings of the VLDB Endowment. 13 edn, vol. 7, Association for Computing Machinery, pp. 1565-1568.
Geerts F, Mecca G, Papotti P, Santoro D. That's all folks! LLUNATIC goes open source. In Proceedings of the VLDB Endowment. 13 ed. Vol. 7. Association for Computing Machinery. 2014. p. 1565-1568
Geerts, Floris ; Mecca, Giansalvatore ; Papotti, Paolo ; Santoro, Donatello. / That's all folks! LLUNATIC goes open source. Proceedings of the VLDB Endowment. Vol. 7 13. ed. Association for Computing Machinery, 2014. pp. 1565-1568
@inbook{14de38f7c80b47b49f9655ae798c878d,
title = "That's all folks! LLUNATIC goes open source",
abstract = "It is widely recognized that whenever different data sources need to be integrated into a single target database errors and inconsistencies may arise, so that there is a strong need to apply data-cleaning techniques to repair the data. Despite this need, database research has so far investigated mappings and data repairing essentially in isolation. Unfortunately, schema-mappings and data quality rules interact with each other, so that applying existing algorithms in a pipelined way - i.e., first exchange then data, then repair the result - does not lead to solutions even in simple settings. We present the LLUNATIC mapping and cleaning system, the first comprehensive proposal to handle schema mappings and data repairing in a uniform way. LLUNATIC is based on the intuition that transforming and cleaning data are different facets of the same problem, unified by their declarative nature. This holistic approach allows us to incorporate unique features into the system, such as configurable user interaction and a tunable trade-off between efficiency and quality of the solutions.",
author = "Floris Geerts and Giansalvatore Mecca and Paolo Papotti and Donatello Santoro",
year = "2014",
language = "English",
volume = "7",
pages = "1565--1568",
booktitle = "Proceedings of the VLDB Endowment",
publisher = "Association for Computing Machinery",
edition = "13",

}

TY - CHAP

T1 - That's all folks! LLUNATIC goes open source

AU - Geerts, Floris

AU - Mecca, Giansalvatore

AU - Papotti, Paolo

AU - Santoro, Donatello

PY - 2014

Y1 - 2014

N2 - It is widely recognized that whenever different data sources need to be integrated into a single target database errors and inconsistencies may arise, so that there is a strong need to apply data-cleaning techniques to repair the data. Despite this need, database research has so far investigated mappings and data repairing essentially in isolation. Unfortunately, schema-mappings and data quality rules interact with each other, so that applying existing algorithms in a pipelined way - i.e., first exchange then data, then repair the result - does not lead to solutions even in simple settings. We present the LLUNATIC mapping and cleaning system, the first comprehensive proposal to handle schema mappings and data repairing in a uniform way. LLUNATIC is based on the intuition that transforming and cleaning data are different facets of the same problem, unified by their declarative nature. This holistic approach allows us to incorporate unique features into the system, such as configurable user interaction and a tunable trade-off between efficiency and quality of the solutions.

AB - It is widely recognized that whenever different data sources need to be integrated into a single target database errors and inconsistencies may arise, so that there is a strong need to apply data-cleaning techniques to repair the data. Despite this need, database research has so far investigated mappings and data repairing essentially in isolation. Unfortunately, schema-mappings and data quality rules interact with each other, so that applying existing algorithms in a pipelined way - i.e., first exchange then data, then repair the result - does not lead to solutions even in simple settings. We present the LLUNATIC mapping and cleaning system, the first comprehensive proposal to handle schema mappings and data repairing in a uniform way. LLUNATIC is based on the intuition that transforming and cleaning data are different facets of the same problem, unified by their declarative nature. This holistic approach allows us to incorporate unique features into the system, such as configurable user interaction and a tunable trade-off between efficiency and quality of the solutions.

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

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

M3 - Chapter

AN - SCOPUS:84905824914

VL - 7

SP - 1565

EP - 1568

BT - Proceedings of the VLDB Endowment

PB - Association for Computing Machinery

ER -