OLTP & OLAP

OLAP stands for Online Analytical Processing. OLAP systems have the capability to analyze database information of multiple systems at the current time. The primary goal of OLAP Service is data analysis and not data processing.  OLTP stands for Online Transaction Processing. OLTP has the work to administer day-to-day transactions in any organization. The main goal of OLTP is data processing not data analysis. ONLINE TRANSACTION PROCESSING SYSTEM (OLTP) EXAMPLE: ONLINE ANALYTICAL PROCESSING SYSTEM (OLAP) EXAMPLE: DIFFERENCE BETWEEN OLTP AND OLAP Data: Transaction: Normalization: Queries: Integrity: