OLTP: Applications where large number of users make large number
(millions) of transactions
Transaction - small, discrete, unit of work (Ex: Transfer money to your friend's
account)
Heavy writes and moderate reads
Quick processing expected
Use cases: Most traditional applications - banking, e-commerce, ..
Cloud Managed Services:
AWS: Amazon RDS (PostgreSQL/MySQL/MariaDB/Oracle/SQLServer), Amazon
Aurora
Azure: Azure SQL Database (SQL Server), Azure Database for
MySQL/PostgreSQL/MariaDB
Google Cloud: Cloud SQL (MySQL/PostgreSQL/SQL Server), Cloud Spanner