A monotone preservation result for Boolean queries expressed as a containment of conjunctive queries

When a relational database is queried, the result is normally a relation. Some queries, however, only require a yes/no answer; such queries are often called boolean queries. It is customary in database theory to express boolean queries by testing nonemptiness of query expressions. Another interesting way for expressing boolean queries are containment statements of the form Q(1) subset of Q(2) where Q(1) and Q(2) are query expressions. Here, for any input instance I, the boolean query result is true if Q(1) (I) is a subset of Q(2) (I) and false otherwise. In the present paper we will focus on nonemptiness and containment statements about conjunctive queries. The main goal is to investigate the monotone fragment of the containments of conjunctive queries. In particular, we show a preservation like result for this monotone fragment. That is, we show that, in expressive power, the monotone containments of conjunctive queries are exactly equal to conjunctive queries under nonemptiness. (C) 2019 Elsevier B.V. All rights reserved.