Data inconsistency occurs when similar data is kept in dissimilar formats in more than than one file. When this happens, it is important to match the data betwixt files. Sometimes, files duplicate some data. When data like names and addresses are duplicated, it may pb to a compromise in information integrity.
What Is Data Integrity?
Information integrity occurs when the data in a database are consequent. Every organization relies on data integrity to ensure that they have reliable and accurate data. The information must also be consistent with real-globe events.
When an system has strong information integrity, the data represents real data. For case, information technology provides accurate information about a patient'due south accost and phone number subsequently they have moved.
Information Inconsistency Is Caused By Redundancy
Redundant data is a problem considering it can create unreliable data. I person may change the value in 1 file merely not in another file. This is a problem for companies that rely on accurate data.
Let's say that a infirmary has a organisation for file processing, but several files for 1 patient are kept separately. If a professional changes the patient'south accost in one file but not in any others, the patient'south bill, or insurance information could be sent to the wrong destination. If you lot do not take the correct phone number on each file, you may find yourself running into problems regarding which i to phone call.
How to Prevent Information Redundancy
Several methods tin prevent data back-up. For 1, planning improve structures for databases tin forbid data from beingness present in several files. In some cases, this is not possible. Normalizing a database is the next step. The process involves cleaning upwards the tables in the database.
The goal of preventing data redundancy is to ensure that data is in ane place. It is not scattered throughout the database.
Sometimes an organization tries to normalize a database. They may non exist able to make clean up all the redundant data. When this happens, i may run across a data anomaly.
Human Mistake
Sometimes, the system needs to step in and ensure that employees are trained properly. Data input can be catchy, and untrained employees may non realize they are adding new information rather than irresolute quondam information.
How to Prevent Data Inconsistency
People arroyo data inconsistency in two ways. One way to fix the problem is through central semantic storage. This requires a lot of logging and storing rules. It also involves creating a central expanse for information. The process tin can be hard.
You can also employ the master reference store approach. This process seeks to centralize the data. This ways that in that location are strict rules about where the database stores information. The goal of this approach is to have more command over important data. Information technology may require more resources than other methods.
Every organization wants its data to be accurate and reliable. From insurance companies to tech companies, organizations all across the land need to know the information they have collected is useful.
DOWNLOAD HERE
Posted by: bettyarde1937.blogspot.com
Post a Comment