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 am sure my bones would not rest in an English grave, or my clay mix with the earth of that country. I believe the thought would drive me mad on my death-bed could I suppose that any of my friends would be base enough to convey my carcass back to her soil. I would not even feed her worms if I could help it.
    George Gordon Noel Byron (1788–1824)

    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)

    Subject the material world to the higher ends by understanding it in all its relations to daily life and action.
    Ellen Henrietta Swallow Richards (1842–1911)