Avoid having multiple artifacts updating data on the same SQL table (EGL) | CAST Appmarq

Avoid having multiple artifacts updating data on the same SQL table (EGL)


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

Health Factor

  Total Quality Index


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.

Benchmark Statistics

Global Compliance

nan%

Total Violations
0
Total Opportunities
0
Average Violations / App.
nan
The compliance score represents 1 minus the ratio between the number of times a rule has been violated compared to the number of opportunities in a set of applications that the rule could have been violated.

Industry Insights