Difference between OLAP & OLTP

[Former Member]

Hi,

Kindly let me know the difference between SAP BW (OLAP) and SAP R/3 (OLTP).

[Former Member]

Hi,

R/3 – OLTP (Online Transactional Data Processing)

1.The OLTP layer stores data with a very high level of detail (Transactional Data)

2.Reports from R/3 ia done by ABAP codes which is coplex and report retirval time is very high.

3.OLTP serever is very busy in handling transactions so if you use that for analysis thatis for reproting the preformance of the server goes down.

BW – OLAP (Online Analytical Processing)

1.Data in the data warehouse(OLAP) is compressed for high-performance access (agrregation).

2.It is designed specifically for query processing, not data updating and OLTP. Within BW, the data structures are designed differently and are much better suited for reporting than R/3 data structures. For example, BW utilizes star schema design which includes fact and dimension tables with bit-mapped indexes. Other important factors include the built-in support for aggregates, database partitioning, more efficient ABAP code by utilizing TRFC processing versus IDOC.

3.Better front-end reporting within BW. Although the BW excel front-end has it's problems, it provides more flexibility and analysis capability than the R/3 reporting screens.

4.BW has ability to pull data from other SAP or non-SAP sources into a consolidated cube.

5.reporting time is very less also server fuction is only for reporting and data extraction from various source system.

Assign points if it helps

Thanks & Regards,

santo

[Former Member]

Apologise to address you with a different name.

Dear Purushotham,

BW offers ready out-of-the-box components to meet the general challenges when ETL-ing, staging, exploring and broadcasting structured and integrated information in a BI solution.

OLTP as it name suggests OnLine Transaction Processing System, where as BW is related to analysis and decision making which depends less on individual transaction and more on summary information, trends.

Regards,

Chakra Pani.

[Former Member]

Dear Prashanth,

BW offers ready out-of-the-box components to meet the general challenges when ETL-ing, staging, exploring and broadcasting structured and integrated information in a BI solution.

OLTP as it name suggests OnLine Transaction Processing System, where as BW is related to analysis and decision making which depends less on individual transaction and more on summary information, trends.

Please revert for further clarifications.

Regards,

Chakra Pani.

[Former Member]

Hi

plese go through this links

http://www.geekinterview.com/question_details/209

http://blogs.netindonesia.net/kiki/archive/2006/02/28/8822.aspx

this will help you.

mahesh

[Former Member]

Hi Friend,

IT WOULD BE BETTER IF YOU COULD SEARCH THE FORUM BEFORE POSTING YOUR QUERY.

I GUESS THE SAME QUESTION WAS DISCUSSED EVEN YESTERDAY.

Regards

Hemant Khemani

Edited by: Hemant Khemani on Apr 23, 2008 6:47 PM

[Former Member]

Hi

olTP is optimized for transactions ex:SAP R/3

OLAp:analytical tool and is optimized for reporting ex:SAP BW

cheers,

Swapna.G

[rajkumar_kandula]

Hi,

OLAP: Stands for Online Analytical Proecss

OLTP: Online Transaction Process

OLTP

Online Transaction Processing-

a)Here we have transactional data generate from MasterData.

b)Data Stored in E-R Model.

Master data is detailed Description about any entity.

Ex: SAP R/3, any Data Base.

Online Analytical Processing-

a) Here we have Analytical data generate from Transaction data.

b) Data stored in Multidimensional model.

Transaction data generates 2 or more entities performs any transaction.

Ex: SAP BW, ETL.

For More Info Refer any of the below links:

http://en.wikipedia.org/wiki/OLAP

http://en.wikipedia.org/wiki/OLTP

http://www.geekinterview.com/question_details/209

http://blogs.netindonesia.net/kiki/archive/2006/02/28/8822.aspx