Question

- Identify one benefit and one drawback of each concurrency control strategy in an OLTP application. Explain.

- Identify one benefit and one drawback of each concurrency control strategy in a data warehouse. Explain.

- Suggest a scenario for a hypothetical OLTP business system where optimistic concurrency control is most appropriate and another scenario where pessimistic concurrency control is most appropriate.

- How would the type of user, such as a computer program, an internal business user, or a customer on the web, affect your choices?

Answer 1

ANSWER 1:

Benefits:

Optimistic concurrency:

• Quick activities do which are required in OLTP.
• OLTP framework requires numerous data control like additions, erase, refreshes rather than choice activity. OLTP framework does the activity exceptionally quick as a contrast with other frameworks.
• That is the primary explanation behind picking the optimistic concurrency for on the web transaction handling framework.
• Optimistic concurrency framework first starts the transaction execution without making a big deal about the conditions that whether it will have the option to complete the assignment or not.
• In the event that we talk about the exhibition and speed the optimistic concurrency gives better outcomes in OLTP.

Pessimistic concurrency:

• To control and maintain the crucial business undertakings.
• OLTP is utilized to maintain the crucial business assignment and control its handling.
• Since the pessimistic concurrency control does bolts all the necessary variables before beginning the execution and inlocks them simply subsequent to completing the execution it gives the best control on the framework.
• Pessimistic concurrency control guarantees the effective execution of the undertaking.

Drawback:

Optimistic concurrency:

• The disappointment pace of the transactions is exceptionally high in the optimistic concurrency control.
• Since optimistic concurrency control begins the undertaking without dealing with the future issues like transaction execution going into the loop and so on in that circumstance when the disappointment rate is extremely high the OLTP won't give a decent exhibition.

Pessimistic concurrency:

• The starvation issue inside the transactions.
• Since the pessimistic concurrency control first bolts the necessary variables.
• Once in awhile the assignments which arrive behind schedule in the framework used to hold up till the culmination of the past transaction which is holding the assets.