Friday, June 29, 2012

OLTP vs BI

If you were asked to explain what is the difference between
OLTP system and BI system, how would you do it?

Here how I did it in one of my presentations:
Here is how OLTP system looks like:
















The OLTP system is just flow of raw data (Transactions).

And here how BI system looks like:















PS: Only real DBA can see the red women in the first picture:)

If you did not get it, I recommend you to see the Matrix movie

1 comment: