Base and Derived Relations
In a relational database, all data are stored and accessed via relations. Relations that store data are called "base relations", and in implementations are called "tables". Other relations do not store data, but are computed by applying relational operations to other relations. These relations are sometimes called "derived relations". In implementations these are called "views" or "queries". Derived relations are convenient in that they act as a single relation, even though they may grab information from several relations. Also, derived relations can be used as an abstraction layer.
Read more about this topic: Database Constraints
Famous quotes containing the words base, derived and/or relations:
“The base emotions Plato banned
have left a radio-active and not radiant land.”
—Libby Houston (b. 1941)
“There is, it seems to us,
At best, only a limited value
In the knowledge derived from experience....”
—T.S. (Thomas Stearns)
“What a man sows, that shall he and his relations reap.”
—Clarissa Graves (1892–1985?)