That's all folks! LLUNATIC goes open source

Floris Geerts, Giansalvatore Mecca, Paolo Papotti, Donatello Santoro

Research output: Contribution to journalArticle

23 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 (US)
Pages (from-to)1565-1568
Number of pages4
JournalUnknown Journal
Volume7
Issue number13
StatePublished - 2014
Externally publishedYes

Fingerprint

Databases
Intuition
Cleaning
Information Storage and Retrieval
Repair
Electronic data interchange
Research
Data Accuracy

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. Unknown Journal, 7(13), 1565-1568.

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

In: Unknown Journal, Vol. 7, No. 13, 2014, p. 1565-1568.

Research output: Contribution to journalArticle

Geerts, F, Mecca, G, Papotti, P & Santoro, D 2014, 'That's all folks! LLUNATIC goes open source', Unknown Journal, vol. 7, no. 13, pp. 1565-1568.
Geerts F, Mecca G, Papotti P, Santoro D. That's all folks! LLUNATIC goes open source. Unknown Journal. 2014;7(13):1565-1568.
Geerts, Floris ; Mecca, Giansalvatore ; Papotti, Paolo ; Santoro, Donatello. / That's all folks! LLUNATIC goes open source. In: Unknown Journal. 2014 ; Vol. 7, No. 13. pp. 1565-1568.
@article{9a404419b7ef4b709b0f69a2017b5b4e,
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 (US)",
volume = "7",
pages = "1565--1568",
journal = "Scanning Electron Microscopy",
issn = "0586-5581",
publisher = "Scanning Microscopy International",
number = "13",

}

TY - JOUR

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 - Article

VL - 7

SP - 1565

EP - 1568

JO - Scanning Electron Microscopy

JF - Scanning Electron Microscopy

SN - 0586-5581

IS - 13

ER -