OLAP N OLTP

**Spoorthi** · 23-01-07, 01:22 PM

WHAT IS THE DIFFERENCE BETWEEN OLAP N OLTP?

kiran_nitw · 30-01-08, 04:12 PM

OLAP means Online analytical processing it's a 2 dimensional model where the scope for analysis is limited, it is implementd with the concept of Enity relationship model,we can create delete,change a transaction

OLTP means Online transaction Processing which is implemented with the concept of star Schema, Extended Star Schema, Hybrid schema and Snowflake schema where we can analyze the data in multiple abgles.

saiepi · 01-02-08, 03:06 AM

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

04-03-08, 03:36 PM

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

23-01-07, 01:22 PM	#1 (permalink)
Spoorthi Super Moderator Join Date: Mar 2006 Posts: 4,803 Thanks: 9 Thanked 593 Times in 462 Posts Thanks: 9 Thanked 593 Times in 462 Posts Blog Entries: 2 Rep Power: 97	OLAP N OLTP WHAT IS THE DIFFERENCE BETWEEN OLAP N OLTP?

30-01-08, 04:12 PM	#2 (permalink)
kiran_nitw Junior Member Join Date: Jan 2008 Age: 27 Posts: 10 Thanks: 0 Thanked 0 Times in 0 Posts Thanks: 0 Thanked 0 Times in 0 Posts Rep Power: 1	Re: OLAP N OLTP OLAP means Online analytical processing it's a 2 dimensional model where the scope for analysis is limited, it is implementd with the concept of Enity relationship model,we can create delete,change a transaction OLTP means Online transaction Processing which is implemented with the concept of star Schema, Extended Star Schema, Hybrid schema and Snowflake schema where we can analyze the data in multiple abgles.

01-02-08, 03:06 AM	#3 (permalink)
saiepi Senior Member Join Date: Jan 2008 Posts: 214 Thanks: 43 Thanked 9 Times in 8 Posts Thanks: 43 Thanked 9 Times in 8 Posts Rep Power: 4	Re: OLAP N OLTP 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

Thread Tools
Show Printable Version Email this Page
Display Modes	Rate This Thread
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode	Rate This Thread:

Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)