Supriya Ghosh (Editor)

Boolean conjunctive query

Updated on
Edit
Like
Comment
Share on FacebookTweet on TwitterShare on LinkedInShare on Reddit

Similar
  
Boole's expansion theorem, Residuated Boolean algebra, Free Boolean algebra
theory - Query optimisation - Boolean retrieval of conjunctive queries -  Stack Overflow

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 ) 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 F a t h e r (binary, who's the father of whom) and E m p l o y e d (unary, who is employed), a conjunctive query could be F a t h e r ( M a r k , x ) E m p l o y e d ( 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?"

References

Boolean conjunctive query Wikipedia


Similar Topics