OLTP, OLAP
OLTP (On-Line Transaction Processing)
This system is an application that modifies data the instance it receives and has a large number of concurrent users
OLAP (On-Line Analytical Processing)
This system is an application that collects, manages, processes and presents multidimensional data for analysis and management purposes
Different types of OLAP
- ROLAP
- MOLAP
- DOLAP
- HOLAP
OLTP vs OLAP
OLTP
- Current data
- Short database transactions
- Online Insert/Update/Delete
- Normalization is promoted
- Simple quick running queries ran by users
- High volume transactions
- Transaction recovery is necessary
OLAP
- Current and Historical data
- Long database transactions
- Batch Insert/Update/Delete
- Denormalization is promoted
- Complex long running queries by system to update the aggregated data
- Low volume transactions
- Transaction recovery is not necessary