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.