A study of homogeneity in relational databases

  • Authors:
  • José María Turull Torres

  • Affiliations:
  • Universidad Tecnológica Nacional, F.R.B.A. and Universidad Nacional de San Luis Perón 2315, piso 4, depto. P, 1040 Capital Federal, Argentina E-mail: turull@mail.unlu.edu.ar

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

Quantified Score

Hi-index 0.00

Visualization

Abstract

We define four different properties of relational databases which are related tothe notion of homogeneity in classical model theory. The main question for their definition is, for any given database to determine the minimum integer ik, such that whenever two ik-tuples satisfy the same properties which are expressible in first order logic with up to ik variables (FOik), then there is an automorphism which maps each of these ik-tuples onto each other. We study these four properties as a means to increase the computational power of subclasses of the reflective relational machines (RRMs) of bounded variable complexity. These were introduced by S. Abiteboul, C. Papadimitriou and V. Vianu and are known to be incomplete. For this sake we first give a semantic characterization of the subclasses of total RRM with variable complexity ik (RRMik) for every natural number ik. This leads to the definition of classes of queries denoted as iQiCiQik. We believe these classes to be of interest in their own right. For each ik0, we define the subclass iQiCiQik as the total queries in the class iCiQ of computable queries which preserve realization of properties expressible in FOik. The nature of these classes is implicit in the work of S. Abiteboul, M. Vardi and V. Vianu. We prove iQiCiQik=itotal(RRMik) for every ik0. We also prove that these classes form a istrict hierarchy within a strict subclass of itotal(iCiQ). This hierarchy is orthogonal to the usual classification of computable queries in time-space-complexity classes. We prove that the computability power of RRMik machines is much greater when working with classes of databases which are homogeneous, for three of the properties which we define. As to the fourth one, we prove that the computability power of RRM with sublinear variable complexity also increases when working on databases which satisfy that property. The strongest notion, pairwise ik-homogeneity, allows RRMik machines to achieve icompleteness.