Differentiate between 'database' and 'data warehouse'.

Main difference between database and data warehouse are as under: Database is a collection of related information stored in a structured form in terms of table so that it makes easier insertion, deletion and manipulation of data. While, Data warehouse is a storage area for processed and integrated data across different sources which will be both operational data and external data. Database consists of tables that contain attributes. Whereas a data warehouse is a database system optimized for reporting and analysis. Data warehouse generally refers to the combination of many different databases across entire enterprise. Once the data entered in the data warehouse, it can be then only loaded, refreshed and accessed for queries. Data warehousing emphasizes the capture of data from diverse sources for useful analysis and access, but does not generally start from the point-of-view of the end user who may need access to specialized, sometimes local databases.