Wednesday 21 May 2014

Difference Between Database and Data Warehouse



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.
Storage of data
Flat Relational Approach is used for data storage.
Data Ware House uses dimensional and normalized approach for data storage.
Query Type
Simple Transaction Queries are Used.
Uses Complex Queries for the analysis of Database.
Data Summary
Detailed Data is stored in database.
It stores detailed, lightly and highly summarized data.
Read/Write Optimization
Write Optimized: database is designed to make sure every transaction gets recorded within time. Data can be updated, deleted or can be over written.
Read Optimized and contains mostly read only data. Data in the data warehouse are never over-written or deleted — once committed, the data are static, read-only, and retained for future reporting.
Modeling
ER Modeling Technique is used for database Design.
Data Modeling Techniques is Data Warehouse Design.
User Access
Used by a large number of Operational Users.
Used by a limited number of managerial Users.


Alternate Links:
Difference between Database and Data Warehouse
How Database is Different from Data Ware House
Database vs Data Ware House
Distinguish between Database and Data Ware House
Compare Database and Data Ware House

No comments:

Post a Comment