mercy123

 Profile Answers by 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.

FALAK

 Profile Answers by FALAK 

• Apr 25th, 2006

 

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

mahbubul0123

 Profile Answers by mahbubul0123 

• May 13th, 2006

 

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.

opbang

 Profile Answers by 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.

parambollina

 Profile Answers by parambollina 

• Mar 28th, 2007

 

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.
               

karthickmsc

 Profile Answers by karthickmsc 

• Sep 7th, 2009

 

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.

kalai

• Jan 29th, 2014

 

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