Tuesday, February 2, 2010

Difference between OLTP and Data Warehouse

One major difference between the types of system is that data warehouses are not
usually in third normal form (3NF), a type of data normalization common in OLTP
environments.
Following figure illustrates key differences between an OLTP system and a data
warehouse.

1 comment:

  1. Thanks for great information you write it very clean. I am very lucky to get this tips from you


    Refrigerated transportation Canada

    ReplyDelete