What is data integrity testing?

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.

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.

Q&A Related to "What is data integrity testing?"
Data integrity is having the integrity to use private information correctly. Data integrity should be use on the internet but when it is not it can be a pain if your personal info
http://www.ask.com/web-answers/Computers/Networkin...
1. Purchase software programs with coding that identifies data issues as they occur. Create program rules that allow auto-correction and "if then" coding so accurate data
http://www.ehow.com/how_8150810_manage-data-integr...
By restoring part of the backup.
http://wiki.answers.com/Q/How_should_a_company_tes...
If you were looking at an informal definition, Data Integration (DI) involves aggregating different sources of data and combining them in a meaningful way. And why would one need
http://www.quora.com/Data-Integration/What-is-Data...
Explore this Topic
The term 'Data integrity' in Microsoft Access refers to ensuring that the data entered is valid. Relationships in the tables need to be defined and the data entered ...
Alphanumeric data entry is when a person enters information into an electronic system that is organized both by the alphabet and by number. A test that is designed ...
Data consistency is the validity, accuracy, usability and integrity of related data between applications and across the IT enterprise. Data Consistency problems ...
About -  Privacy -  Careers -  Ask Blog -  Mobile -  Help -  Feedback  -  Sitemap  © 2014 Ask.com