Rule Definition
One main source of data corruption within applications comes from lack of compliance to data modification rules defined for an application. These rules are usually related to the use of specific procedures for update/insert/delete, a specific API or a data layer that is fully tested to maintain data integrity. The creation of new, different update/insert/delete procedures and functions that do not make use the existing tested code is at origin of many data corruption cases.
Remediation
try to reduce the sources having data update on the same table.
Violation Code Sample
DML syntax supported for udpate statements detection:
udpate CAST_INSERT set ....
udpate CAST_INSERT with
#sql{
udpate CAST_INSERT I1
set ......
};
execute update for CAST set .....;
Reference
Standard suggestions based on CAST Quality Model
Related Technologies
Technical Criterion
CWE-1060 - Excessive Number of Inefficient Server-Side Data Accesses
About CAST Appmarq
CAST Appmarq is by far the biggest repository of data about real IT systems. It's built on thousands of analyzed applications, made of 35 different technologies, by over 300 business organizations across major verticals. It provides IT Leaders with factual key analytics to let them know if their applications are on track.