|
Posted on
31 Jan 2014 04:33 PM IST
Database
- Used for Online Transactional Processing (OLTP) but can be used for other purposes such as Data Warehousing. This records the data from the user for history.
- The tables and joins are complex since they are normalized (for RDMS). This is done to reduce redundant data and to save storage space.
- Entity – Relational modeling techniques are used for RDMS database design.
- Optimized for write operation.
- Performance is low for analysis queries.
Data Warehouse
- Used for Online Analytical Processing (OLAP). This reads the historical data for the Users for business decisions.
- The Tables and joins are simple since they are de-normalized. This is done to reduce the response time for analytical queries.
- Data – Modeling techniques are used for the Data Warehouse design.
- Optimized for read operations.
- High performance for analytical queries.
- Is usually a Database.
Differences:
1.Data mart is usually sponsored at the department level and developed with a specific issue or subject in mind, a data mart is a data warehouse with a focused objective.
.Data warehouse is a “Subject-Oriented, Integrated, Time-Variant, Nonvolatile collection of data in support of decision making”.
2.A data mart is used on a business division/ department level.
.A data warehouse is used on an enterprise level.
3.A Data Mart is a subset of data from a Data Warehouse. Data Marts are built for specific user groups.
4.A Data Warehouse is simply an integrated consolidation of data from a variety of sources that is specially designed to support strategic and tactical decision making.
.By providing decision makers with only a subset of data from the Data Warehouse, Privacy, Performance and Clarity Objectives can be attained.
|