Transaction Processing (OLTP) vs Analytic Processing (OLAP)

• Transaction Processing (OLTP) – Used to automate operations – Efficient for transaction processing – Inefficient for ad-hoc report generation – Requests for reports created by IT staff • Analytical Processing (OLAP) – Used for analysis – Data is a snapshot of company data at a point in time – Data stored in data warehouses – Data reorganized and structured in such a way that it was fast and efficient for querying, analysis, and decision support.