Data Reduncy and other Database Management Issue - Essay Example

Is a condition created within a database or data storage technology In which the same piece of data Is held In two separate places. Or In the case of a flat file database, there are records with partly duplicated data. For example Jones, 48, Male, Teacher Jones, 48, 3 Advent Drive Jones, employee number 22345 As you can see in the records above, the name is repeated three times and the age is duplicated twice. Whenever data is repeated, this basically constitutes data redundancy.

We Will Write A Custom Essay Sample On

For Only $13.90/page

order now

This can occur by accident, but is also done deliberately for backup and recovery purposes. What Is Data Inconsistency Data Inconsistency Is when different and conflicting versions of the same data appear In different places In a database. This causes unreliable Information, because It Is difficult to determine which version of the Information Is correct. It’s difficult to make correct and timely decisions if those decisions are made based on conflicting information. Consistency talks about ensuring that any transaction will bring the database from one valid state to another.

Any data written to the database must be valid according to all defined rules. Data inconsistency is likely to occur when there is data redundancy. That’s why one major goal of good database design is to eliminate data redundancy. For example, in a banking transaction that debits a savings account and credits a checking account, a failure must not cause the database to credit only one account, which would lead to inconsistent data. Atomicity of update Atomicity Is a feature of databases systems dictating where a transaction must be all- or-nothing.

When an update occurs to a database, either all or none of the update becomes available to anyone beyond the user or application performing the update. This update to the database Is called a transaction and It either commits or aborts. This means that only a fragment of the update cannot be placed into the database. The transaction must either fully happen, or not happen at all. It must not complete partially. If one part of the transaction fails, the entire transaction fails. For example, if a transaction starts updating 100 rows, but the system fails after 20 updates, then he database rolls back the changes to these 20 rows.

Concurrent access to Data Data concurrency means that many users can access data at the same time. It is the ability to gain admittance to a system , component or data by more than one user or process. Multiple users who access a resource at the same time are said to be accessing the resource concurrently. For example, concurrent access to a computer means multiple users are Interacting with the system simultaneously. Concurrent access to a hardware component, such as a memory chip or memory bank.