What Is Used to Prevebt Reading of Inconsistent Data in Dbms
The chief difference betwixt information back-up and data inconsistency is that data redundancy is a status that occurs when the same slice of data exists in multiple places in the database whereas data inconsistency is a status that occurs when the same data exists in dissimilar formats in multiple tables.
A database is a drove of information. DBMS (Database Management Arrangement) is a software that helps to manage databases. Introduced effectually the year 1960, it can handle a large collection of information. Moreover, information technology helps to create, think, update and delete information easily. DBMS allows multiple users to access information simultaneously and provides security to the data. Data redundancy and data inconsistency are two terms related to DBMS.
Primal Areas Covered
i. What is Data Back-up
– Definition, Functionality
2. What is Information Inconsistency
– Definition, Functionality
iii. What is the Divergence Between Data Redundancy and Information Inconsistency
– Comparison of Key Differences
Key Terms
Data Inconsistency, Data Back-up
What is Data Redundancy
Data redundancy refers to the same data located in multiple places in the database. It clusters the database with unneeded information. It also makes information retrieving less efficient. Furthermore, data redundancy consumes more resources in the database. Over time, information back-up makes database abuse, causing the information to be unusable.
For instance, assume a table in the school database. It has a table chosen student as follows.
The pupil one and 2 are learning from teacher P, and educatee iii and four are learning from instructor Q. Here, the teacher_id and teacher_name repeats twice. Instead, the teacher_id and teacher name can exist stored into a split up tabular array. New pupil tabular array and the teacher table are equally follows.
The solution is to data back-up is normalization. It reduces information redundancy and makes data more meaningful.
What is Data Inconsistency
Data inconsistency refers to a situation of keeping the same data in different formats in two dissimilar tables or a situation where it requires to friction match the data between tables. However, this can cause one tabular array in the database to accept the right value and the remaining tables to be different. It can likewise cause unreliable and meaningless information. Moreover, it is hard to reduce information inconsistency.
For instance, presume a hospital database. Irresolute the address of one patient can affect many other tables. Only 1 record will have correct information while the others will have fake data. Hence, this is data inconsistency. It causes the infirmary management to cheque multiple records to obtain the right patient address. It happens because the same data residing in multiple places are not updated. Using adequate constraints inside the database is a solution to forestall information inconsistency.
Relationship Between Data Redundancy and Information Inconsistency
- Data redundancy can cause data inconsistency.
Difference Betwixt Data Redundancy and Data Inconsistency
Definition
Data redundancy is a status that occurs within a database or data storage applied science in which, yous can find the same piece of data in two or more separate places. Whereas, information inconsistency is a condition that occurs between tables when nosotros proceed similar information in different formats in two different tables, or when matching of data between tables is a must. These definitions, thus, explicate the main deviation between data redundancy and information inconsistency.
Prevention
Prevention is the other main deviation betwixt data redundancy and information inconsistency. Normalization helps to minimize information redundancy. Nevertheless, using constraints on the database helps to prevent data inconsistency.
Conclusion
In general, information redundancy and data inconsistency are two terms related to DBMS. The main difference between information redundancy and data inconsistency is that data redundancy is a condition that occurs when the same piece of information exists in multiple places in the database whereas data inconsistency is a status that occurs when the same data exists in different formats in multiple tables.
Reference:
i. "What Is Information Redundancy?" Reference, IAC Publishing, Available here.
2. "What Is the Definition of Information Inconsistency?" Reference, IAC Publishing, Available here.
Image Courtesy:
1. "1954920" (CC0) via Pixabay
Most the Writer: Lithmee
Lithmee holds a Available of Science degree in Computer Systems Technology and is reading for her Master's degree in Figurer Science. She is passionate nearly sharing her knowldge in the areas of programming, data science, and computer systems.
Source: https://pediaa.com/what-is-the-difference-between-data-redundancy-and-data-inconsistency/
0 Response to "What Is Used to Prevebt Reading of Inconsistent Data in Dbms"
إرسال تعليق