Data warehouse is a ‘relational database’ which stores many months or years of historical records. It also provides support for gathering data, transportation, transformation, reporting, data mining, statistical analysis etc. Data warehouses are designed to analyze data rather than transaction processing. They usually contain data which are derived from transaction data. Data warehouses are said […]