Reference articles on history, science, culture and more
Encyclopedia

Boolean conjunctive query

Query returning true/false based on whether a conjunction of conditions holds

In the theory of relational databases, a Boolean conjunctive query is a conjunctive query without distinguished predicates, i.e., a query in the form R_{1}(t_{1})\wedge \cdots \wedge R_{n}(t_{n}), where each R_{i} is a relation symbol and each t_{i} is a tuple of variables and constants; the number of elements in t_{i} is equal to the arity of R_{i}. Such a query evaluates to either true or false depending on whether the relations in the database contain the appropriate tuples of values, i.e. the conjunction is valid according to the facts in the database.

As an example, if a database schema contains the relation symbols Father (binary, who's the father of whom) and Employed (unary, who is employed), a conjunctive query could be Father({\text{Mark}},x)\wedge Employed(x). This query evaluates to true if there exists an individual x who is a child of Mark and employed. In other words, this query expresses the question: "does Mark have an employed child?"

Watch videos about Boolean conjunctive queryExplainers and documentaries on YouTube (opens in a new tab)

Sources and credits

This article is adapted from the Wikipedia article Boolean conjunctive query, written by its contributors and licensed under CC BY-SA 4.0. Fathomly has changed the layout, removed citation markers, navigation and maintenance notices, and adjusted punctuation. This adapted version is shared under the same license. For references, see the original article.

Fathomly is not affiliated with or endorsed by the Wikimedia Foundation. Spotted a problem? Tell us.