Which Of The Following Is Incorrect In Terms Of Data Warehousing And Business Intelligence
Information inconsistency occurs when similar data is kept in different formats in more than ane file. When this happens, it is important to match the data between files. Sometimes, files indistinguishable some data. When information like names and addresses are duplicated, it may lead to a compromise in data 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 take reliable and accurate information. The information must also be consequent with existent-world events.
When an system has strong data integrity, the data represents existent information. For example, it provides accurate data about a patient'due south address and phone number afterwards they have moved.
Data Inconsistency Is Caused By Redundancy
Redundant data is a problem because information technology can create unreliable information. One person may modify the value in one file merely not in some other file. This is a trouble for companies that rely on accurate information.
Let's say that a hospital has a system for file processing, simply several files for 1 patient are kept separately. If a professional changes the patient'south address in one file simply non in any others, the patient's neb, or insurance data could be sent to the incorrect destination. If yous do not take the correct phone number on each file, you may find yourself running into problems regarding which ane to telephone call.
How to Forestall Data Redundancy
Several methods can forbid information back-up. For one, planning better structures for databases can prevent data from being present in several files. In some cases, this is not possible. Normalizing a database is the next step. The process involves cleaning upward the tables in the database.
The goal of preventing information back-up is to ensure that data is in one place. It is not scattered throughout the database.
Sometimes an arrangement tries to normalize a database. They may not be able to clean up all the redundant information. When this happens, one may see a data anomaly.
Human being Error
Sometimes, the organization needs to step in and ensure that employees are trained properly. Data input tin can be catchy, and untrained employees may not realize they are calculation new information rather than changing old information.
How to Prevent Data Inconsistency
People approach information inconsistency in two ways. One fashion to set the problem is through central semantic storage. This requires a lot of logging and storing rules. Information technology also involves creating a central area for information. The procedure can be difficult.
You can also use the primary reference store approach. This procedure seeks to centralize the information. This ways that there are strict rules nigh where the database stores data. The goal of this approach is to have more control over important data. It may require more than resources than other methods.
Every organisation wants its data to be accurate and reliable. From insurance companies to tech companies, organizations all across the country need to know the information they have collected is useful.
Which Of The Following Is Incorrect In Terms Of Data Warehousing And Business Intelligence,
Source: https://www.reference.com/world-view/definition-data-inconsistency-5bc80c9fd30c5f1a?utm_content=params%3Ao%3D740005%26ad%3DdirN%26qo%3DserpIndex
Posted by: grayvick1986.blogspot.com
0 Response to "Which Of The Following Is Incorrect In Terms Of Data Warehousing And Business Intelligence"
Post a Comment