← go back

Backend ODD#12 ODD#13

❐ copy the link

Recommendation : 1. Reduce the impact of data from its storage and access

Is an alternative to the relational model being considered ?

Advice

Data

C People

B Planet

B Prosperity

Difficulty

N/A

Priority

Récurrence

Tests

Is a NoSql solution in place?

Precisions

Relational DBMS models offer efficient solutions for managing highly segmented data structures, but on the other hand these DBMS engines are more resource intensive. Alternative models may be more efficient (NoSQL) for certain categories of usage.

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 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 ?

➞