In the era of information technology, almost all the organization needs the database to store and manage their large pool of data and information, in an organized manner, to carry out or perform certain specific multiple operations, with the ease.
A database is the pool of collected data and information interrelated to each other and stored in an organized manner, so as to access, retrieve, manage and update it, easily. A most common type of database, used by the organization is the relational database, where data are structured in such a way that they may be rearrange or reassemble in various ways, to gain multiple views of the data, based on the need and the requirement, without affecting the other existing data.
Data Integrity, it is the property of a database, which ensures the accuracy and consistency of the data. It reflects the quality of the data, being stored in a database.
Testing the integrity of a database refers to the evaluation of all sorts of processes, operations and methods, used in accessing, managing and updating the database, whereas data integrity testing focuses on the accuracy and consistency of the stored data, so that these data produces out expected or desired results.
The basic purpose behind testing the database integrity is to assess that how correctly and consistently the data is accessed, processed and updated or manipulated, using certain methods. Further, it is used to validate that the data is not corrupted, lost, modified, added, etc. unexpectedly, while accessing the database.
The need of testing a database may be described through following given requirements:
The integrity of a database may evaluated by testing the different types of integrity, present in a database, as given below
The data integrity of a database may be tested by carrying out the following activities:
Further, the results of the data integrity may be enhanced by making use of the specific automated tools, as it will be preferable to constantly test the database and data integrity, after some specific period of time, regularly, keeping in view of the volatile nature of the database. These automated tools helps in reducing the efforts and time required in frequently and regularly testing the database & data integrity.
In view of the above, it may be stated that testing the integrity of the data, is the only proven method to ensure the consistency, completeness and accuracy of the data, throughout the life cycle.