Saturday, August 29, 2009

Data Warehouse VS OLTP

Data Warehouse V’s OLTP
Enterprise Data Warehouse Traditional Database
Integrated Data Application-specific Data
Current/Historical Data Current Data
Organized by Subject Organized for Data Entry
Non-Volatile Data Updated Data
Denormalized Data Normalized Data
Descriptive Data Encoded Data
Detailed/Summarized Data Raw Data
Knowledge user (Manager) Clerical User

No comments: