DATA WAREHOUSE

[PASSED]

How to compare and contract between an online transaction processing system and data warehose

 

[kishleo]

can you tell us on what basis you want to compare the OLTP and data warehouse? both are very different, OLTP is completely depends on transactions and ensured that data is consistant and accurate according to the bussiness logic for any instance
where as datawarehouse is built on the OLTP system and normally the schema of the OLTP system is denormalised in many ways to build a datawarehouse, the data in datawarehouse is based on the dimentional model not a relational model (as in case of OLTP) ô¿ô Kishore

 

[Guest_imported]

DW vs OLTP ~ if you go to teradata.com there is a section called TechCenter. On the this page is a link to WhitePapers:

http://www.teradata.com/library/res_white_pap.asp

There is a whitepaper called "Using your OLTP Database for DSS? May be time to rethink" that has a lot of info on the differences between DW & OLTP database environments. You'll have to fill out a form & get a free user id to this site to download the paper but I think you'll find it easy & useful. You may also want to look at some of the "Active Data Warehousing" papers. "Active Warehousing" is a new area that starts to blur the lines between the typical short tactical and strategic ad hoc queries. good luck & great question! DWinfo guy