TX Db deals with day to day prod data.

DW deals with historical data. Yes it receives prod data and store them.

But users should not be able to manipulate date there.

Transaction Database Vs DataWarehouse Database-

1. Transaction Database is Relational Database with the normalised table whereas DataWarehouse is with denormalised Table.

2. Transaction Database is highly volatile... Designed to maintain transaction of the business Where DataWarehouse is non volatile.. with periodic updates.

3. Transaction Database is OLTP... Datawarehouse ... is for analysis...

4. Transaction Database is functional data... DataWarehouse database Data is subject oriented.

A transactional database is defined for day to day oprations like insert delete and update. These databases are highly normalized (upto 3NF) to avoid redundancy.

Where as in Datawarehouse databases (OLAP databases) are designed for Analytical purpose. So they require historical data for analysis. These databases are huge databses to store historical data. And this data is read only. (ex: only select stmts allowed). To make analysis easily these data bases will be denormalized. The Schemas which are used to design these databases are Star Schema Snowflake Schema and Star Flake schemas.

Here in OLAP databses the data is consistent Non-colatile Subject Oriented and intergrated.

1) Transaction database is designed for a specific application.

Datawarehouse is designed to integrate data from multiple datasource.

2) Transaction focuses on the details Datawarehouse focuses on high level aggregates.

3) Transaction database is volatile. Datawarehouse is non volatile.

4) Transaction is used for OLTP and Datawarehouse is used for OLAP.