What is the difference between olap and oltp?

Hi,

The difference can be highlighted by defining the two entities separately,

OLTP: Online Transaction Processing is a system normally used in the regular routine of database or User end Transactions (These Transactions are short Transactions).

In OLTP, the data is fully normalized in order to avoid redundancy,Duplication of data etc, for achieving normalization various Joins are used that connects the tables. (without these joins OLTP cannot be fully Normalized).

Now move on,

OLAP: Online Analytical Processing is a system helpful for analysis purposes, it is used in Business Intelligence for analysis reporting, unlike OLTP it doesn't have too many joins in it because in OLAP it is not required to normalize the data, the basic purpose is to make Facts and Dimensions.

<<Specifically for reporting purposes the data retrieval should be faster (The joins make the data processing slow) so the basic need of designing OLAP is to make the reporting system faster.>>