OLTP, OLAP, and Data Mining

Online Transaction Processing

• It deals with simple queries that update data

• The focus is on data consistency, data protection and throughput

• Ex. bank account transactions

Online Analytical Processing

• It deals with complex queries to explore data

• The focus is on the performance of the complex queries

• Ex. finding total sales listed by product or region

Data Mining

• It deals with finding interesting patterns in data

• It can also be used to find rules or exceptions to rules and to make the data tell a story