Please enable JavaScript.
Coggle requires JavaScript to display documents.
Database - Coggle Diagram
Database
Relational
Structured
Data
Tabular
(w/ rows and
columns, joins)
Structure doesn't
change
very often
ACID
(A)tomicity
- each Tx is
all or nothing
(C)onsistency
- database must be
consistent
before and after
the Tx
(I)solation
- Transactions do not affect each other
(D)urability
- committed data
wouldn't be lost
even after system failure
Used in Apps that require
higher accuracy
for Tx reads/writes
Google Cloud Platform
Cloud SQL
Managed Service -
~ MySQL
~ PostgreSQL
~ SQL Server
best for general purpose -
~ Web apps
~ ERP
~ CRM
~ eCommerce
~ SaaS apps
Automates
Storage Capacity
Management
Out of the box -
High Aavailability
Disaster Recovery
Automates
DB provisioning
Cloud Spanner
Globally
distributed
99.9999%
availability
best for -
~ RDBMS at large scale
~ HA
~ HTAP
use in -
~ global financial ledger
~ online gaming platform
~ supply chain inventory mgmt
Cloud-native
Bare Metal
e.g. lift and shift
Oracle workloads
to Cloud
to modernise
legacy apps
Non-relational
stores complex,
unstructured
data
Document-type
Google Cloud Platform
Firestore
Cloud-native
Backend-as-a-Service
Global
consistency
99.999%
availability
good for
~ large scale
~
complex hierarchical
data
use in -
~ mobile/gaming/iot
~ realtime dashboard
~ offline sync
~ personalisations
Key Value-type
Google Cloud Platform
Cloud Bigtable
Cloud-native
Serverless
Low-latency
workloads
wide-column store
at a large scale
good for -
~ heavy read/write
~ event-store
use in -
~ personalisation
~ adTech
~ fraud detection
~ trends and recommendations
Ideal for
Map-reduce
ops
compliant to open-source
HBase API standard
Apache Hadoop
Apache Beam
Apache HBase
Apache Spark
eventual consistency
handles data-structure
that changes frequently
for apps that handles
different kinds
of data
In-memory
Google Cloud Platform
Memory-store
~ fully-managed
~
Redis
&
memcached
~
sub-millisecond
access
use in -
~ caching
~ user session store
~ leaderboard
~ adTech
~ personalisation