Compare Data Warehouse database and OLTP database - Data warehousing

Compare Data Warehouse database and OLTP database.

Data Warehouse is used for business measures cannot be used to cater real time business needs of the organization and is optimized for lot of data, unpredictable queries. On the other hand, OLTP database is for real time business operations that are used for a common set of transactions. Data warehouse does not require any validation of data. OLTP database requires validation of data.

Compare Data Warehouse database and OLTP database.

Both data warehouse and OLTP are relational databases.

Data Warehouse:

- Designed for business measures analysis, by creation of attributes and categories
- Does not cater to real time operational requirements of an enterprise.
- Store house of current and historical data along with data extracted from external resources.
- Bulk loads, unpredictable queries can access many rows for each table.
- Data warehouse is loaded with valid, consistent data and real time validation is not needed.
- Data warehouse is capable of supporting few concurrent users.


- Designed for performing transaction of real time business records.
- Caters to real time operational requirements of an enterprise.
- Optimized for a set of transactions, which are like adding and retrieving single row at a time for each table.
- OLAP is optimized for validating incoming data at the time of transactions. It uses validation data tables.
- OLAP is capable of supporting thousands of concurrent users.
Difference between ETL tool and OLAP tool - Data warehousing
ETL is the process of Extracting, loading and transforming data into meaningful form.......
What is the difference between OLAP and DSS? - Data warehousing
DSS, Decision Support System, as the name suggests, helps in taking decisions for top executive professionals.....
20 Cognos Interview Questions and Answers - Freshers, Experienced
Cognos interview questions - What are the products of Cognos? Can you set them in the order they were released?, How is report scheduling done in Cognos?, How do you create users in Cognos and assign them permissions?, Cognos Visualizer, Cognos Scripting, Snapshot, Transformer.
Post your comment