DZone
Thanks for visiting DZone today,
Edit Profile
  • Manage Email Subscriptions
  • How to Post to DZone
  • Article Submission Guidelines
Sign Out View Profile
  • Post an Article
  • Manage My Drafts
Over 2 million developers have joined DZone.
Log In / Join
Refcards Trend Reports
Events Video Library
Over 2 million developers have joined DZone. Join Today! Thanks for visiting DZone today,
Edit Profile Manage Email Subscriptions Moderation Admin Console How to Post to DZone Article Submission Guidelines
View Profile
Sign Out
Refcards
Trend Reports
Events
View Events Video Library
Zones
Culture and Methodologies Agile Career Development Methodologies Team Management
Data Engineering AI/ML Big Data Data Databases IoT
Software Design and Architecture Cloud Architecture Containers Integration Microservices Performance Security
Coding Frameworks Java JavaScript Languages Tools
Testing, Deployment, and Maintenance Deployment DevOps and CI/CD Maintenance Monitoring and Observability Testing, Tools, and Frameworks
Culture and Methodologies
Agile Career Development Methodologies Team Management
Data Engineering
AI/ML Big Data Data Databases IoT
Software Design and Architecture
Cloud Architecture Containers Integration Microservices Performance Security
Coding
Frameworks Java JavaScript Languages Tools
Testing, Deployment, and Maintenance
Deployment DevOps and CI/CD Maintenance Monitoring and Observability Testing, Tools, and Frameworks

Integrating PostgreSQL Databases with ANF: Join this workshop to learn how to create a PostgreSQL server using Instaclustr’s managed service

Mobile Database Essentials: Assess data needs, storage requirements, and more when leveraging databases for cloud and edge applications.

Monitoring and Observability for LLMs: Datadog and Google Cloud discuss how to achieve optimal AI model performance.

Automated Testing: The latest on architecture, TDD, and the benefits of AI and low-code tools.

Related

  • Automating Database Operations With Ansible and DbVisualizer
  • Database Monitoring: Key Metrics and Considerations
  • Resolving Log Corruption Detected During Database Backup in SQL Server
  • Build Quicker With Zipper: Building a Ping Pong Ranking App Using TypeScript Functions

Trending

  • Agile Metrics and KPIs in Action
  • Memory Management in Java: An Introduction
  • Effective Tips for Debugging Complex Code in Java
  • How To Verify Database Connection From a Spring Boot Application
  1. DZone
  2. Data Engineering
  3. Databases
  4. What Is Data Redundancy?

What Is Data Redundancy?

When you start compiling true big data sets, having redundant records is a massive headache. Read on to learn how to avoid redundancy.

Garrett Alley user avatar by
Garrett Alley
·
Feb. 04, 19 · Analysis
Like (3)
Save
Tweet
Share
22.32K Views

Join the DZone community and get the full member experience.

Join For Free

Data Redundancy Explained

Data redundancy occurs when the same piece of data is stored in two or more separate places. Suppose you create a database to store sales records, and in the records for each sale, you enter the customer address. Yet, you have multiple sales to the same customer so the same address is entered multiple times. The address that is repeatedly entered is redundant data.

How Does Data Redundancy Occur?

Data redundancy can be designed; for example, suppose you want to back up your company’s data nightly. This creates a redundancy. Data redundancy can also occur by mistake. For example, the database designer who created a system with a new record for each sale may not have realized that his design caused the same address to be entered repeatedly. You may also end up with redundant data when you store the same information in multiple systems. For instance, suppose you store the same basic employee information in Human Resources records and in records maintained for your local site office.

Why Data Redundancy Can Be a Problem

When data redundancy is unplanned, it can be a problem. For example, if you have a Customers table which includes the address as one of the data fields, and the John Doe family conducts business with you and all live at the same address, you will have multiple entries of the same address in your database. If the John Doe family moves, you'll need to update the address for each family member, which can be time-consuming, and introduce the possibility of entering a mistake or a typo for one of the addresses. In addition, each entry of the address that is unnecessary takes up additional space that becomes costly over time. Lastly, the more redundancy, the greater difficulty in maintaining the data. These problems — inconsistent data, wasted space, and effort to maintain data — can become a major headache for companies with lots of data.

How Data Redundancy Is Resolved for a Database

It’s not possible or practical to have zero data redundancy, and many database administrators consider it acceptable to have a certain amount of data redundancy if there is a central master field. Master data is a single source of common business data used across multiple systems or applications. It is usually non-transactional data, such as a list of customers and their contact information. The master data ensures that if a piece of data changes, you update the data only one time, which allows you to prevent data inconsistencies.

In addition, the process of normalization is commonly used to remove redundancies. When you normalize the data, you organize the columns (attributes) and tables (relations) of a database to ensure that their dependencies are correctly enforced by database integrity constraints. The set of rules for normalizing data is called a normal form, and a database is considered "normalized" if it meets the third normal form, meaning that it is free of insert, delete, and update anomalies.

How Data Redundancy Is Resolved Between Different Systems

But, what if you have data redundancy between multiple systems? For example, what if you have employee information stored in a departmental database, a Human Resources database, and a database for your site office? Many companies handle this by integrating their data and removing the redundancies when doing so. However, this can be a time-intensive process and can involve multiple steps, including designing the data warehouse and cleansing the data. If you're interested, see What is Data Integration? for more details about the process of data integration.

Data redundancy Database

Opinions expressed by DZone contributors are their own.

Related

  • Automating Database Operations With Ansible and DbVisualizer
  • Database Monitoring: Key Metrics and Considerations
  • Resolving Log Corruption Detected During Database Backup in SQL Server
  • Build Quicker With Zipper: Building a Ping Pong Ranking App Using TypeScript Functions

Comments

Partner Resources

X

ABOUT US

  • About DZone
  • Send feedback
  • Careers
  • Sitemap

ADVERTISE

  • Advertise with DZone

CONTRIBUTE ON DZONE

  • Article Submission Guidelines
  • Become a Contributor
  • Visit the Writers' Zone

LEGAL

  • Terms of Service
  • Privacy Policy

CONTACT US

  • 3343 Perimeter Hill Drive
  • Suite 100
  • Nashville, TN 37211
  • support@dzone.com

Let's be friends: