Skip to content
FR EN

Handbook of Sustainable Design of Digital Services

MENU

Family Backend |  6 recommendations - 72 criteria

Filters level 1 :

The backend represents the computer translation of business processes, the technical means and data implemented for their use, as well as all the external interactions implemented for their realization.

The Essentials  |  Level *  | Level * *  |  Level * * *

Filtered by :

Backend    ODD#12     ODD#13    

Recommendation Essential

Data

Is the number of requests kept to a minimum (no looping) ?

Advice

Data

Is an alternative to SQL queries used when possible (local storage or similar) ?

Recommendation

Data

Do implemented queries use joins rather than multiple queries ?

Advice

Data

Can data be backed up incrementally ?

Recommendation

Data

Is the removal of obsolete data being managed ?

Recommendation

Data

Are database indexes consistent with operations ?

Advice

Data

Is an alternative to the relational model being considered ?

Advice

Data

Is a NoSql solution more efficient than its relational equivalent ?

Advice

Data

Have the different data access solutions (queries, triggers, stored procedures) been tested ?

Advice

Data

Are EXPLAIN clauses used on "Slow queries" to optimize indexes ?

Advice

Data

Are the slow query detection thresholds set effectively ?

Recommendation

Data

Are "live" and "dead" data handled differently (eg: Slow storage for "dead" data) ?

Recommendation

Data

Is frequently accessed data available in RAM ?

Recommendation

Data

Are data replications between multiple Database Engine (Cluster) instances appropriate for sensitivity and availability requirement ?

Recommendation

Data processing

Does the data have an expiration date when it is deleted ?

Recommendation

Data processing

Is sensitive data collected ?

Recommendation

Data processing

Is the data collected really useful ?

Recommendation

Data processing

Does the API provide limits, filters and the list of fields to return ?

Recommendation

security

Is sensitive user data secure ?

Advice

Data processing

Does regulated data (personal, health, financial) comply with the recommendations for structuring these categories of data ?

Backend    ODD#9     ODD#12     ODD#13    

Recommendation Essential

Quality

Is the documentation of the functionality available to enable its reuse ?

Advice

Performance

Is the web server used asynchronous and multi-threaded ?

Advice

Performance

Has the dependency tree of the integrated components been evaluated ?

Advice

Performance

Can dependencies be reduced by using an alternative component ?

Advice

Performance

Is the user informed of a processing in progress in the background ?

Advice

Performance

Has the integration of asynchronous processing been evaluated ?

Recommendation

Performance

Are unused resources freed up as quickly as possible ?

Advice

Performance

Is a VM necessary as opposed to a container solution ?

Recommendation

Performance

Does service availability require redundancy ?

Recommendation

Architecture

Do interactions between components benefit from caching mechanisms ?

Recommendation

Architecture

Are the browser caches not being blocked by the framework or technology used ?

Advice

Architecture

Is there a lighter framework / library that meets the functional need ?

Advice

Architecture

Is an Open Source solution available for the functional need ?

Advice

security

Are the versions of the components used tracked and deployed ?

Recommendation

security

Is the security implemented justified with regard to the operations carried out ?

Advice

Data processing

Is the level of logs adapted to the environment ?

Recommendation

Data processing

Are temporary files included in the "logrotate" ?

Backend    ODD#10     ODD#12     ODD#13