Just for the additional knowledge. Before I changed my working title, the title is about 'Instance Recovery'. Based on this blog, instance recovery means the action that performed by the Oracle when the database is restarted after it suffered from the instance failure or shutdown abort or startup force.
Back to my working title "Corrective Action for Unauthorized Committed Database Transaction". For the progress, actually it is quite hard to find the corrective action taken by the companies in order to recover the inconsistency state of the database. On the Internet, there is an article from R. M. Baldwin, Inc. and the title is "Preventive/Corrective Actions (CAPA) Guidelines". CAPA is more focused on FDA, ISO 9000, Automotive and Aerospace industries. However, it is a good article for me to give brief explanation about what the corrective action is. According to the article, corrective action means the process to take an action regarding to the product's problem, customer complaints, or other nonconformities and fix them up. Corrective action may involved these processes:
- review & define problem
- find cause of problem
- develop action plan
- implement plan
- evaluate effectiveness of the correction
I will put the clearer picture on the CAPA later, in the next post insyaAllah.
REVISING THE PROBLEM STATEMENT AND RESEARCH BACKGROUND
Problem Statement : still waiting for the conformation from the PSMB
Research Background :-
What : 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.
Where : 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.
Why : 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.
That's all for my post this time. InsyaAllah there will be more from me. Thank you.
Assalamualaikum..
No comments:
Post a Comment