wht is oltp

[Former Member]

wht is oltp(online transaction processing)

[Former Member]

Hai,

SAP DB OLTP is a database instance type of the SAP DB database system. SAP DB is a relational database system that was developed for OLTP (Online Transaction Processing). The database system is optimized to process individual transactions fast in environments with a high number of users and large databases.

The OLTP database instance type has been optimized for the rapid processing of individual transactions with a large number of users and large databases

Regards

kishore ale

[Former Member]

Transaction:

Logical unit of program execution that takes a database from one consistent state to another consistent state.

Transaction Systems

Batch Transaction Processing System

On-Line Transaction Processing System

Real time Transaction Processing System

Requirements for an OLTP system

1. Integrity

2. Concurrency

Rewards if useful.

Thanks

Mohinder Singh Chauhan

[Former Member]

Hi,

OLTP Means Online Transaction Process it is just like our bank transaction if we go to bank and withdraw cash from our account that transaction is posted into our records...OLTP it holds data just 30- 60 days.It is not used in enterprises decisions making poroess.

R/3 is OLTP system and BW is OLAP system.

Check these links:

http://datawarehouse.ittoolbox.com/documents/document.asp?i=2066

http://expertanswercenter.techtarget.com/eac/knowledgebaseAnswer/0,295199,sid63_gci977813,00.html

http://www.datawarehouse.com/article/?articleid=4593

http://asktom.oracle.com/pls/ask/f?p=4950:8:::::F4950_P8_DISPLAYID:30801968442845

Please reward if helpful.