language-icon Old Web
English
Sign In

Conjunctive query

In database theory, a conjunctive query is a restricted form of first-order queries using the logical conjunction operator. Many first-order queries can be written as conjunctive queries. In particular, a large part of queries issued on relational databases can be expressed in this way. Conjunctive queries also have a number of desirable theoretical properties that larger classes of queries (e.g., the relational algebra queries) do not share. In database theory, a conjunctive query is a restricted form of first-order queries using the logical conjunction operator. Many first-order queries can be written as conjunctive queries. In particular, a large part of queries issued on relational databases can be expressed in this way. Conjunctive queries also have a number of desirable theoretical properties that larger classes of queries (e.g., the relational algebra queries) do not share. The conjunctive queries are simply the fragment of (domain independent) first-order logic given by the set offormulae that can be constructed from atomic formulae using conjunction ∧ andexistential quantification ∃, but not using disjunction ∨, negation ¬,or universal quantification ∀.Each such formula can be rewritten (efficiently) into an equivalent formula in prenex normal form, thus this form is usually simply assumed.

[ "Relational database", "Query optimization", "Query language", "SQL", "Universal relation assumption" ]
Parent Topic
Child Topic
    No Parent Topic