Open formulaAn open formula is a formula that contains at least one free variable.[citation needed] An open formula does not have a truth value assigned to it, in contrast with a closed formula which constitutes a proposition and thus can have a truth value like true or false. An open formula can be transformed into a closed formula by applying a quantifier for each free variable. This transformation is called capture of the free variables to make them bound variables. For example, when reasoning about natural numbers, the formula "x+2 > y" is open, since it contains the free variables x and y. In contrast, the formula "∃y ∀x: x+2 > y" is closed, and has truth value true. Open formulas are often used in rigorous mathematical definitions of properties, like
(with free variables x, y, and bound variable z) defining the notion of "aunt" in terms of "parent" and "sister". Another, more formal example, which defines the property of being a prime number, is
(with free variable x and bound variables m,n). An example of a closed formula with truth value false involves the sequence of Fermat numbers studied by Fermat in connection to the primality. The attachment of the predicate letter P (is prime) to each number from the Fermat sequence gives a set of closed formulae. While they are true for n = 0,...,4, no larger value of n is known that obtains a true formula, as of 2023[update]; for example, is not a prime. Thus the closed formula ∀n P(Fn) is false. In database theory, when expressing a query as an open first-order formula, the free variables represent the ones that in an SQL query would occur in the SELECT clause. For example, a formula like: where is the only free variable, could be expressed in SQL as follows: SELECT y1.person AS son
FROM birth_year y1
WHERE y1.year = 2020
AND EXISTS (
SELECT *
FROM mother_of m1
JOIN birth_year y2 ON m1.mother = y2.person
WHERE m1.son = y1.person
AND y2.year = 1999
)
which selects all the people born in 2020 and having a mother born in 1999. Formally, executing the above SQL query over a database is equivalent to look for all the substitutions of the free variables of with constants such that the Herbrand interpretation of satisfies , where is the set of ground atoms representing the database. See also
References
|