Home » Database Management System » Atomicity and Security Problems

Atomicity and Security Problems

Atomicity Problem:

When you perform an operation on data, it may consist of different steps. A collection of all steps required to complete a process is known as transaction. The atomicity means that either one transaction should take place as a whole or it should not take place at all. Suppose you want to transfer money from account A to account B. This process consists of two steps:
1. Deduct the money from account A.
2. Add the money to account B.

Suppose that the system fails when the computer has performed the first step. It means that the amount has been deducted from account A but has not been added to account B. This situation can make your data inconsistent. File processing system does not provide the facility to ensure atomicity of data.

Security Problems:

File processing system does not provide adequate security on data. In some situations, you may want to provide different types of access permission to data for different users. For example, a data entry operator should only he allowed entering data. The chairman of the organization should be able to access or delete the data completely. Such types of security options are not available in file processing system.


Other Topics

    comment closed

    Get Adobe Flash playerPlugin by wpburn.com wordpress themes
    Copyright © 2010 Information Village. All rights reserved.