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 fata.
|
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.
|
No comments:
Post a Comment