01859nas a2200145 4500008004100000245006200041210006200103300000900165520142600174100002201600700001701622700001901639700001801658856003701676 1996 eng d00aRelational Expressive Power of Constraint Query Languages0 aRelational Expressive Power of Constraint Query Languages a5-163 aThe expressive power of first-order query languages with several classes of equality and inequality constraints is studied in this paper. We settle the conjecture that recursive queries such as parity test and transitive closure cannot be expressed in the relational calculus augmented with polynomial inequality constraints over the reals. Furthermore, noting that relational queries exhibit several forms of genericity, we establish a number of collapse results of the following form: The class of generic boolean queries expressible in the relational calculus augmented with a given class of constraints coincides with the class of queries expressible in the relational calculus (with or without an order relation). We prove such results for both the natural and active-domain semantics. As a consequence, the relational calculus augmented with polynomial inequalities expresses the same classes of generic boolean queries under both the natural and active-domain semantics. In the course of proving these results for the active-domain semantics, we establish Ramsey-type theorems saying that any query involving certain kinds of constraints coincides with a constraint free query on databases whose elements come from a certain innite subset of the domain. To prove the collapse results for the natural semantics, we make use of techniques from nonstandard analysis and from the model theory of ordered structures.
1 aBenedikt, Michael1 aDong, Guozhu1 aLibkin, Leonid1 aWong, Limsoon uhttp://www.knoesis.org/node/1508