GeekInterview.com
Series: Subject: Topic:
Question: 74 of 93

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

Asked by: Interview Candidate | Asked on: Apr 8th, 2006

Editorial / Best Answer

Answered by: opbang

View all answers by opbang

Member Since Mar-2006 | Answered On : 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

Answered On : Apr 19th, 2006

View all answers by mercy123

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

  
Login to rate this answer.
FALAK

Answered On : Apr 25th, 2006

View all answers by FALAK

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

  
Login to rate this answer.
mahbubul0123

Answered On : May 13th, 2006

View all answers by mahbubul0123

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.

  
Login to rate this answer.
opbang

Answered On : Sep 24th, 2006

View all answers by opbang

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.

Yes  1 User has rated as useful.
  
Login to rate this answer.
VANITHA R

Answered On : 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....

Yes  1 User has rated as useful.
  
Login to rate this answer.
Parameswari

Answered On : 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.

  
Login to rate this answer.
parambollina

Answered On : Mar 28th, 2007

View all answers by parambollina

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.
               

  
Login to rate this answer.
karthickmsc

Answered On : Sep 7th, 2009

View all answers by karthickmsc

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.

Yes  1 User has rated as useful.
  
Login to rate this answer.
sreenivas

Answered On : 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.

  
Login to rate this answer.
kalai

Answered On : Jan 29th, 2014

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

  
Login to rate this answer.

Give your answer:

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

Related Open Questions

Ads

Connect

twitter fb Linkedin GPlus RSS

Ads

Question Categories

Btrieve Interview Questions

Clipper Interview Questions

Database Admin Interview Questions

Firebird Interview Questions

Informix Interview Questions

Microsoft Access Interview Questions

MYSQL Interview Questions

PostgreSQL Interview Questions

Progress Interview Questions

SAP DB Interview Questions

SQL Interview Questions

SQL Server Interview Questions

Stored Procedures Interview Questions

Sybase Interview Questions

Teradata Interview Questions

Unify Interview Questions

Interview Question

 Ask Interview Question?

 

Latest Questions

Interview & Career Tips

Get invaluable Interview and Career Tips delivered directly to your inbox. Get your news alert set up today, Once you confirm your Email subscription, you will be able to download Job Inteview Questions Ebook . Please contact me if you there is any issue with the download.