Denormalization

In computing, denormalization is the process of attempting to optimise the read performance of a database by adding redundant data or by grouping data. In some cases, denormalisation is a means of addressing performance or scalability in relational database software. A relational normalised database imposes a heavy access load over physical storage of data even if it is well tuned for high performance.