Pages

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: