OLTP
- strong consistency
- for reading large amounts of data quickly (column-by-column)
- High-speed transactional apps OLAP
- Aggregating and summarizing large datasets
- eventual consistency
- Limited rollback capabilities
- Not suited for systems that need to constantly write small changes
- optimized for large, complex queries run occasionally, not many small fast queries.
- Insert/update operations generally are batch-oriented and expensive.