Skip to content
FR EN

Handbook of Sustainable Design of Digital Services

MENU
← go back
Backend    ODD#12     ODD#13    

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

Advice 

Data processing

B People

C Planet

B Prosperity

Difficulty

N/A

Priority

/

Récurrence

/

Tests

How much of the regulated data is used?

Precisions

The regulatory framework for certain categories of data is very strict, and protection of this data is an important criterion. It is essential that in the development process no gaps are left and that interoperability with standard mechanisms in these areas is validated.

Additional elements

Rule for assessing the level of compliance of the criterion

0 / 0

Life cycle

Déploiement

19 other criteria related to the recommendation: Reduce the impact of data from its storage and access

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 ?