Data Warehouse vs. Operational DBMS

• OLTP (on-line transaction processing)

  • Major task of traditional relational DBMS
  • Day-to-day operations: purchasing, inventory, banking, manufacturing, payroll, registration, accounting, etc.

• OLAP (on-line analytical processing)

  • Major task of data warehouse system
  • Data analysis and decision making

• Distinct features (OLTP vs. OLAP):

  • User and system orientation: customer vs. market
  • Data contents: current, detailed vs. historical, consolidated
  • Database design: ER + application vs. star + subject
  • View: current, local vs. evolutionary, integrated
  • Access patterns: update vs. read-only but complex queries

Previous slide

Next slide

Back to first slide

View graphic version