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 queries10 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