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:

    There is but one pride pardonable; that of being above doing a base or dishonorable action.
    Samuel Richardson (1689–1761)

    These are our grievances which we have thus laid before his majesty with that freedom of language and sentiment which becomes a free people, claiming their rights as derived from the laws of nature, and not as the gift of their chief magistrate.
    Thomas Jefferson (1743–1826)

    All social rules and all relations between individuals are eroded by a cash economy, avarice drags Pluto himself out of the bowels of the earth.
    Karl Marx (1818–1883)