# 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