Why do we need to use an OLTP?

Asked By Barbara Rothermal 0 points N/A Posted on - 12/09/2014

What is an Online Transaction processing system(OLTP)? How does OLTP differ from OLAP? What is it used for?What are the two types of OLTP? What is a TP heavy Monitor and what is a TP Light monitor? Where do we use each one of them? What are the basic two functions of a TP monitor?

 

• Status: Open
• Question Views: 702
• Answer Count: 2
• Vote Up 0 Vote Down

• Answer Accepted: Yes
• Question Category: Misc Networking

Best Answer by Sharath Reddy

Go To Solution

Best Answer

Best Answer

Answered By Sharath Reddy 590495 points N/A #145189

Why do we need to use an OLTP?

OLTP or OnLine Transaction Processing is a class of programs or applications that is able to support transaction-oriented applications over the internet. Online transaction processing systems are normally used for financial transactions, order entry, retail sales, and CRM or Content Relationship Management. These systems have a huge number of users who do short transactions.

One essential quality of an online transaction processing system is its capacity to keep concurrency. Online transaction processing systems are frequently distributed or spread out to prevent single points of failure. One example of an online transaction processing product is the IBM CICS or Customer Information Control System. OLAP or OnLine Analytical Processing is a kind of computer processing that allows a user to view and extract data selectively and easily from various points of view.

Online analytical processing can also be used for data mining as well as to find out earlier unrecognized affiliations among data items.

About Sharath Reddy

Questions
1

Answers
14599

Best Answers
2290

• Vote Up 0 Vote Down

• Posted on - 12/14/2014
• Question Category: Misc Networking

Answered By Nothman tale 0 points N/A #200167

Why do we need to use an OLTP?

Online transaction processing (OLTP) system in a data processing system usually used in medical stores, shopping stores, banks etc.



In OLTP – Online transaction processing we can simply process the data and can apply simple mathematical actions, like total sale, items left etc.

On the other hand in OLAP – Online Analytical Processing system we can perform analysis on the provided data, like “reason for decrease in sale” etc.



It is used to save the time and fraudulent activities, it is also used to find the way to increase business by analyzing data.

Two types of OLTP are:

• MOLAP – Multi dimensional analytical processing

• ROLAP – Relational Analytical processing

Transaction Processing (TP) Light Monitor: TP light monitors the database function’s those are not much complex.

Transaction Processing (TP) Heavy Monitor: TP heavy monitor supports the client server architechture which supports very complex and multiserver transections.



Two basic functions of TP-Monitors are:

• It guarantee the integrity of transactions

• It provides resource management and runtime management services

About Nothman tale

Questions
0

Answers
77

Best Answers
2

• Vote Up 0 Vote Down

• Posted on - 12/29/2014
• Question Category: Misc Networking