Differences between the Operational System and the Data Warehouse

Data in Operational System

• High volume, detailed
• High update frequency
• Record oriented, optimized for performance
• Current data only
• Internal data of one application

Data in a Data Warehouse

• Medium volume, summarized
• Low update frequency (daily, weekly)
• optimized for queries, accessible for analysis
• Past and present data
• Used for several application (OLAP, DSS,...)

Index: Contents