Please enable JavaScript.
Coggle requires JavaScript to display documents.
Implement Data Storage Solutions - Coggle Diagram
Implement Data Storage Solutions
Implement RD stores
RD features
tables have relationships between them
data stored in tables
every row has a primary key
tables linked via foreign keys
Columnar format
RD Limitations
Can't delete data with dependencies
Queries require multi-table look-ups
Model/Schema can grow complex
Harder to shard, scale and archive due to high dependency
+/-
better for fewer users
doesn't hyper scale
fragile
compute intensive
RDBenefits
Enforces integrity
Normalization
Enforces standard schema & rules
Established
Implement Non-RD (NoSQL) stores
Non RD Features
No relationships enforced by db
R/ships will be enforced by app
Non tablular format
Document (e.g. JSON)
Graph
Key-value
Column family
Non-RD Limitations
schemaless = missing data
no normalization = duplication
duplications may cause inaccuracies & conflicts
a lot of features provided by RD engine not available
stored procedures, functions, views etc
Non RD Benefits
No joins, faster reads
adding new properties easy
More flexible for devs
Easier to shard & Scale
Diff models for diff use cases
Azure Options
Cosmos DB
Data Lake Storage Gen 2
Blob Storage
Binary Large
OB
ject
Container metaphor
puts blobs in containers
weak folder system but not hierarchical
file name = key
file contents = data
Redis & HBase in HD Insigh
Manage Data Security