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 language | English (US) |
|---|---|
| Pages (from-to) | 1565-1568 |
| Number of pages | 4 |
| Journal | Unknown Journal |
| Volume | 7 |
| Issue number | 13 |
| State | Published - 2014 |
| Externally published | Yes |
Fingerprint
ASJC Scopus subject areas
- Computer Science (miscellaneous)
- Computer Science(all)
Cite this
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 journal › Article
}
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 -