Monday 24 October 2011

Week 6 Progress - Knocking the Door! [PART 2]

Assalamualaikum..
Just want to update my research background..


Data is a collection of facts which play a critical role in the business operation for any organizations whether it is big or small organization. It is like an engine for a car. Without the engine, the car can't move. The same goes to the data. Without data, organization may suffer a lot of problems. In the information technology era, the usage of database management systems becomes wider. In the same time, the data growth rate is rapidly increasing. Nowadays, business processes are operating 24x7 and the availability of data must be there in order to support the daily operations.

Data corruption or data loss may lead to several problems. Business processes may be interrupted, inconsistent data and etc. There are a lot of causes why the data may loss. For example, hardware and system malfunction, human error, and also natural disaster. According to ONTRACK Data Recovery, Inc. (1995), their experience in the ONTRACK Data Recovery professional labs, the threats to the data integrity which is human error contribute to 32% chances of data loss. The result shows that, errors by human are occur frequently. The errors by human may be done on purpose or accidentally. After they commit the transaction, it must be rolled back on order to correct the problem. Regarding to the inconsistency state of the database, the corrective action must be taken in order to put the database back to the consistent state.

Corrective action means the process to take an action regarding to the product's problem, customer complaints, or other nonconformities and fix them up. Oracle stated that committing a transaction means making a permanent changes which is performed by the SQL statement that is executed within the transaction. Meanwhile, unauthorized committed database transaction means that the transaction was committed by the users with the legal authentication but doing something that may change the content of the database accidentally or purposely.

The corrective action involve in the database level of the information system and may also include the process flow in the organization needed to be followed in order to implement the corrective action.

Corrective action is important to bring the database back to the consistency state because the data is the value of the organization. Losing data or information means losing the money. Therefore the policy of the corrective action is very essential in order to maintain the data availability.

As a result, there must be a corrective action plan in order to recover the faulty data in the context of using Oracle database. It may undo the operation and turn to the original value of data. Log management or audit trail play an important role of auditing and monitoring the operations that have been done. For example, updating the table in the database, creating the table, and etc.


Feel free to leave any comments, thank you. 
P/S : posting the blog in sleepy mode, something may go wrong. 

No comments:

Post a Comment