Contact US

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here




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


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


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

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members! Already a Member? Login

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close