Automatic and transparent denormalization support, wherein denormalization is achieved through appending of fields to base relations of a normalized database

摘要

A system may be used to enable a database administrator to selectively denormalize a database transparently to users and programmers. The system keeps a record of the mapping between the denormalized fields and the base fields from which they are derived. Processors access those recorded links to keep the database self-consistent and to retrieve data from denormalized fields whenever possible.