04-03-08, 03:36 PM
|
#4 (permalink)
|
|
Unregistered
|
Re: OLAP N OLTP
Good work,
Thanks,
Venu
Quote:
Originally Posted by saiepi
OLTP
OLAP
Online Transaction Processing
Eg: ATM / E-Seva SAP R/3. SAP CRM
Online Analytical Processing
Eg: All DWH SAP BW, SAS, Informatica + Erwin + Cognos
Deals with Current Data
Deals with Past Data
Deals with Detail Data
Deals with Summarized Data
Supports ERM
Supports MDM
Supports DML Operations (Read & Write)
Read only
Can be Used by End User / Any User
Can be used by Top Management Only
Huge number of concurrent users
Less number of concurrent users
It Deals with less volume of data
It deals with more number of data
|
|
|
|
|