# Transitive closure

(Redirected from Recursive closure)

In mathematics, the transitive closure of a binary relation R on a set X is the transitive relation R+ on set X such that R+ contains R and R+ is minimal (Lidl and Pilz 1998:337). If the binary relation itself is transitive, then the transitive closure is that same binary relation; otherwise, the transitive closure is a different relation. For example, if X is a set of airports and x R y means "there is a direct flight from airport x to airport y", then the transitive closure of R on X is the relation R+: "it is possible to fly from x to y in one or more flights."

## Transitive relations and examples

A relation R on a set X is transitive if, for all x,y,z in X, whenever x R y and y R z then x R z. Examples of transitive relations include the equality relation on any set, the "less than or equal" relation on any linearly ordered set, and the relation "x was born before y" on the set of all people. Symbolically, this can be denoted as: if x < y and y < z then x < z.

One example of a non-transitive relation is "city x can be reached via a direct flight from city y" on the set of all cities. Simply because there is a direct flight from one city to a second city, and a direct flight from the second city to the third, does not imply there is a direct flight from the first city to the third. The transitive closure of this relation is a different relation, namely "there is a sequence of direct flights that begins at city x and ends at city y". Every relation can be extended in a similar way to a transitive relation.

## Existence and description

For any relation R, the transitive closure of R always exists. To see this, note that the intersection of any family of transitive relations is again transitive. Furthermore, there exists at least one transitive relation containing R, namely the trivial one: X × X. The transitive closure of R is then given by the intersection of all transitive relations containing R.

For finite sets, we can construct the transitive closure step by step, starting from R and adding transitive edges. This gives the intuition for a general construction. For any set X, we can prove that transitive closure is given by the following expression

$R^{+}=\bigcup_{i\in \{1,2,3,\ldots\}} R^i.$

where $R^i$ is the i-th power of R, defined inductively by

$R^1 = R\,\!$

and, for $i>0$,

$R^{i+1} = R \circ R^i$

where $\circ$ denotes composition of relations.

To show that the above definition of R+ is the least transitive relation containing R, we show that it contains R, that it is transitive, and that it is the smallest set with both of those characteristics.

• $R \subseteq R^{+}$: $\displaystyle R^+$ contains all of the $\displaystyle R^i$, so in particular $\displaystyle R^+$ contains $\displaystyle R$.
• $\displaystyle R^{+}$ is transitive: every element of $\displaystyle R^+$ is in one of the $\displaystyle R^i$, so $\displaystyle R^+$ must be transitive by the following reasoning: if $(s_1, s_2)\in R^j$ and $(s_2, s_3)\in R^k$, then from composition's associativity, $(s_1, s_3)\in R^{j+k}$ (and thus in $\displaystyle R^+$) because of the definition of $\displaystyle R^i$.
• $\displaystyle R^{+}$ is minimal: Let $\displaystyle G$ be any transitive relation containing $\displaystyle R$, we want to show that $R^{+} \subseteq G$. It is sufficient to show that for every $i>0$, $R^i\subseteq G$. Well, since $\displaystyle G$ contains $\displaystyle R$, $R^1\subseteq G$. And since $\displaystyle G$ is transitive, whenever $R^i\subseteq G$, $R^{i+1}\subseteq G$ according to the construction of $R^i\,\!$ and what it means to be transitive. Therefore, by induction, $\displaystyle G$ contains every $R^i\,\!$, and thus also $\displaystyle R^+$.

## Properties

The union of two transitive relations need not be transitive. To preserve transitivity, one must take the transitive closure. This occurs, for example, when taking the union of two equivalence relations or two preorders. To obtain a new equivalence relation or preorder one must take the transitive closure (reflexivity and symmetry—in the case of equivalence relations—are automatic).

## In graph theory

Transitive closure constructs the output graph from the input graph.

In computer science, the concept of transitive closure can be thought of as constructing a data structure that makes it possible to answer reachability questions. That is, can one get from node a to node d in one or more hops? A binary relation tells you only that node a is connected to node b, and that node b is connected to node c, etc. After the transitive closure is constructed, as depicted in the following figure, in an O(1) operation one may determine that node d is reachable from node a. The data structure is typically stored as a matrix, so if matrix[1][4] = 1, then it is the case that node 1 can reach node 4 through one or more hops.

The transitive closure of a directed acyclic graph (DAG) is the reachability relation of the DAG and a strict partial order.

## In logic and computational complexity

In finite model theory, first-order logic (FO) extended with a transitive closure operator is usually called transitive closure logic, and abbreviated FO(TC) or just TC. TC is a sub-type of fixpoint logics. The fact that FO(TC) is strictly more expressive than FO was discovered by Ronald Fagin in 1974; the result was then rediscovered by Alfred Aho and Jeffrey Ullman in 1979, who proposed to use fixpoint logic as a database query language (Libkin 2004:vii). With more recent concepts of finite model theory, proof that FO(TC) is strictly more expressive than FO follows immediately from the fact that FO(TC) is not Gaifman-local (Libkin 2004:49).

In computational complexity theory, the complexity class NL corresponds precisely to the set of logical sentences expressible in TC. This is because the transitive closure property has a close relationship with the NL-complete problem STCON for finding directed paths in a graph. Similarly, the class L is first-order logic with the commutative, transitive closure. When transitive closure is added to second-order logic instead, we obtain PSPACE.

## In database query languages

Since the 1980s Oracle Database has implemented a proprietary SQL extension CONNECT BY... START WITH that allows the computation of a transitive closure as part of a declarative query. The SQL 3 (1999) standard added a more general WITH RECURSIVE construct also allowing transitive closures to be computed inside the query processor; as of 2011 the latter is implemented in IBM DB2, Microsoft SQL Server, and PostgreSQL, although not in MySQL (Benedikt and Senellart 2011:189).

Datalog also implements transitive closure computations (Silberschatz et al. 2010:C.3.6).

## Algorithms

Efficient algorithms for computing the transitive closure of a graph can be found in Nuutila (1995). The simplest technique is probably the Floyd–Warshall algorithm. The fastest worst-case methods, which are not practical, reduce the problem to matrix multiplication.

More recent research went into efficient ways of computing transitive closure on distributed systems based on the MapReduce paradigm (Afrati et al. 2011).