0 votes
in Sql by
What is Online Transaction Processing (OLTP) ?

1 Answer

0 votes
by

OLTP stands for Online Transaction Processing, is a class of software applications capable of supporting transaction-oriented programs. An essential attribute of an OLTP system is its ability to maintain concurrency. To avoid single points of failure, OLTP systems are often decentralized. These systems are usually designed for a large number of users who conduct short transactions. Database queries are usually simple, require sub-second response times and return relatively few records. Here is an insight into the working of an OLTP system [ Note - The figure is not important for interviews ] -

Related questions

0 votes
asked Mar 31, 2022 in SAP S/4HANA Reporting and Analytics by Robindeniel
0 votes
asked Jul 12, 2020 in Sql by Robindeniel
...