Semantic classifications of queries to relational databases

  • Authors:
  • José María Turull Torres

  • Affiliations:
  • Massey University, Information Science Research Centre, Department of Information Systems, Wellington, New Zealand

  • Venue:
  • Proceedings of the 2nd international conference on Semantics in databases
  • Year:
  • 2001

Quantified Score

Hi-index 0.00

Visualization

Abstract

We investigate cardinality constraints of the form M →Θ K, where M is a set and Θ is one of the comparison operators "=", "≤", or "≥"; such a constraint states that "exactly", "at most", or "at least", respectively, K elements out of the set M have to be chosen. We show how a set C of constraints can be represented by means of a positive-disjunctive deductive database PC, such that the models of PC correspond to the solutions of C. This allows for embedding cardinality constraints into applications dealing with incomplete knowledge. We also present a sound calculus represented by a definite logic program Pcc, which allows for directly reasoning with sets of exactly-cardinality constraints (i.e., where Θ is "="). Reasoning with Pcc is very efficient, and it can be used for performance reasons before PC is evaluated. For obtaining completeness, however, PC is necessary, since we show the theoretical result that a sound and complete calculus for exactly-cardinality constraints does not exist.