Relational Database - Base and Derived Relations

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:  Relational Database

Famous quotes containing the words base, derived and/or relations:

    I think it is worse to be poor in mind than in purse, to be stunted and belittled in soul, made a coward, made a liar, made mean and slavish, accustomed to fawn and prevaricate, and “manage” by base arts a husband or a father,—I think this is worse than to be kicked with hobnailed shoes.
    Frances Power Cobbe (1822–1904)

    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)

    The interest in life does not lie in what people do, nor even in their relations to each other, but largely in the power to communicate with a third party, antagonistic, enigmatic, yet perhaps persuadable, which one may call life in general.
    Virginia Woolf (1882–1941)