Database vs Data Warehouse
"All data warehouses are databases, not all databases are data warehouses."
A database is an integrated collection of logically related records or files consolidated into a common pool that provides data for one or multiple uses. On the other hand, Data warehouse is a repository of an organization's electronically stored data. Data warehouses are designed to facilitate reporting and analysis.
The primary difference betwen you application database and a data warehouse is that while the former is designed (and optimized) to record , the latter has to be designed (and optimized) to respond to analysis questions that are critical for your business.
Defference between OLTP database and OLAP data warehouse
| Data warehouse database | OLTP database |
| Designed for analysis of business measures by categories and attributes | Designed for real time business operations. |
| Optimized for bulk loads and large, complex, unpredictable queries that access many rows per table. | Optimized for a common set of transactions, usually adding or retrieving a single row at a time per table. |
| Loaded with consistent, valid data; requires no real time validation | Optimized for validation of incoming data during transactions; uses validation data tables. |
| Supports few concurrent users relative to OLTP | Supports thousands of concurrent users. |