Repeating Group

What Does Repeating Group Mean?

A repeating group is a repeating series of information in a database. It is a common
problem organizations face, as the same set of information being present in
different areas can cause data redundancy and data inconsistency. While
the problem can be manageable in small organizations that need to
manage only a small set of data, for bigger organizations managing huge
volumes of information, it can be a nightmare managing several instances of
repeating groups. One of the most common ways of resolving repeating groups is
assigning a primary key to the table containing the repeating groups.

Advertisements

Techopedia Explains Repeating Group

The concept of repeating groups can be more easily understood with an example. Suppose that a multinational company has many employees. Roger Davis, Tina Martins and Josh Turner are three employees who all work with both the IT
and finance departments and their records such as Employee Code, Employee First
Name and Employee Last Name are maintained in the records of both the IT and finance departments. Therefore, since the records are maintained in the databases of
multiple departments, it is a case of repeating groups.

This can cause problems when records need to be updated. For example, if Tina Martins gets married and changes her last name to Elton, this means that the records would need to be updated in the
databases of both the IT and finance departments. This not only results in a bigger effort,
but also is fraught with risks, as mistakes in any record updating could cause
major problems.

Advertisements

Related Terms

Latest Data Management Terms

Related Reading

Margaret Rouse

Margaret Rouse is an award-winning technical writer and teacher known for her ability to explain complex technical subjects to a non-technical, business audience. Over the past twenty years her explanations have appeared on TechTarget websites and she's been cited as an authority in articles by the New York Times, Time Magazine, USA Today, ZDNet, PC Magazine and Discovery Magazine.Margaret's idea of a fun day is helping IT and business professionals learn to speak each other’s highly specialized languages. If you have a suggestion for a new definition or how to improve a technical explanation, please email Margaret or contact her…