OLTP - Operational Database
Online Transaction Processing
More on day-to-day transactions Purpose: Support daily transactions Design: Application-oriented Data: Up-to-date, operational Size: Snapshot, gigabytes Queries: Simple transactions & frequent updates Users: thousands
OLAP - Data Warehouse
Online Analytical Processing
More on overall decision making Purpose: Report and analyze data Data: Subject-oriented Design: Consolidated, historical Size: Archive, terabytes Queries: Complex, aggregate queries & limited updates Users: Hundreds