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

Last updated