Difference between OLTP and OLAP

OLTP: Online transaction processing

1. OLTP is transaction process.
2. It is time sensitive.
3. Operator view.
4. Normalized efficient design for TP.
5. organized by transaction (order, inventory).
6. It is relatively smaller database.
7. Many concurrent users.
8. Volatile data.
9. Stores all data.
10. Efficiency

OLAP: Online analytical processing

1. OLAP is query processing.
2. it is history oriented.
3. Managerial view.
4. Denormalized design for query processing.
5. organized by subject (customer, product).
6. it is a large database size.
7. relatively few concurrent users.
8. non volatile data.
9. stores relevant data.
10. effectiveness.

For more info on this topic goto LINK