Recommendation : 1. Reduce the impact of data from its storage and access
Does the data have an expiration date when it is deleted ?
How often are expiration dates checked?
The specifications reveal data collections of asynchronous procedures or periodic tasks essential for the proper functioning of the service. These elements are most often invisible and in the absence of explicit specifications of the withdrawal process they are rarely taken into account for the purposes of operating a service. Each of these elements should carry its own end-of-life information.
Rule for assessing the level of compliance of the criterion
Formalized = 100 ; Planned = 75 ; Identified = 50 ; Ignored = 0 / 100
Fin de Vie
19 other criteria related to the recommendation: Reduce the impact of data from its storage and access
Is the number of requests kept to a minimum (no looping) ?
Is an alternative to SQL queries used when possible (local storage or similar) ?
Do implemented queries use joins rather than multiple queries ?
Can data be backed up incrementally ?
Is the removal of obsolete data being managed ?
Are database indexes consistent with operations ?
Is an alternative to the relational model being considered ?
Is a NoSql solution more efficient than its relational equivalent ?
Have the different data access solutions (queries, triggers, stored procedures) been tested ?
Are EXPLAIN clauses used on "Slow queries" to optimize indexes ?
Are the slow query detection thresholds set effectively ?
Are "live" and "dead" data handled differently (eg: Slow storage for "dead" data) ?
Is frequently accessed data available in RAM ?
Are data replications between multiple Database Engine (Cluster) instances appropriate for sensitivity and availability requirement ?
Is sensitive data collected ?
Is the data collected really useful ?
Does the API provide limits, filters and the list of fields to return ?
Is sensitive user data secure ?
Does regulated data (personal, health, financial) comply with the recommendations for structuring these categories of data ?