More precisely, in the two-sorted algebra ( Φ , D ) {\displaystyle (\Phi ,D)} , the following operations are defined
Additionally, in D {\displaystyle D} the usual lattice operations (meet and join) are defined.
The axioms of the two-sorted algebra ( Φ , D ) {\displaystyle (\Phi ,D)} , in addition to the axioms of the lattice D {\displaystyle D} :
To focus an information on x {\displaystyle x} combined with another information to domain x {\displaystyle x} , one may as well first focus the second information to x {\displaystyle x} and then combine.
To focus an information on x {\displaystyle x} and y {\displaystyle y} , one may focus it to x ∧ y {\displaystyle x\wedge y} .
An information combined with a part of itself gives nothing new.
Each information refers to at least one domain (question).
A two-sorted algebra ( Φ , D ) {\displaystyle (\Phi ,D)} satisfying these axioms is called an Information Algebra.
A partial order of information can be introduced by defining ϕ ≤ ψ {\displaystyle \phi \leq \psi } if ϕ ⊗ ψ = ψ {\displaystyle \phi \otimes \psi =\psi } . This means that ϕ {\displaystyle \phi } is less informative than ψ {\displaystyle \psi } if it adds no new information to ψ {\displaystyle \psi } . The semigroup Φ {\displaystyle \Phi } is a semilattice relative to this order, i.e. ϕ ⊗ ψ = ϕ ∨ ψ {\displaystyle \phi \otimes \psi =\phi \vee \psi } . Relative to any domain (question) x ∈ D {\displaystyle x\in D} a partial order can be introduced by defining ϕ ≤ x ψ {\displaystyle \phi \leq _{x}\psi } if ϕ ⇒ x ≤ ψ ⇒ x {\displaystyle \phi ^{\Rightarrow x}\leq \psi ^{\Rightarrow x}} . It represents the order of information content of ϕ {\displaystyle \phi } and ψ {\displaystyle \psi } relative to the domain (question) x {\displaystyle x} .
The pairs ( ϕ , x ) {\displaystyle (\phi ,x)\ } , where ϕ ∈ Φ {\displaystyle \phi \in \Phi } and x ∈ D {\displaystyle x\in D} such that ϕ ⇒ x = ϕ {\displaystyle \phi ^{\Rightarrow x}=\phi } form a labeled Information Algebra. More precisely, in the two-sorted algebra ( Φ , D ) {\displaystyle (\Phi ,D)\ } , the following operations are defined
Here follows an incomplete list of instances of information algebras:
Let A {\displaystyle {\mathcal {A}}} be a set of symbols, called attributes (or column names). For each α ∈ A {\displaystyle \alpha \in {\mathcal {A}}} let U α {\displaystyle U_{\alpha }} be a non-empty set, the set of all possible values of the attribute α {\displaystyle \alpha } . For example, if A = { name , age , income } {\displaystyle {\mathcal {A}}=\{{\texttt {name}},{\texttt {age}},{\texttt {income}}\}} , then U name {\displaystyle U_{\texttt {name}}} could be the set of strings, whereas U age {\displaystyle U_{\texttt {age}}} and U income {\displaystyle U_{\texttt {income}}} are both the set of non-negative integers.
Let x ⊆ A {\displaystyle x\subseteq {\mathcal {A}}} . An x {\displaystyle x} -tuple is a function f {\displaystyle f} so that dom ( f ) = x {\displaystyle {\hbox{dom}}(f)=x} and f ( α ) ∈ U α {\displaystyle f(\alpha )\in U_{\alpha }} for each α ∈ x {\displaystyle \alpha \in x} The set of all x {\displaystyle x} -tuples is denoted by E x {\displaystyle E_{x}} . For an x {\displaystyle x} -tuple f {\displaystyle f} and a subset y ⊆ x {\displaystyle y\subseteq x} the restriction f [ y ] {\displaystyle f[y]} is defined to be the y {\displaystyle y} -tuple g {\displaystyle g} so that g ( α ) = f ( α ) {\displaystyle g(\alpha )=f(\alpha )} for all α ∈ y {\displaystyle \alpha \in y} .
A relation R {\displaystyle R} over x {\displaystyle x} is a set of x {\displaystyle x} -tuples, i.e. a subset of E x {\displaystyle E_{x}} . The set of attributes x {\displaystyle x} is called the domain of R {\displaystyle R} and denoted by d ( R ) {\displaystyle d(R)} . For y ⊆ d ( R ) {\displaystyle y\subseteq d(R)} the projection of R {\displaystyle R} onto y {\displaystyle y} is defined as follows:
The join of a relation R {\displaystyle R} over x {\displaystyle x} and a relation S {\displaystyle S} over y {\displaystyle y} is defined as follows:
As an example, let R {\displaystyle R} and S {\displaystyle S} be the following relations:
Then the join of R {\displaystyle R} and S {\displaystyle S} is:
A relational database with natural join ⋈ {\displaystyle \bowtie } as combination and the usual projection π {\displaystyle \pi } is an information algebra. The operations are well defined since
It is easy to see that relational databases satisfy the axioms of a labeled information algebra:
The axioms for information algebras are derived from the axiom system proposed in (Shenoy and Shafer, 1990), see also (Shafer, 1991).