In simple words, a database is used to store information, and a data warehouse is used to query and analyse the stored data in several ways. Data warehouse helps business management to take important choices and decisions by providing them with detailed analysis on historical data.While databases are OLTP (On-Line Transaction Processing) systems, data warehouse is an OLAP (On-Line Analytical Processing) system.Databases are write-optimised, Data warehouse are read-optimised