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:

src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEh5jUYjzx5dLyKDrcCqZKigb2CgADMYP7j34Aj7XeCX8reHuRUiTOMMoa-diQLAAHToZrmKiMZAoY8MiPr9A-D_80N8Fwmp5PZE0bd_zBoaTXICyysOiYoL3NTOwC4quMewSO0RZU0hU48/s320/OLTP+DB.png" title="OLTP vs BI" width="320">














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

Tweet