Data Integrity Risks from External Systems
Where applications replicate or update data with external sources such as relational database systems, changes to applications must be tested extensively with realistic data. If done incorrectly, small changes to applications can have catastrophic effects on data integrity. Such situations require:
- Defined processes for analyzing and assessing whether data integrity requirements have been met
- Detailed rollback plans including plans for how to restore integrity of existing data and new data created post-deployment
- Coded and tested rollback functionality, if applicable
- Documented process for determining if the planned rollback can successfully restore data integrity
- Identification of parties responsible for decision making in the event that roll-backs or other drastic actions are required
Category Data Management Risk