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:

    The base emotions Plato banned
    have left a radio-active and not radiant land.
    Libby Houston (b. 1941)

    All moral discipline, all moral perfection derived from the soul of literature.
    Thomas Mann (1875–1955)

    I know all those people. I have friendly, social, and criminal relations with the whole lot of them.
    Mark Twain [Samuel Langhorne Clemens] (1835–1910)