Thats all folks! LLUNATIC goes open sourceThats all folks! LLUNATIC goes open source
Faculty of Sciences. Mathematics and Computer Science
Advanced Database Research and Modeling (ADReM)
Proceedings of the VLDB Endowment
7(2014):13, p. 1565-1568
University of Antwerp
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.