« Sneak Peek Analyzer template preview | Main| Data Integrity Audit »

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
Upgrades to applications that require data transformations pose similar risks and should be handled with the same level of care.

Category  

Post A Comment

Feeds

Custom Button Custom Button

Category Cloud

Disclaimer

The views expressed by the authors on this blog do not necessarily reflect the views of Teamstudio, those who link to this blog, or even the author’s mother, father, sister, brother, uncle, aunt, grandparents, cousins, step relations, any other blood relative - and sometimes not even the author himself or herself.

Comments on this website are the sole responsibility of their writers and it is assumed those writers will take full responsibility, liability, and blame for any libel or litigation that results from something written in, or as a direct result of something written in, a comment. The accuracy, completeness, veracity, honesty, exactitude, factuality and politeness of comments are not guaranteed. Oh, how they are SO not guaranteed.
en-us,en;q=0.5OFFCCBot/1.0 (+http://www.commoncrawl.org/bot.html)38.107.179.212www.getthemostfromnotes.comHTTP/1.180Lotus-Domino/tsblog.nsf/D6Plinks/KFRA-7TYQE6-Data-Integrity-Risks-from-External-Systems