Transacaltional versus analytical systems

Database	Manages individual transctions	Respond to analysis queries
	Write-intensive	Read-intensive
	Contant updates, inserts and deletes	Static data loads
	Queries return small datasets	Queries return large datasets
	Little data aggregation	Data highly aggregated
	Reports require calculations	Data precalculated for reporting
	Data optimised for storage and read/write performance    Data relatively normalized    Multiple table joins	Data optimised for query preformance     Data denormalized, flattened     Minimal table joins
Use	Data entry Data retrieval	Reports Charts and pivote tables