Difference between OLTP and DWH

OLTP system is basically application orientation (eg, purchase order it is functionality of an application) Where as in DWH concern is subject orient (subject in the sense customer, product, item, time)

OLTP

• Application Oriented
• Used to run business
• Detailed data
• Current up to date
• Isolated Data
• Repetitive access
• Clerical User
• Performance Sensitive
• Few Records accessed at a time (tens)
• Read/Update Access
• No data redundancy
• Database Size 100MB-100 GB

DWH

• Subject Oriented
• Used to analyze business
• Summarized and refined
• Snapshot data
• Integrated Data
• Ad-hoc access
• Knowledge User
• Performance relaxed
• Large volumes accessed at a time (millions)
• Mostly Read (Batch Update)
• Redundancy present