Q:

What is data integrity testing?

A:

Quick Answer

Data integrity testing refers to a manual or automated process used by database administrators to verify the accuracy, quality and functionality of data stored in databases or data warehouses. This test is regularly done by administrators to ensure that stored data has remained unaltered and to discover system design bugs that could compromise the files in a database.

Know More
What is data integrity testing?
Credit: Erik Isakson Blend Images Getty Images

Full Answer

Data normally undergoes modifications, especially when it is migrating from an old database into a new database architecture. Administrators test the data to ensure that it has remained unaltered and free from corruption during migration. They also test data to ensure that it is compatible with different versions of computer operating systems and hardware.

There are numerous automated tools available to test data integrity, and these tools commonly check if the stored data in data tables can be edited, saved and deleted. These tools also check if data in a given application functions as intended.

According to Agile Data, testing data accuracy is crucial to any business, especially companies that keep large databases. They need to maintain a consistently accessible data bank and risk system downtime if they do not conduct routine data checks. These companies usually employ a dedicated team of database administrators that primarily tests databases for errors to improve the system.

Learn more about Software

Related Questions

  • Q:

    What is regression testing?

    A:

    Regression testing ensures that the changes made to software and applications do not impact the overall functionality of these resources. These operations involve a formulaic set of various tests designed in sequence to ensure all operations are normal. This is an integral part of software development and quality control.

    Full Answer >
    Filed Under:
  • Q:

    What is the purpose of a database?

    A:

    A database is used to collect and organize data. Although an electronic version such as one created in Microsoft Access may be the first that comes to mind, there are many non-automated database versions as well, such as a personal phone and address book.

    Full Answer >
    Filed Under:
  • Q:

    What are the uses of database management systems?

    A:

    Database management systems, or DBMSs are computer programs that facilitate the systematic management and creation of databases by allowing end users and other applications to freely interact with the database. The DBMS guarantees that the database is organized constantly and accessible quickly to enable the storage, modification and extraction of data.

    Full Answer >
    Filed Under:
  • Q:

    How secure is the SSN database?

    A:

    The Social Security Administration uses validation certificates and two-factor authentication technology to secure access to their databases. Its internal security measures are not published, but none of the 10 major federal data breaches in 2014 involved the Social Security Administration.

    Full Answer >
    Filed Under:

Explore