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 and, base, derived and/or relations:
“Time, force, and death
Do to this body what extremes you can,
But the strong base and building of my love
Is as the very centre of the earth,
Drawing all things to it.”
—William Shakespeare (1564–1616)
“For those who are base in judgement do not know the good they hold in their hands until they cast it off.”
—Sophocles (497–406/5 B.C.)
“If all political power be derived only from Adam, and be to descend only to his successive heirs, by the ordinance of God and divine institution, this is a right antecedent and paramount to all government; and therefore the positive laws of men cannot determine that, which is itself the foundation of all law and government, and is to receive its rule only from the law of God and nature.”
—John Locke (1632–1704)
“Actually, the laboring man has not leisure for a true integrity day by day; he cannot afford to sustain the manliest relations to men; his labor would be depreciated in the market.
He has no time to be anything but a machine.”
—Henry David Thoreau (1817–1862)