Tuesday 22 December 2015

What is the difference between OLTP and OLAP?

Following are the differences between OLTP and OLAP:
 OLTP:
 Data is from original data source
 Simple queries by users
 Normalized small database
Fundamental business tasks
 OLAP:
 Data is from various data sources
 Complex queries by system
De-normalized Large Database
Multi-dimensional business tasks.

No comments:

Post a Comment