How OLTP systems differ from Data Warehousing?

OLTP Systems

Data Warehousing

----------------------------------------------------------------------------------

Holds currnet data		Holds historical data
Stores detailed data		Stores detailed and highly summarized data
Data is dynamic		Data is largely static
Repititive processing		Ad hoc,unstructured and heuristic processing
High level of transaction processing		Medium to low level
Predicatble pattern of usage		It is Unpredictable
Transaction driven		Analysis driven
Application oriented		Suject oriented
Supports day-to-day decisions		Supports strategic decisions
Used by clerical/operational users (Large number)		Used by managerial users (Less number)