Answered Questions

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

    Star Read Best Answer

    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.

    kalai

    • Jan 29th, 2014

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

    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.