What is the difference between transaction database and data warehouse databases?

Editorial / Best Answer

opbang  

  • Member Since Mar-2006 | Sep 24th, 2006


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.

Showing Answers 1 - 10 of 10 Answers

mercy123

  • Apr 19th, 2006
 

A Tx database is more of a Tx based (insert,update,rollback) oriented whereas a Datawarehouse database is repository based & hence * select * oriented.

  Was this answer useful?  Yes

FALAK

  • Apr 25th, 2006
 

hi buddies idon't think this is enough fort his que can anyone give further details

  Was this answer useful?  Yes

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.

  Was this answer useful?  Yes

opbang

  • Sep 24th, 2006
 

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.

VANITHA R

  • Oct 17th, 2006
 

hai,I am Vanitha.i am doing M.E.I am doing project in data mining.For that i have doubt.Waht is the difference between transactional data base and relational data base?and Where R the Types of data bases?Please tell me Your answer is useful for my project.Reply as soon as posible.Thank you....

Parameswari

  • Nov 21st, 2006
 

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.

  Was this answer useful?  Yes

Hi Vinitha,  Realational database is one database with relational approach. 
Transaction database is also a Relational database that is used to store your daily transactions.
               

  Was this answer useful?  Yes

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.

sreenivas

  • Nov 25th, 2012
 

A transactional database is defined for day-to-day operations like insert, delete and update and in a Datawarehouse databases (OLAP databases) are designed for Analytical purpose. So they require historical data for analysis. These databases are huge databases to store historical data.

  Was this answer useful?  Yes

kalai

  • Jan 29th, 2014
 

transactional database means current data in database.
data warehouse means historical data.i.e old data that are flushed out.

  Was this answer useful?  Yes

Give your answer:

If you think the above answer is not correct, Please select a reason and add your answer below.

Answer Question

Click here to Login / Register your free account


 
Send   Reset

 

Related Answered Questions

 

Related Open Questions