Parameter
|
Database
|
Data Warehouse
|
Definition
|
Organized Collection of Data is called database.
|
Database of Databases is Called Data Warehouse.
|
Purpose
|
It is designed to allow the definition, creation, querying, update, administration of data (Transaction Processing).
|
It is a relational database that is designed for query and analysis rather than transaction processing.
|
Data Type
|
Data stored in Database is up to date.
|
Current and Historical Data is Stored in Data Warehouse.
|
Orientation
|
Transaction Oriented: e.g. Each Transaction of Bank Customer is written to database and is interpreted as Accounting Database.
|
Subject Oriented: The data in the data warehouse is organized so that all the data elements relating to the same real-world event or object are linked together.
|
Data Redundancy
|
Databases are designed to avoid redundancy.
|
Data Warehouse design is intended to introduce redundancy.
|
