Q:

What are the disadvantages of data redundancy?

A:

Quick Answer

Disadvantages of data redundancy include an unnecessary increase in size of databases, and the likelihood of data corruption being a direct result of redundancy. Other disadvantages include the likelihood of inconsistency of data as well as decreased efficiency of a database.

 Know More

Full Answer

Data redundancy is a very common attribute of the modern computer database. Fundamentally, it is a repetition of data within a database. It can appear within a table as repeated data, or it can appear by itself. It is typically not something that the programmer intended to be part of the system, however, it is a by-product of programming without forethought.

Data redundancy can occur in databases that list clientele and customer information. If a customer gives information two separate times during two separate visits, now the customer's information is entered twice in the database and all fields are duplicated. If the system is smart enough to catch repeated information, then the customer's name will only exist one time in the system. A name could also appear several times if a customer visits separate locations of the same chain store. If the databases are not synced well with one another, duplication could occur. Too many instances of extra data such as this can lead to an overloaded hard drive due to the excessive backup of useless data.

Learn more about Internet & Networking
Sources:

Related Questions

  • Q:

    What are the advantages of DBMS?

    A:

    A database management system (DBMS) offers several advantages, such as preventing redundancy of data and improvement in data security. DBMS reduces the costs associated with the retrieval of data.

    Full Answer >
    Filed Under:
  • Q:

    What is the definition of "meta search engine"?

    A:

    A meta search engine is a search engine that searches other search engines and databases to provide a variety of results. It gives the user the ability to enter a search once and receive results from multiple sources.

    Full Answer >
  • Q:

    What is FilesTube?

    A:

    FilesTube functions as a metasearch engine, which allows users to look for files in several search engines and databases simultaneously and view the results on a single page. FilesTube searches for its content on file-sharing and uploading services on which users share music, movies, games, e-books and software. The main FilesTube page lists the latest trending files and provides direct links for downloads.

    Full Answer >
  • Q:

    How do you set up a business website?

    A:

    Build, create and maintain a business website to make your business more visible to potential clients and increase sales. A great business website is easy to use, features company products and remains relevant to search engine optimization practices.

    Full Answer >

Explore