On the distance of databases

  • Authors:
  • Gyula O. Katona;Attila Sali

  • Affiliations:
  • Alfréd Rényi Institute of Mathematics, Hungarian Academy of Sciences, Budapest, Hungary 1364;Alfréd Rényi Institute of Mathematics, Hungarian Academy of Sciences, Budapest, Hungary 1364 and Department of Computer Science, Budapest University of Technology and Economics, Budapest ...

  • Venue:
  • Annals of Mathematics and Artificial Intelligence
  • Year:
  • 2012

Quantified Score

Hi-index 0.00

Visualization

Abstract

In the present paper a distance concept of databases is investigated. Two database instances are of distance 0, if they have the same number of attributes and satisfy exactly the same set of functional dependencies. This naturally leads to the poset of closures as a model of changing database. The distance of two databases (closures) is defined to be the distance of the two closures in the Hasse diagram of that poset. We determine the diameter of the poset and show that the distance of two closures is equal to the natural lower bound, that is to the size of the symmetric difference of the collections of closed sets. We also investigate the diameter of the set of databases with a given system of keys. Sharp upper bounds are given in the case when the minimal keys are 2 (or r)-element sets.