DataBase Selection Strategy for DryBean
Dec 3, 2021
This is a documentation to select the appropriate database for the DryBean project.
- RDBMS :
Pros : 1) Normalisations which makes data non-redundant in the tables.
2) Always available data.
3) Consistent Data
Cons :
- No Partition Tolerance — NOT PREFERRED.
2. Cassandra / DynamoDb / CouchDb / Riak :
Prons :
- High availablility of data
- Higher partition tolerance
Cons:
- No Consistency — Thats Alright to be compromised.
3. MongoDb/HBase/Redis :
Pros:
- More consistency and tolerance
Cons :
- no Avialability — NOT PREFERRED.FINAL CONCLUSION : Cassandra / Riak / CouchDb is preferred for this requirement.