Q:

What are the disadvantages of data redundancy?

A:

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 in Internet & Networking
Sources:

Related Questions

  • Q:

    How does the Trojan Horse virus infect a computer?

    A:

    A Trojan virus works by obtaining unauthorized access to a computer's hard drive with the intent of causing loss or theft of data. Once the virus infects a computer it can block access to programs or information, copy data or even cause a disruption in performance.

    Full Answer >
    Filed Under:
  • Q:

    How do wireless modem routers work?

    A:

    Wireless modem routers use radio frequency waves to receive data from the Internet or a network and to send data to personal computers. Routers use the same technology as radio, television and mobile phone networks through the use of modem and Ethernet cables. Once a wireless router is properly configured, it can send large amounts of data to multiple computers within a single home or work network.

    Full Answer >
    Filed Under:
  • Q:

    What is the main purpose of the Internet?

    A:

    The main purpose of the Internet is to provide global access to data and communications. Use of the Internet and networking is essential for advancing research in science, medicine, engineering and design as well as in maintaining global defense and surveillance. With better access to microcomputing, the Internet also fosters a global workforce and users provides access to wider cultural contexts.

    Full Answer >
    Filed Under:
  • Q:

    What are the six elements in an information system?

    A:

    The six key elements or functions of an information system are to capture data, transmit data, store data, retrieve data, manipulate data and display data. Information systems are usually computerized and provide management and employees with timely information concerning an organization's performance.

    Full Answer >
    Filed Under:

Explore