|
Answer» The differences between Data warehouse and Database are given below. Parameter
| Data warehouse
| Database
| Definition
| It is a SYSTEM that collects and stores information from multiple data sources within an organization
| It is organised collection of logical data that is EASY to search, manipulate and analyse.
| Purpose and Usage
| It is used for the purpose of ANALYSIS of your business
| It is used for recording the data and performing various fundamental operations for your business.
| Data Availability
| When required, data is refreshed and captured from various data sources
| Real time data is always available
| Type of data stored
| It contains only SUMMARIZED data
| It contains detailed data
| Usage of Queries
| Complex queries are used
| Simple queries are used
| Tables and Joins
| In Data warehouse, Tables and Joins are simple
| In Database, Tables and Joins are complex
|
|
