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.

Continue Reading
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 a data warehouse?

    A:

    Data warehouses consist of relational databases that are programmed to provide responses to user queries. A data warehouses allows for the collection of data from a variety of sources into one location, and usually consists of historical or transaction information.

    Full Answer >
    Filed Under:
  • Q:

    What does data security refer to?

    A:

    Data security, also known as information security or computer security, refers to measures taken to protect the privacy of digital information, preventing unauthorized access to computers, websites and databases. Additionally, IT technicians apply data security safeguards to protect data from unexpected corruption.

    Full Answer >
    Filed Under:
  • Q:

    What is some information about the assessors online database?

    A:

    The assessors online database is a land parcel management and tax revenue billing, assessment and collection tool that enables state and municipal assessors, tax authorities and administrators to access property tax and building information digitally. Officials use this information for tax revenue activities for funding municipal operations.

    Full Answer >
    Filed Under:
  • Q:

    Where can you find a comprehensive database of pill marking images?

    A:

    WebMD provides a database of pill images with search functionality. The entry of any combination of markings, color, or shape returns images of all medications that fit the search criteria. Photos display both sides of each pill.

    Full Answer >
    Filed Under:

Explore