Friday, July 6, 2012

OLTP and OLAP

I found this image here and learned that the divide between OLTP (On-line Transaction Processing) of CRUD and OLAP (On-line Analytical Processing) of complex queries is not unlike the difference between a normalized schema and a second denormalized Business Intelligence schema of the same information for reporting respectively.

No comments:

Post a Comment