> For the complete documentation index, see [llms.txt](https://vikram-bajaj.gitbook.io/cs-gy-6083-principles-of-database-systems/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://vikram-bajaj.gitbook.io/cs-gy-6083-principles-of-database-systems/oltp-olap-and-data-mining.md).

# 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