relational algebra

(redirected from Natural join)

relational algebra

(database, theory)
A family of algebra with a well-founded semantics used for modelling the data stored in relational databases, and defining queries on it. The main operations of the relational algebra are the set operations (such as union, intersection, and cartesian product), selection (keeping only some lines of a table) and the projection (keeping only some columns).

The relational data model describes how the data is structured.

Codd's reduction algorithm can convert from relational calculus to relational algebra.

relational algebra

(1) The branch of mathematics that deals with relations; for example, AND, OR, NOT, IS and CONTAINS.

(2) In a relational database, a collection of rules for dealing with tables; for example, JOIN, UNION and INTERSECT.
References in periodicals archive ?
IAMS Sensitive Naturals and IAMS Simple & Natural Join IAMS Healthy Naturals to Offer Pet Parents More Choices When Looking for Holistic Natural Nutrition
We feel privileged to see an imaginative utility like NW Natural join us in this evolution," said Ron Renzini, vice president, Itron North America sales.
As each vendor is likely to provide enterprise data stores as well as business intelligence tools, any initiative that allows natural joins across the data, using the customer's analytic tools of choice, will enhance corporate decision-making.