Difference between OLAP and OLTP

Difference between OLAP and OLTP
OLTP stands for On Line Transaction Processing:
OLAP stands for On Line Analytical Processing
The data available at transaction side (Siebel Application) is OLTP and when that data is moved from transaction side for analyzing (Siebel Analytics) that becomes OLAP data.
OLAP brings into picture the concept of Data warehouse.
Data warehouse is a Relational /Multidimensional database that is designed for query and analysis rather for transaction processing. A data warehouse usually contains historical data that is derived from transaction data.

No comments: