OLTP
- Transactional processing
- Need to update what is happening
- High volume of small transactions
- Fast access
- Normalised DB
- De-duplication
- Other things, basically things need to fit in a table
- ACID
OLAP
- Analytical Processing
- Large data volume
- Historical data
- Mainly read only
- 202404261931 Azure Data warehouse and analytics
references:
Subscribe to NordLetter
A weekly newsletter on living in Finland.