Redundancy

Redundancy means that data, information, or things that are comparable with each other are available several times (at least twice). The term redundancy comes from the Latin "redundare" and means that things are available in abundance. In IT technology, redundancy is advantageous because it ensures that data, networks, and systems can be accessed even if a malfunction occurs. Components are therefore used more than once with the same installation to be prepared for incidents such as power failures. However, redundancy has a negative impact on databases. If data appears more than once (redundantly) in databases, this leads to incorrect database queries and slows down the database. It is therefore important to avoid redundant data in databases.