andclud
Andclud is a hypothetical operator in logic and database theory that combines a logical conjunction with an inclusion constraint. Formally, given a domain U, predicates P and Q on U, and an inclusion set I ⊆ U, andclud(P, Q; I) returns the subset { x ∈ I | P(x) and Q(x) }.
Semantics: andclud is equivalent to the intersection of the predicate sets restricted to I. When extended to
Examples: In a document database, I may select documents accessible to a user. Applying andclud to predicates
Applications: andclud can be used for refined query filtering, access control, and data cleaning where results
Origin and note: andclud is not part of standard query languages and is discussed here as a
See also: conjunction, intersection, inclusion constraint, relational algebra.