the DATABASE helps to perform the fundamental operation of business:

• keep customer records
• product records
• transactions,
• patient profile records
• patient DNA samples,
• ...

the DATA WAREHOUSE helps you to analyze your business.

	Where do you store a petabyte of data for  
	business intelligence?  A  data warehouse, 
	that’s where. Data spans for 2+ years...
	
	At  its  core, a   Data  Warehouse  is  a 
	centralized, read-optimized system designed 
	specifically for querying, reporting,  and 
	analytics. It’s where  your business  data 
	goes  after it’s  been cleaned, structured,  
	and denormalized for performance. 
	
	Unlike operational databases that are built 
	for transactions —  fast  inserts,  updates, 
	deletes — a warehouse is built for OLAP (online 
	analytical processing): aggregations, joins, 
	historical trends, and slow-but-heavy queries.

	Data  warehousing (DW) is a technique 
	of gathering and  analyzing data from 
	many sources to get valuable business 
	insights. Typically, a data warehouse 
	integrates and analyzes business data 
	from many sources. 	
		
	The data  warehouse  is the  basis of 
	the business intelligence (BI) system, 
	which can analyze and report on data.

	Derive insights from data by 
	building analytical, managerial 
	and baseline technical skills.