olap &oltp

[Former Member]

hi

what it exactly diffrence b/w OLAP & OLTP

how both of it works and more over what is the roll of its

can any body explain me

thanks

regards

gurkiran

[Former Member]

Hi,

OLTP

Purely transaction system

Analysis is not supports, supports but limited

Detailed level of Reporting

2 dimensional database design - ERM

reports on OLTP gives CURRENT TRUTH

OLAP

Purely analysis system

Aggregate level of analysis

MDM database design

purely reporting system

Reports on OLAP gives FACT

to simple, OLAP is a copy of OLTP

Hope this helps u a lot.........

Assigning points is the way of saying Thanks in SDN

Regards

Ramakrishna Kamurthy

[nvytla]

Time Scale

OLTP: This stores current data

OLAP: This stores History data for analysis

Indexing

OLTP: Optimizes update performance by minimizing the number of indexes

OLAP: Optimizes adhoc queries by including lots of indexes

Normalization

OLTP: This is fully normalized

OLAP: Possibly partially denormalized for performance reasons. As this is used for reporting.

Organization

OLTP: Data stored revolves around business functions

OLAP: Data stored revolves around information topics.

Stored Values

OLTP: Stores typically coded data.

OLAP: Stores descriptive data

Homegenity

OLTP: Scattered among different databases or DBMS and using different value coding schemes

OLAP: Centralized in data warehouse. Or in a collection of subject oriented data marts

Hope it helps-Naveen

[Former Member]

Hi

OLTP (R/3)

Current Data

Detailed Level reporting

Daily Transaction data

Two Dimensional Reporting

Online Data

OLAP (BW)

Historical Data

Summarized reporting

Analytical data

Multi Dimensional Reporting

2 - 10 Years Data

Thanks

Ramana Paruchuri

[Former Member]

http://www.rainmakerworks.com/pdfdocs/OLTP_vs_OLAP.pdf