Handling dirty databases: from user warning to data cleaning -- towards an interactive approach

  • Authors:
  • Olivier Pivert;Henri Prade

  • Affiliations:
  • Irisa, Enssat, University of Rennes 1, Lannion Cedex, France;IRIT, CNRS and University of Toulouse, Toulouse Cedex 9, France

  • Venue:
  • SUM'10 Proceedings of the 4th international conference on Scalable uncertainty management
  • Year:
  • 2010

Quantified Score

Hi-index 0.00

Visualization

Abstract

One can conceive many reasonable ways of characterizing how dirty a database is with respect to a set of integrity constraints (e.g., functional dependencies). However, dirtiness measures, as good as they can be, are difficult to interpret for an end-user and do not give the database administrator much hint about how to clean the base. This paper discusses these aspects and proposes some methods aimed at either helping the user or the administrator overcome the limitations of dirtiness measures when it comes to handling dirty databases.