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:

    Shall we now
    Contaminate our fingers with base bribes,
    And sell the mighty space of our large honors
    For so much trash as may be grasped thus?
    I had rather be a dog and bay the moon
    Than such a Roman.
    William Shakespeare (1564–1616)

    Those who have been once intoxicated with power, and have derived any kind of emolument from it, even though but for one year, never can willingly abandon it. They may be distressed in the midst of all their power; but they will never look to anything but power for their relief.
    Edmund Burke (1729–1797)

    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)